擅长:python、mysql、java
<p>对于这种简单的情况,您可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.apply.html" rel="nofollow noreferrer">^{<cd1>}</a>对每列应用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.explode.html" rel="nofollow noreferrer">^{<cd2>}</a>,如下所示:</p>
<pre><code>df = df.apply(pd.Series.explode)
</code></pre>
<p><strong>结果:</strong></p>
<pre><code>print(df)
ID Title Sponsor name date comparator
0 NT0235 bla bla bla sponsor name1 2021-08-13 comparator1
1 NT0236 bla bla bla sponsor name2 2021-08-12 comparator2
2 NT0237 bla bla bla sponsor name3 2021-08-11 comparator3
3 NT0238 bla bla bla sponsor name4 2021-08-10 comparator4
4 NT0239 bla bla bla sponsor name5 2021-08-09 comparator5
</code></pre>
<p>如果只想应用于选定列,可以使用:</p>
<pre><code>df[['ID', 'Title', 'Sponsor name', 'Comparator']] = df[['ID', 'Title', 'Sponsor name', 'Comparator']].apply(pd.Series.explode)
</code></pre>