How to resample a dataframe with different functions applied to each column?

by

With pandas 0.18 the resample API changed (see the docs).
So for pandas >= 0.18 the answer is:

In [31]: frame.resample('1H').agg({'radiation': np.sum, 'tamb': np.mean})
Out[31]: 
                         tamb   radiation
2012-04-05 08:00:00  5.161235  279.507182
2012-04-05 09:00:00  4.968145  290.941073
2012-04-05 10:00:00  4.478531  317.678285
2012-04-05 11:00:00  4.706206  335.258633
2012-04-05 12:00:00  2.457873    8.655838

Old Answer:

I am answering my question to reflect the time series related changes in pandas >= 0.8 (all other answers are outdated).

Using pandas >= 0.8 the answer is:

In [30]: frame.resample('1H', how={'radiation': np.sum, 'tamb': np.mean})
Out[30]: 
                         tamb   radiation
2012-04-05 08:00:00  5.161235  279.507182
2012-04-05 09:00:00  4.968145  290.941073
2012-04-05 10:00:00  4.478531  317.678285
2012-04-05 11:00:00  4.706206  335.258633
2012-04-05 12:00:00  2.457873    8.655838

More Related Contents:

  1. Pandas finding local max and min
  2. Split Python sequence (time series/array) into subsequences with overlap
  3. how to do multiple scatter plots with matploatlib
  4. Split (explode) pandas dataframe string entry to separate rows
  5. Binning a column with Python Pandas
  6. NumPy or Pandas: Keeping array type as integer while having a NaN value
  7. Performant cartesian product (CROSS JOIN) with pandas
  8. Best way to join / merge by range in pandas
  9. Numpy “where” with multiple conditions
  10. efficiently convert uneven list of lists to minimal containing array padded with nan
  11. ValueError: numpy.ndarray size changed, may indicate binary incompatibility. Expected 88 from C header, got 80 from PyObject
  12. float64 with pandas to_csv
  13. Cumsum reset at NaN
  14. Recursive definitions in Pandas
  15. extracting days from a numpy.timedelta64 value
  16. Vectorizing Haversine distance calculation in Python
  17. how do I calculate a rolling idxmax
  18. binning a dataframe in pandas in Python [duplicate]
  19. How do you plot a vertical line on a time series plot in Pandas?
  20. why does pandas rolling use single dimension ndarray
  21. pandas .plot() x-axis tick frequency — how can I show more ticks?
  22. Combine Date and Time columns using pandas
  23. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  24. Plot the x-axis as a date
  25. Store numpy.array in cells of a Pandas.DataFrame
  26. Python pandas: how to remove nan and -inf values
  27. Filtering pandas dataframe with multiple Boolean columns
  28. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  29. mean from pandas and numpy differ
  30. Convert Pandas dataframe to Sparse Numpy Matrix directly

Leave a Comment