title: Pandas import two csv files and plot specific data
body: <p><a href="https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?src=bkmk" rel="nofollow noreferrer">link 1</a><br>
  <a href="http://www.thearda.com/denoms/D_836_d.asp" rel="nofollow noreferrer">link 2</a> *I copied table and created csv file </p>
  
  <p>I need to plot total population from file 1 and Adherents total for New Jersey as a line or bar graph to compare.</p>
  
  <p>I've tried append to combine both cvs's but comes out weird</p>
  
  <pre><code>import pandas as pd
  import matplotlib.pyplot as plt
  
  clifton_data = pd.read_csv('cliftondata2010census.csv')
  
  religion = pd.read_csv('2010_ Top Five States by Adherence Rate - Sheet1.csv')
  
  all_data = clifton_data.append(religion)
  all_data.plot()
  all_data.plot(kind='line',x='1',y='2') # scatter plot
  all_data.plot(kind='density')
  </code></pre>
  
  <p>I need to plot total population from file 1 and compare to Adherents total for New Jersey as a line or bar graph.</p>