擅长:python、mysql、java
<p>在使用<code>pd.wide_to_Long</code>之前需要一点处理</p>
<pre><code>hh=pd.Series(df.columns)
df.columns=hh+hh.groupby(hh).cumcount().add(1).astype(str)
pd.wide_to_long(df,['color','size','dim'],i=['ID1','Material1','Description1','Tech1'],j='drop').reset_index().drop('drop',1
)
Out[556]:
ID1 Material1 Description1 Tech1 color size dim
0 1 xcv456 Rubber elastic 101 s 32
1 1 xcv456 Rubber elastic 102 m 34
</code></pre>