正在写入CSV文件Python3 issu

Question

我正在使用poloniex trader api获取实时市场行情信息。它在控制台上工作得很好。每当我要求市场行情的回报，我得到这个{'last': '0.07269671', 'high24hr': '0.07379970', 'quoteVolume': '71582.56540639', 'isFrozen': '0', 'lowestAsk': '0.07277290', 'percentChange': '-0.00551274', 'id': 148, 'low24hr': '0.07124645', 'highestBid': '0.07269671', 'baseVolume': '5172.41552885'}

问题是它只存储项目名/列表名，比如-low24hr, lowestAsk, highestBid etc。不是它们的值像-low24hr : 0.07124645

polo = Poloniex()
ticker_data = (polo('returnTicker')['BTC_ETH'])

out = csv.writer(open("myfile.csv","w"), delimiter=',',quoting=csv.QUOTE_ALL,)
out.writerow(ticker_data)
print(ticker_data)

下面是我的csv文件的样子-

Answer 1

with open('my_file.csv', 'w') as f:
    for key, value in ticker_data.items(): f.write('{0},{1}\n'.format(key, value))

来自here。你知道吗

Answer 2

您的问题是out.writerow(ticker_data)只获取字典的键并将它们写入文件。尝试使用csv.DictWriter：

with open('myfile.csv', 'w', newline='') as csv_file:
    # Pass the keys of the `ticker_data` as the fieldnames.
    writer = csv.DictWriter(csv_file, fieldnames=ticker_data, quoting=csv.QUOTE_ALL)
    # Write the fieldnames.
    writer.writeheader()
    # Write the values.
    writer.writerow(ticker_data)