擅长:python、mysql、java
<p>尝试:</p>
<pre><code>df["First_date"] = pd.to_datetime(df["First_date"])
df["Second_date"] = pd.to_datetime(df["Second_date"])
sundays = df.apply(lambda x: len(pd.date_range(x["Second_date"], x["First_date"], freq="W-SUN")), axis=1)
df["days"] = (df["First_date"]-df["Second_date"]).dt.days-sundays
>>> df
First_date Second_date days
0 2021-09-18 2021-09-17 1
1 2021-09-22 2021-09-17 4
2 2021-09-27 2021-09-17 8
</code></pre>