title: R - sqldf - update query
body: <p>I am currently working on a project where I need to update variables in my dataframe conditionally. I found the simplest way to do this would be to use sqldf/RSQLite. I have tried several code combinations so far and this is the one that I've got the furthest with (anonymising the dataset)</p>
  
  <pre><code>sqldf("UPDATE dataframe SET Variable = 'New Text Value' WHERE Variable.name.category = 'Text Value'")
  </code></pre>
  
  <p>From the research that I have done on the topic, I understand that sqldf has issues with the '.' character. Is there a simple workaround for this?</p>
  
  <p>Thanks in advance!</p>