title: How do I search and replace using a loop data in 2 data frame?
body: <p>For example</p>
  <p>I am reading a csv file</p>
  <pre><code>readURL = &quot;https://storage.googleapis.com/covid19-open-data/v2/vaccinations.csv&quot; 
  </code></pre>
  <p>CRV Sample Shown Below</p>
  <pre><code>    Date        Code
  1 2020-01-20     AL99
  2 2020-01-20     AL9
  3 2020-01-20     IO
  4 2020-01-20     AL
  
  Frame = read.csv(url(readURL))
  </code></pre>
  <p>I can search and manually change any text with AL in the dataframe using this method</p>
  <pre><code>Frame$key=gsub(&quot;.*AL.*&quot;, &quot;Albania&quot;, Frame$key, perl=TRUE)
  </code></pre>
  <p>But I have another csv file with country codes. I don't want to manually write above code for all countries. how do I search using below dataframe code and replace using a loop?</p>
  <pre><code>readCountryURL = &quot;https://pkgstore.datahub.io/core/country-list/data_csv/data/d7c9d7cfb42cb69f4422dec222dbbaa8/data_csv.csv&quot;
  </code></pre>
  <p>CRV Sample Shown Below</p>
  <pre><code>    Name        Code
  1 Afghanistan    AF
  2 Albania        AL
  </code></pre>