mikedewar · December 16, 2011 13:17 · lrq3000 · Mar 28, 2013 · asmedrano · Jun 18, 2013
diff --git a/df2json.py b/df2json.py
 """
 tiny script to convert a pandas data frame into a JSON object
 """

 import ujson as json
 import pandas
 import numpy as np

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

 d = [ 
    dict([
        (colname, row[i]) 
        for i,colname in enumerate(df.columns)
    ])
    for row in df.values
 ]
 return json.dumps(d)
	"""
	tiny script to convert a pandas data frame into a JSON object
	"""

	import ujson as json
	import pandas
	import numpy as np

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

	d = [
	dict([
	(colname, row[i])
	for i,colname in enumerate(df.columns)
	])
	for row in df.values
	]
	return json.dumps(d)