[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Convert a scientific notation to decimal number, and still keeping the data format as float64

On Friday, October 18, 2019 at 4:55:33 PM UTC+3, Chris Angelico wrote:
> On Sat, Oct 19, 2019 at 12:51 AM <doganadres at> 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