擅长:python、mysql、java
<p>这是因为右侧是一个具有不同列名(<code>0</code>,<code>1</code>)的数据帧,Pandas在该数据帧中找不到<code>Column 2</code>或<code>Column 3</code></p>
<p>您可以传递基础numpy数组而不是数据帧:</p>
<pre><code>df[['Column 2','Column 3']] = df['Column 1'].str.extract(r'(\d+)TO(\d+)').values
</code></pre>
<p>输出:</p>
<pre><code> School ID Column 1 Column 2 Column 3
0 School 1 AD6000 NaN NaN
1 School 2 3000TO4000 3000 4000
2 School 3 5000TO6000 5000 6000
3 School 4 AC2000 NaN NaN
4 School 5 BB3300 NaN NaN
5 School 6 9000TO9900 9000 9900
</code></pre>