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%3ELignes%20de%20sous-ensemble%20automatiquement%20s%C3%A9lectionn%C3%A9es%20par%20mot%20cl%C3%A9%20dans%20la%20colonne%26nbsp%3B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJ'ai%20un%20grand%20tableau%20de%20donn%C3%A9es%20avec%20l'ID%20de%20l'%C3%A9chantillon%2C%20le%20test%2C%20le%20nombre%20et%20quelques%20informations%20cat%C3%A9gorielles.%20La%20colonne%20de%20test%20identifie%20%C3%A0%20quel%20test%20le%20d%C3%A9compte%20fait%20r%C3%A9f%C3%A9rence%20et%20s'il%20s'agit%20d'une%20population%20positive%20ou%20n%C3%A9gative.%20Par%20exemple%20%22Test%20un%20positif%22%2C%20%22test%20un%20n%C3%A9gatif%22%2C%20etc.%2C%20ainsi%20que%20certaines%20lignes%20telles%20que%20%22total%20des%20tests%22.%20Ceux-ci%20se%20r%C3%A9p%C3%A8tent%20pour%20chaque%20%C3%A9chantillon.%3C%2FP%3E%3CP%3EComment%20puis-je%20s%C3%A9lectionner%20toutes%20les%20lignes%20avec%20un%20%C2%AB%26nbsp%3Bpositif%26nbsp%3B%C2%BB%20dans%20la%20colonne%2C%20quel%20que%20soit%20l'ID%20de%20test%20qui%20la%20pr%C3%A9c%C3%A8de%2C%20afin%20de%20pouvoir%20ensuite%20les%20regrouper%20dans%20une%20nouvelle%20table%20de%20donn%C3%A9es%26nbsp%3B%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%3EM%C3%A9lange%20et%20nettoyage%20des%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eles%20fen%C3%AAtres%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%20%3A%20Lignes%20de%20sous-ensemble%20automatiquement%20s%C3%A9lectionn%C3%A9es%20par%20mot%20cl%C3%A9%20dans%20la%20colonne%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ES%C3%A9lectionnez%20Lignes%20%26gt%3B%20S%C3%A9lectionnez%20les%20lignes%20o%C3%B9...%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.