Search Results for "excel data mapping"

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility that can handle millions of rows with ease. A terminal interface for exploring and arranging tabular data. VisiData supports tsv, CSV, SQLite, JSON, xlsx (Excel), hdf5, and many other formats. Requires Linux, OS/X, or Windows (with WSL).

...The MIT Open Source license allows any user to fork the project to either add features to the broader community or create their own customized terminal version. The terminal allows for users to import their own proprietary datasets to use on our econometric menu. In addition, users are allowed to export any type of data to any type of format whether that is raw data in Excel or an image in PNG. This is ideal for finance content creation. Create notebook templates (through papermill) which can be run on different tickers. This level of automation allows to speed up the development of your investment thesis and reduce human error.

Alpha Vantage delivers a free API for real time financial data and most used finance indicators in a simple json or pandas format. This module implements a python interface to the free API provided by Alpha Vantage. You can have a look at all the API calls available in their API documentation. For code-less access to the APIs, you may also consider the official Google Sheet Add-on or the Microsoft Excel Add-on by Alpha Vantage.

...You no longer need to access all your wallets with passwords to simply just check that your money are still there. Cryptocheck also provides a simple profit calculation and history charts mapping your portfolio history. And there is also a server node available! It continuously monitors balances, records history data and sends all the data to your Cryptocheck desktop application. Supported cryptocurrencies: https://sourceforge.net/p/cryptocheck/wiki/Home/#supported-cryptocurrencies For more details about Cryptocheck and how to use it, see wiki: https://sourceforge.net/p/cryptocheck/wiki I am open to add other cryptocurrencies on your request.

US Tax Forms (1040 Schedule D and 8949 supplemental forms) require that every capital gains sale is listed by line, even if no cost basis or even a 1099-B has been provided to the IRS. Entering this data into tax software like TurboTax is tedious and error prone. Some institutions provide limited export capabilities such as CSV or excel export but this is not easy to translate into tax preparation software. These python scripts convert two simple to generate input files BuyLots.csv and Sales.csv into a .TXF file that can be imported into tax prep software and a second RemainingLots.csv that can be used for next year. ...

Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python. The goal of pyspread is to be the most pythonic spreadsheet. Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Dependencies + Python (>=2.7, <3.0) + numpy...

iTelliHashExcel is a cryptographic “one-way” hashing application designed to securely protect sensitive or private information from disclosure. Proper use of this program allows organizations, businesses, and individuals (i.e., the data owners) to share complete/intact datasets containing sensitive data with others without actually disclosing the sensitive or private information. Additionally, if such datasets are subsequently modified or enhanced through value-added services or products...

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

The main purpose of "python2xlw" is to create an Excel-compatible file which can be sent to users via the web as an excel application. The motivation is mainly to support the display of XY Scatter plots and tabular numerical data(eg engineering data)