擅长:python、mysql、java
<p>给定csv:</p>
<pre><code>NH08OTR, 2008, Vauxhall, Corsa, Blue, In
NH08OTY, 2008, Vauxhall, Corsa, Blue, Out
NH08OTZ, 2008, Vauxhall, Corsa, Blue, In
</code></pre>
<p>我们要打开它,在内存中编辑它,然后保存编辑,因此:</p>
<pre><code>import csv
# Open csv
r = csv.reader(open('car_parking.csv'))
line_in = [k for k in r]
#look for plate
number_plate = 'NH08OTZ'
#get current parking status
find_plate=([i for i,k in enumerate(line_in) if k[0] == number_plate]) #find plate in array
current_park_status = line_in[find_plate[0]][5]
print current_park_status
#edit array position, with new status
new_parking_status = 'IN'
line_in[find_plate[0]][5] = new_parking_status
#overwrite cv with new result
out = csv.writer(open('car_parking.csv', 'w'))
out.writerows(line_in)
</code></pre>