python对csv操作_python中的CSV操作

使用pip install csvmapper安装import csvmapper

# create parser instance

parser = csvmapper.CSVParser('customers.csv', hasHeader=True)

# create object

customers = parser.buildDict() # buildObject() if you want object

# perform manipulation

for customer in customers:

customer['Name'] = customer['FirstName'] + ' ' + customer['LastName']

# remove last name and firstname

# maybe this was what you wanted ?

customer.pop('LastName', None)

customer.pop('FirstName', None)

print customers

输出

^{pr2}$

这通过以dict形式访问来组合firstName和lastName，因为我想您可能想删除last name和firstName，只将其替换为“name”属性。如果您想像javascript那样访问它，可以使用parser.buildObject()

编辑

你也可以把它保存回CSV。在writer = csvmapper.CSVWriter(customers) # modified customers from the above code

writer.write('customers-final.csv')

对于能够执行数学运算，您可以使用自定义映射器文件，例如mapper = csvmapper.DictMapper(x = [

[

{ 'name':'ID' ,'type':'long'},

{ 'name':'LastName' },

{ 'name':'FirstName' },

{ 'name':'Item' },

{ 'name':'Date', 'type':'int' }

]

]

parser = csvmapper.CSVParser('customers.csv', mapper)

并指定类型