I have the following DataFrame called prices: DateTime PriceAmountGBP 0 2022-03-27 23:00:00 202.807890 1 2022-03-28 00:00:00 197.724150 2 2022-03-28 01:00:00 191.615328 3 2022-03-28 02:00:00 188.798436 4 2022-03-28 03:00:00 187.706682 … … … 19 2023-01-24 18:00:00 216.915400 20 2023-01-24 19:00:00 197.050516 21 2023-01-24 20:00:00 168.227992 22 2023-01-24 21:00:00 158.954200 23 2023-01-24 22:00:00 149.039322 I’m trying to… Read More Resampling Hourly Data into Half Hourly in Pandas

I need to resample from a real (cluster) trial data set. So far, I have used the following PROC SURVEYSELECT procedure in SAS to sample 10 clusters from the trial with replacement, with 50% of clusters coming from the control arm and 50% coming from the treatment arm. I repeat this 100 times to get… Read More Create unique label for repeated units with PROC SURVEYSELECT in SAS

Suppose I have a dataframe like this import pandas as pd df = pd.DataFrame({‘ID’:[1,1,1,1,1,2,2,2,2], ‘Order’:[1,2,3,4,5,1,2,3,4]}) df ID Order 0 1 1 1 1 2 2 1 3 3 1 4 4 1 5 5 2 1 6 2 2 7 2 3 8 2 4 I need to upsample by entire blocks, so essentially creating… Read More upsampling entire groups in python