Weekly Shaarli
Week 34 (August 23, 2021)
An example of all the nuisances of modern websites
In-depth workflow example from a longtime taskwarrior user.
Includes explanation of what to do when syncing taskwarrior with other installations (e.g. android) to avoid doubling up of recurring tasks!
Very nice introductory page to SQLite, how to work with it, its peculiarities and so on.
A very simple full-text search tool for plaintext files.
Can support multiple indexes, uses established search db library, is set up with a single config file.
easiest answer is with pandas as a library:
df = pd.read_json('inputfile.json')
df.to_csv('outputfile.csv', encoding='utf-8', index = False)
read_json converts a JSON string to a pandas object (either a series or dataframe).
to_csv can either return a string or write directly to a csv-file. See the docs for to_csv.
works best when json is an array of structured objects (unstructured data, see SO answer in link)
additional pandas to csv tips see this SO thread