Python Pandas - 如何从 DataFrame 中选择多行
要从DataFrame中选择多行,请使用:运算符设置范围。首先,使用别名导入requirepandas库-
import pandas as pd
现在,创建一个新的PandasDataFrame-
dataFrame = pd.DataFrame([[10, 15], [20, 25], [30, 35], [40, 45]],index=['w', 'x', 'y', 'z'],columns=['a', 'b'])
使用:操作符选择多行-
dataFrame[0:2]
示例
以下是代码-
import pandas as pd #CreateDataFrame dataFrame = pd.DataFrame([[10, 15], [20, 25], [30, 35], [40, 45]],index=['w', 'x', 'y', 'z'],columns=['a', 'b']) #DataFrame print"DataFrame...\n",dataFrame #selectrowswithloc print"\nSelect rows by passing label..." print(dataFrame.loc['z']) #selectrowswithintegerlocationusingiloc print"\nSelect rows by passing integer location..." print(dataFrame.iloc[1]) #selectingmultiplerows print"\nSelect multiple rows..." print(dataFrame[0:2])输出结果
这将产生以下输出-
DataFrame...
     a    b
w   10   15
x   20   25
y   30   35
z   40   45
Select rows by passing label...
a   40
b   45
Name: z, dtype: int64
Select rows by passing integer location...
a   20
b   25
Name: x, dtype: int64
Select multiple rows...
     a    b
w   10   15
x   20   25