[R] dplyr help

Jeff Newmiller jdnewmil at dcn.davis.ca.us
Tue Jul 11 13:45:03 CEST 2017


A better thanks would be to post the solution that met your needs... particularly since in spite of our efforts it appears we may not have understood your problem. A small sample data set generated with dput along with your code would be helpful in making sure others learn along with you. 
-- 
Sent from my phone. Please excuse my brevity.

On July 11, 2017 12:56:45 AM PDT, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote:
>Thank you very much for the support.  I have just used the reshape
>library and my problem was solved.
>
>Kind regards,
>
>Peter
>
>-----Original Message-----
>From: Jeff Newmiller [mailto:jdnewmil at dcn.davis.ca.us] 
>Sent: 10 July 2017 03:52 PM
>To: r-help at r-project.org; Mangalani Peter Makananisa;
>r-help at r-project.org
>Cc: Vito Ricci (vito_ricci at yahoo.com)
>Subject: Re: [R] dplyr help
>
>I am pretty sure that this is not a question about dplyr... it is a
>question about tidyr. Look at the help file ?tidyr::spread.
>
>If I understand your question (I may not,  because you gave no example
>of input/output data), the answer is no, the column names come from the
>column named by the key parameter and the values that fill those
>columns come from the column named by the value parameter. Modify your
>data frame to contain both columns before using this function.
>
>When the function is used outside a pipe chain there is also the first
>argument, the data frame that is being reshaped.
>
>Please post using plain text in the future... this is a plain text
>mailing list,  and HTML email is what-you-see-is-not-what-we-see.
>--
>Sent from my phone. Please excuse my brevity.
>
>On July 10, 2017 1:29:41 AM PDT, Mangalani Peter Makananisa
><pmakananisa at sars.gov.za> wrote:
>>HI all,
>>
>>Is it possible to use one column spread on multiple columns values.
>>
>>example
>>spread( Key_col, value1:value7)
>>
>>spreading Key_col to variable value1, value2, ....... Value7
>>
>>Please advise,
>>
>>Kind regards
>>
>>Mangalani Peter Makananisa (5786)
>>South African Revenue Service (SARS) - HO
>>+2782 456 4669 / +2712 422 7357
>>
>>Please Note: This email and its contents are subject to our email
>legal 
>>notice which can be viewed at 
>>http://www.sars.gov.za/Pages/Email-disclaimer.aspx
>>
>>	[[alternative HTML version deleted]]
>>
>>______________________________________________
>>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see 
>>https://stat.ethz.ch/mailman/listinfo/r-help
>>PLEASE do read the posting guide
>>http://www.R-project.org/posting-guide.html
>>and provide commented, minimal, self-contained, reproducible code.
>
>Please Note: This email and its contents are subject to our email legal
>notice which can be viewed at
>http://www.sars.gov.za/Pages/Email-disclaimer.aspx



More information about the R-help mailing list