我正在处理这个由id
和date
个变量组成的数据框架.
structure(list(id = c("1000", "1000", "1000", "1000", "1000",
"1000", "1000", "1000", "1000", "1000", "1000", "1000", "1000",
"1000", "1000", "1000", "1000", "1000"), Date = c("2022-01-18",
"2022-01-18", "2022-01-18", "1/20/2022", "1/20/2022", "2022-02-25",
"2022-03-04", "2022-03-12", "2022-03-15", "2022-03-21", "2022-03-21",
"2022-03-21", "2022-03-21", "2022-03-28", "3/30/2022", "3/30/2022",
"3/30/2022", "2022-04-07")), row.names = c(NA, -18L), class = c("tidytable",
"data.table", "data.frame"))
这个数据集有一点很奇怪,那就是date
列.有时是m/d/y格式,有时是y-m-d格式.我更喜欢R中使用的第二种格式.
因为列不匹配,所以我很难对数据框进行排序,从而将两种不同的日期格式分开.有什么操作可以将日期格式转换为y-m-d格式吗?像ifelse(date = m/d/y, (transform it to)y-m-d, (otherwise leave it the same as)y-m-d))
这样的东西(伪代码)?