python excel文件操作
#将数据存储以字典的形势,存到列表当中productList = [{"sku": 1,"name": "iphone 12 pro max","price": 12999,"brand": "苹果"}, {"sku": 2,"name": "mate 40","price": 7999,"brand": "华为"}, {
·
#将数据存储以字典的形势,存到列表当中
productList = [{
"sku": 1,
"name": "iphone 12 pro max",
"price": 12999,
"brand": "苹果"
}, {
"sku": 2,
"name": "mate 40",
"price": 7999,
"brand": "华为"
}, {
"1sku": 3,
"name": "vivo r9",
"prbcxice": 3999,
"brand": "vivo"
}]
import csv
def write_csv_list(list):
list_new = []
print(list)
for obj in list:
list_new.append([obj["sku"],obj["name"],obj["price"],obj["brand"]])
print(list_new)
with open("data.csv",'w',encoding='utf8') as csvFile:
writer = csv.writer(csvFile)
writer.writerow(["sku","名字","价格","品牌"])
writer.writerow(list_new)
#封装函数
def write_csv_dic(list):
with open("data1.csv",'w',encoding='utf8',newline='') as csvFile:
#存储csv,拿到writer对象
writer = csv.DictWriter(csvFile,["sku",'name',"price","brand"])
#writer.writeheader()
writer.writerows(list)
write_csv_dic(productList)

GitCode 天启AI是一款由 GitCode 团队打造的智能助手,基于先进的LLM(大语言模型)与多智能体 Agent 技术构建,致力于为用户提供高效、智能、多模态的创作与开发支持。它不仅支持自然语言对话,还具备处理文件、生成 PPT、撰写分析报告、开发 Web 应用等多项能力,真正做到“一句话,让 Al帮你完成复杂任务”。
更多推荐
所有评论(0)