Resample hourly TimeSeries with certain starting hour

by

Resample has an base argument which covers this case:

ts.resample(rule="24H", closed='left', label="left", base=17).sum()

Output:

2012-01-01 17:00:00    24
2012-01-02 17:00:00    24
2012-01-03 17:00:00    12
Freq: 24H

More Related Contents:

  1. How to change the order of DataFrame columns?
  2. Split pandas dataframe based on groupby
  3. Add missing dates to pandas dataframe
  4. pandas loc vs. iloc vs. at vs. iat?
  5. Pandas: sum DataFrame rows for given columns
  6. How to drop rows from pandas data frame that contains a particular string in a particular column? [duplicate]
  7. Find the end of the month of a Pandas DataFrame Series
  8. Vectorised Haversine formula with a pandas dataframe
  9. Read a small random sample from a big CSV file into a Python data frame
  10. How to concatenate two dataframes without duplicates?
  11. Most efficient way to forward-fill NaN values in numpy array
  12. Python Pandas replicate rows in dataframe
  13. Efficiently create sparse pivot tables in pandas?
  14. How to remove or hide x-axis labels from a seaborn / matplotlib plot
  15. Computing np.diff in Pandas after using groupby leads to unexpected result
  16. Remove NaN ‘Cells’ without dropping the entire ROW (Pandas,Python3)
  17. Large Dataset Polynomial Fitting Using Numpy
  18. Pandas converting row with unix timestamp (in milliseconds) to datetime
  19. Cumsum as a new column in an existing Pandas dataframe
  20. Deleting multiple columns based on column names
  21. Number rows within group in increasing order in a pandas dataframe
  22. Plot a bar plot from a Pandas DataFrame
  23. Difference between pivot and pivot_table. Why is only pivot_table working?
  24. Get part of day (morning, afternoon, evening, night) in Python dataframe
  25. Using replace efficiently in pandas
  26. Extract dictionary value from column in data frame
  27. Read data (.dat file) with Pandas
  28. Pandas: remove duplicates that exist in any order
  29. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x
  30. Numpy.dtype has the wrong size, try recompiling

Leave a Comment