title: select a column and replace a value if condition satisfy within the column
body: <p>look active and if upper row is zero then replace zero with string <code>"xyz"</code> </p>
  
  <p>How to write code in R?</p>
  
  <pre><code>Name
  0
  Active
  0
  Active
  NA
  Active
  </code></pre>