{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "b16c5a59", "metadata": { "ExecuteTime": { "end_time": "2023-11-11T17:06:50.890404Z", "start_time": "2023-11-11T17:06:46.978101Z" } }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "from scipy import stats\n", "import sweetviz\n", "import folium\n", "import geopandas\n", "from geopy.distance import geodesic\n", "from datetime import datetime" ] }, { "cell_type": "code", "execution_count": 4, "id": "8f50b52d", "metadata": { "ExecuteTime": { "end_time": "2023-11-11T17:08:00.495157Z", "start_time": "2023-11-11T17:07:36.704491Z" } }, "outputs": [ { "data": { "text/plain": [ "(5733451, 13)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data = pd.read_csv('../../../Desktop/SamX/Bike_Study_Files/big_raw.csv')\n", "data.shape" ] }, { "cell_type": "code", "execution_count": 5, "id": "10b9af74", "metadata": { "ExecuteTime": { "end_time": "2023-11-11T17:08:28.280332Z", "start_time": "2023-11-11T17:08:00.498051Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", " | ride_id | \n", "rideable_type | \n", "member_casual | \n", "started_at | \n", "ended_at | \n", "ride_duration | \n", "start_date | \n", "start_hour | \n", "day_of_week | \n", "week_of_year | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "46F8167220E4431F | \n", "electric_bike | \n", "member | \n", "2021-12-07 15:06:07 | \n", "2021-12-07 15:13:42 | \n", "7.583333 | \n", "2021-12-07 | \n", "15 | \n", "Tuesday | \n", "49 | \n", "
1 | \n", "73A77762838B32FD | \n", "electric_bike | \n", "casual | \n", "2021-12-11 03:43:29 | \n", "2021-12-11 04:10:23 | \n", "26.900000 | \n", "2021-12-11 | \n", "3 | \n", "Saturday | \n", "49 | \n", "
2 | \n", "4CF42452054F59C5 | \n", "electric_bike | \n", "member | \n", "2021-12-15 23:10:28 | \n", "2021-12-15 23:23:14 | \n", "12.766667 | \n", "2021-12-15 | \n", "23 | \n", "Wednesday | \n", "50 | \n", "
3 | \n", "3278BA87BF698339 | \n", "classic_bike | \n", "member | \n", "2021-12-26 16:16:10 | \n", "2021-12-26 16:30:53 | \n", "14.716667 | \n", "2021-12-26 | \n", "16 | \n", "Sunday | \n", "51 | \n", "
4 | \n", "6FF54232576A3B73 | \n", "electric_bike | \n", "member | \n", "2021-12-30 11:31:05 | \n", "2021-12-30 11:51:21 | \n", "20.266667 | \n", "2021-12-30 | \n", "11 | \n", "Thursday | \n", "52 | \n", "