This project is a custom tool that processes the CSV file that is available for download to all N26 Bank users. This information will be presented in two csv output files (n26_year_balance_<year>.csv and n26_year_expenses_classified_<year>.csv), than can be used as input data by other scripts, spreadsheets, etc.
This file, called n26-csv-transactions.csv contains all the banking transactions between two dates.
By running the following command, we will get the processed data for the given year.
python3 <path_to_project>/main.py <year>
Some considerations to be done:
- N26 space names are hardcoded in the
main.pyfile. - The text strings used for column names and expenses types in the code may vary, depending on the N26 Bank account language. In my case, for example, this information is in spanish. Check it in your n26-transactions.csv file
- All this variables are defined at the begining of the
main.py.
The file has the following format:
| Anual total | January | February | March | April | May | June | July | August | September | October | November | December | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Income | |||||||||||||
| Expenses | |||||||||||||
| Difference |
The file has the following columns, being "Expense type" the categories used by N26 Bank to classify the expenses and incomes:
| Expense type | Annual total | January | February | March | April | May | June | July | August | September | October | November | December |
|---|