Home > Software design >  WHy is my JSON not importing into Python Pandas?
WHy is my JSON not importing into Python Pandas?

Time:03-25

For some reason, my JSON is not importing into Python. I have tried using JSONlint but the error message I receive there seems to be conflicting with the one in Pandas.

Error: "Unexpected character found when decoding array value (2)"

The JSON I am using is a Telegram chat history that I have imported - so I'm a little confused as to why it won't import. Below is a sample:

{
 "name": "فاندامنتال | سرمایه گذاری مطمئن",
 "type": "public_channel",
 "id": 1151766431,
 "messages": [
  {
   "id": 1,
   "type": "service",
   "date": "2020-10-17T13:56:10",
   "actor": "فاندامنتال | سرمایه گذاری مطمئن",
   "actor_id": "channel1151766431",
   "action": "create_channel",
   "title": "استخراج رایگان بیت کوین | Free Bitcoin Mining",
   "text": ""
  },
  {
   "id": 3,
   "type": "message",
   "date": "2020-10-17T14:10:51",
   "edited": "2021-10-12T17:47:45",
   "from": "فاندامنتال | سرمایه گذاری مطمئن",
   "from_id": "channel1151766431",
   "author": "unconquerablee",
   "text": "سلام دوستان امیدوارم حال همگی خوب باشه اگه هم خوب نباشه با این کانال خوب‌ میشه           
  •  Tags:  
  • json
  • Related