Skip to content
Related Articles

Related Articles

How to convert Dictionary to Pandas Dataframe?

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 10 Jul, 2020

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.

Example 1: Passing the key value as a list.




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

Output:

pandas-dataframe-from-dict-1

Example 2




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:

pandas-dataframe-from-dict-2

Example 3: Using the orient parameter to change the orientation of the dataframe from column to index




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:

pandas-dataframe-from-dict-3


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!