擅长:python、mysql、java
<p>下面。代码创建3个csv文件。每个id对应一个</p>
<pre><code>import csv
from collections import defaultdict
data_by_id = defaultdict(list)
with open('c:\\temp\\temp.csv')as f:
reader = csv.reader(f)
next(reader)
for row in reader:
data_by_id[row[0]].append(row[1:])
for _id, data in data_by_id.items():
with open('c:\\temp\\{}.csv'.format(_id), 'w') as f:
f.write('id,description,price\n')
for line in data:
line.insert(0, _id)
f.write(','.join(line) + '\n')
</code></pre>
<p>temp.csv</p>
<pre><code>id,description,price
12,desc1,12.4
13,desc13,13.4
12,desc132,312.4
13,desc1er,5.8
11,desc1wewe,77.9
</code></pre>