Upload pdp.csv

pdp.csv

@@ -1,10 +1,41 @@
-bus_number,bus_route,arrival_time,status,city,area,latitude,longitude
-102,Adyar to Tambaram,21-03-2025 10:30,On Time,Chennai,Adyar,13.01,80.24
-205,Madurai to Kovilpatti,21-03-2025 11:15,Delayed,Madurai,Tallakulam,9.92,78.12
-307,Coimbatore to Pollachi,21-03-2025 12:00,On Time,Coimbatore,Gandhipuram,11.01,76.96
-412,Velachery to Guindy,21-03-2025 13:15,On Time,Chennai,Velachery,12.98,80.22
-518,Madurai to Periyar,21-03-2025 14:00,Delayed,Madurai,Periyar,9.9252,78.1198
-624,Gandhipuram to Ukkadam,21-03-2025 15:45,On Time,Coimbatore,Ukkadam,11.002,76.954
-725,T. Nagar to Koyambedu,21-03-2025 16:20,On Time,Chennai,T. Nagar,13.04,80.23
-830,Madurai to Mattuthavani,21-03-2025 17:30,Delayed,Madurai,Mattuthavani,9.95,78.11
-906,Coimbatore to Peelamedu,21-03-2025 18:00,On Time,Coimbatore,Peelamedu,11.03,76.98
+bus_number,city,area,bus_route,latitude,longitude,arrival_time,status,upcoming_bus_number,upcoming_arrival_time,same_route_return
+111,Chennai,Koyambedu,Koyambedu to T. Nagar,13.069,80.217,22-03-2025 10:50,delayed,120,22-03-2025 12:20,102
+112,Chennai,Nungambakkam,Nungambakkam to Guindy,13.061,80.247,22-03-2025 11:00,on time,119,22-03-2025 12:00,113
+113,Chennai,Guindy,Guindy to Nungambakkam,13.0025,80.221,22-03-2025 11:15,on time,118,22-03-2025 12:10,112
+114,Chennai,Velachery,Velachery to Tambaram,12.978,80.218,22-03-2025 11:30,delayed,117,22-03-2025 12:15,115
+115,Chennai,Tambaram,Tambaram to Velachery,12.922,80.127,22-03-2025 11:45,on time,116,22-03-2025 12:30,114
+116,Chennai,Saidapet,Saidapet to Chromepet,13.035,80.2252,22-03-2025 12:00,delayed,115,22-03-2025 11:45,117
+117,Chennai,Chromepet,Chromepet to Velachery,12.9487,80.1345,22-03-2025 12:15,on time,114,22-03-2025 11:30,116
+118,Chennai,Porur,Porur to Guindy,13.0333,80.1797,22-03-2025 12:30,delayed,113,22-03-2025 11:15,119
+119,Chennai,Nungambakkam,Nungambakkam to Porur,13.061,80.247,22-03-2025 12:45,on time,112,22-03-2025 11:00,118
+120,Chennai,T. Nagar,T. Nagar to Koyambedu,13.041,80.233,22-03-2025 13:00,on time,111,22-03-2025 10:50,102
+301,Coimbatore,RS Puram,RS Puram to Gandhipuram,11.0111,76.9497,22-03-2025 10:00,on time,311,22-03-2025 12:00,302
+302,Coimbatore,Gandhipuram,Gandhipuram to RS Puram,11.0168,76.9558,22-03-2025 10:15,delayed,310,22-03-2025 11:45,301
+303,Coimbatore,Ukkadam,Ukkadam to Peelamedu,10.995,76.9675,22-03-2025 10:30,on time,309,22-03-2025 11:30,304
+304,Coimbatore,Peelamedu,Peelamedu to Ukkadam,11.0268,76.9768,22-03-2025 10:45,delayed,308,22-03-2025 11:15,303
+305,Coimbatore,Saibaba Colony,Saibaba Colony to Singanallur,11.0212,76.9567,22-03-2025 11:00,on time,307,22-03-2025 11:00,306
+306,Coimbatore,Singanallur,Singanallur to Saibaba Colony,11.0167,76.9559,22-03-2025 11:15,delayed,306,22-03-2025 11:00,305
+307,Coimbatore,Kavundampalayam,Kavundampalayam to RS Puram,11.0623,76.9428,22-03-2025 11:30,on time,305,22-03-2025 11:00,308
+308,Coimbatore,Avinashi Road,Avinashi Road to Gandhipuram,11.0345,76.978,22-03-2025 11:45,delayed,304,22-03-2025 10:45,307
+309,Coimbatore,Kovaipudur,Kovaipudur to Ukkadam,11.005,76.9425,22-03-2025 12:00,on time,303,22-03-2025 10:30,310
+310,Coimbatore,Ukkadam,Ukkadam to Kovaipudur,10.995,76.9675,22-03-2025 12:15,delayed,302,22-03-2025 10:15,309
+121,Madurai,Mattuthavani,Mattuthavani to Periyar,9.938,78.142,22-03-2025 10:50,delayed,122,22-03-2025 12:20,122
+122,Madurai,Periyar,Periyar to Mattuthavani,9.9213,78.1197,22-03-2025 11:00,on time,121,22-03-2025 10:50,121
+123,Madurai,Thiruparankundram,Thiruparankundram to Periyar,9.9005,78.0731,22-03-2025 11:15,delayed,124,22-03-2025 12:10,124
+124,Madurai,Periyar,Periyar to Thiruparankundram,9.9213,78.1197,22-03-2025 11:30,on time,123,22-03-2025 11:15,123
+125,Trichy,Central Bus Stand,Central to Srirangam,10.805,78.6856,22-03-2025 10:50,delayed,126,22-03-2025 12:20,126
+126,Trichy,Srirangam,Srirangam to Central,10.8666,78.6828,22-03-2025 11:00,on time,125,22-03-2025 10:50,125
+127,Trichy,Palakarai,Palakarai to Central,10.8265,78.6845,22-03-2025 11:15,delayed,128,22-03-2025 12:10,128
+128,Trichy,Central Bus Stand,Central to Palakarai,10.805,78.6856,22-03-2025 11:30,on time,127,22-03-2025 11:15,127
+129,Salem,New Bus Stand,New Bus Stand to Hasthampatti,11.6535,78.1558,22-03-2025 10:45,on time,130,22-03-2025 12:30,130
+130,Salem,Hasthampatti,Hasthampatti to New Bus Stand,11.6633,78.1629,22-03-2025 11:00,delayed,129,22-03-2025 10:45,129
+131,Erode,Central Bus Stand,Erode Central to Perundurai,11.3424,77.7274,22-03-2025 10:50,delayed,132,22-03-2025 12:20,132
+132,Erode,Perundurai,Perundurai to Central,11.2768,77.5883,22-03-2025 11:00,on time,131,22-03-2025 10:50,131
+133,Thanjavur,New Bus Stand,Thanjavur to Kumbakonam,10.7852,79.1391,22-03-2025 11:10,on time,134,22-03-2025 12:30,134
+134,Thanjavur,Kumbakonam,Kumbakonam to Thanjavur,10.9591,79.384,22-03-2025 11:25,delayed,133,22-03-2025 11:10,133
+135,Dindigul,Central Bus Stand,Dindigul to Palani,10.3664,77.9708,22-03-2025 11:45,delayed,136,22-03-2025 12:40,136
+136,Dindigul,Palani,Palani to Dindigul,10.4483,77.5207,22-03-2025 12:00,on time,135,22-03-2025 11:45,135
+137,Tirunelveli,New Bus Stand,Tirunelveli to Palayamkottai,8.7139,77.7567,22-03-2025 10:50,delayed,138,22-03-2025 12:20,138
+138,Tirunelveli,Palayamkottai,Palayamkottai to Tirunelveli,8.7335,77.7115,22-03-2025 11:00,on time,137,22-03-2025 10:50,137
+139,Vellore,New Bus Stand,Vellore to Katpadi,12.9345,79.1353,22-03-2025 11:15,delayed,140,22-03-2025 12:10,140
+140,Vellore,Katpadi,Katpadi to Vellore,12.9787,79.1311,22-03-2025 11:30,on time,139,22-03-2025 11:15,139