[R] a simple reshape

Jeff Newmiller jdnewm|| @end|ng |rom dcn@d@v|@@c@@u@
Fri Apr 3 21:26:00 CEST 2020

Update your packages. If you still have issues post the output of sessionInfo().

On April 3, 2020 12:17:54 PM PDT, Yuan Chun Ding <ycding using coh.org> wrote:
>Hi Rui,
>Thanks a lot,
>i got this error, I have library(tidyverse).
>Error in pivot_wider(., id_cols = "vntr1", names_from = "group",
>names_prefix = "a",  : 
>  could not find function "pivot_wider" 
>From: Rui Barradas [ruipbarradas using sapo.pt]
>Sent: Friday, April 3, 2020 12:08 PM
>To: Yuan Chun Ding; r-help mailing list
>Subject: Re: [R] a simple reshape
>It's a bit more complicated than you have coded it.
>I will use pivot_wider, it's now the natural way of doing it.
>test1 %>%
>   group_by(vntr1) %>%
>   mutate(group = row_number()) %>%
>   ungroup() %>%
>   pivot_wider(
>     id_cols ="vntr1",
>     names_from = "group",
>     names_prefix = "a",
>     values_from = "val"
>   )
>Hope this helps,
>Rui Barradas
>Às 19:57 de 03/04/20, Yuan Chun Ding escreveu:
>> Hi R users,
>> I want to do a data reshape from long to wide, I thought it was easy
>using tidyverse spread function, but it did not work well. Can you help
>> Thank you,
>> Ding
>> test1 data frame is long file and test2 is the wide file I want to
>> test1 <- data.frame (vntr1=c("v1","v1", "v2","v2","v2","v2"),
>>                       val =c(0.98,0.02, 0.59,0.12,0.11,0.04))
>> test2  <- data.frame(vntr1=c("v1","v2"),
>>                       a1 =c(0.98, 0.5693),
>>                       a2 = c(0.02, 0.12),
>>                       a3 =c(NA, 0.11),
>>                       a4=c(NA, 0.04))
>> the following code does not work
>> test2 <-test1 %>%spread(vntr1, val)
>>   Error: Each row of output must be identified by a unique
>combination of keys.
>> Keys are shared for 6 rows:
>> * 1, 2
>> * 3, 4, 5, 6
>> Do you need to create unique ID with tibble::rowid_to_column()?
>> Call `rlang::last_error()` to see a backtrace
>> ------------------------------------------------------------
>> This message and any attachments are intended solely for the
>individual or entity to which they are addressed. This communication
>may contain information that is privileged, confidential, or exempt
>from disclosure under applicable law (e.g., personal health
>information, research data, financial information). Because this e-mail
>has been sent without encryption, individuals other than the intended
>recipient may be able to view the information, forward it to others or
>tamper with the information without the knowledge or consent of the
>sender. If you are not the intended recipient, or the employee or
>person responsible for delivering the message to the intended
>recipient, any dissemination, distribution or copying of the
>communication is strictly prohibited. If you received the communication
>in error, please notify the sender immediately by replying to this
>message and deleting the message and any accompanying files from your
>system. If, due to the security risks, you do not wish to receive
>further communications via e-mail, please reply to this message and
>inform the sender that you do not wish to receive further e-mail from
>the sender. (LCP301)
>> ______________________________________________
>> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

Sent from my phone. Please excuse my brevity.

More information about the R-help mailing list