title: Changing column values in R
body: <p>I have the following dataset that I want to clean up:</p>
  
  <pre><code>              Provice      Lat     Long Date Recovered
  Anhui.1         Anhui  31.8257 117.2264    1         0
  Chongqing.1 Chongqing  30.0572 107.8740    1         0
  Guangdong.1 Guangdong  23.3417 113.4244    1         0
  Henan.1         Henan 33.88202 113.6140    1         0
  Hubei.1         Hubei  30.9756 112.2707    1        28
  Hunan.1         Hunan  27.6104 111.7088    1         0
  Jiangsu.1     Jiangsu  32.9711 119.4550    1         0
  Jiangxi.1     Jiangxi   27.614 115.7221    1         0
  Shandong.1   Shandong  36.3427 118.1498    1         0
  Zhejiang.1   Zhejiang  29.1832 120.0934    1         0
  Anhui.2         Anhui  31.8257 117.2264    2         0
  Chongqing.2 Chongqing  30.0572 107.8740    2         0
  Guangdong.2 Guangdong  23.3417 113.4244    2         2
  Henan.2         Henan 33.88202 113.6140    2         0
  Hubei.2         Hubei  30.9756 112.2707    2        28
  Hunan.2         Hunan  27.6104 111.7088    2         0
  Jiangsu.2     Jiangsu  32.9711 119.4550    2         0
  Jiangxi.2     Jiangxi   27.614 115.7221    2         0
  Shandong.2   Shandong  36.3427 118.1498    2         0
  Zhejiang.2   Zhejiang  29.1832 120.0934    2         0
  </code></pre>
  
  <p>What I want to do is change the Provice column so that instead of it reading "Anhui.1   Anhui" it simply reads "Anhui" (and similar for the rest of the values under Provice. Also, I would like to associate an actual date for each value under the Date column. For instance if there is a value 1 under Date then I would like it to read 20-01-22 and if there is a value 2 under Date then read 20-01-23.</p>
  
  <p>Essentially, I would like my dataset to look like this:</p>
  
  <pre><code>  Provice      Lat     Long      Date   Recovered
  Anhui      31.8257 117.2264    20-01-22         0
  Chongqing  30.0572 107.8740    20-01-22         0
  Guangdong  23.3417 113.4244    20-01-22         0
  Henan     33.88202 113.6140    20-01-22         0
  Hubei      30.9756 112.2707    20-01-22        28
  Hunan      27.6104 111.7088    20-01-22         0
  Jiangsu    32.9711 119.4550    20-01-22         0
  Jiangxi     27.614 115.7221    20-01-22         0
  Shandong   36.3427 118.1498    20-01-22         0
  Zhejiang   29.1832 120.0934    20-01-22         0
  Anhui      31.8257 117.2264    20-01-23         0
  Chongqing  30.0572 107.8740    20-01-23         0
  Guangdong  23.3417 113.4244    20-01-23         2
  Henan     33.88202 113.6140    20-01-23         0
  Hubei      30.9756 112.2707    20-01-23        28
  Hunan      27.6104 111.7088    20-01-23         0
  Jiangsu    32.9711 119.4550    20-01-23         0
  Jiangxi     27.614 115.7221    20-01-23         0
  Shandong   36.3427 118.1498    20-01-23         0
  Zhejiang   29.1832 120.0934    20-01-23         0
  </code></pre>
  
  <p>Could someone please help me out?</p>