擅长:python、mysql、java
<p>IIUC,如果您有这样一个数据帧<code>df</code>:</p>
<pre><code> Project Status
0 101 Open
1 102 Closed
</code></pre>
<p>您可以重复将日期范围放入第三列,然后<code>explode</code>它,即</p>
<pre><code>dates = pd.date_range(start="1/1/2021", periods=12, freq="M")
df["Period"] = [dates] * len(df)
df = df.explode("Period")
</code></pre>
<p>得到</p>
<pre><code> Project Status Period
0 101 Open 2021-01-31
0 101 Open 2021-02-28
0 101 Open 2021-03-31
0 101 Open 2021-04-30
0 101 Open 2021-05-31
0 101 Open 2021-06-30
0 101 Open 2021-07-31
0 101 Open 2021-08-31
0 101 Open 2021-09-30
0 101 Open 2021-10-31
0 101 Open 2021-11-30
0 101 Open 2021-12-31
1 102 Closed 2021-01-31
1 102 Closed 2021-02-28
1 102 Closed 2021-03-31
1 102 Closed 2021-04-30
1 102 Closed 2021-05-31
1 102 Closed 2021-06-30
1 102 Closed 2021-07-31
1 102 Closed 2021-08-31
1 102 Closed 2021-09-30
1 102 Closed 2021-10-31
1 102 Closed 2021-11-30
1 102 Closed 2021-12-31
</code></pre>