Skip to content

Instantly share code, notes, and snippets.

@janeadams

janeadams/sample_json_parse.py

Last active May 20, 2021 18:01
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save janeadams/718aa001f18637c75db803c600ea2fdc to your computer and use it in GitHub Desktop.
Save janeadams/718aa001f18637c75db803c600ea2fdc to your computer and use it in GitHub Desktop.
Download ZIP
Sample JSON Parse from UI Download, for StoryWrangler
Raw
sample_json_parse.py
import json
import pandas as pd
import csv
dfs={}
with open('storywrangler_data.json') as json_file:
data = json.load(json_file)
for ngram in data['metadata']['ngrams']:
dfs[ngram] = pd.DataFrame(data['data'][ngram], columns=['date',data['metadata']['metric']])
for ngram in dfs:
dfs[ngram].to_csv(f"{ngram}-{data['metadata']['language']}-{data['metadata']['metric']}.csv")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment