'pandas importing float values and returning object values how to prevent this?
i would like to keep the formatation data type of excel when i import on the pandas, but when in the case os screenshot i'am trying to import in my csv the header area venda m2 is numeric but when i import to the pandas it's became a object.
Code of the imports
df = pd.read_csv('C:\\Users\\LucasSilvaDantasAbra\\Desktop\\teste\\base_nova_040420224.csv', delimiter = ';')
df.columns
Code to show all the colums
pd.set_option('display.max_rows', None)
Data frame
dfbase = df
Showing types
dfbase.dtypes
Solution 1:[1]
Pandas Data Frame is confused with the commas "," You need to replace then by dots "."
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Danrley Perez Sena |


