Pandas read sql integer became float
Problem is your data contains NaN values, so int is automatically cast to float. I think you can check NA type promotions: 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 … Read more