擅长:python、mysql、java
<p>需要:</p>
<pre><code>s=df.day_count
s1=[pd.Timedelta(x,'D') for x in sum(df.day_count.apply(lambda x : list(range(x))),[])]
df_new=df.reindex(df.index.repeat(s))
df_new['hold_date']=df_new.hold_date+s1
df_new
Out[642]:
hold_date day_count qty item ccy
0 2015-01-01 1 1200 CB04box USD
1 2015-01-01 3 1500 AB01box USD
1 2015-01-02 3 1500 AB01box USD
1 2015-01-03 3 1500 AB01box USD
2 2015-01-02 2 550 CB03box USD
2 2015-01-03 2 550 CB03box USD
</code></pre>