I’m looking for a preferably pre existing format that I can easily automatically add new data to.
From my current understanding the best filetypes would be JSON, possibly a database such as SQLite or a spreadsheet.
What are your experiences with this?
My main motivation for looking for a standard is so that I can easily gather most of my data trough API’s and automation, ultimately requiring very little work on my part.
The end goal is to have it all analysed trough python, and since python is the tool i’m most comfortable with, I prefer to use python to write the code to gather the data.
Apologies if this has been asked before, I could not find something similar, I’ll happily be redirected.