Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal StudiesPython - 計算 Pandas DataFrame 中的組值最後一名
要計算組值的最後一名，請使用 groupby.last() 方法。首先，使用別名匯入所需的庫 −
import pandas as pd;
使用 3 列建立 DataFrame −
dataFrame = pd.DataFrame(
{
"Car": ['BMW', 'Lexus', 'BMW', 'Tesla', 'Lexus', 'Tesla'],"Place": ['Delhi','Bangalore','Pune','Punjab','Chandigarh','Mumbai'],"Units": [100, 150, 50, 80, 110, 90]
}
)
現在，按一列對 DataFrame 進行分組 −
groupDF = dataFrame.groupby("Car")計算組值的最後一名並重置索引 −
res = groupDF.last() res = res.reset_index()
示例
以下是完整程式碼。將顯示重複值的最後一次出現，即組值的最後一名 −
import pandas as pd;
dataFrame = pd.DataFrame(
{
"Car": ['BMW', 'Lexus', 'BMW', 'Tesla', 'Lexus', 'Tesla'],"Place": ['Delhi','Bangalore','Pune','Punjab','Chandigarh','Mumbai'],"Units": [100, 150, 50, 80, 110, 90]
}
)
print"DataFrame ...\n",dataFrame
# grouping DataFrame by column Car
groupDF = dataFrame.groupby("Car")
res = groupDF.last()
res = res.reset_index()
print"\nLast of group values = \n",res
輸出
將生成如下輸出 −
DataFrame ... Car Place Units 0 BMW Delhi 100 1 Lexus Bangalore 150 2 BMW Pune 50 3 Tesla Punjab 80 4 Lexus Chandigarh 110 5 Tesla Mumbai 90 Last of group values = Car Place Units 0 BMW Pune 50 1 Lexus Chandigarh 110 2 Tesla Mumbai 90
更新於: 16-Sep-2021
133 次觀看
廣告