擅长:python、mysql、java
<p>您可以将<code>groupby()</code>日期设置为工作日或周末。下面的代码源代码并演示了这一点</p>
<pre><code>import requests
import io
import pandas as pd
dfall = pd.read_csv(io.StringIO(requests.get(
"https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/owid-covid-data.csv").text))
dfall["date"] = pd.to_datetime(dfall["date"])
dtlcols = ["date", "iso_code", "location", "continent"]
cols = ["new_cases", "new_deaths", "new_tests"]
dfall.loc[dfall["iso_code"].eq("GBR"), dtlcols + cols].groupby(
dfall["date"].dt.dayofweek.isin([5, 6]), as_index=False
).agg({**{c: "last" for c in dtlcols}, **{c: "mean" for c in cols}})
</code></pre>
<div class="s-table-container">
^{tb1}$
</div>