擅长:python、mysql、java
<p>你就快成功了。你遇到的两个问题是:</p>
<p>1)将<code>signals_list</code>粘贴到外部列表中。将<code>signals_list</code>直接传递给<code>zip_longest</code>,您应该被设置在那里:</p>
<pre><code>transposed_signals = list(zip_longest(*signals_list, fill_value = ''))
</code></pre>
<p>2)写入标题行。首先,您需要编写该行中的所有列(您只需编写一列)。另外,<code>writerow()</code>需要iterable,这就是为什么在传递字符串时,每列只能得到一个字符。试试这个,省去<code>col_name</code>:</p>
<pre><code>wr.writerow(('sound_' + str(i + 1) for i in range(len(transposed_signals))))
</code></pre>
<p>把这一切放在一起(只是第二部分),你应该有:</p>
<pre><code>transposed_signals = list(zip_longest(*signals_list, fillvalue=''))
with open('C:/Users/Marwat/.spyder-py3/FYP/input/numbers.csv', 'w', encoding="ISO-8859-1", newline='') as myfile:
wr = csv.writer(myfile)
wr.writerow(('sound_' + str(i + 1) for i in range(len(transposed_signals))))
wr.writerows(transposed_signals)
# Calling myfile.close() isn't necessary since `with` does that automatically upon exiting that scope.
</code></pre>