how to fetch the latest row while joining two datasets and the latest row should be less than the date from the dataset ‘A’ [duplicate]
This question already has answers here: Pandas Merge on Name and Closest Date (3 answers) Closed 29 days ago. Consider I have a dataset which has a date column that is generated everyday as given below. DF_A ID name qty date 1 abc 20 17/01/2022 1 abc 10 18/01/2022 2 def 10 24/01/2022 2 def […]