How to keep zero left on import in Python?

Question

Hello I have several TXT files with CPF numbers. CPF has 11 numbers, so you can have zeros left to complete this size I opened these files in Excel and gathered them in one. In the CPF column, before opening each file, I turned the Excel import command to as Text to keep the zeros. In xlsx format it worked

But when I recorded it as CSV I saw the zeroes on the left were gone

In Python 3 opened, to use pandas later, and I saw that really lost the zero on the left and turned int64:

candidatos = pd.read_csv("candidatos_excel_cpfinteiro_csv.csv",sep=';',encoding = 'latin_1')

candidatos.info()

    <class 'pandas.core.frame.DataFrame'>
RangeIndex: 26245 entries, 0 to 26244
Data columns (total 9 columns):
UF                  26245 non-null object
Estado              26245 non-null object
Cargo               26245 non-null object
Nome_completo       26245 non-null object
CPF                 26245 non-null int64
Nome_urna           26245 non-null object
Partido             26245 non-null object
Partido_completo    26245 non-null object
Situacao            26245 non-null object
dtypes: int64(1), object(8)
memory usage: 1.0+ MB

I tried to open the Excel file directly with the xlrd, but it got as number in the same way:

xlsx = pd.ExcelFile('candidatos_excel_cpfinteiro.xlsx')

candidatos = pd.read_excel(xlsx, 'Planilha1')

candidatos.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 26245 entries, 0 to 26244
Data columns (total 9 columns):
UF                  26245 non-null object
Estado              26245 non-null object
Cargo               26245 non-null object
Nome_completo       26245 non-null object
CPF                 26245 non-null int64
Nome_urna           26245 non-null object
Partido             26245 non-null object
Partido_completo    26245 non-null object
Situacao            26245 non-null object
dtypes: int64(1), object(8)
memory usage: 1.0+ MB

Would someone please have a suggestion on how to keep zeros on the left? Or keep that column as a string?

Answer 1

You can define the dtype at the time of import. For example:

candidatos = pd.read_csv("candidatos_excel_cpfinteiro_csv.csv",sep=';',
                         encoding = 'latin_1', dtype=str)

It is also possible to define the dtype individually, for example, {‘a’: np.float64, ‘b’: np.int32}.

For more details, I recommend documentation.

Answer 2

Try to import directly from excel, use this line of code you will not lose any value:

import pandas as pd

seu_dataframe = pd.read_excel('nome do seu arquivo .xlsx')