擅长:python、mysql、java
<p>这里有一个方法</p>
<pre><code>df = pd.read_clipboard(sep = '\s\s+')
Index_Date A B C D
2015-01-31 10 10 we 10
2015-02-01 2 3 jk 22 and 23 and 24
2015-02-02 10 60 nm 280
2015-02-03 10 100 oi 250
df.set_index(['Index_Date', 'A', 'B', 'C']).D.str.split('and', expand = True)\
.stack().reset_index(4,drop = True).reset_index(name = 'D')
Index_Date A B C D
0 2015-01-31 10 10 we 10
1 2015-02-01 2 3 jk 22
2 2015-02-01 2 3 jk 23
3 2015-02-01 2 3 jk 24
4 2015-02-02 10 60 nm 280
5 2015-02-03 10 100 oi 250
</code></pre>