Select multiple ranges of columns in Pandas DataFrame

by

use np.r_

np.r_[1:10, 15, 17, 50:100]

array([ 1,  2,  3,  4,  5,  6,  7,  8,  9, 15, 17, 50, 51, 52, 53, 54, 55,
       56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72,
       73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89,
       90, 91, 92, 93, 94, 95, 96, 97, 98, 99])

so you can do

df.iloc[:, np.r_[1:10, 15, 17, 50:100]]

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Split (explode) pandas dataframe string entry to separate rows
  3. Convert pandas dataframe to NumPy array
  4. Binning a column with Python Pandas
  5. Performant cartesian product (CROSS JOIN) with pandas
  6. Pandas read_csv low_memory and dtype options
  7. How to take column-slices of dataframe in pandas
  8. replace() method not working on Pandas DataFrame
  9. Numpy “where” with multiple conditions
  10. How to map numeric data into categories / bins in Pandas dataframe
  11. Coalesce values from 2 columns into a single column in a pandas dataframe
  12. Conditionally fill column values based on another columns value in pandas
  13. How can I map True/False to 1/0 in a Pandas DataFrame?
  14. How to check if a value is in the list in selection from pandas data frame?
  15. Pandas finding local max and min
  16. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  17. Pandas lookup from one of multiple columns, based on value
  18. ‘DataFrame’ object has no attribute ‘sort’
  19. python pandas flatten a dataframe to a list
  20. how do I calculate a rolling idxmax
  21. What is dtype(‘O’), in pandas?
  22. vectorize conditional assignment in pandas dataframe
  23. Why is np.where faster than pd.apply
  24. Binning a column with pandas
  25. Unpivot Pandas Data
  26. Get first and second highest values in pandas columns
  27. Store numpy.array in cells of a Pandas.DataFrame
  28. Python pandas: how to remove nan and -inf values
  29. Filtering pandas dataframe with multiple Boolean columns
  30. What’s the best way to sum all values in a Pandas dataframe? [duplicate]

Leave a Comment