title: Excel CSV output appearing wrong after calling Python File
body: <p>Currently struggling with the following output in .csv where their is various random character within the is the players names and values where there shouldn't be</p>
  <p><strong>(I've given a picture below of the output)</strong></p>
  <p>I'm wondering where I'm going wrong in the code where I'm struggling to eliminate the random characters</p>
  <p><strong>I'm trying to remove the characters below such as Â, Ã, ©, ‰ and so on.
  Any suggestions?</strong></p>
  <p><strong>Python Code</strong></p>
  <pre><code>#importing
  
  import requests
  from bs4 import BeautifulSoup
  import pandas as pd
  
  headers = {'User-Agent': 
         'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like 
  Gecko) Chrome/47.0.2526.106 Safari/537.36'}
  
  #calling websites
  page = &quot;https://www.transfermarkt.co.uk/transfers/transferrekorde/statistik/top/plus/0/galerie/0?saison_id=2000&quot;
  pageTree = requests.get(page, headers=headers)
  pageSoup = BeautifulSoup(pageTree.content, 'html.parser')
  
  #calling players names
  Players = pageSoup.find_all(&quot;a&quot;, {&quot;class&quot;: &quot;spielprofil_tooltip&quot;})
  #Let's look at the first name in the Players list.
  Players[0].text
  
  #calling value of players
  Values = pageSoup.find_all(&quot;td&quot;, {&quot;class&quot;: &quot;rechts hauptlink&quot;})
  #Let's look at the first name in the Values list.
  Values[0].text
  
  PlayersList = []
  ValuesList = []
  
  for i in range(0,25):
     PlayersList.append(Players[i].text)
     ValuesList.append(Values[i].text)
  
  df = pd.DataFrame({&quot;Players&quot;:PlayersList,&quot;Values&quot;:ValuesList})
  
  df.to_csv('2000.csv', index=False)
  
  df.head()
  </code></pre>
  <p>====================================================================</p>
  <p><strong>My Excel output</strong></p>
  <p><a href="https://i.stack.imgur.com/gXCXh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gXCXh.png" alt="The Output" /></a></p>