title: Conditionally removing rows changing all values to NA
body: <p>I have a data frame which has multiple columns.. The first column doesn't have a name, so R is giving Col1 header to it.I have to remove certain rows from the data frame which have Value "tbd" in Col1.</p>
  
  <p>Data frame:</p>
  
  <pre><code>Col1   Name   Addreess
  &lt;NA&gt;   ABC    ddfddf
  &lt;NA&gt;   XYZ    HJJJ
  &lt;NA&gt;   KKL    PPOI
  tbd    HGGF   UYTT
  &lt;NA&gt;   fFFF   OOOO
  </code></pre>
  
  <p>I used the below code to do it,</p>
  
  <pre><code>df1&lt;- df[!(df$Col1=="tbd"), ] 
  </code></pre>
  
  <p>and writing the output in excel format. But, the output is not removing the tbd rows and changing all the values in the dataframe to NA</p>