Nested Json to csv in python 3

[ravikuc]

I am trying to convert JSON data into a CSV in Python3, but it no longer works with this script, giving me different errors. Anyone know how to fix for Python 3? Thanks.

Below is my JSON data:

{
"fruit": [
{
"name": "Apple",
"binomial name": "Malus domestica",
"major_producers": [
"China",
"United States",
"Turkey"
],
"nutrition": {
"carbohydrates": "13.81g",
"fat": "0.17g",
"protein": "0.26g"
}
},
{
"name": "Orange",
"binomial name": "Citrus x sinensis",
"major_producers": [
"Brazil",
"United States",
"India"
],
"nutrition": {
"carbohydrates": "11.75g",
"fat": "0.12g",
"protein": "0.94g"
}
},
{
"name": "Mango",
"binomial name": "Mangifera indica",
"major_producers": [
"India",
"China",
"Thailand"
],
"nutrition": {
"carbohydrates": "15g",
"fat": "0.38g",
"protein": "0.82g"
}
}
]
}

[ravikuc]

The output CSV should look like:

[JeffMv]

Hi @ravikuc (or rather anyone looking to make it work for python 3),
I created a fork for Python 3 and added most of the changes made up until today (2020-06) by other forks. I dropped python 2.

If you want to do it by yourself, just the best thing to do would be to execute the python command utility 2to3 with option -w to convert the deprecated Python 2 code to Python 3.
For instance on Unix:

2to3 -w json2csv.py

[bitscott1102]

@ravikuc you can flatten json by from flatten_json import flatten. Then apply json2csv

[brahma19]

@ravikuc refer to py3 port of the same, https://github.com/brahma19/json2csvpy3

I have tested this in my local and getting this as output