資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
JavaScript
PHP
物理
化學
生物
數學
英語
經濟學
心理學
社會學
時裝學
法律如何在 Python 中將列表作為行附加到 Pandas DataFrame？
要開啟列表，我們可以使用 append() 方法。有了它，我們還可以使用 loc() 方法。首先，讓我們匯入所需的庫 -
import pandas as pd
以下是按團隊排名組織的資料 -
Team = [['India', 1, 100],['Australia', 2, 85],['England', 3, 75],['New Zealand', 4 , 65],['South Africa', 5, 50]]
使用上述資料並新增列來建立 DataFrame -
dataFrame = pd.DataFrame(Team, columns=['Country', 'Rank', 'Points'])
假設以下是要附加的行 -
myList = [["Sri Lanka", 6, 40]]
以列表的形式附加上述行 -
dataFrame = dataFrame.append(pd.DataFrame(myList, columns=['Country', 'Rank', 'Points']), ignore_index=True)
示例
以下是使用 append() 附加的程式碼 -
import pandas as pd # data in the form of list of team rankings Team = [['India', 1, 100],['Australia', 2, 85],['England', 3, 75],['New Zealand', 4 , 65],['South Africa', 5, 50]] # Creating a DataFrame and adding columns dataFrame = pd.DataFrame(Team, columns=['Country', 'Rank', 'Points']) print"DataFrame...\n",dataFrame # row to be appended myList = [["Sri Lanka", 6, 40]] # append the above row in the form of list dataFrame = dataFrame.append(pd.DataFrame(myList, columns=['Country', 'Rank', 'Points']), ignore_index=True) # display the update dataframe print"\nUpdated DataFrame after appending a row...\n",dataFrame
輸出
這將產生以下輸出 -
DataFrame... Country Rank Points 0 India 1 100 1 Australia 2 85 2 England 3 75 3 New Zealand 4 65 4 South Africa 5 50 Updated DataFrame after appending a row... Country Rank Points 0 India 1 100 1 Australia 2 85 2 England 3 75 3 New Zealand 4 65 4 South Africa 5 50 5 Sri Lanka 6 40
讓我們看另一個例子 -
示例
以下是使用 loc() 方法附加的程式碼 -
import pandas as pd # data in the form of list of team rankings Team = [['India', 1, 100],['Australia', 2, 85],['England', 3, 75],['New Zealand', 4 , 65],['South Africa', 5, 50],['Bangladesh', 6, 40]] # Creating a DataFrame and adding columns dataFrame = pd.DataFrame(Team, columns=['Country', 'Rank', 'Points']) print"DataFrame...\n",dataFrame # row to be appended myList = ["Sri Lanka", 7, 30] # append the above row in the form of list using loc() dataFrame.loc[len(dataFrame)] = myList # display the update dataframe print"\nUpdated DataFrame after appending a row using loc...\n",dataFrame
輸出
這將產生以下輸出 -
DataFrame... Country Rank Points 0 India 1 100 1 Australia 2 85 2 England 3 75 3 New Zealand 4 65 4 South Africa 5 50 5 Bangladesh 6 40 Updated DataFrame after appending a row using loc... Country Rank Points 0 India 1 100 1 Australia 2 85 2 England 3 75 3 New Zealand 4 65 4 South Africa 5 50 5 Bangladesh 6 40 6 Sri Lanka 7 30
更新時間：2021-09-21
2K+ 瀏覽
廣告