【panda】处理读取文件时以0开头缺失,或数字变成科学计数法,read_csv参数增加dtype=object
1.原数据以0开头
2.在read_csv中,加入参数dtype=object
df = pd.read_csv('./rate_file/rate_20200216.csv', low_memory=False, sep=',', encoding="UTF-8", header=None, usecols=[14, 23,28],dtype=object)
3.成功显示
4.不添加任何参数时,数字以科学计数法显示
df = pd.read_csv('./rate_file/rate_20200216.csv', low_memory=False, sep=',', encoding="UTF-8", header=None, usecols=[14, 23,28])
5.设置display.float_format时,数字前面的0没了
pd.set_option('display.float_format', lambda x: '%.0f' % x)
df = pd.read_csv('./rate_file/rate_20200216.csv', low_memory=False, sep=',', encoding="UTF-8", header=None, usecols=[14, 23,28])