Skip to content

Instantly share code, notes, and snippets.

@hsyyid

hsyyid/json-cols.py Secret

Created August 25, 2020 19:53
Show Gist options
  • Save hsyyid/a72386429d615854aeeee558bdd9023f to your computer and use it in GitHub Desktop.
Save hsyyid/a72386429d615854aeeee558bdd9023f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
json-cols.py
# Grab the string value of entries
invoices = invoices.pipe(gs.explode_json_to_cols, 'CustomField', reducer=gs.array_to_dict_reducer('Name', 'StringValue'))
invoices[['Id', 'CustomField.Crew #']].head()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment