Open In App

How to convert Dictionary to Pandas Dataframe?

Improve
Improve
Like Article
Like
Save
Share
Report

Let’s discuss how to convert Python Dictionary to Pandas Dataframe. We can convert a dictionary to a Pandas dataframe by using the pd.DataFrame.from_dict() class-method.

Convert Dictionary to Pandas Dataframe In Python Examples

Below are the ways by which we can convert dictionary to Pandas Dataframe in Python:

  • Using pandas constructor (pd.DataFrame())
  • Convert a Dictionary Into a DataFrame
  • Converting Dictionary to DataFrame With Orient=‘Index’
  • Converting dictionary with keys and list of values with different lengths.

Using Pandas Constructor (pd.DataFrame())

In this example, we are using Pandas constructor pd.DataFrame().

Python3




import pandas as pd
 
data = {'name': ['nick', 'david', 'joe', 'ross'],
        'age': ['5', '10', '7', '6']}
new = pd.DataFrame.from_dict(data)
 
new


Output

    name age
0 nick 5
1 david 10
2 joe 7
3 ross 6

Convert a Dictionary Into a DataFrame

In this example, we are using list of dictionary to convert the dictionary into a Pandas Dataframe.

Python3




import pandas as pd
 
data = [{'area': 'new-hills', 'rainfall': 100, 'temperature': 20},
        {'area': 'cape-town''rainfall': 70, 'temperature': 25},
        {'area': 'mumbai''rainfall': 200'temperature': 39}]
 
df = pd.DataFrame.from_dict(data)
 
df


Output

         area  rainfall  temperature
0 new-hills 100 20
1 cape-town 70 25
2 mumbai 200 39

Converting Dictionary to DataFrame With Orient=‘Index’

In this example, we are using the orient parameter to change the orientation of the dataframe from column to index

Python3




import pandas as pd
 
data = {'area': ['new-hills', 'cape-town', 'mumbai'],
        'rainfall': [100, 70, 200],
        'temperature': [20, 25, 39]}
 
df = pd.DataFrame.from_dict(data, orient='index')
df
print(df)


Output

         area rainfall temperature
0 new-hills 100 20
1 cape-town 70 25
2 mumbai 200 39

Converting dictionary with keys and list of values with different lengths

In this example, we are converting dictionary with keys and list of values with different lengths to Pandas Dataframe.

Python3




import pandas as pd
 
# Your dictionary with keys and lists of values
data = {
    'key1': [1, 2, 3],
    'key2': [4, 5],
    'key3': [6, 7, 8, 9]
}
 
# Convert the dictionary to a pandas DataFrame
df = pd.DataFrame(list(data.items()), columns=['Key', 'Values'])
 
# Display the DataFrame
print(df)


Output

    Key      Values
0 key1 [1, 2, 3]
1 key2 [4, 5]
2 key3 [6, 7, 8, 9]


Last Updated : 01 Dec, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads