Python pandas slice dataframe by multiple index ranges

by

You can use numpy’s r_ “slicing trick”:

df = pd.DataFrame({'a':range(10,100)})
df.iloc[pd.np.r_[10:12, 25:28]]

NOTE: this now gives a warning The pandas.np module is deprecated and will be removed from pandas in a future version. Import numpy directly instead. To do that, you can import numpy as np and then slice the following way:

df.iloc[np.r_[10:12, 25:28]]

This gives:

     a
10  20
11  21
25  35
26  36
27  37

More Related Contents:

  1. How to query MultiIndex index columns values in pandas
  2. How are iloc and loc different?
  3. Select rows in pandas MultiIndex DataFrame
  4. pandas loc vs. iloc vs. at vs. iat?
  5. How to reset index in a pandas dataframe? [duplicate]
  6. What rules does Pandas use to generate a view vs a copy?
  7. How to avoid Python/Pandas creating an index in a saved csv?
  8. What is the difference between using squared brackets or dot to access a column?
  9. how do I insert a column at a specific column index in pandas?
  10. Pandas – Slice large dataframe into chunks
  11. What is the performance impact of non-unique indexes in pandas?
  12. Python Pandas: Get index of rows which column matches certain value
  13. Remove index name in pandas
  14. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  15. What is the point of indexing in pandas?
  16. How to extract an arbitrary line of values from a numpy array?
  17. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  18. Why does indexing numpy arrays with brackets and commas differ in behavior?
  19. Insert element in Python list after every nth element
  20. Pandas – Compute z-score for all columns
  21. How to avoid pandas creating an index in a saved csv
  22. Get first row value of a given column
  23. How to slice a pandas DataFrame by position?
  24. Using replace efficiently in pandas
  25. In Python pandas, start row index from 1 instead of zero without creating additional column
  26. Slicing multiple ranges of columns in Pandas, by list of names
  27. Selecting a range of columns in a dataframe
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. What’s the alternative to pandas chain indexing?
  30. start index at 1 for Pandas DataFrame

Leave a Comment