How to select all columns except one in pandas?

by

When the columns are not a MultiIndex, df.columns is just an array of column names so you can do:

df.loc[:, df.columns != 'b']

          a         c         d
0  0.561196  0.013768  0.772827
1  0.882641  0.615396  0.075381
2  0.368824  0.651378  0.397203
3  0.788730  0.568099  0.869127

More Related Contents:

  1. Split / Explode a column of dictionaries into separate columns with pandas
  2. How to split a dataframe string column into two columns?
  3. Annotate bars with values on Pandas bar plots
  4. Comparing two dataframes and getting the differences [duplicate]
  5. plot different color for different categorical levels using matplotlib
  6. Counting consecutive positive values in Python/pandas array
  7. Pandas GroupBy and select rows with the minimum value in a specific column
  8. Pandas Dataframe: Replacing NaN with row average
  9. How to read a .xlsx file using the pandas Library in iPython?
  10. Pandas – Number of Months Between Two Dates
  11. Convert list into a pandas data frame
  12. Take the sum of every N rows in a pandas series
  13. Convert pandas data frame to series
  14. Pandas DataFrame merge summing column
  15. Mapping ranges of values in pandas dataframe [duplicate]
  16. Pandas can’t read hdf5 file created with h5py
  17. Binning a column with pandas
  18. Plotting a stacked Bar Chart
  19. Get first row value of a given column
  20. ValueError: view limit minimum -35738.3640567 is less than 1 and is an invalid Matplotlib date value
  21. Convert month int to month name in Pandas
  22. Pandas Passing Variable Names into Column Name
  23. How to plot percentage with seaborn distplot / histplot / displot
  24. Python pandas integer YYYYMMDD to datetime
  25. MemoryError when I merge two Pandas data frames
  26. Add numpy array as column to Pandas data frame
  27. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  28. Why is NaN considered as a float?
  29. Pandas Rolling Computations on Sliding Windows (Unevenly spaced)
  30. DataFrame object has no attribute append

Leave a Comment