Skip to content
Back to formatted view

Raw Message

Message-ID: <CANdqJqcQ8AYa3_YeUcY8nBruq1rTycEMVLcy_fdvxc9FinKtRA@mail.gmail.com>
Date: 2021-07-22T03:12:49Z
From: N. F. Parsons
Subject: Assigning categorical values to dates

Hi all,

If I have a tibble as follows:

tibble(dates = c(rep("2021-07-04", 2),  rep("2021-07-25", 3),
rep("2021-07-18", 4)))

how in the world do I add a column that evaluates each of those dates and
assigns it a categorical value such that

dates                cycle
<chr>               <chr>
2021-07-04      1
2021-07-04      1
2021-07-25      3
2021-07-25      3
2021-07-25      3
2021-07-18      2
2021-07-18      2
2021-07-18      2
2021-07-18      2

Not to further complicate matters, but some months I may only have one
date, and some months I will have 4 dates - so thats not a fixed quantity.
We've literally been doing this by hand at my job and I'd like to automate
it.

Thanks in advance!

Nate Parsons

	[[alternative HTML version deleted]]