how to use dcast on a dataframe that has only 1 row in R

Question

Hi I have a dataframe like this

Start <- c("A")
End <- c("C")
Days <- c("Day1")

df2 <- data.frame(Start,End,Days)

I am trying to use dcast

df2 <- dcast(df2,Days ~ End,value.var="Days")

but it returns is

  Days    C
1 Day1 Day1

My desired output is the count

  Days    C
1 Day1    1

What am I missing here? Kindly provide some inputs on this. Is there a better way to do this using dplyr?

Where is the `1` supposed to come from? The row number? – alistaire Feb 03 '16 at 02:52 — alistaire, Feb 03 '16 at 02:52
It's the count of how many C's – Sharath Feb 03 '16 at 02:57 — Sharath, Feb 03 '16 at 02:57

akrun · Accepted Answer · 2016-02-03T03:01:32.943

1

We can create a sequence column of 1 and then use dcast

 dcast(transform(df2, i1=1), Days~End, value.var='i1')
#  Days C
#1 Day1 1

Or another option is using the fun.aggregate

dcast(df2, Days~End, length)
#  Days C
#1 Day1 1

As the OP mentioned about dplyr, it involves using the first method as it doesn't have the fun.aggregate

 library(dplyr)
 df2 %>%
    mutate(C=1) %>%
    select(Days:C)

edited Feb 03 '16 at 03:01

answered Feb 03 '16 at 02:52

akrun

874,273
37
540
662

score 1 · Answer 2 · answered Feb 03 '16 at 02:54

1

Hi you are on the right track. What you need when you cast your data frame is to have a function that is applied to the aggregation during the casting.

In this case , you want something that counts the occurence of each group to do so you use the function length

dcast(df2,Days ~ End, length ) # or dcast(df, Days ~ End, table)

answered Feb 03 '16 at 02:54

biobirdman

4,060
1
17
15

You were right. length is what I was missing there. Thanks @biobirdman – Sharath Feb 03 '16 at 02:58

how to use dcast on a dataframe that has only 1 row in R

2 Answers2