Creating a dataframe, by running pd.read_sql returns the column as float. When I try converting it back to integer, I get "ValueError: Cannot convert non-finite values (NA or inf) to integer", but the ...

SQL sensor with uncontrollable number precision floods state_attributes table. When SQL-sensor fetch result it store all data to state_attributes.shared_data JSON, so any new FLOAT value creates an ...