NYC MTA Subway Analysis Project

The main purpose of this analytical report is to provide clear insights into Metropolitan Transportation Authority (MTA) turnstiles data. Also, the objective of the descriptive-analytic report is to reduce the electricity bill of MTA and provide high-quality services that satisfy the customer's needs. And also provide a clear visualization to make the data easier to understand and pull insights from.

To reduce the electricity bill we need to see what's lease used turnstile and what time and day it needs to be turned off.

After gathering the necessary data from New York City Metropolitan Transportation Authority Subway Database, I’ve done some Feature Engineering and Cleaning on the data some visualization to view what station is least used.

RESULT

Q1: what's the least used station?

From this graph, we can see that Orchard Beach is the least commonly used Station. and from this, we check what days do people use this station.

Q2: what’s the most traffic of the least used station?

From this, we can see that workdays are the least commonly used since the station is close to the beach.

Q3: whats is the least time used in the least used station?

And we check on average traffic on that station with respect to time.

We see that from 4 am to 8 am it's practically not used at all so we can shut down the station at that time during the workdays and that would reduce the electricity bill.