Pd.read_sql add zero to int number from table sql server

Question

I'm wondering why pandas.read_sql add .zero at the end of my data please ? In SQL Server, the data are number indicated like int.

Someone knows why please?

And when I look type of data, it's indicated like float64.

cdrrr · Accepted Answer · 2021-06-17 07:17:30Z

0

According to this solution, this happens because your data might contains NaN values, so in order to handle this, int data type is automatically converted to float.

When introducing NAs into an existing Series or DataFrame via reindex or some other means, boolean and integer types will be promoted to a different dtype in order to store the NAs. These are summarized by this table:

Typeclass   Promotion dtype for storing NAs
floating    no change
object      no change
integer     cast to float64
boolean     cast to object

answered Jun 17, 2021 at 7:17

cdrrr

1,0844 gold badges17 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pd.read_sql add zero to int number from table sql server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related