Dataset: Indian Railways Schedule-Prices-Availability Data

About this Dataset

Indian Railways Schedule-Prices-Availability Data

Context

This dataset originates from my project that aims to improve the accessibility of train travel in India. The project helps travelers find and book indirect train journeys, which can be useful for long or remote trips where direct trains are scarce. The dataset is based on this project and covers the gap left by other platforms that only show direct trains, which may not suit some travelers' needs.

Sources

The primary source of this dataset is the Indian Railways Catering and Tourism Corporation (IRCTC) website during October-2023. Through web scraping techniques, data was collected, including public train schedules, pricing details, and availability information.

Project on GitHub

The Project Report on my GitHub Repository explains how I analyzed the prices and their dependencies, and why I chose decision tree regression as the best ML model for this case. You can find all the code regarding the data collection, model building and final output generation in the repository. Users here can perform time-series analysis on the prices and availability data, improve the accuracy of price prediction and create a model for availability prediction.

Tables

Price Data

@kaggle.bhavyarajdev_indian_railways_schedule_prices_availability_data.price_data

5.33 MB
326643 rows
19 columns


CREATE TABLE price_data (
  "basefare" BIGINT,
  "reservationcharge" BIGINT,
  "superfastcharge" BIGINT,
  "fuelamount" DOUBLE,
  "totalconcession" BIGINT,
  "tatkalfare" BIGINT,
  "servicetax" DOUBLE,
  "othercharge" BIGINT,
  "cateringcharge" BIGINT,
  "dynamicfare" BIGINT,
  "totalfare" BIGINT,
  "availability" VARCHAR,
  "trainnumber" BIGINT,
  "timestamp" TIMESTAMP,
  "fromstncode" VARCHAR,
  "tostncode" VARCHAR,
  "classcode" VARCHAR,
  "distance" BIGINT,
  "duration" DOUBLE
);

Schedules

@kaggle.bhavyarajdev_indian_railways_schedule_prices_availability_data.schedules

2.59 MB
3292 rows
13 columns


CREATE TABLE schedules (
  "trainnumber" BIGINT,
  "trainname" VARCHAR,
  "stationfrom" VARCHAR,
  "stationto" VARCHAR,
  "trainrunsonmon" VARCHAR,
  "trainrunsontue" VARCHAR,
  "trainrunsonwed" VARCHAR,
  "trainrunsonthu" VARCHAR,
  "trainrunsonfri" VARCHAR,
  "trainrunsonsat" VARCHAR,
  "trainrunsonsun" VARCHAR,
  "timestamp" TIMESTAMP,
  "stationlist" VARCHAR
);