Analysis of MTA Turnstyle Data -

 The analysis is about MTA (The Metropolitan Transportation Authority) of the New York City at mostly all the stations. The analysis was done to know the effects of covid on the public train transport in New York for a non-profit company called Transit Center, which works for the betterment of public transport and provides cheap transport for the people with low incomes. The data is taken from the MTA's website and being analyzed for the effects of covid on train traffic. When covid hit the New York city, the trains were reduced by 40% as people were not using them as heavily as pre-covid and also due to low number of train staff. I would be observing the traffic in low income communities and stations which are near to hospitals in the New York city, and the observations will help the organization to urge the government to increase trains in these areas which in-turn will help the population with low incomes.

Analysis of the three months March, April and May 2020:

 I have transferred the data from the MTA website to my system and used sqlite engine to access the database. The observations were done for the months of March, April, and May for the year 2020. This was the time when New York was under lockdown for the months of March and April, but the public transport was still running. The covid cases were also at it’s peak at this time. Since it was a lockdown for this period, the travelers should be the ones who would use transport only for emergency situations, and not for entertainment, jobs or shopping. The data was observed for the number of entries of the turnstyle for the foot traffic at various stations in New York.  As we can see in the line plot that the peak was in March, this signifies that most travel was done when covid was at it’s highest for treatment of their family members.

  Also, the traffic at different low community boroughs was like Queens, Bronx and Brooklyn was observed, along with the traffic at Manhattan which is a high income area. The highest traffic at Manhattan was 34-St Penn Station which is again near to Mount Sinai Beth and NYU hospitals. This observation was the sum of daily entries for the three months together.

Analysis of the six months July -Dec 2020:

    As we can see in the line plot that the traffic at various stations was high in the holiday periods i.e November and December. We can see the traffic for each month for all the six months at various stations. The highest traffic for the month of September was at Flushing-Main which is under Queens Borough (Hardest hit by Covid). Again the bar plot for all the six months shows the highest traffic at 34-Penn street, and the reason for travel can be for shopping or hospital visits.