0

I am using the following code to go through a table with serial numbers and months and look for a equivalent service-log in another table to determine for each line, if there was a service in the recent 12 months. The code works but is very slow. Does anyone have a hint for a more performant alternative?

Test_Machines["Loyal"]=Test_Machines.apply(lambda x: ServiceLogs.isin({"serialnumber": [x.serialnumber] ,"request_date" : pd.date_range(x.Year_Month.to_timestamp()-pd.offsets.DateOffset(years=1),x.Year_Month.to_timestamp())}).all(axis=1).any(), axis=1)

Thanks in advance!

Richard

Richard Wonner
  • 35
  • 5
  • See [How to make good pandas examples](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) and [edit] your question to include a [mcve] with sample input data and expected output so that we can better understand your task – G. Anderson Jan 24 '22 at 18:26

0 Answers0