python - How to make a dictionary from the pandas data frame?

Question

Closed. This question needs to be more focused. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65860797/how-to-make-a-dictionary-from-the-pandas-data-frame

Answer 1

You can create a new column first using apply function, then use that column to group and format data

df['gkey'] = df.apply(lambda row: row['col1'].split(',')[0], axis=1)
l = []
for key, value in df.groupby('gkey'):
    l.append({'key': key, 'Results': [{row['col1'].split(',')[1]: row['fre']}for index, row in value.iterrows()]})