pandas implements selecting rows at a specific index
Apr 20, 2018 pm 02:11 PMBelow 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!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Solving common pandas installation problems: interpretation and solutions to installation errors

Read CSV files and perform data analysis using pandas

How to read txt file correctly using pandas

Practical tips for reading txt files using pandas

Pandas easily reads data from SQL database

Revealing the efficient data deduplication method in Pandas: Tips for quickly removing duplicate data

Practical methods for reading web page data with Pandas
