New answers tagged


As some commenters alluded, SQL is a good option for expressing rather complicated sets of constraints. The sqldf package makes it easy to use SQL's power in R without needing to set up a relational database yourself. Here's a solution using SQL. Before running, I had to rename your data's interval columns to startTime and endTime because the name from is ...

Top 50 recent answers are included