python转csv,Python将字典转换为CSV

最新推荐文章于 2024-07-06 03:19:54 发布

转载最新推荐文章于 2024-07-06 03:19:54 发布 · 542 阅读

文章标签：

#python转csv

本文介绍如何从Shopee API获取商品信息，并将这些信息转换为CSV格式，便于进一步的数据分析。示例代码使用Python的urllib和json模块获取数据，并通过csv.DictWriter实现CSV文件的写入。

I am trying to convert dictionary to CSV so that it is readable (in their respective key).

import csv

import json

from urllib.request import urlopen

x =0

id_num = [848649491, 883560475, 431495539, 883481767, 851341658, 42842466, 173114302, 900616370, 1042383097, 859872672]

for bilangan in id_num:

with urlopen("https://shopee.com.my/api/v2/item/get?itemid="+str(bilangan)+"&shopid=1883827")as response:

source = response.read()

data = json.loads(source)

#print(json.dumps(data, indent=2))

data_list ={ x:{'title':productName(),'price':price(),'description':description(),'preorder':checkPreorder(),

'estimate delivery':estimateDelivery(),'variation': variation(), 'category':categories(),

'brand':brand(),'image':image_link()}}

#print(data_list[x])

x =+ 1

i store the data in x, so it will be looping from 0 to 1, 2 and etc. i have tried many things but still cannot find a way to make it look like this or close to this:

解决方案

Using DictWriter from the csv module

Demo:

import csv

data_list ={'x':{'title':'productName()','price':'price()','description':'description()','preorder':'checkPreorder()',

'estimate delivery':'estimateDelivery()','variation': 'variation()', 'category':'categories()',

'brand':'brand()','image':'image_link()'}}

with open(filename, "w") as infile:

writer = csv.DictWriter(infile, fieldnames=data_list["x"].keys())

writer.writeheader()

writer.writerow(data_list["x"])