python - 将元组转换为 Pandas DataFrame 时出错

Question

当我尝试将元组转换为 pandas 数据框时，出现以下错误:

DataFrame constructor not properly called!

我正在使用下面的代码

columnlist=["Timestamp","Price","Month","Day","DayofWeek","tDaysleftMonth","tDayinMonth","tDayinWeek"]
tickerData=pd.DataFrame(tickerDataRaw,columns=columnlist)

数据从 MySQL 数据库加载到元组中，

请找数据截图。 Data I am trying to convert

Answer 1

我想你可以使用 DataFrame.from_records将 tuples 转换为 list:

import pandas as pd

tuples = ((1,2,3),(4,6,7),(7,3,6),(8,2,7),(4,6,3),(7,3,6))

columnlist = ['a','b','c']
df = pd.DataFrame.from_records(list(tuples), columns=columnlist)
print (df)
   a  b  c
0  1  2  3
1  4  6  7
2  7  3  6
3  8  2  7
4  4  6  3
5  7  3  6

另一种仅使用 DataFrame 构造函数的解决方案:

import pandas as pd

tuples = ((1,2,3),(4,6,7),(7,3,6),(8,2,7),(4,6,3),(7,3,6))

columnlist = ['a','b','c']
df = pd.DataFrame(list(tuples), columns=columnlist)
print (df)
   a  b  c
0  1  2  3
1  4  6  7
2  7  3  6
3  8  2  7
4  4  6  3
5  7  3  6

编辑:

如果勾选DataFrame和参数 data:

data : numpy ndarray (structured or homogeneous), dict, or DataFrame

Dict can contain Series, arrays, constants, or list-like objects