title: Pandas Scrape switching values on scrape
body: <pre><code>import requests
  import pandas as pd
  import csv
  
  
  headers = {
      &quot;User-Agent&quot;: &quot;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36&quot;
  }
  
  urls = [
      'https://stats.ncaa.org/game/play_by_play/12465',
      'https://stats.ncaa.org/game/play_by_play/12755',
      'https://stats.ncaa.org/game/play_by_play/12640',
      'https://stats.ncaa.org/game/play_by_play/12290',
  ]
  s = requests.Session()
  s.headers.update(headers)
  for url in urls:
      r = s.get(url)
      dfs = pd.read_html(r.text)
      for df in dfs:
          df.to_csv('pbp.csv', mode='a', index=False)
  </code></pre>
  <p>I have this amazing script I've struggled through (with the help of this community).  It pulls the table data from these different sites, and pushes to a CSV.</p>
  <p>For some reason, the &quot;Score&quot; in some places loses it's format (Image below).  I've tried formatting in Excel/Sheets, but no luck.</p>
  <p>I don't see anything different in Inspector with these lines -- it's not all of them, only a select few on each link.</p>
  <p>Any way I could prevent this from happening? Doesn't make much sense to me.</p>
  <p><a href="https://i.stack.imgur.com/Nt5ss.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nt5ss.png" alt="Incorrect Score" /></a></p>