I have two datasets, one an hourly weather record:
And one a set of events with dates and times:
I would like to join the two, such that I have the format:
This weather data is about 52,000 rows, so a cross join is out of the question! I considered the potential for using SQL, but is there a way of feeding .xlsx into an SQL query to process the join? Or is there perhaps another way of doing it? I have had a look at “H2” databases, but that seems to hold all information about my tables but the actual data! Thanks!