cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%C2%BFSubconjunto%20de%20filas%20seleccionadas%20autom%C3%A1ticamente%20por%20palabra%20clave%20en%20la%20columna%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ETengo%20una%20tabla%20de%20datos%20alta%20con%20ID%20de%20muestra%2C%20prueba%2C%20recuento%20y%20alguna%20informaci%C3%B3n%20categ%C3%B3rica.%20La%20columna%20de%20prueba%20identifica%20a%20qu%C3%A9%20prueba%20se%20refiere%20el%20recuento%20y%20si%20se%20trata%20de%20una%20poblaci%C3%B3n%20positiva%20o%20negativa.%20Por%20ejemplo%20%22Prueba%20uno%20positivo%22%2C%20%22Prueba%20uno%20negativo%22%2C%20etc.%2C%20as%C3%AD%20como%20algunas%20filas%20como%20%22pruebas%20totales%22.%20Estos%20se%20repiten%20para%20cada%20muestra.%3C%2FP%3E%3CP%3E%C2%BFC%C3%B3mo%20seleccionar%C3%ADa%20todas%20las%20filas%20con%20un%20%22positivo%22%20en%20la%20columna%2C%20independientemente%20del%20ID%20de%20prueba%20que%20est%C3%A9%20antes%2C%20para%20luego%20poder%20subconjuntarlas%20en%20una%20nueva%20tabla%20de%20datos%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3ECombinaci%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eventanas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFSubconjunto%20de%20filas%20seleccionadas%20autom%C3%A1ticamente%20por%20palabra%20clave%20en%20la%20columna%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESeleccionar%20filas%20%26gt%3B%20Seleccionar%20filas%20donde...%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Mcc99
Level I

Subset rows automatically selected for by key word in column?

I have a tall data table with sample ID, test, count, and some categorical info. The test column identifies which test the count refers to and whether it's a positive or negative population. For example "Test one positive", "test one negative", etc., as well as some rows such as "total tests". These repeat for each sample.

How would I select all the rows with a "positive" in the column regardless of which test ID is before it, so I can then subset them into a new data table?  

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Subset rows automatically selected for by key word in column?

Select Rows > Row Selection > Select Where...

See Row Selection examples.

View solution in original post

1 REPLY 1

Re: Subset rows automatically selected for by key word in column?

Select Rows > Row Selection > Select Where...

See Row Selection examples.