Writing a CSV File Using Data from an API in Python

Question

I'm learning Python and decided to play around a bit with a project that I've been wanting to tackle for a while now. I ended up trying to use an API that returns data that I would like to write to a CSV file. I'm struggling with how to parse that out given the formatting of the data, though. I used the following lines to grab the data in question. How can I take that data (shortened version shown below the code) and parse that into a CSV file?

    from pycoingecko import CoinGeckoAPI
    import pandas as pd

    cg = CoinGeckoAPI()

    data = cg.get_coin_market_chart_by_id('bitcoin', 'usd', 'max')
    print(data)

{'prices': [[1367107200000, 135.3], [1367193600000, 141.96], [1367280000000, 135.3], [1367366400000, 117.0], [1367452800000, 103.43], [1367539200000, 91.01], [1367625600000, 111.25], [1367712000000, 116.79], [1367798400000, 118.33], [1367884800000, 106.4], [1367971200000, 112.64]]}

flawr · Accepted Answer · 2021-03-25 21:25:27Z

1

I'd recommend using pandas. Note that in the following snippet just uses the default options for to_csv(), but you can customize it quite a lot to suit your needs.

import pandas as pd
data = {'prices': [[1367107200000, 135.3], [1367193600000, 141.96], [1367280000000, 135.3], [1367366400000, 117.0], [1367452800000, 103.43], [1367539200000, 91.01], [1367625600000, 111.25], [1367712000000, 116.79], [1367798400000, 118.33], [1367884800000, 106.4], [1367971200000, 112.64]]}
df = pd.DataFrame.from_dict(data['prices'])
df.to_csv('test.csv')

answered Mar 25, 2021 at 21:25

flawr

11.7k4 gold badges49 silver badges83 bronze badges

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

Comments

Vova · Accepted Answer · 2021-03-25 22:06:43Z

1

or try something like that:

import csv

a = {'prices': [[1367107200000, 135.3], [1367193600000, 141.96], [1367280000000, 135.3], [1367366400000, 117.0], [1367452800000, 103.43], [1367539200000, 91.01], [1367625600000, 111.25], [1367712000000, 116.79], [1367798400000, 118.33], [1367884800000, 106.4], [1367971200000, 112.64]]}

with open('new_file.csv', 'w+') as f:
    writer = csv.writer(f)
    for line in a.get('prices'):
        writer.writerow(line)

answered Mar 25, 2021 at 22:06

Vova

3,6173 gold badges19 silver badges26 bronze badges

Collectives™ on Stack Overflow

Writing a CSV File Using Data from an API in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related