Creating CSVs

[Sol Lederman]

Hi,

I find it useful to process the OpenAlex json files for data mining. In the past I've written my own Python code to create CSVs from the json. Those scripts are quite dusty and I'm wondering if the code referenced here might be a good replacement for my old stuff.

https://docs.openalex.org/download-all-data/upload-to-your-database/load-to-a-relational-database

Does anyone have experience with this code? Are there other pieces of code out there that process the json that I may want to compare this code to?

I may also load the CSV into a database but that's a separate exercise in my mind since I get a ton of value from processing CSVs, especially parallelizing the effort with multople cores.

Thanks!

Sol