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:
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() |
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")] |
I hereby claim:
To claim this, I am signing this object:
#coding: utf-8 | |
import keychain | |
import console | |
import editor | |
import time | |
import re | |
import requests | |
import json |