I'm reading a csv file like this:
import pandas as pd
arq_pedido = pd.read_csv('Pedido.csv',delimiter=";", encoding = "ISO-8859-1")
I have a ID column (this column is supposed to be an INT column, but in Brazil (Portuguese), thousand's numbers is represented like this: 1.000 instead of 1000. So, my ID column is dfloat64 at the moment.
I have one ID who is 1.908 (1908), and this number shows 1.9080000000000001. How can I transform dfloat64 to int? Or, how can I replace dots (.) for comma (,), to turned that numbers in thousands ones?
There is a thousands parameter for this. Try,
arq_pedido = pd.read_csv('Pedido.csv', delimiter=";", encoding = "ISO-8859-1", thousands=".")
You may also wish to set decimal="," to handle decimal numbers correcltly.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments