字典转DataFrame报错
原代码
import pandas as pd
a=['1','2','3','4']
b=['a','b','c']
d={
'数字': a,
'字母': b
}
c=pd.DataFrame(d)
c.to_excel('1.xlsx')
修改后代码
import pandas as pd
a=['1','2','3','4']
b=['a','b','c']
d={
'数字': a,
'字母': b
}
c = pd.DataFrame(dict([(k, pd.Series(v)) for k, v in d.items()])) #空缺值补null
c.to_excel('1.xlsx')
删去上图的第一列索引
c.to_excel('1.xlsx',index=False)