Find the column name which has the maximum value for each row

by

You can use idxmax with axis=1 to find the column with the greatest value on each row:

>>> df.idxmax(axis=1)
0    Communications
1          Business
2    Communications
3    Communications
4          Business
dtype: object

To create the new column ‘Max’, use df['Max'] = df.idxmax(axis=1).

To find the row index at which the maximum value occurs in each column, use df.idxmax() (or equivalently df.idxmax(axis=0)).

More Related Contents:

  1. Find maximum value of a column and return the corresponding row values using Pandas
  2. Set maximum value (upper bound) in pandas DataFrame
  3. return max value from pandas dataframe as a whole, not based on column or rows
  4. Get max value from row of a dataframe in python [duplicate]
  5. Renaming column names in Pandas
  6. Import CSV file as a pandas DataFrame
  7. How to pivot a dataframe in Pandas? [duplicate]
  8. Get a list from Pandas DataFrame column headers
  9. Concatenate rows of two dataframes in pandas
  10. Normalize columns of pandas data frame
  11. How do I sum values in a column that match a given condition using pandas?
  12. Update a dataframe in pandas while iterating row by row
  13. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  14. Conditionally format Python pandas cell
  15. Changing multiple column names but not all of them – Pandas Python
  16. python pandas flatten a dataframe to a list
  17. How to create a dictionary of two pandas DataFrame columns
  18. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  19. Pandas dataframe – running sum with reset
  20. What is dtype(‘O’), in pandas?
  21. Move column by name to front of table in pandas
  22. Convert List to Pandas Dataframe Column
  23. How to merge a Series and DataFrame
  24. dataframe to dict such that one column is the key and the other is the value [duplicate]
  25. Is there a way to speed up handling large CSVs and dataframes in python?
  26. Got continuous is not supported error in RandomForestRegressor
  27. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  28. Get the row corresponding to the max in pandas GroupBy [duplicate]
  29. Copy text between parentheses in pandas DataFrame column into another column
  30. Get frequency of item occurrences in a column as percentage [duplicate]

Leave a Comment