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