您只需指定转换器。我创建了具有以下结构的Excel电子表格:
names ages
bob 05
tom 4
suzy 3
“年龄”列的格式设置为字符串。加载:
import pandas as pd
df = pd.read_excel('Book1.xlsx',sheetname='Sheet1',header=0,converters={'names':str,'ages':str})
>>> df
names ages
0 bob 05
1 tom 4
2 suzy 3