dataset-examples JSON_to_CSV

Hi I am trying to convert json code into CSV and I am using the code that you have provided, however I am running into some errors. When I write the $ python json_to_csv_converter.py yelp_academic_dataset.json in the commandline i am getting the following error:

Traceback (most recent call last): File "json_to_csv_converter.py", line 122, in column_names=get_superset_of_column_names_from_file<json_file> File "json_to_csv_converter.py", line 25, in get_superset_of_column_names_from_file for line in fin: File "C:\Users\Bengi\Appdata\Local\Programs\Python\Python35-32\lib\encodings\cp1252.py" line 23, in decode return codecs.charmap_decode(input, self_errors,decoding_table)[0] Unicode Decode Error: 'charmap' codec cant decode byte 0X9d in position 1102: character maps to

Can you help me please?

Feb 27 '16 23:02 bngksgl

@bngksgl, or anyone else, if you're seeing json DecodeErrors, it may be that the input file is not a valid json file. The Yelp dataset is delivered as a compressed archive, .tar and is, 'double-zipped'. Before running the converter script you should see 5 separate json files (business,json, review.json etc...). In Windows, after unzipping yelp_dataset_challenge_academic_dataset.tar, I had to add the .tar extension again to the ~2GB output file, and unzip that to get the individual files... Then, converting the individual json files worked fine. I ran into a similar error, not realizing the file hadn't been completely unpacked.

capture