How to select specific lines and specific columns

Question

I have a data frame that contain lot of columns and lines, like this for example

Column1   Column2 
5            T1
1            T2
1            T3
1            T1
2            T1
1            T1
2            T1
1            T1

I want to extract just lines that have the value 1 in column 1 and Value T1 in Column 2

So the result I want is

Column1   Column2 
1            T1
1            T1
1            T1

Can you tell me please how I can do that

Hi @James what code have you written so far? You must have imported into R and done some basic dataframe work. — M__, Dec 20, 2020 at 19:16
Hello , thank you very much for you answer , yes i tried this one : Pokemon_2 <- dropRows(ds, Pokemon$Generation == 1 , Pokemon$Type_1=="Water" ) but it didn't work , Error in dropRows(ds, Pokemon$Generation == 1, Pokemon$Type_1 == "Water") : could not find function "dropRows" — Reda, Dec 20, 2020 at 20:08
You should look at the subset function. Please google "filter data frame by column value" - much like writing for loops in basic programming languages, it is a basic operation that does not warrant creating new posts on forums. — Ram RS, Dec 20, 2020 at 20:27
I’m voting to close this question because it is a basic R operation has nothing to do with bioinformatics specifically — Ram RS, Dec 20, 2020 at 20:28

Ammar Sabir Cheema · Accepted Answer · 2020-12-20 20:18:32Z

2

You can simply use subset function in R and use the code given below,

    new_dataframe <- 
    subset(name_of_your_dataframe,Column1 == 1 && 
    Column2 ==  "T1")

Please keep in mind that R is case sensitive and you should be careful while using the variable names.

answered Dec 20, 2020 at 20:18

9517 silver badges20 bronze badges

Add a comment |

1 Answer 1