I’m having trouble using the Python SDK with a new datasource. You can see that all these keys got collapsed into one column on Panoply. Can you recommend a format to use when converting a dataframe to a list of dicts so that this won’t happen?
I converted a csv to a dict_list as in:
with open(os.path.join(zipfiledir,file)) as csvfile: reader = csv.DictReader(csvfile,delimiter=",") for line in reader: dict_list.append(line)
When I first tried:
for dict in dict_list:
conn.write( targettables, dict );
I got this mashed-up column in Panoply, so I converted the list of dicts to a DataFrame and back, but I still got the same thing.
I have tried converting the DataFrame to_dict as ‘records’, but that didn’t help.