title: My JSON is parsing incorrectly. What am I doing wrong?
body: <p>I am trying to run a small script just to read a two column CSV, convert to JSON, and send to a service. The code should be fairly straight-forward I think : </p>
  
  <pre><code>#read excel
  df = pd.read_csv('C:\\Users\\Admin\\Desktop\\CSV_1.csv')
  
  # Randomly sample 3% of your dataframe
  df_10 = df.sample(frac=0.03)
  
  #convert excel to json for testing
  json_file=df_10.to_json()
  
  source = json.loads(json_file)
  
  for row in source:
      player = row[0]
      team = row[1]
  </code></pre>
  
  <p>The issue is that row[0] and row[1] seem to be the first character in each column of my CSV....not the full row. My CSV was originally of the format</p>
  
  <pre><code>Player, Team
  </code></pre>
  
  <p>Am I parsing my JSON incorrectly or how can I read the correct data here ? </p>
  
  <p>Thanks.</p>