{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "%config InlineBackend.figure_format='retina'" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "df = pd.read_csv(\"austin_bikeshare_20191101.csv\")" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "df['start_time'] = pd.to_datetime(df['start_time'])\n", "df['start_date'] = df['start_time'].dt.date\n", "df['start_hour'] = df['start_time'].dt.hour" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "tags": [ "parameters" ] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "2019-11-05\n" ] } ], "source": [ "date = '2019-11-05'\n", "print(date)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "filter_df = df[df['start_date'].astype(str) == date]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | trip_id | \n", "subscriber_type | \n", "bikeid | \n", "start_time | \n", "start_station_id | \n", "start_station_name | \n", "end_station_id | \n", "end_station_name | \n", "duration_minutes | \n", "start_date | \n", "start_hour | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "21204361 | \n", "Local30 | \n", "2124 | \n", "2019-11-05 12:49:51+00:00 | \n", "4050 | \n", "5th/Campbell | \n", "3660 | \n", "East 6th/Medina | \n", "21 | \n", "2019-11-05 | \n", "12 | \n", "
182 | \n", "21203639 | \n", "Single Trip (Pay-as-you-ride) | \n", "1543 | \n", "2019-11-05 11:17:07+00:00 | \n", "4059 | \n", "Nash Hernandez/East @ RBJ South | \n", "4059 | \n", "Nash Hernandez/East @ RBJ South | \n", "7 | \n", "2019-11-05 | \n", "11 | \n", "
183 | \n", "21203659 | \n", "24 Hour Walk Up Pass | \n", "336G | \n", "2019-11-05 11:21:37+00:00 | \n", "4061 | \n", "Lakeshore/Austin Hostel | \n", "4061 | \n", "Lakeshore/Austin Hostel | \n", "34 | \n", "2019-11-05 | \n", "11 | \n", "
184 | \n", "21206699 | \n", "Pay-as-you-ride | \n", "123 | \n", "2019-11-05 17:37:49+00:00 | \n", "4062 | \n", "Lakeshore/Pleasant Valley | \n", "4062 | \n", "Lakeshore/Pleasant Valley | \n", "15 | \n", "2019-11-05 | \n", "17 | \n", "
207 | \n", "21203633 | \n", "Single Trip (Pay-as-you-ride) | \n", "588 | \n", "2019-11-05 11:16:30+00:00 | \n", "4059 | \n", "Nash Hernandez/East @ RBJ South | \n", "4059 | \n", "Nash Hernandez/East @ RBJ South | \n", "9 | \n", "2019-11-05 | \n", "11 | \n", "