Pandas Dict to Data Frames

How to convert a Python dictionary to Pandas data frame

In this tutorial, we will use Python dictionary and convert it into the Pandas data frame.

The data frame object has class methods that can be used for converting a Python list, dictionary, etc. to the data frame.

In this tutorial, we will show you examples of the Data frame’s from_dict() method (pd.DataFrame.from_dict()) to convert dictionaries to data frames.

Syntax of pd.DataFrame.from_dict()

An example of a dict to a data frame

In the example below, we created a dictionary of telephone numbers that only contains Names and Phone numbers.

It contains three records for the demo only.

See the code and output below and we will explain how it worked.

Python Program:

import pandas as pd

#Creating a dictionary 

tel_dir = {'Name': ['Mike','Haynes','Mina'],

           'Phone No':[123445689,45678910, 635363636]}

#Create data frame based on dict

df_dir = pd.DataFrame.from_dict(tel_dir)

#Display data frame

print(df_dir)

Output:

Using column names as index example

In the dictionary, we used the following column names (as you can see above):

• Name
• Phone No

If you want to use these as an index then you may use the orient parameter of the from_dict method.

Above, we have seen the usage of columns which is the default. In that case, keys of the dictionary became columns of the DataFrame.

By using ‘index’ value, the result is as follows:

import pandas as pd

#Creating a dictionary 

tel_dir = {'Name': ['Mike','Haynes','Mina'],

           'Phone No':[123445689,45678910, 635363636]}

#Create data frame based on dict by using orient = index

df_dir = pd.DataFrame.from_dict(tel_dir,orient='index')

#Display data frame

print(df_dir)

Output:

                  0         1          2

Name           Mike    Haynes       Mina

Phone No  123445689  45678910  635363636

You can see, the keys of the dictionary became index.

Display DataFrame without index

This is not straightforward to not show the index column (0,1,2…) by using from_dict method.

You may use other ways to hide the index column in the data frame.

In the following example, we will only display columns and rows provided in the dictionary – without row numbers:

import pandas as pd

#Creating a dictionary 

tel_dir = {'Name': ['Mike','Haynes','Mina'],

           'Phone No':[123445689,45678910, 635363636]}

#Create data frame based on dict by using orient = index

df_dir = pd.DataFrame.from_dict(tel_dir)


#Display data frame without index column

print(df_dir.to_string(index=False))

Output:

In the above program:

• We created a DateFrame based on a dict
• Then we used to_string method with index=False to display the data frame without an index column.