Python Json Expecting property name enclosed in double quotes

Question

I ve been trying to figure out a good way to load JSON objects in Python  I send this json data     http   example org about     http   purl org dc terms title      type    literal    value    Anna s Homepage        to the backend where it will be received as a string then I used json loads data  to parse it   But each time I got the same exception     ValueError  Expecting property name enclosed in double quotes  line 1 column 2  char 1    I googled it but nothing seems to work besides this solution json loads json dumps data   which personally seems for me not that efficient since it accept any kind of data even the ones that are not in json format   Any suggestions will be much appreciated

User · Answer

For anyone who wants a quick-fix  this simply replaces all single quotes with double quotes  import json   predictions       def get top k predictions predictions path          load the predictions             with open  predictions path  as json lines file          for line in json lines file              predictions append json loads line replace  quot   quot    quot   quot  quot                       get top k predictions  quot  sh sh-experiments outputs john baseline 1000 test predictions jsonl quot

User · Answer

It is always ideal to use the json dumps   method  To get rid of this error  I used the following code  json dumps YOUR DICT STRING  replace

User · Answer

As it clearly says in error  names should be enclosed in double quotes instead of single quotes  The string you pass is just not a valid JSON  It should look like    http   example org about     http   purl org dc terms title      type    literal    value    Anna s Homepage

User · Answer

as JSON only allows enclosing strings with double quotes you can manipulate the string like this  str   str replace  quot    quot    quot   quot  quot    if your JSON holds escaped single-quotes      then you should use the more precise following code  import re p   re compile     lt            str   p sub    quot    str   This will replace all occurrences of single quote with double quote in the JSON string str and in the latter case will not replace escaped single-quotes  You can also use js-beautify which is less strict    pip install jsbeautifier   js-beautify file js

User · Answer

This         http   example org about              http   purl org dc terms title                   type    literal    value    quot Anna s Homepage quot                       is not JSON  This          quot http   example org about quot               quot http   purl org dc terms title quot                    quot type quot    quot literal quot    quot value quot    quot Anna s Homepage quot                          is JSON  EDIT  Some commenters suggested that the above is not enough  JSON specification - RFC7159 states that a string begins and ends with quotation mark  That is  quot   Single quoute   has no semantic meaning in JSON and is allowed only inside a string

User · Answer

x   x replace           j   json loads x    Although this is the correct solution  but it may lead to quite a headache if there a JSON like this -    status    success    data     equity     enabled   True   net   66706 14510000008   available     adhoc margin   0   cash   1277252 56   opening balance   1277252 56   live balance   66706 14510000008   collateral   249823 93   intraday payin   15000    utilised     debits   1475370 3449   exposure   607729 3129   m2m realised   0   m2m unrealised   -9033   option premium   0   payout   0   span   858608 032   holding sales   0   turnover   0   liquid collateral   0   stock collateral   249823 93     commodity     enabled   True   net   0   available     adhoc margin   0   cash   0   opening balance   0   live balance   0   collateral   0   intraday payin   0    utilised     debits   0   exposure   0   m2m realised   0   m2m unrealised   0   option premium   0   payout   0   span   0   holding sales   0   turnover   0   liquid collateral   0   stock collateral   0       Noticed that  True  value  Use this to make things are double checked for Booleans  This will cover those cases -   x   x replace           replace  True     True    replace  False     False    replace  null     null    j   json loads x    Also  make sure you do not make   x   json loads x    It has to be another variable

User · Answer

In my case  double quotes was not a problem    Last comma gave me same error message     a    b  c                   To remove this comma  I wrote some simple code   import json  with open  a json   r   as f      s   f read       s   s replace   t          s   s replace   n          s   s replace               s   s replace               data   json loads s    And this worked for me

User · Answer

Quite simply  that string is not valid JSON  As the error says  JSON documents need to use double quotes   You need to fix the source of the data

User · Answer

Use the eval function   It takes care of the discrepancy between single and double quotes

User · Answer

I ve checked your JSON data     http   example org about     http   purl org dc terms title      type    literal    value    Anna s Homepage        in http   jsonlint com  and the results were   Error  Parse error on line 1       http   example org  --  Expecting  STRING        got  undefined    modifying it to the following string solve the JSON error          http   example org about              http   purl org dc terms title                   type    literal                value    Anna s Homepage

User · Answer

As the other answers explain well the error occurs because of invalid quote characters passed to the json module  In my case I continued to get the ValueError even after replacing   with  quot  in my string  What I finally realized was that some quote-like unicode symbols had found their way into my string                                        To clean all of these you can just pass your string through a regular expression  import re  raw string        key       value       parsed string   re sub r quot                                quot     quot    my string   json object   json loads parsed string

User · Answer

I had the same problem and what I did is to replace the single quotes with the double one  but what was worse is the fact I had the same error when I had a comma for the last attribute of the json object  So I used regex in python to replace it before using the json loads   function   Be careful about the s at the end of  quot loads quot   import re  with open  quot file json quot    r   as f       s   f read        correct format   re sub  quot     n    quot    quot   quot   s       data json   json loads correct format    The used regex return each comma followed by a newline and  quot   quot   replacing it just with a  quot   quot

User · Answer

with open  input json   r   as f      s   f read       s   s replace                data   json loads s    This worked perfectly well for me  Thanks

User · Answer

I had similar problem   Two components communicating with each other was using a queue     First component was not doing json dumps before putting message to queue   So the JSON string generated by receiving component was in single quotes  This was causing error     Expecting property name enclosed in double quotes   Adding json dumps started creating correctly formatted JSON  amp  solved issue

User · Answer

import ast  inpt     http   example org about     http   purl org dc terms title                                           type    literal    value    Anna s Homepage       json data   ast literal eval json dumps inpt    print json data    this will solve the problem

User · Answer

JSON strings must use double quotes   The JSON python library enforces this so you are unable to load your string   Your data needs to look like this     http   example org about     http   purl org dc terms title      type    literal    value    Anna s Homepage        If that s not something you can do  you could use ast literal eval   instead of json loads

User · Answer

I have run into this problem multiple times when the JSON has been edited by hand  If someone was to delete something from the file without noticing it can throw the same error   For instance  If your JSON last     is missing it will throw the same error   So If you edit you file by hand make sure you format it like it is expected by the JSON decoder  otherwise you will run into the same problem   Hope this helps

User · Answer

I used this method and managed to get the desired output  my script  x      inner-temperature   31 73   outer-temperature   28 38   keys-value   0    x   x replace           j   json loads x  print j  keys-value      output    gt  gt  gt  0

[python] Python/Json:Expecting property name enclosed in double quotes

Examples related to python

Examples related to json

Examples related to parsing