Get column name where value is something in pandas dataframe

by

Just wanted to add that for a situation where multiple columns may have the value and you want all the column names in a list, you can do the following (e.g. get all column names with a value=”x”):

df.apply(lambda row: row[row == 'x'].index, axis=1)

The idea is that you turn each row into a series (by adding axis=1) where the column names are now turned into the index of the series. You then filter your series with a condition (e.g. row == 'x'), then take the index values (aka column names!).

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. How to change the order of DataFrame columns?
  3. Filter dataframe rows if value in column is in a set list of values [duplicate]
  4. Add missing dates to pandas dataframe
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. Pandas: sum DataFrame rows for given columns
  7. String concatenation of two pandas columns
  8. datetime dtypes in pandas read_csv
  9. Pandas DataFrame: replace all values in a column, based on condition
  10. Pandas – Slice large dataframe into chunks
  11. Calculate average of every x rows in a table and create new table
  12. Find column name in pandas that matches an array
  13. Removing prefix from column names in Pandas
  14. Python Pandas replicate rows in dataframe
  15. pandas get the row-wise minimum value of two or more columns
  16. Set maximum value (upper bound) in pandas DataFrame
  17. Normalizing pandas DataFrame rows by their sums
  18. How to merge multiple dataframes
  19. How can I get a value from a cell of a dataframe?
  20. Extract int from string in Pandas
  21. How to add header row to a pandas DataFrame
  22. Cumsum as a new column in an existing Pandas dataframe
  23. Plot a bar plot from a Pandas DataFrame
  24. creating a column which keeps a running count of consecutive values
  25. How to drop column according to NAN percentage for dataframe?
  26. Using replace efficiently in pandas
  27. Extracting dates that are in different formats using regex and sorting them – pandas
  28. Returning multiple values from pandas apply on a DataFrame
  29. Pandas DataFrame search is linear time or constant time?
  30. case_when function from R to Python

Leave a Comment