JSON import in Python

Question

I would like to import the JSON file located at "https://www.drivy.com/cars/458342/reviews?page=1&paginate_per=6&rel=next" in python.

When I run this:

with open('C:/Users/coppe/Documents/py trials/eval.json') as json_file:  
reviews = json.load(json_file)

I get an error:

UnicodeDecodeError: 'charmap' codec can't decode byte 0x8d in position 6776: character maps to <undefined>

Actually this error is due to a special character contained in the html keyvalue. Knowing that this character is an emoticon (a thumb), how can I still import my JSON by ignoring this ?

Kirill Zabrodin · Accepted Answer · 2019-06-07 09:28:12Z

4

You need to specify the correct format for the json encoder to use. Most use utf8, therefore use something like:

reviews = json.load(
    open("C:/Users/coppe/Documents/py trials/eval.json", encoding="utf8")
)

or

with open('C:/Users/coppe/Documents/py trials/eval.json') as json_file:
    reviews = json.load(json_file, encoding="utf8")

Good Luck!

answered Jun 7, 2019 at 9:28

Kirill Zabrodin

841 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam · Accepted Answer · 2019-06-07 09:19:29Z

1

use

open(json_file, encoding="utf8")

answered Jun 7, 2019 at 9:19

Sam

5145 silver badges19 bronze badges

Collectives™ on Stack Overflow

JSON import in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related