title: Trying to load multiple json files and merge into one pandas dataframe
body: <p>I am trying to load multiple json files from a directory in my Google Drive into one pandas dataframe.</p>
  
  <p>I have tried quite a few solutions but nothing seems to be yielding a positive result. </p>
  
  <p>This is what I have tried so far</p>
  
  <pre><code>path_to_json = '/path/'
  json_files = [pos_json for pos_json in os.listdir(path_to_json) if pos_json.endswith('.json')]
  jsons_data = pd.DataFrame(columns=['participants','messages','active','threadtype','thread path'])
  for index, js in enumerate(json_files):
      with open(os.path.join(path_to_json, js)) as json_file:
          json_text = json.load(json_file)
          participants = json_text['participants']
          messages = json_text['messages']
          active = json_text['is_still_participant']
          threadtype = json_text['thread_type']
          threadpath = json_text['thread_path']
          jsons_data.loc[index]=[participants,messages,active,threadtype,threadpath]
  jsons_data
  </code></pre>
  
  <p>And this is the full traceback of error message I am receiving:</p>
  
  <pre><code>---------------------------------------------------------------------------
  JSONDecodeError                           Traceback (most recent call last)
  &lt;ipython-input-30-8385abf6a3a7&gt; in &lt;module&gt;()
        1 for index, js in enumerate(json_files):
        2     with open(os.path.join(path_to_json, js)) as json_file:
  ----&gt; 3         json_text = json.load(json_file)
        4         participants = json_text['participants']
        5         messages = json_text['messages']
  
  /usr/lib/python3.6/json/__init__.py in load(fp, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
      297         cls=cls, object_hook=object_hook,
      298         parse_float=parse_float, parse_int=parse_int,
  --&gt; 299         parse_constant=parse_constant, object_pairs_hook=object_pairs_hook, **kw)
      300 
      301 
  
  /usr/lib/python3.6/json/__init__.py in loads(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
      352             parse_int is None and parse_float is None and
      353             parse_constant is None and object_pairs_hook is None and not kw):
  --&gt; 354         return _default_decoder.decode(s)
      355     if cls is None:
      356         cls = JSONDecoder
  
  /usr/lib/python3.6/json/decoder.py in decode(self, s, _w)
      337 
      338         """
  --&gt; 339         obj, end = self.raw_decode(s, idx=_w(s, 0).end())
      340         end = _w(s, end).end()
      341         if end != len(s):
  
  /usr/lib/python3.6/json/decoder.py in raw_decode(self, s, idx)
      355             obj, end = self.scan_once(s, idx)
      356         except StopIteration as err:
  --&gt; 357             raise JSONDecodeError("Expecting value", s, err.value) from None
      358         return obj, end
  
  JSONDecodeError: Expecting value: line 1 column 1 (char 0) 
  </code></pre>
  
  <p>I have added a sample of the json files I am trying to read from</p>
  
  <p><a href="https://drive.google.com/drive/folders/1kC7900JPFqWLGtzPS-74se-1yClVG0qu?usp=sharing" rel="nofollow noreferrer">Link to Jsons</a></p>
  
  <p>Example of jsons:</p>
  
  <pre><code>{
  participants: [
  {
  name: "Test 1"
  },
  {
  name: "Person"
  }
  ],
  messages: [
  {
  sender_name: "Person",
  timestamp_ms: 1485467319139,
  content: "Hie",
  type: "Generic"
  }
  ],
  title: "Test 1",
  is_still_participant: true,
  thread_type: "Regular",
  thread_path: "inbox/xyz"
  }
  #second example
  {
  participants: [
  {
  name: "Clearance"
  },
  {
  name: "Person"
  }
  ],
  messages: [
  {
  sender_name: "Emmanuel Sibanda",
  timestamp_ms: 1212242073308,
  content: "Dear",
  share: {
  link: "http://www.example.com/"
  },
  type: "Share"
  }
  ],
  title: "Clearance",
  is_still_participant: true,
  thread_type: "Regular",
  thread_path: "inbox/Clearance"
  }
  </code></pre>