擅长:python、mysql、java
<p>像那样的东西应该适合这份工作。在</p>
<pre><code>import csv
transformed = []
with open('excel.csv', newline='') as csvfile:
r = csv.reader(csvfile, delimiter=' ', quotechar='|')
for row in r:
channel, condition, *vals = row
for val in vals:
transformed.append([channel, condition, val])
with open('transformed.csv', 'w', newline='') as csvfile:
w = csv.writer(csvfile, delimiter=' ',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
for row in transformed:
w.writerow(' '.join(row))
</code></pre>