As shown in the figure, Figure 1 shows the number of people entering the station at each subway station at each time. Since it is a simulated real data, for example, no one entered the station at Qilizhuang at 5 o'clock, so there is no data record, while Figure 2 is the complete period. The schedule is from 5 o'clock to 23 o'clock, every 15 minutes. Now I want each subway station in Figure 1 to be completed according to the timetable in Figure 2. If there is no record at this subway station at this time, it proves that no one enters the station. , the number of people entering the station defaults to 0.
It would be best if you can use sql, but you can also use pandas.
But I don’t know how to do it, so I’m asking for help.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
According to your current table structure, the main table in Figure 2, the left connection table in Figure 1, the condition start time = start time, end time = end time. Query the start and end time of Figure 2 and the number of people in Figure 1
Suppose there is a site table that records the basic information of all sites.
PS: If possible, please add a station name field to the second photo.