On Friday, October 18, 2019 at 4:55:33 PM UTC+3, Chris Angelico wrote: > On Sat, Oct 19, 2019 at 12:51 AM <doganad...@gmail.com> wrote: > > By taking the default OUTPUT of a numpy formula, in my case standart > > deviation, I am using the advantage of saving the result into an excel file > > without any problems.(they come as numpy.float64) From there, The excel > > takes all the things as they are and some of my small numbers are shown > > with the 'e' on the excel sheet. Which I am trying to avoid. > > > > I don't need 100 numbers after the comma. What I need is a reasonable > > amount of decimal numbers to show that the number is small enough, also > > keeping them in float64, in my case to save them into excel file. One > > important thing to say is that, if I convert them into string and save them > > on excel they come with 'dot' instead of comma. And If try to translate the > > 'dot' manually into 'comma' the excel gives warning message to turn those > > inputs into numbers. Which I also avoid. > > > > If this is Python default, showing all numbers smaller than 0.0001 with 'e' > > and there is no way to have them in both a human readable and excel savable > > form. > > > > You're conflating the number with its representation. Whenever you > display a number, you need a set of digits. The number itself is > exactly the same whether it's written as 0.00000001 or 1e-8 or any > other form, just as you can write a fraction as 3 1/7 or as 22/7 and > it's the same number. > > Look at the way you're "saving the result into an Excel file". > Firstly, is it CSV or actually saved into Excel format? Then look at > the way you actually display the number there. In a CSV file, once > again, you need a series of digits, so you simply need to format the > number the way that people have been advising you. > > ChrisA
Thank you Chris, I will answer down below, on Richard's -- https://mail.python.org/mailman/listinfo/python-list
