NaN Quantitavity – Quant Trading, Statistical Learning, Coding and Brainstorming

import pandas as pd
import pandas.io.sql as pd_sql
import sqlite3 as sql
import os

path = “C:\\test”
os.chdir(path)

DF = pd.read_csv(‘spy2011.csv’)
DF.head(10)
con = sql.connect(‘data.db’)
pd_sql.write_frame(DF, “tbl”, con)
con.commit()

df = pd.DataFrame({‘label’: [‘A’, ‘B’, ‘C’] + [‘B’] * 2 + [‘A’] * 3, ‘value’: [4, 3, 6, 3, 1, 2, 4, 4]})
df2 = df.sort([‘label’, ‘value’])
df3 = df2.drop_duplicates([‘label’])