擅长:python、mysql、java
<p>有一个办法</p>
<pre><code>In [93]: df
Out[93]:
TITLE1 TITLE2 TITLE3
A B
idx1 idx2 val1 val2 val3
idx3 va11 val2 val3
idx3 va11 val2 val3
idx3 va11 val2 val3
idx2 idx4 val1 val2 val3
idx5 va11 val2 val3
idx6 va11 val2 val3
idx7 va11 val2 val3
</code></pre>
<p>重置级别1上的索引。在</p>
^{pr2}$
<p>替换列中的值。在</p>
<pre><code>In [96]: dff['B'] = dff['B'].str.replace('idx', 'new')
In [97]: dff
Out[97]:
B TITLE1 TITLE2 TITLE3
A
idx1 new2 val1 val2 val3
idx1 new3 va11 val2 val3
idx1 new3 va11 val2 val3
idx1 new3 va11 val2 val3
idx2 new4 val1 val2 val3
idx2 new5 va11 val2 val3
idx2 new6 va11 val2 val3
idx2 new7 va11 val2 val3
</code></pre>