Question

Assignment instruction:

First one shows the Bus GPS data, second shows the ticketing information and third is the

MET data.

WE need to merge the datasets where a particular row shows all information from the GPS

dataset and all information of ticketing dataset based on any transactions happening at that

particular stop on that particular date and time. Some transactions even happen after bus

departure time which also need to be included for that stop and the row should cover the

MET basic data about rain or snow or wind on that day.

Question image 1