我需要?jiǎng)討B(tài)構(gòu)建以下 JSON 結(jié)構(gòu)。json = { "mainkey":"val1", "key2":[ {"keya":"val1rec1","keyb":"val2rec1","keyc":"val3rec1"}, {"keya":"val1rec2","keyb":"val2rec2","keyc":"val3rec2"}, {"keya":"val1rec3","keyb":"val2rec3","keyc":"val3rec3"}, {"keya":"val1rec4","keyb":"val2rec4","keyc":"val3rec4"}, {"keya":"val1rec5","keyb":"val2rec5","keyc":"val3rec5"} ] }只有 "{"keya":"val1rec1","keyb":"val2rec1","keyc":"val3rec1"}," 行 "迭代" - 即從 CSV 文件中讀取值，然后填充/創(chuàng)建行基于 CSV 文件中的內(nèi)容。所以我的偽代碼看起來像這樣：#create dictpath = 'somewhere\on\my\disk\file.csv'json_file = {}json_file['mainkey'] = "val1" #read from CSV filedf1 = pd.read_csv(path, header=None) #iterate through csvfor row,s in df1.iterrows(): number = df1.loc[row,0] #I'm reading keyb and keyc values from CSV as well, but for brevity my substitution below is not showing that.... json_file['key2'] = "'keya':'"+str(number)+"','keyb':'whatever','keyc':'whatever'"print (json_file)它顯然無法產(chǎn)生我在上面尋找的東西 - 因此我在這里發(fā)帖尋求幫助。
2 回答
寶慕林4294392
TA貢獻(xiàn)2021條經(jīng)驗(yàn) 獲得超8個(gè)贊
您正在覆蓋key2值，而您應(yīng)該將它們附加到列表中：
json_file['key2'] = []
for row,s in df1.iterrows():
number = df1.loc[row,0]
json_file['key2'].append({'keya': str(number), 'keyb': 'whatever', 'keyc': 'whatever'})
print (json_file)
添加回答
舉報(bào)
0/150
提交
取消