Convert a pandas dataframe to a json blob

df2json.py

"""
tiny script to convert a pandas data frame into a JSON object
orig: https://gist.github.com/1486027 via Mike Dewar

Test data: 

df = pandas.DataFrame({
    "time" : [1,2,3,4,5],
    "temp" : np.random.rand(5)
})

"""
 
import json as json

def to_json(df,filename):
    d = [ 
        dict([
            (colname, row[i]) 
            for i,colname in enumerate(df.columns)
        ])
        for row in df.values
    ]
    return json.dump(d, open(filename + '.json', 'w'))

to_json(df, 'my_filename')

# Preview file:
!head my_filename.json

Why does this assume you are in an ipython notebook? Seems like it is agnostic to both ipython and notebook :-)

The last line will only work in an ipython notebook. The rest is agnostic.