title: Pandas remove white space/unknown character when importing csv file
body: <p>I can download files:</p>
  
  <pre><code>seasons = [2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017]
  
  epl_tables = {}
  epl_seasons = {}
  for year in seasons:
      start_year = str(year)[-2:]
      end_year = str(year+1)[-2:]
      season = start_year + end_year
      epl_seasons[season] = pd.read_csv("https://www.football-data.co.uk/mmz4281/{}{}/E0.csv".format(start_year, end_year)).dropna(how='all')
      epl_tables[season] = league(epl_seasons[season]) 
  </code></pre>
  
  <p>This works fine.</p>
  
  <p>However when I try to add the 2004-05 season by adding 2004 to seasons, there is a problem and the code fails.</p>
  
  <pre><code>seasons = [2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017]
  </code></pre>
  
  <p>The problem is caused by a white space before the referee's name in rows 337 to 345 of the csv file.</p>
  
  <p>I can work around by manually deleting the white space and then loading from disk this works but obviously it's not ideal.</p>
  
  <p>I've tried various ways to get it to work such as shown below but nothing seems to work, </p>
  
  <pre><code>epl_seasons[season] = pd.read_csv("https://www.football-data.co.uk/mmz4281/{}{}/E0.csv".format(start_year, end_year), delimiter=',', encoding="utf-8", skipinitialspace=True).dropna(how='all')
  </code></pre>
  
  <p>A potential complication is that when I open the file in excel the space appears as a white space but then I open it in libreCalc (in Ubuntu which is what I'm working in), it appears as an unknown character a question mark in a black box tipped at 45 degrees. See the answer from PeterMau in the link below to see what this unknown character looks like.  </p>
  
  <p><a href="https://ask.libreoffice.org/en/question/113125/characters-turned-into-question-marks/" rel="nofollow noreferrer">https://ask.libreoffice.org/en/question/113125/characters-turned-into-question-marks/</a></p>
  
  <p>Can someone please tell me who I can automatically remove these white spaces/ unknown characters?</p>