Answers for "dictionary to dataframe in pandas"

7

convert a dictionary into dataframe python

import pandas as pd
data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
pd.DataFrame.from_dict(data, orient='index').T
Posted by: Guest on November-05-2020
1

convert pandas dataframe/ table to python dictionary

df.to_dict(orient='index')
Posted by: Guest on August-21-2021
2

python convert dictionary to pandas dataframe

>>> data = {'col_1': [3, 2, 1, 0], 'col_2': ['a', 'b', 'c', 'd']}
>>> pd.DataFrame.from_dict(data)
   col_1 col_2
0      3     a
1      2     b
2      1     c
3      0     d
Posted by: Guest on June-12-2020
4

dataframe to dictionary

>>> df.to_dict('records')
[{'col1': 1, 'col2': 0.5}, {'col1': 2, 'col2': 0.75}]
Posted by: Guest on December-31-2020
1

create pandas dataframe from dictionary

In [11]: pd.DataFrame(d.items())  # or list(d.items()) in python 3
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
Posted by: Guest on May-01-2021
0

dataframe from dict

pd.DataFrame.from_dict(data)
Posted by: Guest on July-03-2020

Code answers related to "dictionary to dataframe in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language