json_to_csv_converter.py fixed for Python 3 about dataset-examples HOT 7 OPEN

@mattdee @meenurajapandian After making the above changes I get this:

UnicodeEncodeError: 'charmap' codec can't encode character '\x9c' in position 112: character maps to

any thoughts on how to fix this?

You need to include the encoding in every place that you have used the open() function. There are 3 places where they need to be included.

from dataset-examples.

Thank you! Also, it worked for me only after I changed line 26 and line 17 to this:
with open(json_file_path, encoding="utf-8") as fin:

from dataset-examples.

@mattdee @meenurajapandian After making the above changes I get this:

UnicodeEncodeError: 'charmap' codec can't encode character '\x9c' in position 112: character maps to

any thoughts on how to fix this?

from dataset-examples.

Totally agree with @meenurajapandian , in this case, encoding = 'latin1' worked fine for me.

from dataset-examples.

@meenurajapandian, i have python 3.6 and newbie to this language. Can you please help me how to set the json file path. I want to convert yelp data set. Please help with the full syntax.i will be very thankful to you. I need fully running code.

from dataset-examples.

Slightly simpler version of json to csv conversion script can be found here: https://github.com/CAVIND46016/Yelp-Dataset-Analysis/blob/master/json_to_csv.py
I have hard-coded the paths, so it should be simple to follow...

from dataset-examples.

@meenurajapandian, i have python 3.6 and newbie to this language. Can you please help me how to set the json file path. I want to convert yelp data set. Please help with the full syntax.i will be very thankful to you. I need fully running code.

From the terminal, you can run the command
$ python json_to_csv_converter.py yelp_academic_dataset.json

if the files are in the current directory or mention the path instead

$ python json_to_csv_converter.py path/yelp_academic_dataset.json

This is given in the documentation of the code.

from dataset-examples.