Having aggregated data - wanna have data for each element

Question

Hei,

My aim is to do a histogramm.

Therefor I need unaggregated data - but unfortunately I only have it in aggregated form.

My data:

tribble(~date,~groupsize,
"2020-09-01",3,
"2020-09-02",2,
"2020-09-03",1,
"2020-09-04",2)

I want to have:

tribble(~date,~n,
        "2020-09-01",1,
        "2020-09-01",1,
        "2020-09-01",1,
        "2020-09-02",1,
        "2020-09-02",1,
        "2020-09-01",1,
        "2020-09-04",1,
        "2020-09-04",1)

I think this is really simple, but I am at a loss. Sorry for that!

What can I do? I really like dplyr solutions :-)

Thank you!

`tidyr::uncount(df, groupsize)` – Ronak Shah Sep 22 '20 at 10:14 — Ronak Shah, Sep 22 '20 at 10:14
Thank you - i didn't know uncount. – Volker Holzendorf Sep 22 '20 at 10:21 — Volker Holzendorf, Sep 22 '20 at 10:21

score 0 · Answer 1 · answered Sep 22 '20 at 10:19

repeat the date according to groupsize.

res <- data.frame(date=rep(dat$date, dat$groupsize), n=1)
res
#         date n
# 1 2020-09-01 1
# 2 2020-09-01 1
# 3 2020-09-01 1
# 4 2020-09-02 1
# 5 2020-09-02 1
# 6 2020-09-03 1
# 7 2020-09-04 1
# 8 2020-09-04 1

Having aggregated data - wanna have data for each element

1 Answers1