擅长:python、mysql、java
<p>这就是<code>wide_to_long</code>构建</p>
<pre><code>pd.wide_to_long(df,['wk'],i=['SKU','Ids'],j='value',sep='_').reset_index()
Out[28]:
SKU Ids value wk
0 10 20 1 1
1 10 20 2 2
2 10 20 3 3
3 10 20 4 4
4 10 20 5 5
5 10 20 6 6
6 30 40 1 6
7 30 40 2 5
8 30 40 3 4
9 30 40 4 3
10 30 40 5 2
11 30 40 6 1
</code></pre>