divtracker-import.py

import codecs
import pandas as pd

def start():
    doc = codecs.open("import.csv", "r", "utf-8")
    df = pd.read_csv(doc, sep=',')

    df = df[(df['Type'] == 'BUY') | (df['Type'] == 'SELL')]
    df = df.drop(columns=['Description', 'Currency', 'Type', 'Amount' ])
    df['Date'] = pd.to_datetime(df['Date'])
    df['Stock'] = df['Stock'] + ".PH"


    df = df.rename(columns={'Stock': 'Ticker',  'Price': 'Cost Per Share', 'Comm & Other Fees': 'Commission'})
    df.to_csv('export.csv', index=False,)


start()