pandas implements selecting rows at a specific index

Below I will share with you a pandas implementation of selecting rows of a specific index. It has a good reference value and I hope it will be helpful to everyone. Come and take a look together

As shown below:

>>> import numpy as np
>>> import pandas as pd
>>> index=np.array([2,4,6,8,10])
>>> data=np.array([3,5,7,9,11])
>>> data=pd.DataFrame({'num':data},index=index)
>>> print(data)
  num
2   3
4   5
6   7
8   9
10  11
>>> select_index=index[index>5]
>>> print(select_index)
[ 6 8 10]
>>> data['num'].loc[select_index]
6   7
8   9
10  11
Name: num, dtype: int32
>>>

Note that iloc cannot be used. iloc accesses the sequence as an array, and the subscript will start from 0:

>>> data['num'].iloc[2:5] 
6   7 
8   9 
10  11 
Name: num, dtype: int32 
>>> data['num'].iloc[[2,3,4]] 
6   7 
8   9 
10  11 
Name: num, dtype: int32 
>>>

Related recommendations:

Method for selecting rows and columns based on pandas data samples

pandas groupby grouping method to select the first few rows of each group to record

The above is the detailed content of pandas implements selecting rows at a specific index. For more information, please follow other related articles on the PHP Chinese website!