I am trying to export my df to gsheets after grouping them. However the numeric columns have values starting with ‘. E.g. instead of 250.43 it exports ‘250.43
I have tried everything suggested by chatgpt lol. Any other recommendations? Losing it!
df_new = df.groupby(['column a','column b','column c']).agg({'column d':'sum', 'column e':'sum','column f':'sum'}).reset_index()
I used regex, astype, lambda formatting, even locale.
New contributor
pullukse is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.