subject:"\[R\] a replace for subset"

Re: [R] a replace for subset

2016-04-16 Thread Jeff Newmiller


On Sat, 16 Apr 2016, ch.elahe via R-help wrote:

-Thank you James, well the problem of my type of data is that there can 
be many possible subsets and therefore plots, and I want to 
automatically generate them, and facet_wrap does not give me all the 
possible cases


Not true.

It may get cramped, but it does give you all of the cases listed in the 
levels of the factor you plot with. If you specify a vector of character 
strings then ggplot will automatically convert it to a factor using only 
those cases present in the data. You can use the "factor" function to 
specify how you want the data represented more precisely than this 
automatic conversion will represent it. Read ?factor.


Note that if you have missing cases throughout, you may encounter 
difficulties plotting some graphs due to not having any data.




On Saturday, April 16, 2016 6:01 AM, James C. Whanger  
wrote:

Would facet_wrap or facet_grid give you what you want?

On Sat, Apr 16, 2016 at 8:45 AM, ch.elahe via R-help  
wrote:

Hi,

I have a data set (mydata), which a part of this is like the following:


'data.frame':   36190 obs. of 16 variables:
$ RE: int  38 41 11 67 30 18 38 41 41 30 ...
$ LU : int  4200 3330 530 4500 3000 1790 4700 3400 3640 
4000 ...
$ COUNTRY: Factor w/ 4 levels "DE","FR","JP", "FR"?
$Light  : Factor w/2 levels   "ON","OFF","ON", ?.
$OR : Factor w/2 levels   "S","T","S",?.
$PAT  : Factor w/3 levels   "low", "high", "middle",?.


Now I want to plot RE vs LU with ggplot2 for all the possible cases, I 
know how to do subsetting for the data but I want to know is there any 
shorter way to do that? For example I want to have a plot for RE vs LU 
for (COUNTRY= FR, Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, 
Light=on, OR=S, PAT=high) and ?., as you see doing subset is time 
consuming, is there any other way?

Thank you for any help.
Elahe


[...]

---
Jeff NewmillerThe .   .  Go Live...
DCN:Basics: ##.#.   ##.#.  Live Go...
  Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/BatteriesO.O#.   #.O#.  with
/Software/Embedded Controllers)   .OO#.   .OO#.  rocks...1k

__
R-help@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.

Re: [R] a replace for subset

2016-04-16 Thread Jeff Newmiller

Use the split function to automatically create a list of pre-subsetted 
data frames, and then generate your output however you wish to. For 
example (using Jim Lemon's sample data generator):


library(ggplot2)

mydata <- data.frame( RE = sample( 5:50, 100, TRUE)
, LU = sample( 1500:4500, 100 )
, COUNTRY = factor( sample( c( "DE","FR","JP","AU")
  , 100
  , TRUE
  )
  )
, Light = factor( sample( c( "ON", "OFF" )
, 100
, TRUE
)
)
, OR = factor( sample( c( "S", "T" )
 , 100
 , TRUE
 )
 )
, PAT = factor( sample( c( "low", "high", "middle" )
  ,100
  ,TRUE
  )
  )
)
# split wants you to specify a list of columns to create unique
# groups by;
# data frames are lists of columns;
# data frame indexing lets you specify a subset of columns
mydataList0 <- split( mydata
, mydata[ , c( "COUNTRY", "Light" ) ]
)
# you should use the str() function frequently in an interactive
# fashion to help you understand the data you are working with:
str( mydataList0 )

# if you try to specify a single column as a subset of columns,
# R will by default forget the "list of" aspect... to keep it, use 
# drop=FALSE

mydataList <- split( mydata
   , mydata[ , c( "COUNTRY" ), drop = FALSE ]
   )

# I happen to like packing information into a single plot where possible.
# Since you did not provide a minimial reproducible example, I cannot
# tell whether this will work for you. You can use some variant of 
# mydataList0 if you don't like this approach.

for ( idx in seq_along( mydataList ) ) {
print( ggplot( mydataList[[ idx ]], aes( x=RE, y=LU, shape=Light ) ) +
geom_point() +
facet_grid( PAT ~ OR ) +
ggtitle( paste( "Country ="
  , mydataList[[ idx ]][1,"COUNTRY"]))
)
}

For future reference, the Posting Guide mentions several good practices 
for asking questions online that will help you understand your own problem 
better as well as making it easier for us to provide answers.


On Sat, 16 Apr 2016, ch.elahe via R-help wrote:

Hi, 
I have a data set (mydata), which a part of this is like the following: 



'data.frame':   36190 obs. of 16 variables: 
$ RE: int  38 41 11 67 30 18 38 41 41 30 ... 
$ LU : int  4200 3330 530 4500 3000 1790 4700 3400 3640 4000 ... 
$ COUNTRY: Factor w/ 4 levels "DE","FR","JP", "FR"? 
$Light  : Factor w/2 levels   "ON","OFF","ON", ?. 
$OR : Factor w/2 levels   "S","T","S",?. 
$PAT  : Factor w/3 levels   "low", "high", "middle",?. 



Now I want to plot RE vs LU with ggplot2 for all the possible cases, I know how to do subsetting for the data but I want to know is there any shorter way to do that? For example I want to have a plot for RE vs LU for (COUNTRY= FR, Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, Light=on, OR=S, PAT=high) and ?., as you see doing subset is time consuming, is there any other way? 
Thank you for any help. 
Elahe


__
R-help@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.


---
Jeff NewmillerThe .   .  Go Live...
DCN:Basics: ##.#.   ##.#.  Live Go...
  Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/BatteriesO.O#.   #.O#.  with
/Software/Embedded Controllers)   .OO#.   .OO#.  rocks...1k

__
R-help@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.

Re: [R] a replace for subset

2016-04-16 Thread ch.elahe via R-help

-Thank you James, well the problem of my type of data is that there can be many 
possible subsets and therefore plots, and I want to automatically generate 
them, and facet_wrap does not give me all the possible cases




On Saturday, April 16, 2016 6:01 AM, James C. Whanger  
wrote:



Would facet_wrap or facet_grid give you what you want?


On Sat, Apr 16, 2016 at 8:45 AM, ch.elahe via R-help  
wrote:

Hi,
>I have a data set (mydata), which a part of this is like the following:
>
>
>'data.frame':   36190 obs. of 16 variables:
>$ RE: int  38 41 11 67 30 18 38 41 41 30 ...
>$ LU : int  4200 3330 530 4500 3000 1790 4700 3400 3640 
>4000 ...
>$ COUNTRY: Factor w/ 4 levels "DE","FR","JP", "FR"…
>$Light  : Factor w/2 levels   "ON","OFF","ON", ….
>$OR : Factor w/2 levels   "S","T","S",….
>$PAT  : Factor w/3 levels   "low", "high", "middle",….
>
>
>Now I want to plot RE vs LU with ggplot2 for all the possible cases, I know 
>how to do subsetting for the data but I want to know is there any shorter way 
>to do that? For example I want to have a plot for RE vs LU for (COUNTRY= FR, 
>Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, Light=on, OR=S, PAT=high) 
>and …., as you see doing subset is time consuming, is there any other way?
>Thank you for any help.
>Elahe
>
>__
>R-help@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.


-- 

James C. Whanger

__
R-help@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.

Re: [R] a replace for subset

2016-04-16 Thread James C. Whanger

Would facet_wrap or facet_grid give you what you want?

On Sat, Apr 16, 2016 at 8:45 AM, ch.elahe via R-help 
wrote:

> Hi,
> I have a data set (mydata), which a part of this is like the following:
>
>
> 'data.frame':   36190 obs. of 16 variables:
> $ RE: int  38 41 11 67 30 18 38 41 41 30 ...
> $ LU : int  4200 3330 530 4500 3000 1790 4700 3400
> 3640 4000 ...
> $ COUNTRY: Factor w/ 4 levels "DE","FR","JP", "FR"…
> $Light  : Factor w/2 levels   "ON","OFF","ON", ….
> $OR : Factor w/2 levels   "S","T","S",….
> $PAT  : Factor w/3 levels   "low", "high", "middle",….
>
>
> Now I want to plot RE vs LU with ggplot2 for all the possible cases, I
> know how to do subsetting for the data but I want to know is there any
> shorter way to do that? For example I want to have a plot for RE vs LU for
> (COUNTRY= FR, Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, Light=on,
> OR=S, PAT=high) and …., as you see doing subset is time consuming, is there
> any other way?
> Thank you for any help.
> Elahe
>
> __
> R-help@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.




-- 
*James C. Whanger*

[[alternative HTML version deleted]]

__
R-help@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.

[R] a replace for subset

2016-04-16 Thread ch.elahe via R-help

Hi, 
I have a data set (mydata), which a part of this is like the following: 


'data.frame':   36190 obs. of 16 variables: 
$ RE: int  38 41 11 67 30 18 38 41 41 30 ... 
$ LU : int  4200 3330 530 4500 3000 1790 4700 3400 3640 
4000 ... 
$ COUNTRY: Factor w/ 4 levels "DE","FR","JP", "FR"… 
$Light  : Factor w/2 levels   "ON","OFF","ON", …. 
$OR : Factor w/2 levels   "S","T","S",…. 
$PAT  : Factor w/3 levels   "low", "high", "middle",…. 


Now I want to plot RE vs LU with ggplot2 for all the possible cases, I know how 
to do subsetting for the data but I want to know is there any shorter way to do 
that? For example I want to have a plot for RE vs LU for (COUNTRY= FR, 
Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, Light=on, OR=S, PAT=high) 
and …., as you see doing subset is time consuming, is there any other way? 
Thank you for any help. 
Elahe

__
R-help@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.

Re: [R] a replace for subset

2016-04-15 Thread Jim Lemon

Hi Elahe,
When you want to include a usable toy data frame, it's better to use
something like:

dput(mydata[1:100])

So if we have a data frame like this:

mydata<-data.frame(RE=sample(5:50,100,TRUE),
  LU=sample(1500:4500,100),
  COUNTRY=factor(sample(c("DE","FR","JP","AU"),100,TRUE)),
  Light=factor(sample(c("ON","OFF"),100,TRUE)),
  OR=factor(sample(c("S","T"),100,TRUE)),
  PAT=factor(sample(c("low","high","middle"),100,TRUE)))

Then you can create logical expressions for all combinations of your
levels like this:

subcomb<-expand.grid(list(levels(mydata$COUNTRY),
 levels(mydata$Light),levels(mydata$OR),levels(mydata$PAT)))

Then you can loop through this data frame creating a string that
corresponds to your logical expression:

for(subsetter in 1:dim(subcomb)[1]) {
 subexpr<-paste(names(mydata)[3:6],subcomb[subsetter,],
  sep="==",collapse="&")
 subset(mydata,do_something_to(subexpr),select=c("RE","LU"))
}

but I have not been able to work out how to transform the strings
"subexpr" into logical expressions. I feel pretty sure that someone
will show me up on this.

Jim

__
R-help@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.

Re: [R] a replace for subset

2016-04-14 Thread Bert Gunter

A mess!
Please follow the posting guide: post in *plain text*, not HTML.

Cheers.
Bert


Bert Gunter

"The trouble with having an open mind is that people keep coming along
and sticking things into it."
-- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )


On Thu, Apr 14, 2016 at 1:14 PM, ch.elahe via R-help
 wrote:
> Hi,I have a data set (mydata), which a part of this is like the following:  
> 'data.frame':   36190 obs. of 16 variables:$ RE: int  38 
> 41 11 67 30 18 38 41 41 30 ...$ LU : int  4200 3330 530 
> 4500 3000 1790 4700 3400 3640 4000 ...$ COUNTRY: Factor w/ 4 levels 
> "DE","FR","JP", "FR"…$Light  : Factor w/2 levels   
> "ON","OFF","ON", ….$OR : Factor w/2 levels   
> "S","T","S",….$PAT  : Factor w/3 levels   "low", "high", 
> "middle",….  Now I want to plot RE vs LU with ggplot2 for all the possible 
> cases, I know how to do subsetting for the data but I want to know is there 
> any shorter way to do that? For example I want to have a plot for RE vs LU 
> for (COUNTRY= FR, Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, 
> Light=on, OR=S, PAT=high) and …., as you see doing subset is time consuming, 
> is there any other way?Thank you for any help.Elahe
> [[alternative HTML version deleted]]
>
> __
> R-help@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.

__
R-help@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.

[R] a replace for subset

2016-04-14 Thread ch.elahe via R-help

Hi,I have a data set (mydata), which a part of this is like the following:  
'data.frame':   36190 obs. of 16 variables:$ RE                    : int  38 41 
11 67 30 18 38 41 41 30 ...$ LU                     : int  4200 3330 530 4500 
3000 1790 4700 3400 3640 4000 ...$ COUNTRY        : Factor w/ 4 levels 
"DE","FR","JP", "FR"…$Light                  : Factor w/2 levels   
"ON","OFF","ON", ….$OR                     : Factor w/2 levels   
"S","T","S",….$PAT                  : Factor w/3 levels   "low", "high", 
"middle",….  Now I want to plot RE vs LU with ggplot2 for all the possible 
cases, I know how to do subsetting for the data but I want to know is there any 
shorter way to do that? For example I want to have a plot for RE vs LU for 
(COUNTRY= FR, Light=off, OR=S, PAT=low) and one for (COUNTRY= FR, Light=on, 
OR=S, PAT=high) and …., as you see doing subset is time consuming, is there any 
other way?Thank you for any help.Elahe
[[alternative HTML version deleted]]

__
R-help@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.

Re: [R] a replace for subset

Re: [R] a replace for subset

Re: [R] a replace for subset

Re: [R] a replace for subset

[R] a replace for subset

Re: [R] a replace for subset

Re: [R] a replace for subset

[R] a replace for subset

8 matches

Site Navigation

Mail list logo

Footer information