title: Pandas read_csv() not reading column containing web links or any column after
body: <p>I am trying to remove duplicates from a CSV I created via webscraping and using the following to create the CSV:</p>
  
  <pre><code>Greensboro_Parks = pd.DataFrame({"Mobile Home Park":pd.Series(company_names),"Phone Number":pd.Series(company_phone),"Website":pd.Series(website_link_list),"Street":pd.Series(company_street),"City/State":pd.Series(company_locale)})
  
  Greensboro_Parks.to_csv('Greensboro_Mobile_Homes.csv', index = False, header = True)
  </code></pre>
  
  <p>Link to CSV on Github (screenshot file was to large):
  <a href="https://github.com/sdejewski10/Upwork_Mobile_Homes/blob/master/Greensboro_Mobile_Homes.csv" rel="nofollow noreferrer">https://github.com/sdejewski10/Upwork_Mobile_Homes/blob/master/Greensboro_Mobile_Homes.csv</a></p>
  
  <p>When I open a new file and read the CSV in, it only displays the first two columns: "Mobile Home Park", and "Phone Number". I tried opening the CSV file in Google Sheets and it also only displays the first two columns. I've come to the conclusion it is likely related to the formatting of the weblink trying to be read into the CSV?</p>
  
  <p>I tried using:</p>
  
  <pre><code>data = pd.read_csv('/Users/steve/Documents/Coding/Upwork/Mobile Homes/Greensboro_Mobile_Homes.csv', usecols = ['Mobile Home Park', 'Phone Number', 'Website', 'Street', 'City/State'], dtype= str)
  </code></pre>
  
  <p>OUTPUT:
  <code>ValueError: Usecols do not match columns, columns expected but not found: ['Website', 'Street', 'City/State']</code></p>
  
  <p>I've reviewed:<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html</a> but could not interpret how to format the URL to be read. Any suggestions are greatly appreciated.</p>