I have a timeseries dataset with price variables and want to sort them. The time ist structured into quarter hours. So each group is marked by 4 rows. I want to sort the first two columns within each group. I used different codes, like order or arrange, but they weren't helpful. I hope someone of you, has a idea. Many thanks!
IIUC you want to sort your dataframe vy two variables, let's call them grp for the grouping variable (that you say in the comment to the other answer is already sorted) and value for the other one.
In base R you could do this:
df[order(df$grp, df$value), ]
And with dplyr (in the tidyverse):
library(dplyr)
df |> arrange(grp, value)
order() is a way to sort data frames, that should have worked. Consider sharing the code used--perhaps it is just a usage issue.
Another good way to sort if you're open to using to using data.table is with setkey(). For data.table you can use setkey() to sort, though it will always be ascending (unless descending setkey() ordering is ever added). For smaller datasets it doesn't much matter, but for larger datasets many operations will be faster with data.table than with data frames.
