Skip to content

Instantly share code, notes, and snippets.

@ameliagreenhall

ameliagreenhall/Examples for Creating JSON from Pandas DataFrames.ipynb

Created April 30, 2013 22:02
Show Gist options
  • Save ameliagreenhall/5492283 to your computer and use it in GitHub Desktop.
Save ameliagreenhall/5492283 to your computer and use it in GitHub Desktop.
Download ZIP
Series to Json for nested d3 blobs - iPython Notebook file
Display the source blob
Display the rendered blob
Raw
Examples for Creating JSON from Pandas DataFrames.ipynb
{
"metadata": {
"name": "Examples for Creating JSON from Pandas DataFrames"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"from pandas import *"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"def series_to_json(series, index_name=None, value_name=None):\n",
" idx_name = series.index.name if index_name == None else index_name\n",
" val_name = series.name if value_name == None else value_name\n",
" return [{idx_name: k, val_name: v} for k, v in series.iterkv()]\n",
"Series.to_json = series_to_json\n",
"\n",
"s = Series(['a', 'b', 'c'], name='value_name', index=Index(range(3), name='index_name'))\n",
"print(s)\n",
"s.to_json(index_name='banana')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"index_name\n",
"0 a\n",
"1 b\n",
"2 c\n",
"Name: value_name, dtype: object\n"
]
},
{
"output_type": "pyout",
"prompt_number": 2,
"text": [
"[{'banana': 0, 'value_name': 'a'},\n",
" {'banana': 1, 'value_name': 'b'},\n",
" {'banana': 2, 'value_name': 'c'}]"
]
}
],
"prompt_number": 2
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment