R help es - Jul 2013 - Eliminar filas que cumplen con mas de un criterios simultaneamente ...

Hola de nuevo. Leí mal. Si vas a eliminar esas filas, entonces usa:

sqldf("select * from graph where sol!='lim' and dia!=2")

En el correo anterior seleccioné precisamente a esas descartando a las
demás.

Culpa de mis anteojos... jeje.


On Fri, Jul 12, 2013 at 5:20 PM, Freddy Omar López Quintero <
freddy.vate01@gmail.com> wrote:
> ​Hola.​
>
>
>> Tengo que eliminar las filas cuya columna SOL dice LIM y cuya columna
>> DIA dice 2.
>>
>
> ​​Prueba con:
>
> >library(sqldf)​​
> >graph<-sqldf("select * from graph where sol='lim' and
dia=2")
>
> ​  sol   con dia NCar NIns isom        area rep tipo
> 1 lim 0.003   2 160s    0    s 0.572323700   1 <NA>
> 2 lim 0.003   2 161t    1    t 0.010960770   1 <NA>
> 3 lim 0.003   2 161c    1    c 0.003896926   1 <NA>
> 4 lim 0.003   2 190s    0    s 0.013402530   1 <NA>
> 5 lim 0.003   2 190s    0    s 0.009274320   1 <NA>
> ​
>
> ​Saludos.​
>
>
> --
> «But Gwindor answered: 'The doom lies in yourself, not in your
name.'»
>
> JRR Tolkien
>


-- 
«But Gwindor answered: 'The doom lies in yourself, not in your name.'»

JRR Tolkien

	[[alternative HTML version deleted]]

Hola,

En vez de utilizar "&" (que es "and") utiliza
"|" (que es el "or"):

graph <- graph[graph$sol=="lim" *|* graph$dia==2,]

Saludos,
Carlos Ortega
www.qualityexcellence.es


El 12 de julio de 2013 23:22, Freddy Omar López Quintero <
freddy.vate01@gmail.com> escribió:
> Hola de nuevo. Leí mal. Si vas a eliminar esas filas, entonces usa:
>
> sqldf("select * from graph where sol!='lim' and dia!=2")
>
> En el correo anterior seleccioné precisamente a esas descartando a las
> demás.
>
> Culpa de mis anteojos... jeje.
>
>
> On Fri, Jul 12, 2013 at 5:20 PM, Freddy Omar López Quintero <
> freddy.vate01@gmail.com> wrote:
>
> > Hola.
> >
> >
> >> Tengo que eliminar las filas cuya columna SOL dice LIM y cuya
columna
> >> DIA dice 2.
> >>
> >
> > Prueba con:
> >
> > >library(sqldf)
> > >graph<-sqldf("select * from graph where sol='lim'
and dia=2")
> >
> >   sol   con dia NCar NIns isom        area rep tipo
> > 1 lim 0.003   2 160s    0    s 0.572323700   1 <NA>
> > 2 lim 0.003   2 161t    1    t 0.010960770   1 <NA>
> > 3 lim 0.003   2 161c    1    c 0.003896926   1 <NA>
> > 4 lim 0.003   2 190s    0    s 0.013402530   1 <NA>
> > 5 lim 0.003   2 190s    0    s 0.009274320   1 <NA>
> > 
> >
> > Saludos.
> >
> >
> > --
> > «But Gwindor answered: 'The doom lies in yourself, not in your
name.'»
> >
> > JRR Tolkien
> >
>
>
>
> --
> «But Gwindor answered: 'The doom lies in yourself, not in your
name.'»
>
> JRR Tolkien
>
>         [[alternative HTML version deleted]]
>
>
> _______________________________________________
> R-help-es mailing list
> R-help-es@r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-help-es
>
>

-- 
Saludos,
Carlos Ortega
www.qualityexcellence.es

	[[alternative HTML version deleted]]

Perdona, lo que querías era eliminar... no seleccionar...
Tienes que negar la igualdad "!="... y mantener la condición
"&".

graph <- graph[graph$sol!="lim" & graph$dia!=2,]

Saludos,
Carlos Ortega
www.qualityexcellence.es


El 13 de julio de 2013 00:01, Carlos Ortega
<cof@qualityexcellence.es>escribió:
> Hola,
>
> En vez de utilizar "&" (que es "and") utiliza
"|" (que es el "or"):
>
> graph <- graph[graph$sol=="lim" *|* graph$dia==2,]
>
> Saludos,
> Carlos Ortega
> www.qualityexcellence.es
>
>
> El 12 de julio de 2013 23:22, Freddy Omar López Quintero <
> freddy.vate01@gmail.com> escribió:
>
>> Hola de nuevo. Leí mal. Si vas a eliminar esas filas, entonces usa:
>>
>> sqldf("select * from graph where sol!='lim' and
dia!=2")
>>
>> En el correo anterior seleccioné precisamente a esas descartando a las
>> demás.
>>
>> Culpa de mis anteojos... jeje.
>>
>>
>> On Fri, Jul 12, 2013 at 5:20 PM, Freddy Omar López Quintero <
>> freddy.vate01@gmail.com> wrote:
>>
>> > Hola.
>> >
>> >
>> >> Tengo que eliminar las filas cuya columna SOL dice LIM y cuya
columna
>> >> DIA dice 2.
>> >>
>> >
>> > Prueba con:
>> >
>> > >library(sqldf)
>> > >graph<-sqldf("select * from graph where
sol='lim' and dia=2")
>>
>> >
>> >  sol   con dia NCar NIns isom        area rep tipo
>> > 1 lim 0.003   2 160s    0    s 0.572323700   1 <NA>
>> > 2 lim 0.003   2 161t    1    t 0.010960770   1 <NA>
>> > 3 lim 0.003   2 161c    1    c 0.003896926   1 <NA>
>> > 4 lim 0.003   2 190s    0    s 0.013402530   1 <NA>
>> > 5 lim 0.003   2 190s    0    s 0.009274320   1 <NA>
>> >
>> >
>> > Saludos.
>> >
>> >
>> > --
>> > «But Gwindor answered: 'The doom lies in yourself, not in your
name.'»
>> >
>> > JRR Tolkien
>> >
>>
>>
>>
>> --
>> «But Gwindor answered: 'The doom lies in yourself, not in your
name.'»
>>
>> JRR Tolkien
>>
>>         [[alternative HTML version deleted]]
>>
>>
>> _______________________________________________
>> R-help-es mailing list
>> R-help-es@r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-help-es
>>
>>
>
>
> --
> Saludos,
> Carlos Ortega
> www.qualityexcellence.es
>


-- 
Saludos,
Carlos Ortega
www.qualityexcellence.es

	[[alternative HTML version deleted]]