kaiwei

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()

kaiwei

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 = 4, low_memory = False, keep_default_na = False)

# Cleaning: (1) Drop "Unposted" (2) Remove nonsense entries at the bottom (3) Remove "SG" from all Desc
df.Date = df.Date.str.strip()
df = df[~df.DESCRIPTION.str.contains("UNPOSTED")]

kaiwei

Keybase proof

I hereby claim:

• I am kaiwei on github.
• I am kaiwei (https://keybase.io/kaiwei) on keybase.
• I have a public key ASBs0Eq64ftoeLcc765A_EgHW9ybVPuBuiFHMuetwXFjtgo

To claim this, I am signing this object:

kaiwei

#coding: utf-8
import keychain
import console
import editor
 
import time
import re
 
import requests
import json