Python Pandas add column for row-wise max value of selected columns [duplicate]

by 
>>> frame['HighScore'] = frame[['test1','test2','test3']].max(axis=1)
>>> frame
    name  test1  test2  test3  HighScore
0   bill     85     35     51         85
1    joe     75     45     61         75
2  steve     85     83     45         85

More Related Contents:

  1. Python returns "SyntaxError: invalid syntax sys module" [closed]
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. How to display pandas DataFrame of floats using a format string for columns?
  4. Find the column name which has the maximum value for each row
  5. Reading an Excel file in python using pandas
  6. How do I create test and train samples from one dataframe with pandas?
  7. How to map numeric data into categories / bins in Pandas dataframe
  8. Check if a string in a Pandas DataFrame column is in a list of strings
  9. Naturally sorting Pandas DataFrame
  10. Find maximum value of a column and return the corresponding row values using Pandas
  11. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  12. converting currency with $ to numbers in Python pandas
  13. How to normalize json correctly by Python Pandas
  14. Improve Row Append Performance On Pandas DataFrames
  15. Use Multiple Character Delimiter in Python Pandas read_csv
  16. Merging dataframes based on date range
  17. Set maximum value (upper bound) in pandas DataFrame
  18. pandas: replace string with another string
  19. Pandas max value index
  20. return max value from pandas dataframe as a whole, not based on column or rows
  21. how to merge two data frames based on particular column in pandas python?
  22. How to solve import error for pandas?
  23. I want to multiply two columns in a pandas DataFrame and add the result into a new column
  24. pandas, melt, unmelt preserve index
  25. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  26. Python Pandas – Read csv file containing multiple tables
  27. Group DataFrame in 5-minute intervals
  28. Python Pandas: remove entries based on the number of occurrences
  29. How to filter a DataFrame column of lists for those that contain a certain item
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment