_property _DataFrame.iloc

纯粹基于整数位置的索引,用于按位置选择。

Allow Inputs

  • 一个整数,例如:5
  • 整数列表或数组,例如:[4, 3, 0]
  • 带有整数的切片对象,例如:1:7
  • 一个布尔数组
  • 一个可调用函数,带有一个参数并返回用于索引的有效输出

    Example

    ```python import pandas as pd

df = pd.DataFrame({‘site’:[‘google’, ‘baidu’, ‘wiki’], ‘age’:[18, 39, 22], ‘price’: [1.0, 2.0, 3.0], ‘color’: [‘red’, ‘black’, None]})

df.iloc[0]

site google age 18 price 1 color red Name: 0, dtype: object

  1. <a name="AJeRX"></a>
  2. # Example
  3. ```python
  4. import pandas as pd
  5. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  6. 'age':[18, 39, 22],
  7. 'price': [1.0, 2.0, 3.0],
  8. 'color': ['red', 'black', None]})
  9. df.iloc[[0, 1]]
  10. -----------------------------------------
  11. site age price color
  12. 0 google 18 1.0 red
  13. 1 baidu 39 2.0 black

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[:3]
  7. -----------------------------------------------------
  8. site age price color
  9. 0 google 18 1.0 red
  10. 1 baidu 39 2.0 black
  11. 2 wiki 22 3.0 None

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[[True, False, True]]
  7. -------------------------------------------
  8. site age price color
  9. 0 google 18 1.0 red
  10. 2 wiki 22 3.0 None

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[lambda x: x.index % 2 == 0]
  7. -----------------------------------------------------
  8. site age price color
  9. 0 google 18 1.0 red
  10. 2 wiki 22 3.0 None

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[0, 1]
  7. ---------------------------------------------------------
  8. 18

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[[0, 2], [1, 3]]
  7. -------------------------------------------------------------
  8. age color
  9. 0 18 red
  10. 2 22 None

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[1:3, 0:3]
  7. -----------------------------------------------------------
  8. site age price
  9. 1 baidu 39 2.0
  10. 2 wiki 22 3.0

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[:, [True, False, True, False]]
  7. ---------------------------------------------------------
  8. site price
  9. 0 google 1.0
  10. 1 baidu 2.0
  11. 2 wiki 3.0

Example

  1. import pandas as pd
  2. df = pd.DataFrame({'site':['google', 'baidu', 'wiki'],
  3. 'age':[18, 39, 22],
  4. 'price': [1.0, 2.0, 3.0],
  5. 'color': ['red', 'black', None]})
  6. df.iloc[:, lambda df: [0, 2]]
  7. ------------------------------------------------------------
  8. site price
  9. 0 google 1.0
  10. 1 baidu 2.0
  11. 2 wiki 3.0