擅长:python、mysql、java
<p>与<code>dropna</code>一起使用<code>melt</code></p>
<pre><code>yourdf=df.melt(['Date','DV']).dropna()
yourdf
Date DV variable value
0 22/02/2019 200 FA1 Lazard
1 2/02/2019 50 FA1 Deutsche
2 22/02/2019 120 FA1 ChinaSecurities
4 2/02/2019 50 FA2 Ondra
5 22/02/2019 120 FA2 Ballas
8 22/02/2019 120 FA3 Daiwa
11 22/02/2019 120 FA4 MorganStanley
</code></pre>