About this Dataset

Public Transport Traffic Data In France

Hello,

Data

This Dataset give lot of informations about trains and transports network in France.
This Dataset contains 2 csv and 1 shapefile.

1st CSV: Regularities by liaisons Trains France.csv

From https://data.sncf.com/explore/dataset/regularite-mensuelle-tgv-aqst/information/?sort=periode

It includes data from 2019-07-01 to 2020-05-01.

Look at the file description below for more details.

2nd CSV: Travel titles validations in Paris and suburbs.csv

From https://data.sncf.com/explore/dataset/validations-sur-le-reseau-ferre-nombre-de-validations-par-jour-1er-semestre-2015/information/

It includes data from 2019-07-01 to 2019-12-31.

Look at the file description below for more details.

3rd shp file:

from https://data.iledefrance-mobilites.fr/explore/dataset/referentiel-arret-tc-idf/table/?sort=fichier

Look at the file description below for more details.

Ideas

Time series forecasting: Forecast the number of people per station per day, etc...
Data visualization on the most delayed liaisons etc...

Tables

Regularities By Liaisons Trains France

@kaggle.gatandubuc_public_transport_traffic_data_in_france.regularities_by_liaisons_trains_france

864.67 KB
7806 rows
32 columns


CREATE TABLE regularities_by_liaisons_trains_france (
  "year" BIGINT,
  "month" DOUBLE,
  "departure_station" VARCHAR,
  "arrival_station" VARCHAR,
  "average_travel_time_min" DOUBLE,
  "number_of_expected_circulations" DOUBLE,
  "number_of_cancelled_trains" DOUBLE,
  "number_of_late_trains_at_departure" DOUBLE,
  "average_delay_of_late_departing_trains_min" DOUBLE,
  "average_delay_of_all_departing_trains_min" DOUBLE,
  "comment_optional_delays_at_departure" VARCHAR,
  "number_of_trains_late_on_arrival" DOUBLE,
  "average_delay_of_late_arriving_trains_min" DOUBLE,
  "average_delay_of_all_arriving_trains_min" DOUBLE,
  "comment_optional_delays_on_arrival" VARCHAR,
  "n__trains_late_due_to_external_causes_weather_obstacle_b144048c" DOUBLE,
  "n__trains_late_due_to_railway_infrastructure_maintenance_works" DOUBLE,
  "n__trains_late_due_to_traffic_management_rail_line_tra_3e7e60d2" DOUBLE,
  "n__trains_late_due_to_rolling_stock" DOUBLE,
  "n__trains_late_due_to_station_management_and_reuse_of_material" DOUBLE,
  "n__trains_late_due_to_passenger_traffic_affluence_psh__a7a2ca19" DOUBLE,
  "number_of_late_trains_15min" DOUBLE,
  "average_train_delay_15min" DOUBLE,
  "number_of_late_trains_30min" DOUBLE,
  "number_of_late_trains_60min" DOUBLE,
  "period" TIMESTAMP,
  "delay_due_to_external_causes" DOUBLE,
  "delay_due_to_railway_infrastructure" DOUBLE,
  "delay_due_to_traffic_management" DOUBLE,
  "delay_due_to_rolling_stock" DOUBLE,
  "delay_due_to_station_management_and_reuse_of_material" DOUBLE,
  "delay_due_to_travellers_taken_into_account" DOUBLE
);

Travel Titles Validations In Paris And Suburbs

@kaggle.gatandubuc_public_transport_traffic_data_in_france.travel_titles_validations_in_paris_and_suburbs

4.25 MB
883958 rows
5 columns


CREATE TABLE travel_titles_validations_in_paris_and_suburbs (
  "date" TIMESTAMP,
  "station_name" VARCHAR,
  "id_refa_lda" DOUBLE,
  "title_category" VARCHAR,
  "nb_valid" VARCHAR
);