Fehlermeldung beim Import der CSV-Datei (N26-Konto)

"Booking Date","Value Date","Partner Name","Partner Iban",Type,"Payment Reference","Account Name","Amount (EUR)","Original Amount","Original Currency","Exchange Rate"
2018-03-01,,"LOGPAY FINANCIAL SERVICES GMBH",DE75500400000XXXXXX100,"Direct Debit","LogPay OnlineTicket i.A.v. Muenchner Verkehrs",Hauptkonto,-16.80,,,
2018-03-16,,"TTT MONEYCORP LIMITED",GB81DEUT405XXXXXX59502,"Credit Transfer",LLRXXXX9,Hauptkonto,60.00,,,

""" N26
"""
import warnings
with warnings.catch_warnings():
    warnings.filterwarnings('ignore')
    import pandas as pd
    import numpy as np
from pathlib import Path

cur_dir = Path.cwd()

n26_folder = cur_dir / "N26"
new_transactions_file = n26_folder / "formatted" / "new_transactions_toimport.csv"
if new_transactions_file.exists():
    new_transactions_file.unlink()
csv_files = n26_folder.glob("*.csv")
csv_files_processed = set([
    file.name for file in (n26_folder / "formatted").glob("*.csv")])

num = 0
num_skipped= 0
df_new = None
for csv_file in csv_files:
    if csv_file.name in csv_files_processed:
        num_skipped += 1
        continue
    df = pd.read_csv(csv_file, index_col=False)
    print(csv_file.name)
    # read date column
    df['Booking Date'] = pd.to_datetime(
        df['Booking Date'], format='%Y-%m-%d')
    df['Value Date'] = pd.to_datetime(
        df['Value Date'], format='%Y-%m-%d')
    # write to csv, reformat date column
    df.to_csv(
        n26_folder / "formatted" / csv_file.name,
        date_format='%d.%m.%Y')
    if df_new is None:
        df_new = df
    else:
        df_new = pd.concat([df_new, df])
    num += 1

# write a single file with all newly processed CSVs
# to be imported to Hibiscus
if df_new is not None:
    df_new.sort_values('Booking Date', ascending=True, inplace=True)
    df_new.to_csv(new_transactions_file, date_format='%d.%m.%Y')

print(f'Finished N26, processed {num} files, skipped {num_skipped}')
if df_new is not None:
    print(f'Import the file called "{new_transactions_file.name}"')
else:
    print("Nothing to import.")

## Notes

CSV files are processed individually, each CSV file is only imported once and then archived.
-> only download CSV for completed months!

Will Process:
- Payoneer
- Revolut
- Chase

Run:
```
source ./venv/bin/activate
python ./parse_csv.py
```

Setup:
```
apt-get install python3-venv # required for virtual env
python3 -m venv venv
source ./venv/bin/activate
pip install pandas ofxparse
```