Date <- c("Q1 2005", "Q1 2006","Q1 2007","Q1 2008","Q2 2005", "Q2 2006","Q2 2007","Q2 2008","Q3 2005", "Q3 2006","Q3 2007","Q3 2008","Q4 2005", "Q4 2006","Q4 2007","Q4 2008")

我需要按时间顺序排序。

最佳答案

另一种方法是:

library(dplyr)
libray(tidyr)
df %>% 
  separate(Date, c("Quarter", "Year"), remove = FALSE) %>% 
  arrange(Year, Quarter) %>% 
  select(-Quarter, -Year)

      Date
1  Q1 2005
2  Q2 2005
3  Q3 2005
4  Q4 2005
5  Q1 2006
6  Q2 2006
7  Q3 2006
8  Q4 2006
9  Q1 2007
10 Q2 2007
11 Q3 2007
12 Q4 2007
13 Q1 2008
14 Q2 2008
15 Q3 2008
16 Q4 2008

数据:

df <- data.frame(Date = c("Q1 2005", "Q1 2006","Q1 2007","Q1 2008","Q2 2005", "Q2 2006","Q2 2007","Q2 2008","Q3 2005", "Q3 2006","Q3 2007","Q3 2008","Q4 2005", "Q4 2006","Q4 2007","Q4 2008"))

https://stackoverflow.com/questions/69501712/