I'm struggling with a functions (apologies if I've created an incorrect tag or subject name - I'm still getting familiar with the functions.
I have a dataset I'm trying to 'condense' (I don't know if that's the right term) but essentially I'm looking to reduce the amount of observations by arranging, thickening (to hours) then summarising the data, but I lose some of the information. I think that either summarise is the wrong function or I'm using incorrectly.
See example of tabled info below:
I'm trying to condense the data by hour, but I want to keep the 'site' column. When I perform the following, I get the summarised information but it cuts off the 'site' reference. Can anyone point out my obvious mistake please?
data_400_hour <- data_400_f5 %>%
padr::thicken(interval = "hours") %>%
mutate(SampleNo = row_number()) %>%
summarise(AvActSpd = median("GG SPEED"))