pandas从字典创建数据帧
时间:2020-02-23 14:42:05 来源:igfitidea点击:
在本教程中,我们将看到不同方式从字典创建Pandas DataFrame。
使用Pandas的DataFrame()方法。
示例1:我们只通过字典时 DataFrame()然后,方法根据其名称的升序显示列。
# import pandas package as pd in this code
import pandas as pd
# make a dictionary containing students data
data = {
'Name': ['Swapnil', 'Shivangi', 'Shaurya', 'Priya'],
'Age': [23, 22, 21, 20],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'College': ['Geu','Geu','Gehu','Gehu']
, }
# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame(data)
# print the pandas Dataframe
print("Given Dataframe :\n", df)
输出 :
Given Dataframe :
Age College Course Name
0 23 Geu B.tech Swapnil
1 22 Geu B.tech Shivangi
2 21 Gehu B.sc Shaurya
3 20 Gehu B.sc Priya
例2:如果我们想展示一个 DataFrame具体的列顺序然后我们必须通过一个 columns关键词参数alog与dataframe方法中的字典。
# import pandas package as pd in this code
import pandas as pd
# make a dictionary containing students data
data = {
'Name': ['Swapnil', 'Shivangi', 'Shaurya', 'Priya'],
'Age': [23, 22, 21, 20],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'College': ['Geu','Geu','Gehu','Gehu']
, }
# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame(data, columns = ['Name', 'Age', 'Course', 'College'])
# print the pandas Dataframe
print("Given Dataframe :\n", df)
输出 :
Given Dataframe :
Name Age Course College
0 Swapnil 23 B.tech Geu
1 Shivangi 22 B.tech Geu
2 Shaurya 21 B.sc Gehu
3 Priya 20 B.sc Gehu
使用dataframe.from_dict()方法。
例1:当我们只通过一个时 dictionary在 DataFrame.from_dict()然后,方法根据其名称的升序显示列。
# import pandas package as pd in this code
import pandas as pd
# make a dictionary containing students data
data = {
'Name': ['Swapnil', 'Shivangi', 'Shaurya', 'Priya'],
'Age': [23, 22, 21, 20],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'College': ['Geu','Geu','Gehu','Gehu'],
}
# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame.from_dict(data)
# print the pandas Dataframe
print("Given Dataframe :\n", df)
输出 :
Given Dataframe :
Age College Course Name
0 23 Geu B.tech Swapnil
1 22 Geu B.tech Shivangi
2 21 Gehu B.sc Shaurya
3 20 Gehu B.sc Priya
例2:如果我们想创建一个 Dataframe使用 dictionary其中键作为行,我们必须指定Orient ="索引 DataFrame.from_dict()方法以及 dictionary。
# import pandas package as pd in this code
import pandas as pd
# make a dictionary containing students data
data = {
'Name': ['Swapnil', 'Shivangi', 'Shaurya', 'Priya'],
'Age': [23, 22, 21, 20],
'Course': ['B.tech', 'B.tech', 'B.sc', 'B.sc'],
'College': ['Geu','Geu','Gehu','Gehu'],
}
# Convert the given dictionary into pandas DataFrame
df = pd.DataFrame.from_dict(data, orient = "index")
# print the pandas Dataframe
print("Given Dataframe :\n", df)
输出 :
Given Dataframe :
0 1 2 3
Name Swapnil Shivangi Shaurya Priya
Age 23 22 21 20
Course B.tech B.tech B.sc B.sc
College Geu Geu Gehu Gehu

