I´m trying to save a pandas df column into a csv file. I dont want numbers in scientific notation in my output file. I´ve tried to use the argument float_format inside the df_to_csv but for some reason i am getting numbers in scientific notation just for the cases with negative exponents.
The column i want to have withount scientific notation is a mix of floats and strings. I´ve tried something like this:
df.to_csv(rutacsv, index=False, mode='w', sep=';', encoding='latin-1', float_format='%.12f', decimal='.')
I´ve also tried to use setting pandas display options, df.round() and some sort of things that didn´t work for me.
thanks in advice.