title: Need a way to take three csv files and put into one as well as remove duplicates and replace values in Python
body: <p>I'm new to Python but I need help creating a script that will take in three different csv files, combine them together, remove duplicates from the first column as well as remove any rows that are blank, then change a revenue area to a number.</p>
  
  <p>The three CSV files are setup the same.  </p>
  
  <p>The first column is a phone number and the second column is a revenue area (city).  </p>
  
  <p>The first column will need all duplicates &amp; blank values removed.
  The second column will have values like "Macon", "Marceline", "Brookfield", which will need to be changed to a specific value like:</p>
  
  <pre><code>Macon = 1
  Marceline = 8
  Brookfield = 4 
  </code></pre>
  
  <p>And then if it doesn't match one of those values put a default value of 9.</p>