Standard Chartered Bank Singapore Bank CSV download cleaner

scb_bank_stmt_cleaner.py

import pandas as pd
import numpy as np
import sys

# Create a Dataframe from CSV
df = pd.read_csv(sys.argv[1], thousands = ',', delimiter = ',', skiprows = 5, low_memory = False, keep_default_na = False)

# Cleaning: (1) Tabs in columns and headers (2) Make numbers into numbers instead of strings
df.columns = df.columns.str.strip()
df.Date = df.Date.str.strip()
df['Withdrawal'] = '-' + df['Withdrawal'].astype(str)
df['Withdrawal'] = df.Withdrawal.replace(r'-', np.nan)

# Write to file
df.to_csv('clean_' + sys.argv[1], index = False, float_format = '%.2f', encoding = 'utf-8')