Hello - new with Python. I have downloaded FDA data from here:
https://open.fda.gov/apis/drug/ndc/download/
I am trying to read in the file and then export to csv. For some reason that I cannot figure out, I get error 'Mixing dicts with non-Series may lead to ambiguous ordering.'
My code is as follows:
Code:
import pandas as pd
df = pd.read_json(r'C:\{my_path}\drug-ndc-0001-of-0001.json')
df.to_csv (r'C:\{my_path}\NDCData.xlsx', index = None)
Any assistance is appreciated. Thanks