: {""product"": ""九次方大數(shù)據(jù)""}, ""11"": {""product"": ""瘋貼-Fun""}, ""12"": {""product"": ""辣媽匯""}, ""13"": {""product"": ""四海華辰科技""}, ""14"": {""product"": ""諾爾康""}, ""15"": {""product"": ""天津象形科技""}, ""16"": {""product"": ""淘淘搜""}, ""17"": {""product"": ""夢(mèng)芭莎""}, ""18"": {""product"": ""魔方公寓""}, ""19"": {""product"": ""多利農(nóng)莊""}, ""20"": {""product"": ""米奇網(wǎng)""}, ""21"": {""product"": ""樂(lè)淘網(wǎng)""}, ""22"": {""product"": ""歐瑞思丹""}}"這種文件在csv 里面我用%s/""/"/g替換（把單個(gè)雙引號(hào)替換2個(gè)雙引號(hào)的），字符串之間的逗號(hào)為啥也沒(méi)有了？這是為啥呢、### 題目描述
1 回答
陪伴而非守候
TA貢獻(xiàn)1757條經(jīng)驗(yàn) 獲得超8個(gè)贊
用你的辦法在 vim 里試著替換了一下, 正常替換, 沒(méi)有重現(xiàn)你說(shuō)的情況, 猜測(cè)和你的vim配置相關(guān)?
可參考一下下面的例子
給定一定格式的數(shù)據(jù)，因?yàn)閖son格式可能遠(yuǎn)比csv復(fù)雜，所以只能支持一層扁平結(jié)構(gòu)的json數(shù)據(jù)：
employee_data = '{"employee_details":[{"employee_name": "James", "email": "james@gmail.com", "job_profile": "Sr. Developer"},{"employee_name": "Smith", "email": "Smith@gmail.com", "job_profile": "Project Lead"}]}'import json
import csv
employee_parsed = json.loads(employee_data)
emp_data = employee_parsed['employee_details']
# open a file for writing
employ_data = open('/tmp/EmployData.csv', 'w')
# create the csv writer object
csvwriter = csv.writer(employ_data)count = 0for emp in emp_data:
if count == 0:
header = emp.keys()
csvwriter.writerow(header) count += 1
csvwriter.writerow(emp.values())
employ_data.close()會(huì)輸出結(jié)果，key會(huì)形成表頭，value會(huì)是逗號(hào)分隔的值
$ cat /tmp/EmployData.csv employee_name,email,job_profile James,james@gmail.com,Sr. Developer Smith,Smith@gmail.com,Project Lead
添加回答
舉報(bào)
0/150
提交
取消