How to correctly open the csv file: Data Skewed

[neshant]

Not an issue with code but How do I correctly open/import the csv file in excel the data is skewed due to json in the data which is also a csv data.

[neshant]

there are three columns in particular that are trouble , I just made a small change to get around opening the file in csv although all columns could do this in case more of the json columns are added.

        try:
            if key == 'executed_notional' or key == 'last_trail_price' or key == 'dollar_based_amount' or key == 'total_notional':
                csv += "\""+str(fields[row][key])+"\""
            else:
                csv += str(fields[row][key])
        except:
            csv += ""

[savingsandloan]

dupe of #53

[pvh1983]

Thanks a lot. It worked. I took me a while to find out where to insert it so I post it here: