dataframe汇总求和问题

[johnny1983]

import pandas as pd
col = ["material", "Qty"]
value1 = ["A", 1]
value2 = ["A", 3]
value3 = ["B", 10]
value4 = ["A", 4]
df=pd.DataFrame([col,value1,value2,value3,value4])
df=df.groupby("material").sum()


要输出
material Qty
A 8
B 10


这样写程序一直提示keyerror "material"，怎么破？

[陈年椰子]

import pandas as pd
col = ["material", "Qty"]
value1 = ["A", 1]
value2 = ["A", 3]
value3 = ["B", 10]
value4 = ["A", 4]
df=pd.DataFrame([value1,value2,value3,value4])
df.columns = col
print(df)
df1=df.groupby(["material"]).sum()
print(df1)

[WilliamHuangSt]

简单的说就是建df的时候方法错了，col变成一行数据，建议重新复习df知识。