How do I solve this specific Pandas Type Error

user_4820172 0
Viewed 31

I am using the groupby method to combine the cell values (strings) of a column:

dfz = dfy.groupby('Type ').agg({'Initial ':lambda x: '/'.join(x.unique()),2021:'sum',2022:'sum'}).reset_index()

The following error message appears:

TypeError: Sequence item 0: expected str instance, float found

pandas python
1 Answers

join method input a tuple or array of strings, try this:

dfz = dfy.groupby('Type ').agg({'Initial ':lambda x: '/'.join([str(r) for r in x.unique()]),2021:'sum',2022:'sum'}).reset_index()
user_188927490
Related