How to calculate mean values grouped on another column in Pandas

by

You could groupby on StationID and then take mean() on BiasTemp. To output Dataframe, use as_index=False

In [4]: df.groupby('StationID', as_index=False)['BiasTemp'].mean()
Out[4]:
  StationID  BiasTemp
0        BB       5.0
1     KEOPS       2.5
2    SS0279      15.0

Without as_index=False, it returns a Series instead

In [5]: df.groupby('StationID')['BiasTemp'].mean()
Out[5]:
StationID
BB            5.0
KEOPS         2.5
SS0279       15.0
Name: BiasTemp, dtype: float64

Read more about groupby in this pydata tutorial.

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Convert DataFrame column type from string to datetime
  4. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  5. Can pandas automatically read dates from a CSV file?
  6. df.append() is not appending to the DataFrame
  7. pandas dataframe str.contains() AND operation
  8. Pandas groupby mean – into a dataframe?
  9. How to do/workaround a conditional join in python Pandas?
  10. How to check if a value is in the list in selection from pandas data frame?
  11. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  12. Get column index from column name in python pandas
  13. How to filter a dataframe of dates by a particular month/day?
  14. pandas DataFrame output end of csv
  15. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  16. Pandas compare next row
  17. Appending a list or series to a pandas DataFrame as a row?
  18. Loading multiple csv files of a folder into one dataframe
  19. Why is np.where faster than pd.apply
  20. Extract column value based on another column in Pandas
  21. Python Pandas: Get index of rows where column matches certain value
  22. Change the color of text within a pandas dataframe html table python using styles and css
  23. Row-wise average for a subset of columns with missing values
  24. Plot multiple columns of pandas DataFrame using Seaborn
  25. Dynamically filtering a pandas dataframe
  26. Remove ends of string entries in pandas DataFrame column
  27. How to convert DataFrame.append() to pandas.concat()?
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment