擅长:python、mysql、java
<p>使用<code>pandas</code>的解决方案</p>
<pre><code>import pandas as pd
holidays = ['2017-01-01', "New Year's Day", 'NSW', '2017-01-02', "New Year's Day (Observed)", 'NSW', '2017-01-26', 'Australia Day', 'NSW', '2017-04-14', 'Good Friday', 'NSW', '2017-04-15', 'Easter Saturday', 'NSW']
col_titles = ('date', 'name','state')
data = pd.np.array(holidays).reshape((len(holidays) // 3, 3))
pd.DataFrame(data, columns=col_titles).to_csv("holidays.csv", index=False)
</code></pre>
<p>其中:</p>
<ol>
<li><code>pd.np.array(holidays)</code>将<code>holidays</code>转换为<code>numpy.array</code></li>
<li><code>.reshape((len(holidays) // 3, 3))</code>将数组的结构更改为三个“列”</li>
<li><code>pd.DataFrame(data, columns=col_titles)</code>根据数据和列标题创建<code>pandas.Dataframe</code></li>
<li><code>.to_csv("holidays.csv", index=False)</code>将数据帧保存到CSV文件中</li>
</ol>
<p><code>holidays.csv</code>的内容:</p>
^{pr2}$
<p>请注意,如果在<code>to_csv</code>中使用<code>index=False</code>,则不会包括索引。在</p>