title: How to format a pd DataFrame reading a JSON file with 1 line without splitting into multiple rows?
body: <p>I have data in JSON file that is split up into 2 rows when I read it into a pandas DataFrame because 2 keys have 2 instead of 1 values.</p>
  <p>The JSON file contains:</p>
  <pre><code>{'userId': 'e79dc0d35a30d1b3c6215bb54f163f247ca8f1cd5b988d3496ac7fa2f4dfa06d',
   'attemptTime': '2020-10-21T16:51:12',
   'ipAddress': 'c739bc11e8cb4b56ec984b5939e0606f795176fc2d844ad8f1360a185c57d5cb',
   'location': 'EXTERNAL',
   'score': '8,00',
   'subScores': ['5,00', '3,00'],
   'words': 330,
   'subWords': [132, 198],
   'doNotReview': False}
  </code></pre>
  <p>The output of <code>pd.read_json(f'{qs_path}/metadata.json')</code> is</p>
  <p><a href="https://i.stack.imgur.com/kj9ID.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kj9ID.png" alt="enter image description here" /></a></p>
  <p>Because subScores and subWords are a list of 2 values the data is being split into 2 rows. How do I format it where I keep each list in one cell and end up with just one row?</p>