在 python3 和 pandas 中,我像這樣打開一個 CSV:import pandas as pdkwargs = {'sep': ';', 'dtype': str, 'encoding': 'utf-8'}df = pd.read_csv("COVID_sp_29_mai_2020.csv", **kwargs)df.info()<class 'pandas.core.frame.DataFrame'>RangeIndex: 7119 entries, 0 to 7118Data columns (total 27 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 Secretaria 7119 non-null object 1 Assunto 7119 non-null object 2 13979 7119 non-null object 3 Valor de Empenho no Processo 7119 non-null object 4 órg?o 7119 non-null object 5 Código UG Documento 7119 non-null object 6 Descri??o Processo 7119 non-null object 7 Finalidade 7119 non-null object 8 R$ Empenho 7119 non-null object 9 Tipo Documento 7119 non-null object 10 Data Atualiza??o 7119 non-null object 11 R$ Pago 7119 non-null object 12 Número Empenho 7119 non-null object 13 Número Documento NE Ref / Anul 335 non-null object 14 Número Processo 7119 non-null object 15 CGC CPF 7026 non-null object 16 Nome Credor 7119 non-null object 17 Data Emiss?o 7119 non-null object 18 A??o Or?amentária 7119 non-null object 19 Fonte 7119 non-null object 20 Código Fonte 7119 non-null object 21 Descri??o 7119 non-null object列有'CGC CPF'有識別碼,有時只能有數字或數字和字母在這種情況下,該行的代碼在 CSV 中為“2,29E+13”。這是一個公司代碼,我知道是“22896431000110”請問,如何將列符號轉換為整數?我想將指數表示法值轉換為 int。同時,我將檢查 CSV 值是否正確
在熊貓中如何將符號轉換為整數?
慕工程0101907
2022-12-20 15:02:20