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:当我们只通过一个时 dictionaryDataFrame.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