Using Python to Fetch API Data into CSV

Today, ill be demonstrating a nice beginner 'project' to show how you can quickly and easily build a python script using standard modules to fetch data from an API and write it to a CSV. In this video we'll be using a public API provided from Coincap to grab cryptocurrency prices and write them into a CSV file. I encourage anyone who watches this to expand this out to present this in a webpage or maybe even upload the CSV to Google Sheets!

If you found this video helpful and would like to support my channel make sure you give the sub button a smash so you also dont miss out on video's like this in the future! :)

Note: In this video I am using Python v3.9.4

[griffingillam]

thank you so much for the walkthrough. been trying to find a way to do this for a few days now and your video worked perfectly

[doop]

I love your tutorial! Short & precise & super helpful! This helped a lot! Thanks so much!! 💙

[renan]

Great tutorial!!! Short, precise and very straightforward😁. No time wasting. Your video helped a lot. Much appreciate !!!!

[MegaGroover]

Thank you very much, really good tutorial! I'm so happy it worked!

[thean]

thankyou for the tutorial, im just starting to learn python but im sure this will be useful in the future!

[historique]

Exactly what I needed, thank you so much!!

[VanioJR]

your tutorial is very good, it helped me a lot! thank you so much!

[financephofun]

Thank you Daniel! I used your code to practice on different different API to csv file, it was very helpful, not sure if you have any plans, it would be nice if we took the csv file and did some analysis

[youtubewatch]

thanks for your video Daniel, i try to use same way to pull options data and format like your style.. but i can't find the "data" and i try to run it. the error :for x in myjson['strikePrice']:
TypeError: string indices must be integers
[Finished in 2.524s]

[PoolNinjasTN]

Hey boss, so im having the issue

typeError: list indices must be integers or slices, not str

for the for x in function

My "in" is purple
yours is blue.

Ideas? Im new to python!

[thippeswamykv]

What is the method for storing post api into csv

[monikak]

I use ur code for different api, but i use to get error list indices must be integer or slices, not str

[easylearnfrench]

Hi, thank you for your helpful video.
how can I access to second entry?
e.g there is an order_id with two different rows like below
row #1 order id: i6tp-pucp-dsrx-1gg7-ikef item_no: 2304
row #2 order id: i6tp-pucp-dsrx-1gg7-ikef item_no: 10914

[zuriatnaveed]

myjson = response.json()
TypeError: 'NoneType' object is not callable

how to solvs this error??

[memo.a]

I want to do the same thing but the problem i have is that the json response have so many levels, any Idea how to reach these data in the inner levels

[JasonSvoboda]

How do you approach this if they do not have a top level organizer like data and instead are just the individual items strings themselves?

[qb]

Can you do a tutorial on google places api to csv? Name, address, phone

[aishwary]

how do we filter if the data has more nested arrays ?

[v.abhinav]

the prices are so different today . i just forget the price back then

[whatarewetoday]

...Broooo, I will make you dinner, anything you want. You want to order in courses I got you. This was so helpful