[docs]classFrance(CountryTestBase):location="France"units="people tested"source_url_ref=("https://www.data.gouv.fr/fr/datasets/donnees-relatives-aux-resultats-des-tests-virologiques-covid-19/")source_label="National Public Health Agency"
[docs]defread(self):url="https://www.data.gouv.fr/fr/datasets/r/d349accb-56ef-4b53-b218-46c2a7f902e0"df=pd.read_csv(url,sep=";",usecols=["jour","cl_age90","T","P"])df["T"]=[int(x.replace(",00",""))forxindf["T"]]df["P"]=[int(x.replace(",00",""))forxindf["P"]]df=(df.rename(columns={"jour":"Date"}).groupby("Date",as_index=False).agg(**{"Daily change in cumulative total":("T",sum),"pos":("P",sum)}))df["Positive rate"]=((df["pos"].rolling(7).mean())/(df["Daily change in cumulative total"].rolling(7).mean())).round(3)returndf
[docs]defpipeline(self,df:pd.DataFrame):df=df.dropna(subset=["Daily change in cumulative total","Positive rate"],how="all")df=df.pipe(self.pipe_metadata)returndf