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