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:
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:
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') dfprint(df) |
Output:
… [Trackback]
[…] Read More Information here on that Topic: geeksforgeeks.org/how-to-convert-dictionary-to-pandas-dataframe/ […]