<p>You can simply use subset function in R and use the code given below,</p>
<pre><code>    new_dataframe &lt;- 
    subset(name_of_your_dataframe,Column1 == 1 &amp;&amp; 
    Column2 ==  &quot;T1&quot;)
</code></pre>
<p>Please keep in mind that R is case sensitive and you should be careful while using the variable names.</p>

CC BY-SA 4.0
2020-12-20T20:18:32.877Z
2020-12-20T20:18:32.877Z
Ammar Sabir Cheema
<p>I have  a data frame that contain lot of columns and lines, like this for example</p>
<pre><code>Column1   Column2 
5            T1
1            T2
1            T3
1            T1
2            T1
1            T1
2            T1
1            T1
</code></pre>
<p>I want to extract just lines that have the value 1 in column 1 and Value T1 in Column 2</p>
<p>So the result I want is</p>
<pre><code>Column1   Column2 
1            T1
1            T1
1            T1
</code></pre>
<p>Can you tell me please how I can do that</p>

CC BY-SA 4.0
2020-12-20T19:16:03.130Z
Hi @James what code have you written so far? You must have imported into R and done some basic dataframe work.
M__
CC BY-SA 4.0
2020-12-20T20:08:18.003Z
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
CC BY-SA 4.0
2020-12-20T20:27:59.883Z
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
CC BY-SA 4.0
2020-12-20T20:28:37.223Z
I’m voting to close this question because it is a basic R operation has nothing to do with bioinformatics specifically
Ram RS
<r><database>
How to select specific lines and specific columns
# How to select specific lines and specific columns

(Asked by: username_0 on 2020-12-20)

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

**Tags:** r, database
> **Comments:**
> **username_1**: Hi @James what code have you written so far? You must have imported into R and done some basic dataframe work.  
> **username_0**: 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"  
> **username_2**: 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.  
> **username_2**: I’m voting to close this question because it is a basic R operation has nothing to do with bioinformatics specifically  

---

## 1 answers

### Answer by username_3 on 2020-12-20. Score: 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.


---

