Summarise a set of dates contained in a column

Question

I have a dataset with transactions made from 2018/07/01 to 2019/06/30 and I want to find how many unique dates are in the "DATE" column (it has over 260k rows, so a date can be repeated several times).

I have tried the following but it just lists all the dates contained in the "DATE" column:

numberofdates <- dplyr::summarize(transactionData, DATE)

Thanks for your help!

Try `length(unique(transactionData$DATE))` – Duck Sep 15 '20 at 14:48 — Duck, Sep 15 '20 at 14:48

score 0 · Accepted Answer · answered Sep 15 '20 at 14:53

0

Try one of these approaches:

In dplyr:

library(dplyr)
#Code 1
numberofdates <- transactionData %>% summarize(n_distinct(DATE))

Or in base R:

#Code 2
length(unique(transactionData$DATE))

answered Sep 15 '20 at 14:53

Duck

39,058
13
42
84

This is exactly what I was looking for, thanks! – AbetR Sep 15 '20 at 14:59

score 0 · Answer 2 · answered Sep 15 '20 at 17:26

0

With data.table we can use

 library(data.table)
 numberofdates <- uniqueN(transactionData$DATE)

answered Sep 15 '20 at 17:26

akrun

874,273
37
540
662

Summarise a set of dates contained in a column

2 Answers2