{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Ford Gobike System data exploration\n", "## by Sheila Alwanga Olayo\n", "\n", "## Introduction\n", "> This dataset includes information about individual rides made in a bike-sharing system covering the greater San Francisco Bay area, for the month of February, 2019.\n", "\n", "\n", "## Preliminary Wrangling\n" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "# import all packages and set plots to be embedded inline\n", "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import seaborn as sb\n", "\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 51, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | duration_sec | \n", "start_time | \n", "end_time | \n", "start_station_id | \n", "start_station_name | \n", "start_station_latitude | \n", "start_station_longitude | \n", "end_station_id | \n", "end_station_name | \n", "end_station_latitude | \n", "end_station_longitude | \n", "bike_id | \n", "user_type | \n", "member_birth_year | \n", "member_gender | \n", "bike_share_for_all_trip | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "52185 | \n", "2019-02-28 17:32:10.1450 | \n", "2019-03-01 08:01:55.9750 | \n", "21.0 | \n", "Montgomery St BART Station (Market St at 2nd St) | \n", "37.789625 | \n", "-122.400811 | \n", "13.0 | \n", "Commercial St at Montgomery St | \n", "37.794231 | \n", "-122.402923 | \n", "4902 | \n", "Customer | \n", "1984.0 | \n", "Male | \n", "No | \n", "
1 | \n", "42521 | \n", "2019-02-28 18:53:21.7890 | \n", "2019-03-01 06:42:03.0560 | \n", "23.0 | \n", "The Embarcadero at Steuart St | \n", "37.791464 | \n", "-122.391034 | \n", "81.0 | \n", "Berry St at 4th St | \n", "37.775880 | \n", "-122.393170 | \n", "2535 | \n", "Customer | \n", "NaN | \n", "NaN | \n", "No | \n", "
2 | \n", "61854 | \n", "2019-02-28 12:13:13.2180 | \n", "2019-03-01 05:24:08.1460 | \n", "86.0 | \n", "Market St at Dolores St | \n", "37.769305 | \n", "-122.426826 | \n", "3.0 | \n", "Powell St BART Station (Market St at 4th St) | \n", "37.786375 | \n", "-122.404904 | \n", "5905 | \n", "Customer | \n", "1972.0 | \n", "Male | \n", "No | \n", "
3 | \n", "36490 | \n", "2019-02-28 17:54:26.0100 | \n", "2019-03-01 04:02:36.8420 | \n", "375.0 | \n", "Grove St at Masonic Ave | \n", "37.774836 | \n", "-122.446546 | \n", "70.0 | \n", "Central Ave at Fell St | \n", "37.773311 | \n", "-122.444293 | \n", "6638 | \n", "Subscriber | \n", "1989.0 | \n", "Other | \n", "No | \n", "
4 | \n", "1585 | \n", "2019-02-28 23:54:18.5490 | \n", "2019-03-01 00:20:44.0740 | \n", "7.0 | \n", "Frank H Ogawa Plaza | \n", "37.804562 | \n", "-122.271738 | \n", "222.0 | \n", "10th Ave at E 15th St | \n", "37.792714 | \n", "-122.248780 | \n", "4898 | \n", "Subscriber | \n", "1974.0 | \n", "Male | \n", "Yes | \n", "
\n", " | start_time | \n", "duration_sec | \n", "end_time | \n", "start_station_id | \n", "start_station_name | \n", "start_station_latitude | \n", "start_station_longitude | \n", "end_station_id | \n", "end_station_name | \n", "end_station_latitude | \n", "... | \n", "bike_id | \n", "user_type | \n", "member_birth_year | \n", "member_gender | \n", "bike_share_for_all_trip | \n", "date | \n", "day | \n", "age | \n", "duration_min | \n", "day_period | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2019-02-28 10:30:03.377 | \n", "36190 | \n", "2019-02-28 20:33:14.228 | \n", "58.0 | \n", "Market St at 10th St | \n", "37.776619 | \n", "-122.417385 | \n", "375.0 | \n", "Grove St at Masonic Ave | \n", "37.774836 | \n", "... | \n", "5465 | \n", "Subscriber | \n", "1991 | \n", "Female | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "28 | \n", "603.166667 | \n", "morning | \n", "
1 | \n", "2019-02-28 09:20:43.087 | \n", "31633 | \n", "2019-02-28 18:07:56.344 | \n", "81.0 | \n", "Berry St at 4th St | \n", "37.775880 | \n", "-122.393170 | \n", "93.0 | \n", "4th St at Mission Bay Blvd S | \n", "37.770407 | \n", "... | \n", "2270 | \n", "Customer | \n", "1984 | \n", "Female | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "35 | \n", "527.216667 | \n", "morning | \n", "
2 | \n", "2019-02-28 09:35:13.840 | \n", "30666 | \n", "2019-02-28 18:06:20.011 | \n", "58.0 | \n", "Market St at 10th St | \n", "37.776619 | \n", "-122.417385 | \n", "11.0 | \n", "Davis St at Jackson St | \n", "37.797280 | \n", "... | \n", "5522 | \n", "Customer | \n", "1988 | \n", "Male | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "31 | \n", "511.100000 | \n", "morning | \n", "
3 | \n", "2019-02-28 11:56:08.063 | \n", "21883 | \n", "2019-02-28 18:00:52.007 | \n", "284.0 | \n", "Yerba Buena Center for the Arts (Howard St at ... | \n", "37.784872 | \n", "-122.400876 | \n", "3.0 | \n", "Powell St BART Station (Market St at 4th St) | \n", "37.786375 | \n", "... | \n", "4635 | \n", "Subscriber | \n", "1980 | \n", "Female | \n", "Yes | \n", "2019-02-28 | \n", "Thursday | \n", "39 | \n", "364.716667 | \n", "morning | \n", "
4 | \n", "2019-02-28 08:52:26.557 | \n", "26988 | \n", "2019-02-28 16:22:14.575 | \n", "139.0 | \n", "Garfield Square (25th St at Harrison St) | \n", "37.751017 | \n", "-122.411901 | \n", "112.0 | \n", "Harrison St at 17th St | \n", "37.763847 | \n", "... | \n", "6558 | \n", "Subscriber | \n", "1986 | \n", "Male | \n", "Yes | \n", "2019-02-28 | \n", "Thursday | \n", "33 | \n", "449.800000 | \n", "morning | \n", "
5 rows × 21 columns
\n", "\n", " | start_time | \n", "duration_sec | \n", "end_time | \n", "start_station_id | \n", "start_station_name | \n", "start_station_latitude | \n", "start_station_longitude | \n", "end_station_id | \n", "end_station_name | \n", "end_station_latitude | \n", "... | \n", "bike_id | \n", "user_type | \n", "member_birth_year | \n", "member_gender | \n", "bike_share_for_all_trip | \n", "date | \n", "day | \n", "age | \n", "duration_min | \n", "day_period | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2019-02-28 10:30:03.377 | \n", "36190 | \n", "2019-02-28 20:33:14.228 | \n", "58.0 | \n", "Market St at 10th St | \n", "37.776619 | \n", "-122.417385 | \n", "375.0 | \n", "Grove St at Masonic Ave | \n", "37.774836 | \n", "... | \n", "5465 | \n", "Subscriber | \n", "1991 | \n", "Female | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "28 | \n", "603.166667 | \n", "morning | \n", "
1 | \n", "2019-02-28 09:20:43.087 | \n", "31633 | \n", "2019-02-28 18:07:56.344 | \n", "81.0 | \n", "Berry St at 4th St | \n", "37.775880 | \n", "-122.393170 | \n", "93.0 | \n", "4th St at Mission Bay Blvd S | \n", "37.770407 | \n", "... | \n", "2270 | \n", "Customer | \n", "1984 | \n", "Female | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "35 | \n", "527.216667 | \n", "morning | \n", "
2 | \n", "2019-02-28 09:35:13.840 | \n", "30666 | \n", "2019-02-28 18:06:20.011 | \n", "58.0 | \n", "Market St at 10th St | \n", "37.776619 | \n", "-122.417385 | \n", "11.0 | \n", "Davis St at Jackson St | \n", "37.797280 | \n", "... | \n", "5522 | \n", "Customer | \n", "1988 | \n", "Male | \n", "No | \n", "2019-02-28 | \n", "Thursday | \n", "31 | \n", "511.100000 | \n", "morning | \n", "
3 | \n", "2019-02-28 11:56:08.063 | \n", "21883 | \n", "2019-02-28 18:00:52.007 | \n", "284.0 | \n", "Yerba Buena Center for the Arts (Howard St at ... | \n", "37.784872 | \n", "-122.400876 | \n", "3.0 | \n", "Powell St BART Station (Market St at 4th St) | \n", "37.786375 | \n", "... | \n", "4635 | \n", "Subscriber | \n", "1980 | \n", "Female | \n", "Yes | \n", "2019-02-28 | \n", "Thursday | \n", "39 | \n", "364.716667 | \n", "morning | \n", "
4 | \n", "2019-02-28 08:52:26.557 | \n", "26988 | \n", "2019-02-28 16:22:14.575 | \n", "139.0 | \n", "Garfield Square (25th St at Harrison St) | \n", "37.751017 | \n", "-122.411901 | \n", "112.0 | \n", "Harrison St at 17th St | \n", "37.763847 | \n", "... | \n", "6558 | \n", "Subscriber | \n", "1986 | \n", "Male | \n", "Yes | \n", "2019-02-28 | \n", "Thursday | \n", "33 | \n", "449.800000 | \n", "morning | \n", "
5 rows × 21 columns
\n", "