非常感謝，我一直熱衷于收集有關從相應輸入中獲取以下輸出的一些見解。希望通過使用 python 腳本將表格轉換為理想的格式，因為我必須在稍后階段使用巨大的 CSV。任何輸入都受到高度贊賞。
輸入CSV：
| 參考 | 微商 | 價值 | 貨幣 |
|---|---|---|---|
| 10000 | 5300 | 134.09 | 美元 |
| 10001 | 5651 | 128.95 | 美元 |
| 10002 | 5912 | 104.71 | 美元 |
使用的python代碼：
from csv import DictReader
from itertools import groupby
from pprint import pprint
import json
with open('Test_bulk_transactions_data.csv') as csvfile:
r = DictReader(csvfile, skipinitialspace=True)
data = [dict(d) for d in r]
group = []
uniquekeys = []
for k, g in groupby(data, lambda r: (r['reference'], r['mcc'])):
group.append({
"reference": k[0],
"mcc": k[1],
"amount": [{k:v for k, v in d.items() if k not in ['reference','mcc']} for d in list(g)]})
uniquekeys.append(k)
print(json.dumps(group, indent = 3) '}')
電流輸出：
{
"reference": "10000",
"mcc": "5300",
"amount": [
{
"value": "134.09",
"currency": "USD"
}
]
},
{
"reference": "10001",
"mcc": "5651",
"amount": [
{
"value": "128.95",
"currency": "USD"
}
]
},
{
"reference": "10002",
"mcc": "5912",
"amount": [
{
"value": "104.71",
"currency": "USD"
}
]
}
所需的輸出 JSON：
{
"reference": "10000",
"mcc": "5300",
"amount": {
"value": 134.09,
"currency": "USD"
}
},
{
"reference": "10001",
"mcc": "5651",
"amount": {
"value": 128.95,
"currency": "USD"
}
},
{
"reference": "10002",
"mcc": "5912",
"amount": {
"value": 104.71,
"currency": "USD"
}
}
- 重要說明：金額不應屬于 [] 并且該值應作為數字輸出而不是字串。
uj5u.com熱心網友回復：
import csv
csv_filepath = "/home/mhs/test.csv"
output = []
with open(csv_filepath) as cd:
csvReader = csv.DictReader(cd)
for r in csvReader:
r["amount"] = {"value": float(r.pop("value")), "currency": r.pop("currency")}
output.append(r)
uj5u.com熱心網友回復：
不依賴匯入的模塊，你可以這樣做：
J = []
with open('input.csv') as csv:
cols = next(csv).split()
assert len(cols) == 4
for row in csv:
t = row.split()
if len(t) == 4:
J.append({cols[0]: t[0], cols[1]: t[1], "amount": {cols[2]: float(t[2]), cols[3]: t[3]}})
print(J)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/390997.html
標籤：Python json 蟒蛇-3.x 自动化 csvtojson