BEAZIZ Raphaël, BELCAID Yannis, IEHL Marc-Antoine
26/12/2019
You can click on links below to see all the information that you need to evaluate our project.
We've decided to use the full_trains.csv file to create sncf dashboard
year month service departure_station arrival_station
1 2017 9 National PARIS EST METZ
2 2017 9 National REIMS PARIS EST
3 2017 9 National PARIS EST STRASBOURG
4 2017 9 National PARIS LYON AVIGNON TGV
5 2017 9 National PARIS LYON BELLEGARDE (AIN)
6 2017 9 National PARIS LYON BESANCON FRANCHE COMTE TGV
journey_time_avg total_num_trips num_of_canceled_trains comment_cancellations
1 85.13378 299 0 NA
2 47.06452 218 1 NA
3 116.23494 333 1 NA
4 161.08958 481 1 NA
5 164.45263 190 0 NA
6 128.52105 191 1 NA
num_late_at_departure avg_delay_late_at_departure avg_delay_all_departing
1 15 11.55000 0.7520067
2 10 14.65333 1.2635177
3 20 13.69417 1.1392570
4 36 20.98843 1.4062153
5 16 20.96354 1.7289474
6 18 19.96389 1.8387719
comment_delays_at_departure num_arriving_late avg_delay_late_on_arrival
1 NA 17 13.79412
2 NA 23 13.57029
3 NA 19 21.53246
4 NA 61 26.56667
5 NA 38 23.15175
6 NA 18 31.58796
avg_delay_all_arriving comment_delays_on_arrival delay_cause_external_cause
1 0.4198439 <NA> 0.2500000
2 1.1375576 <NA> 0.2500000
3 1.5863956 <NA> 0.2142857
4 4.7885417 <NA> 0.1551724
5 6.0088596 <NA> 0.1666667
6 5.0336842 <NA> 0.1111111
delay_cause_rail_infrastructure delay_cause_traffic_management
1 0.0000000 0.16666667
2 0.3750000 0.12500000
3 0.2142857 0.07142857
4 0.1206897 0.31034483
5 0.2500000 0.25000000
6 0.1111111 0.22222222
delay_cause_rolling_stock delay_cause_station_management
1 0.4166667 0.16666667
2 0.1250000 0.06250000
3 0.2857143 0.21428571
4 0.3448276 0.03448276
5 0.3055556 0.00000000
6 0.5000000 0.00000000
delay_cause_travelers num_greater_15_min_late avg_delay_late_greater_15_min
1 0.00000000 6 24.03333
2 0.06250000 9 21.49815
3 0.00000000 14 24.69405
4 0.03448276 40 34.04750
5 0.02777778 26 28.40128
6 0.05555556 15 35.79667
num_greater_30_min_late num_greater_60_min_late
1 1 0
2 1 0
3 3 0
4 21 5
5 8 1
6 8 1
Error in file(con, "rb") : impossible d'ouvrir la connexion