python - Parsing a CSV of Nested JSONs

Question

I have a CSV of JSON files, directly from a database. Each JSON has nested JSONs, and I am struggling to parse this CSV and keep each JSON intact (i.e., still nested). Ideally I want to return a Pandas Series/DataFrame object where each row is the highest level of these nested JSONS.

The default pandas.read_csv('filepath.csv') doesn't work. I've tried replacing the delimiter with other characters, but still have the same issue.

I'm unsure of how best to proceed. I would appreciate some help. Thanks in advance.

标签： pythonjsonpandascsv