我想my_df使用以下規則限制我的資料框：如果一個省的所有日期都在 26/09 之前或之后，則應將其洗掉，如desired_df
my_df <- data.frame(Province=c(1, 1, 1, 1, 1, 2, 2, 2, 2, 3, 3, 4, 4, 4),
date=c("23/09", "24/09", "25/09", "26/09", "27/09", "18/09","21/09", "23/09", "26/09", "29/09", "02/10", "25/09", "26/09", "27/09"))
desired_df <- data.frame(Province=c(1, 1, 1, 1, 1, 4, 4, 4),
date=c("23/09", "24/09", "25/09", "26/09", "27/09", "25/09", "26/09", "27/09"))
uj5u.com熱心網友回復：
使用dplyr
date2我為過濾任意變異date。
my_df <- my_df %>% mutate(date2=as.Date(date,'%d/%m'))
my_df %>% group_by(Province) %>%
filter(min(date2) < as.Date('2022-09-26'),
max(date2) > as.Date('2022-09-26')) %>%
ungroup() %>%
select(-date2)
輸出
# A tibble: 8 x 2
Province date
<dbl> <chr>
1 1 23/09
2 1 24/09
3 1 25/09
4 1 26/09
5 1 27/09
6 4 25/09
7 4 26/09
8 4 27/09
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/464027.html