convert pandas dataframe into dictionary code example
Example 1: how to make a pandas dataframe from a dictionary
>>> data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data)
Example 2: dataframe to dict without index
df.to_dict('index')
Example 3: pandas to dictionary
df.to_dict('records')
Example 4: create pandas dataframe from dictionary
In [11]: pd.DataFrame(d.items())
Out[11]:
0 1
0 2012-07-02 392
1 2012-07-06 392
2 2012-06-29 391
3 2012-06-28 391
...
In [12]: pd.DataFrame(d.items(), columns=['Date', 'DateValue'])
Out[12]:
Date DateValue
0 2012-07-02 392
1 2012-07-06 392
2 2012-06-29 391