python解析json多行_用Python将JSON单行解析为多行CSV

我是一个pythonnoob，使用Plaid API获取银行交易。我希望每个事务都是它自己的行，我只想为每个记录提取四个值：日期、帐户、名称和金额，并用这些数据填充一个CSV文件。我有下面的代码，它填充了一行CSV(还附上了JSON文件)。我似乎不知道我要找的是什么样的例子，关于如何做到这一点，谷歌了一点。任何帮助都是非常感谢的。在import csv

#Configuration

from plaid import Client

Client.config({

'url': 'https://api.plaid.com'

})

#Connect to Plaid

from plaid import Client

from plaid import errors as plaid_errors

from plaid.utils import json

client = Client(client_id='test_id', secret='test_secret')

account_type = 'suntrust'

try:

response = client.connect(account_type, {

'username': 'plaid_test',

'password': 'plaid_good'

})

except plaid_errors.PlaidError:

pass

else:

connect_data = response.json()

#Get transactions from Plaid

response = client.connect_get()

transactions = response.json()

#Save the transactions JSON response to a csv file in the Python Projects directory

with open('transactions.csv', 'w') as outfile:

json.dump(transactions, outfile)

csvfile = open('transactions.csv', 'r')

jsonfile = open('transactions.json', 'w')

fieldnames = ("date", "_account","name","amount")

reader = csv.DictReader(csvfile, fieldnames)

for row in reader:

json.dump(row, jsonfile)

jsonfile.write('\n')