Bike_sharing_project_s2017.pdf - Bikeu2010sharing system...

This preview shows page 1 - 3 out of 9 pages.

Bike sharing system using condition in Jersey City from Sep. 2015 to Jul. 2016 Name: Yu Xia 1.Introduction Citi Bike is a bike sharing system in NYC and extends to Jersey City in Sep 2015 with 50 stations. Bike sharing system provides people the opportunity to rent bike at one station and return the bike at another station. Figure 1. layout of bike station in Jersey City [1] . People can access the website ( ) to get real time bike availability. This project is to analysis the service condition of all bike stations in Jersey City. This dataset is downloaded from internet [2] . This dataset contains 161920 renting records occurred between Sep.21 2015 and Jul.26 2016. Each renting record have 15 attributes including: ‘tripduration’, ‘starttime’, ‘stoptime’, ‘start station name’, ‘end station name’, ‘start station id’, ‘end station id’, ‘start station longitude’, ‘start station latitude’, ‘end station latitude’, ‘end station longitude’, ‘bikeid’, ‘gender’, ‘usertype’ and ‘birth year’. Those records provide enough information to analysis the service condition at different bike station.
2.Goal Because each record has ‘start station name’ and ‘end station name’, the needs of bike at different station can be calculated and the frequency of bike renting at each station reflects the importance of station. Figure 2 is a subset of whole dataset. Figure 2. Subset of whole dataset The goal of this project is to find trip pattern and give advises by analyzing the service condition of bike sharing system in Jersey City. 3.Data Clean (1). Delete all records that have value of 0 at ‘gender’ column. (2). Calculate the age of user by subtracting value of 2015 by the value in ‘birth year’ column. (3). Delete records that have age larger than 80 and less than 17. (4). Delete records that have ‘end station name’ which did not exist in ‘start station name’. (5). Delete records that have ‘start station name’ which with occurrence less than 1000 times within 11 months.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture