Row-wise average for a subset of columns with missing values

by

You can simply:

df['avg'] = df.mean(axis=1)

       Monday  Tuesday  Wednesday        avg
Mike       42      NaN         12  27.000000
Jenna     NaN      NaN         15  15.000000
Jon        21        4          1   8.666667

because .mean() ignores missing values by default: see docs.

To select a subset, you can:

df['avg'] = df[['Monday', 'Tuesday']].mean(axis=1)

       Monday  Tuesday  Wednesday   avg
Mike       42      NaN         12  42.0
Jenna     NaN      NaN         15   NaN
Jon        21        4          1  12.5

More Related Contents:

  1. Pandas – How to flatten a hierarchical index in columns
  2. How to groupby consecutive values in pandas DataFrame
  3. How to extract multiple JSON objects from one file?
  4. Sorting columns in pandas dataframe based on column name [duplicate]
  5. Pandas DataFrame stored list as string: How to convert back to list
  6. How to shift a column in Pandas DataFrame
  7. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  8. Find maximum value of a column and return the corresponding row values using Pandas
  9. Merge multiple column values into one column in python pandas
  10. How do I get the row count of a Pandas DataFrame?
  11. Dataframe set_index not setting
  12. Pandas dataframe fillna() only some columns in place
  13. Apply CSS class to Pandas DataFrame using to_html
  14. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  15. How can I replicate rows in Pandas?
  16. OSError: Initializing from file failed on csv in Pandas
  17. Convert column to row in Python Pandas
  18. How to create a DataFrame of random integers with Pandas?
  19. Putting many python pandas dataframes to one excel worksheet
  20. Remove Unnamed columns in pandas dataframe [duplicate]
  21. Find difference between two data frames
  22. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  23. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  24. Remove row with null value from pandas data frame
  25. Calculate summary statistics of columns in dataframe
  26. How to use str.contains() with multiple expressions in pandas dataframes
  27. Check if certain value is contained in a dataframe column in pandas [duplicate]
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment