擅长:python、mysql、java
<p>尝试使用<code>str.split</code>和<code>pd.to_datetime</code>:</p>
<pre><code>df[2] = pd.to_datetime(df[1].str.replace('\(Responses\) ', ''))
print(df)
</code></pre>
<p>输出:</p>
<pre><code> 0 1 2
0 18 (Responses) 17th Nov 20 2020-11-17
1 304 (Responses) 17th Nov 20 2020-11-17
2 1177 (Responses) 17th Nov 20 2020-11-17
3 899 (Responses) 17th Nov 20 2020-11-17
</code></pre>