Oct-09-2020, 10:48 AM
I'm very new to Python, and as a starter project I'm trying to use it to request data using an API which I then want to store in a csv file.
So far I have a working script that makes the API calls and stores the relevant data in a list. I'm a bit stuck as to where to go next to get this data into csv.
Each item in my list is a dictionary with some nested lists/dictionaries within. So I think I need to flatten the data before I can save to csv?
From the googling I've done so far, I think I may need to start looking at pandas - is this the right road to go down?
If anyone can suggest any useful resources/next steps I'd really appreciate it.
So far I have a working script that makes the API calls and stores the relevant data in a list. I'm a bit stuck as to where to go next to get this data into csv.
Each item in my list is a dictionary with some nested lists/dictionaries within. So I think I need to flatten the data before I can save to csv?
From the googling I've done so far, I think I may need to start looking at pandas - is this the right road to go down?
If anyone can suggest any useful resources/next steps I'd really appreciate it.