Writing CSV file Python3 issue

Question

I'm using poloniex trader api to get realtime market ticker info. It works perfect on console. When ever i request for market ticker in returns i get this {'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'}

Problem is it's only storing item name/list name such as - low24hr, lowestAsk, highestBid etc. Not their value like -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)

Here is what my csv file looks like- ImageView

ImageView

Welcome to SO. There isn't enough information in your post for us to help you. Please read How to Ask and minimal reproducible example. — wwii
– wwii, Commented Sep 7, 2017 at 23:07

skrx · Accepted Answer · 2017-09-08 04:11:47Z

1

Your problem is that out.writerow(ticker_data) takes only the keys of the dictionary and writes them to the file. Try to use a 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)

answered Sep 8, 2017 at 4:11

skrx

20.5k5 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NUMB Over a year ago

as a beginner this makes better sense to me friend (hug)

whackamadoodle3000 · Accepted Answer · 2017-09-08 03:18:18Z

1

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

From here.

edited Sep 8, 2017 at 3:18

answered Sep 7, 2017 at 23:23

whackamadoodle3000

6,7604 gold badges29 silver badges45 bronze badges

1 Comment

skrx Over a year ago

Don't use a list comprehension if you don't want to create a list. Just use a normal for loop.

Collectives™ on Stack Overflow

Writing CSV file Python3 issue

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related