Over the past decade, bicycle-sharing systems have been growing in number and popularity in cities across the world. Bicycle-sharing systems allow users to rent bicycles for short trips, typically 30 minutes or less. Thanks to the rise in information technologies, it is easy for a user of the system to access a dock within the system to unlock or return bicycles. These technologies also provide a wealth of data that can be used to explore how these bike-sharing systems are used.
In this project, I will perform an exploratory analysis on data provided by Motivate, a bike-share system provider for many major cities in the United States. I will compare the system usage between three large cities:
New York City
Chicago
Washington DC
.
I will also see if there are any differences within each system for those users that are registered, regular users and those users that are short-term, casual users. I will make use of Python(Pandas) to explore data and perform data wrangling to unify the format of data from the three systems and write code to compute descriptive statistics. I will also make use of a package that is not part of the standard Python library to help you visualize the data.
If you are not familiar with the data analysis process, this project will be your first exposure to the kinds of steps that a data analyst takes when they approach a dataset. For now, all you need is the general python programming skills and a desire to learn about the data analysis process!
This project contains 1 file and 3 folders:
report.ipynb
: This is the main file where I have performed my work on the project.input_data/
: Folder containing 3 csv files of the cities that needs to be analyzed.output_data/
: Folder containing data files required for Exploratory Data Analysis.export/
: Folder containing HTML and PDF file of notebook.plots/
: Contains images of all the plots that are displayed inreport.ipynb
file.
Some code has already been implemented in report.ipynb file
to get me started, I will need to implement additional functionality when requested to successfully complete the project.
The data files for this analysis is in the input_data/
folder containing three csv files of the cities to be analyzed. Each of these cities has a page where we can freely download the trip data.:
New York City (Citi Bike): Link
Chicago (Divvy): Link
Washington DC (Capital Bikeshare): Link
While the original data for 2016 is spread among multiple files for each city, the files in the input_data/
folder collect all of the trip data for the year into one file per city. Some data wrangling of inconsistencies in timestamp format within each city has already been performed. In addition, a random 2% sample of the original data is taken to make the exploration more manageable.
After data wrangling process of the data files, the files are then saved to output_data/
folder.
This project requires Python 3 and the following Python libraries installed:
You will also need to have software installed to run and execute a Jupyter Notebook
If you do not have Python installed yet, it is highly recommended that you install the Anaconda distribution of Python, which already has the above packages and more included.
In a terminal or command window, navigate to the top-level project directory US_Bike-Share_Activity/
(that contains this README) and run one of the following commands:
ipython notebook report.ipynb
or
jupyter notebook report.ipynb
or if you have 'Jupyter Lab' installed
jupyter lab
This will open the Jupyter/iPython Notebook software and project file in your browser.
- How to load csv files in notebook using pandas.
- How to convert date and time to their appropriate format.
- Removing unnecessory rows and columns.
- Renaming Columns
- Visulaizing Data of a column of different files.
- Converting Dataframes to CSV files.
My project was reviewed by a Udacity reviewer against the Explore US Bike-Share project rubric. All criteria found in the rubric must be meeting specifications for me to pass.
My Project Review by an Udacity Reviewer