Pandas DataFrame: Create a dataframe from a dictionary and display it
1. Creating a DataFrame from a Dictionary
Write a Pandas program to create a dataframe from a dictionary and display it.
Sample data: {'X':[78,85,96,80,86], 'Y':[84,94,89,83,86],'Z':[86,97,96,72,83]}
Sample Solution :
Python Code :
import pandas as pd
df = pd.DataFrame({'X':[78,85,96,80,86], 'Y':[84,94,89,83,86],'Z':[86,97,96,72,83]});
print(df)
Sample Output:
X Y Z
0 78 84 86
1 85 94 97
2 96 89 96
3 80 83 72
4 86 86 83
Explanation:
df = pd.DataFrame({'X':[78,85,96,80,86], 'Y':[84,94,89,83,86],'Z':[86,97,96,72,83]});
The above code creates a pandas DataFrame object named ‘df’ with three columns X, Y, and Z and five rows. The values for each column are provided in a dictionary with keys X, Y, and Z.
The print(df) statement prints the entire DataFrame to the console.
For more Practice: Solve these Related Problems:
- Write a Pandas program to create a DataFrame from a nested dictionary and flatten the multi-level columns.
- Write a Pandas program to create a DataFrame from a dictionary where values are lists of unequal lengths by filling missing values with None.
- Write a Pandas program to construct a DataFrame from a dictionary and then randomly shuffle the rows.
- Write a Pandas program to create a DataFrame from a dictionary and then transpose it, ensuring that data types remain consistent.
Python-Pandas Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Python Pandas Data Series, DataFrame Exercises Home.
Next: Write a Pandas program to create and display a DataFrame from a specified dictionary data which has the index labels.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.