For now you can use this as a workaround: JSON->CSV
Or, if you (understandably) don't want to upload your diary to a website, run it locally:
import pandas as pd
import json
# Load the JSON data
file_path = '/data/Diarium_2022-08-01_2024-05-22.json'
with open(file_path, 'r', encoding='utf-8') as file:
data = json.load(file)
# Create a list of entries for the DataFrame
entries = []
for entry in data:
entry_data = {
"Date": entry.get("date", ""),
"Heading": entry.get("heading", ""),
"Content": entry.get("html", ""),
"Location": entry.get("location", []),
"Tags": ", ".join(entry.get("tags", [])),
"People": ", ".join(entry.get("people", [])),
"Weather": entry.get("weather", ""),
"Rating": entry.get("rating", ""),
}
entries.append(entry_data)
# Create DataFrame
df = pd.DataFrame(entries)
# Save DataFrame to CSV
csv_file_path = '/data/Diarium_Entries.csv'
df.to_csv(csv_file_path, index=False)
csv_file_path
