Sorry for the confusing title! I have the following columns in my dataframe:
Column A Column B ['Dogs','Cats','Horses'] [0.5,0.25,0.25] ['Dogs'] [1.0] ['Cats','Horses'] [0.75,0.25] And the output I would like is:
Dogs Cats Horses 0.5 0.25 0.25 1.0 0 0 0 0.75 0.25 Thank you in advance!
I tried the following code:
keys = set([key for row in df['column_a'] for key in row]) for key in keys: df[key] = 0.0 for i, row in df.iterrows(): for key, value in zip(row['column_a'], row['column_b']): if isinstance(value, list): for demography, score in zip(key, value): df.at[i, demography] = score else: df.at[i, key] = value df.drop(columns=['column_a', 'column_b'], inplace=True) and got an error "TypeError: 'float' object is not iterable"
Источник: https://stackoverflow.com/questions/780 ... responding
