thr3ads.net - R help - [R] complex transformation of data [Jan 2011]

If this information is useful, please help other people find it:
Share via:

Den

2011-Jan-21 12:25 UTC

[R] complex transformation of data

Dear [R] people
Could you please help with following data transformation.
Any suggestions, hints, references and even guessing on performing any
of the following steps are highly appreciated. Those transformations are
crucial for my work. 

(n_, _n, j_, k_ signify numbers)

SOURCE DATA:   
id	cycle1	cycle2	cycle3	?	cycle_n
1	c	c	c		c
1	m	m	m		m
1	f	f	f		f
2	m	m	m		NA
2	f	f	f		NA
2	c	c	c		NA
3	a	a	NA		NA
3	c	c	c		NA
3	f	f	f		NA
3	NA	NA	m		NA
...........................................



RESULT DATA1:
id	cyc1	cyc2	cyc3	?	cyc_n
1	cfm	cfm	cfm		cfm
2	cfm	cfm	cfm		NA
3	acf	acf	cfm		NA
...........................................


RESULT DATA2:
id	treatment
1	n_cfm
2	j_cfm
3	2acf->k_cfm
...................


RESULT DATA3:
id	regimen	numOfCycles
1	cfm	n_
2	cfm	j_
3	asf->cfm	{2+k_}
.............................



Thank you
Denis

ONKELINX, Thierry

2011-Jan-21 14:25 UTC

head link

[R] complex transformation of data

Denis,

Have a look at paste(), aggregate(), ddply() (from the plyr package) and melt()
and cast() (both from the reshape package).

Best regards,

Thierry

----------------------------------------------------------------------------
ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek
team Biometrie & Kwaliteitszorg
Gaverstraat 4
9500 Geraardsbergen
Belgium

Research Institute for Nature and Forest
team Biometrics & Quality Assurance
Gaverstraat 4
9500 Geraardsbergen
Belgium

tel. + 32 54/436 185
Thierry.Onkelinx at inbo.be
www.inbo.be

To call in the statistician after the experiment is done may be no more than
asking him to perform a post-mortem examination: he may be able to say what the
experiment died of.
~ Sir Ronald Aylmer Fisher

The plural of anecdote is not data.
~ Roger Brinner

The combination of some data and an aching desire for an answer does not ensure
that a reasonable answer can be extracted from a given body of data.
~ John Tukey
  
> -----Oorspronkelijk bericht-----
> Van: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] Namens Den
> Verzonden: vrijdag 21 januari 2011 13:26
> Aan: R-help
> Onderwerp: [R] complex transformation of data
> 
> Dear [R] people
> Could you please help with following data transformation.
> Any suggestions, hints, references and even guessing on 
> performing any of the following steps are highly appreciated. 
> Those transformations are crucial for my work. 
> 
> (n_, _n, j_, k_ signify numbers)
> 
> SOURCE DATA:   
> id	cycle1	cycle2	cycle3	...	cycle_n
> 1	c	c	c		c
> 1	m	m	m		m
> 1	f	f	f		f
> 2	m	m	m		NA
> 2	f	f	f		NA
> 2	c	c	c		NA
> 3	a	a	NA		NA
> 3	c	c	c		NA
> 3	f	f	f		NA
> 3	NA	NA	m		NA
> ...........................................
> 
> 
> 
> RESULT DATA1:
> id	cyc1	cyc2	cyc3	...	cyc_n
> 1	cfm	cfm	cfm		cfm
> 2	cfm	cfm	cfm		NA
> 3	acf	acf	cfm		NA
> ...........................................
> 
> 
> RESULT DATA2:
> id	treatment
> 1	n_cfm
> 2	j_cfm
> 3	2acf->k_cfm
> ...................
> 
> 
> RESULT DATA3:
> id	regimen	numOfCycles
> 1	cfm	n_
> 2	cfm	j_
> 3	asf->cfm	{2+k_}
> .............................
> 
> 
> 
> Thank you
> Denis
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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.
>

Moritz Grenke

2011-Jan-21 14:46 UTC

head link

[R] complex transformation of data

Hi Denis, 

#minimal example:
test<-as.data.frame(list(id=c(1,1,1,2,2,2), cycle1=c("c",
"m", "f", "m",
"f", "c")))

#gettin your first cell of Result 1
paste(sort(test$cycle1[test$id==1]), collapse="")


Hope this helps for the first task ... 
Moritz

______________________
Moritz Grenke
http://www.360mix.de

-----Urspr?ngliche Nachricht-----
Von: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] Im
Auftrag von Den
Gesendet: Freitag, 21. Januar 2011 13:26
An: R-help
Betreff: [R] complex transformation of data

Dear [R] people
Could you please help with following data transformation.
Any suggestions, hints, references and even guessing on performing any
of the following steps are highly appreciated. Those transformations are
crucial for my work. 

(n_, _n, j_, k_ signify numbers)

SOURCE DATA:   
id	cycle1	cycle2	cycle3	
	cycle_n
1	c	c	c		c
1	m	m	m		m
1	f	f	f		f
2	m	m	m		NA
2	f	f	f		NA
2	c	c	c		NA
3	a	a	NA		NA
3	c	c	c		NA
3	f	f	f		NA
3	NA	NA	m		NA
...........................................



RESULT DATA1:
id	cyc1	cyc2	cyc3	
	cyc_n
1	cfm	cfm	cfm		cfm
2	cfm	cfm	cfm		NA
3	acf	acf	cfm		NA
...........................................


RESULT DATA2:
id	treatment
1	n_cfm
2	j_cfm
3	2acf->k_cfm
...................


RESULT DATA3:
id	regimen	numOfCycles
1	cfm	n_
2	cfm	j_
3	asf->cfm	{2+k_}
.............................



Thank you
Denis

______________________________________________
R-help at r-project.org mailing list
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.

Henrique Dallazuanna

2011-Jan-21 16:16 UTC

head link

[R] complex transformation of data

Try this:

aggregate(.~ id, lapply(test, as.character), FUN = paste, collapse =
"")

On Fri, Jan 21, 2011 at 10:25 AM, Den <d.kazakiewicz@gmail.com> wrote:
> Dear [R] people
> Could you please help with following data transformation.
> Any suggestions, hints, references and even guessing on performing any
> of the following steps are highly appreciated. Those transformations are
> crucial for my work.
>
> (n_, _n, j_, k_ signify numbers)
>
> SOURCE DATA:
> id      cycle1  cycle2  cycle3  …       cycle_n
> 1       c       c       c               c
> 1       m       m       m               m
> 1       f       f       f               f
> 2       m       m       m               NA
> 2       f       f       f               NA
> 2       c       c       c               NA
> 3       a       a       NA              NA
> 3       c       c       c               NA
> 3       f       f       f               NA
> 3       NA      NA      m               NA
> ...........................................
>
>
>
> RESULT DATA1:
> id      cyc1    cyc2    cyc3    …       cyc_n
> 1       cfm     cfm     cfm             cfm
> 2       cfm     cfm     cfm             NA
> 3       acf     acf     cfm             NA
> ...........................................
>
>
> RESULT DATA2:
> id      treatment
> 1       n_cfm
> 2       j_cfm
> 3       2acf->k_cfm
> ...................
>
>
> RESULT DATA3:
> id      regimen numOfCycles
> 1       cfm     n_
> 2       cfm     j_
> 3       asf->cfm        {2+k_}
> .............................
>
>
>
> Thank you
> Denis
>
> ______________________________________________
> R-help@r-project.org mailing list
> 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.
>


-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]

Reasonably Related Threads

Search for more reasonably related threads

R help - Jan 2011 - complex transformation of data

[R] complex transformation of data

[R] complex transformation of data

[R] complex transformation of data

[R] complex transformation of data

Reasonably Related Threads