Integer numbers in pandas python "dataframe"

Question

Integer numbers in pandas python "dataframe"

Navigation

#1 by (1 votes)

2

I import a document to jupiter and enter normal with whole numbers, I apply a formula to group, add and then subtract and the product leaves all the numbers with decimals and exponentials.

How do I get only whole numbers ???

::::::: attached code ::::::::::

mydataset_df.head(10)

cond1_df = (
    mydataset_df
    .groupby(["move_id/id"], as_index=False)
    .sum()
    .assign(
        balance=lambda row: row.credit - row.debit
    )
    .assign(
        resultado=lambda row: row.balance < -0.000001
    )

)

cond1_df.head()

python pandas bigdecimal

asked by Yan Chirino 12.04.2018 в 00:25

source

1 answer

How to access global variables in python Stuck reading YouTube video with C ++ and wxWidgets

score 1 · Accepted Answer

The columns are originally of the float type, the use of scientific notation is used by default to show very large or very small values in order to represent the DataFrame in the always limited screen space without having excessively wide columns.

A very simple example:

>>> import pandas as pd

>>> df = pd.DataFrame({"a":[1214514552.0, 14455145556552.0]})

>>> df
              A
0  1.214515e+09
1  1.445515e+13

You can force a certain format at the time of representing the floats by using the display.float_format option and using the format specification mini language :

>>> pd.set_option('display.float_format', '{.1f}'.format)
>>> df
                 A
0     1214514552.0
1 14455145556552.0

You can also use pd.options.display.float_format = '{:.1f}'.format .

In this case with :.1f force the floats with a single decimal. This does not affect the data itself , only the way it is displayed.