Series to Json for nested d3 blobs - iPython Notebook file

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": {}
  }
 ]
}