title: Merge a dataframe with an rda file in r
body: <p>I'm building a process where I need to import 4 large txt data sets on a recurring basis, the files include multiple variables with codes values that need to be converted into a tangible values, I.e. title_code 01 = Manager. I've created 12 rda files to support conversion, the codes are constant but I need to refresh the import files periodically.</p>
  <p>I have not seen any examples of dplyr or sqldf that uses rda files for this purpose, seemed like a good way to store the data like temp tables, is there a better approach?</p>
  <p>Input Data</p>
  <pre><code> id &lt;- c(1,2,3,4)
      name &lt;- c(&quot;John&quot;,&quot;Bill&quot;,&quot;Mary&quot;,&quot;Cindy&quot;)
      title_code &lt;- c(1,2,3,4)
      df1 &lt;- data.frame(id,name,title_code)   
      
      title_code &lt;- c(1,2,3,4)
      title &lt;- c(&quot;Manager&quot;, &quot;Officer&quot;, &quot;Sales&quot;, &quot;VP&quot;)
      df2 &lt;- data.frame(title_code,title) 
  </code></pre>
  <p>Can I substitute an rda file for df2</p>
  <pre><code>library(sqldf)
  df3 = sqldf('select df1.id, df1.name, df2.title 
        from df1 left join df2 
              on df1.title_code = df2.title_code')
  df3
  </code></pre>
  <p>Expected Outcome</p>
  <p><a href="https://i.stack.imgur.com/8TRyw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8TRyw.png" alt="enter image description here" /></a></p>