gss_cat %>% distinct(race)
## # A tibble: 3 × 1
## race
## <fct>
## 1 White
## 2 Black
## 3 Other
# Recode
gss_cat %>%
# Rename levels
mutate(race_rev = fct_recode(race, "African American" = "Black")) %>%
select(race, race_rev) %>%
filter(race == "Black")
## # A tibble: 3,129 × 2
## race race_rev
## <fct> <fct>
## 1 Black African American
## 2 Black African American
## 3 Black African American
## 4 Black African American
## 5 Black African American
## 6 Black African American
## 7 Black African American
## 8 Black African American
## 9 Black African American
## 10 Black African American
## # ℹ 3,119 more rows
# Collapse multiple levels into one
gss_cat %>%
mutate(race_col = fct_collapse(race, "Minority" = c("Black", "Other"))) %>%
select(race, race_col) %>%
filter(race != "White")
## # A tibble: 5,088 × 2
## race race_col
## <fct> <fct>
## 1 Black Minority
## 2 Black Minority
## 3 Black Minority
## 4 Other Minority
## 5 Black Minority
## 6 Other Minority
## 7 Black Minority
## 8 Other Minority
## 9 Black Minority
## 10 Black Minority
## # ℹ 5,078 more rows
# Lump small levels into other levels
gss_cat %>% count(race)
## # A tibble: 3 × 2
## race n
## <fct> <int>
## 1 Other 1959
## 2 Black 3129
## 3 White 16395
gss_cat %>% mutate(race_lump = fct_lump(race)) %>% distinct(race_lump)
## # A tibble: 2 × 1
## race_lump
## <fct>
## 1 White
## 2 Other
# From strings
"2026-11-18" %>% ymd()
## [1] "2026-11-18"
# From numbers
20261118 %>% ymd()
## [1] "2026-11-18"
"2026-11-18 4-41-30" %>% ymd_hms()
## [1] "2026-11-18 04:41:30 UTC"
flights %>%
select(year:day, hour, minute) %>%
mutate(departure = make_datetime(year = year, month = month, day = day, hour = hour, min = minute))
## # A tibble: 336,776 × 6
## year month day hour minute departure
## <int> <int> <int> <dbl> <dbl> <dttm>
## 1 2013 1 1 5 15 2013-01-01 05:15:00
## 2 2013 1 1 5 29 2013-01-01 05:29:00
## 3 2013 1 1 5 40 2013-01-01 05:40:00
## 4 2013 1 1 5 45 2013-01-01 05:45:00
## 5 2013 1 1 6 0 2013-01-01 06:00:00
## 6 2013 1 1 5 58 2013-01-01 05:58:00
## 7 2013 1 1 6 0 2013-01-01 06:00:00
## 8 2013 1 1 6 0 2013-01-01 06:00:00
## 9 2013 1 1 6 0 2013-01-01 06:00:00
## 10 2013 1 1 6 0 2013-01-01 06:00:00
## # ℹ 336,766 more rows
# From date to date-time
today() %>% as_datetime()
## [1] "2026-11-18 UTC"
# From date-time to date
now() %>% as_date()
## [1] "2026-11-18"
date_time <- ymd_hms("2026-11-18 18-18-18")
date_time
## [1] "2026-11-18 18:18:18 UTC"
year(date_time)
## [1] 2026
month(date_time, label = TRUE, abbr = FALSE)
## [1] November
## 12 Levels: January < February < March < April < May < June < ... < December
yday(date_time)
## [1] 322
mday(date_time)
## [1] 18
wday(date_time, label = TRUE, abbr = FALSE)
## [1] Wednesday
## 7 Levels: Sunday < Monday < Tuesday < Wednesday < Thursday < ... < Saturday
# Create flights_dt
make_datetime_100 <- function(year, month, day, time) {
make_datetime(year, month, day, time %/% 100, time %% 100)
}
flights_dt <- flights %>%
filter(!is.na(dep_time), !is.na(arr_time)) %>%
mutate(
dep_time = make_datetime_100(year, month, day, dep_time),
arr_time = make_datetime_100(year, month, day, arr_time),
sched_dep_time = make_datetime_100(year, month, day, sched_dep_time),
sched_arr_time = make_datetime_100(year, month, day, sched_arr_time)
) %>%
select(origin, dest, ends_with("delay"), ends_with("time"))
flights_dt %>%
transmute(wday = wday(dep_time, label = TRUE)) %>%
ggplot(aes(wday)) +
geom_bar()
# floor_data for rounding down
flights_dt %>%
mutate(week = floor_date(dep_time, "week")) %>%
select(dep_time, week) %>%
slice(2000:2010) %>%
sample_n(10)
## # A tibble: 10 × 2
## dep_time week
## <dttm> <dttm>
## 1 2013-01-03 09:12:00 2012-12-30 00:00:00
## 2 2013-01-03 09:14:00 2012-12-30 00:00:00
## 3 2013-01-03 09:23:00 2012-12-30 00:00:00
## 4 2013-01-03 09:11:00 2012-12-30 00:00:00
## 5 2013-01-03 09:17:00 2012-12-30 00:00:00
## 6 2013-01-03 09:14:00 2012-12-30 00:00:00
## 7 2013-01-03 09:23:00 2012-12-30 00:00:00
## 8 2013-01-03 09:13:00 2012-12-30 00:00:00
## 9 2013-01-03 09:23:00 2012-12-30 00:00:00
## 10 2013-01-03 09:16:00 2012-12-30 00:00:00
# floor_data for rounding up
flights_dt %>%
mutate(week = ceiling_date(dep_time, "week")) %>%
select(dep_time, week) %>%
slice(2000:2010) %>%
sample_n(10)
## # A tibble: 10 × 2
## dep_time week
## <dttm> <dttm>
## 1 2013-01-03 09:23:00 2013-01-06 00:00:00
## 2 2013-01-03 09:11:00 2013-01-06 00:00:00
## 3 2013-01-03 09:23:00 2013-01-06 00:00:00
## 4 2013-01-03 09:12:00 2013-01-06 00:00:00
## 5 2013-01-03 09:23:00 2013-01-06 00:00:00
## 6 2013-01-03 09:14:00 2013-01-06 00:00:00
## 7 2013-01-03 09:17:00 2013-01-06 00:00:00
## 8 2013-01-03 09:13:00 2013-01-06 00:00:00
## 9 2013-01-03 09:14:00 2013-01-06 00:00:00
## 10 2013-01-03 09:16:00 2013-01-06 00:00:00
flights_dt %>%
mutate(dep_hour = update(dep_time, yday = 1)) %>%
select(dep_time, dep_hour) %>%
sample_n(10)
## # A tibble: 10 × 2
## dep_time dep_hour
## <dttm> <dttm>
## 1 2013-03-14 14:58:00 2013-01-01 14:58:00
## 2 2013-03-23 16:13:00 2013-01-01 16:13:00
## 3 2013-05-01 06:24:00 2013-01-01 06:24:00
## 4 2013-11-05 19:36:00 2013-01-01 19:36:00
## 5 2013-06-30 13:00:00 2013-01-01 13:00:00
## 6 2013-09-10 18:50:00 2013-01-01 18:50:00
## 7 2013-06-04 12:45:00 2013-01-01 12:45:00
## 8 2013-02-24 20:23:00 2013-01-01 20:23:00
## 9 2013-02-07 10:15:00 2013-01-01 10:15:00
## 10 2013-01-03 16:05:00 2013-01-01 16:05:00