擅长:python、mysql、java
<p>您只需在<code>pandas</code>中更改df的格式</p>
<pre><code>df=df.reset_index()
df['New']=df.A.loc[df.score=='']
df.ffill().loc[df.score!=''].pivot('New','A','score')
Out[406]:
A test1 test2 test3 test4
New
NameA 10 23 None 15
NameB 10 None 17 None
</code></pre>