Timeline for How to join two tables with aggregation
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 27, 2023 at 7:47 | comment | added | user453575457 | Thanks a lot, your answer is perfectly right and correct, i can check only one answer tho, so checking the earliest | |
| Sep 26, 2023 at 14:26 | history | edited | Shubham Sharma | CC BY-SA 4.0 | deleted 123 characters in body |
| Sep 26, 2023 at 14:24 | comment | added | Shubham Sharma | @Emma Agree, Good point :-) | |
| Sep 26, 2023 at 14:20 | comment | added | Emma | I got a pretty similar to this answer :) except I think you don't need to create sequence if you do conditional join. df1.join(df2, on=(df1.start <= df2.day) & (df1.end >= df2.day)) | |
| Sep 26, 2023 at 14:14 | history | answered | Shubham Sharma | CC BY-SA 4.0 |