python read_sql以后结果不是dataframe,而是tuple,所以要转。但是转化以后没有列名。。。。
import pandas as pd
s = ((1,0,0,0,),(2,3,0,0,),(4,5,6,0,),(7,8,9,10,))
print pd.DataFrame(list(s))
python read_sql以后结果不是dataframe,而是tuple,所以要转。但是转化以后没有列名。。。。
import pandas as pd
s = ((1,0,0,0,),(2,3,0,0,),(4,5,6,0,),(7,8,9,10,))
print pd.DataFrame(list(s))