Skip to content

Instantly share code, notes, and snippets.

@nkrabben

nkrabben/xfr_ia_pandas.py

Created December 17, 2019 23:30
Show Gist options
  • Save nkrabben/14e7cc34db5452c0632e29078d26dee6 to your computer and use it in GitHub Desktop.
Save nkrabben/14e7cc34db5452c0632e29078d26dee6 to your computer and use it in GitHub Desktop.
Download ZIP
Convert IA JSON to CSV using pandas
Raw
xfr_ia_pandas.py
import json
import pandas as pd
with open('Downloads/xfrcollective.json', 'r') as f:
data = json.load(f)
df = pd.DataFrame(data['collection_items'])
df.to_csv('Downloads/xfrcollective.csv', index=False)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment