pandas read_csv(path,dtype)按类型读取字段
参考pandas21 读csv文件read_csv(3.dtypes指定列数据类型)(详细 tcy)_tcy23456的博客-CSDN博客_readcsv数据类型
假设数据是这样的:
id,name,age,depart,career,imageCount
0001,张不错,10,sdsdsd,sdsdsd,1
0002,张学友,10,sdsdsd,ssdsdsd,1
如果read_csv()
这样写:
import pandas as pd
df = pd.read_csv('person.csv')
for index in df.index:
temp = df.loc[index].values
print(temp)
---
[1 '张不错' 10 'sdsdsd' 'sdsdsd' 1]
[2 '张学友' 10 'sdsdsd' 'ssdsdsd' 1]
可以看到id
被处理成int
了,所以在读取时需要指定类型:
dtype = {
'id' : str,
'name' : str,
'age' : str,
'depart' : str,
'career' : str,
'imageCount' : int
}
df = pd.read_csv('person.csv',dtype=dtype)
for index in df.index:
temp = df.loc[index].values
print(temp)
---
['0001' '张不错' '10' 'sdsdsd' 'sdsdsd' 1]
['0002' '张学友' '10' 'sdsdsd' 'ssdsdsd' 1]