思路:先将字典格式的数据转换成数组类型
import pandas as pd
dic = {"name":"张三","phone":"李四","sasnd":"wangwy"}
k = []
for key in dic:
print(key + ":" + dic[key])
num = [key,dic[key]]
k.append(num)
# k.append(key)
# v.append(dic[key])
# print(k)
data = pd.DataFrame(k)
writer = pd.ExcelWriter('统计.xlsx')# 写入Excel文件
data.to_excel(writer, index=False , header = False , encoding='utf_8_sig')
writer.save()
writer.close()
类似于这样的格式才可以写入excel表格中
效果:
不知道怎么把012去掉