Analysis of Kerala State Road Transport Corporation Buses Dataset (2011-12 to 2021-22)

This project aims to analyse and derive insights from the operational and financial data of buses run by Kerala State Road Transport Corporation for 11 years from 2011-12 to 2021-22.

The data was initially collected as text files (.txt), which were then converted to Excel sheets using Python due to certain irregularities in data structure. The Python code used for efficient data cleaning and transformation from text files (.txt) of 11 years to a consolidated Excel sheet is available in my Github repository.

The final datasheet was analysed and visualised using Tableau desktop. The data visuals and insights are attached herewith.