Verify data frame
View(bikeshare_df_2023)
glimpse(bikeshare_df_2023)
Rows: 5,719,877
Columns: 22
$ ...1 <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, …
$ ride_id <chr> "F96D5A74A3E41399", "13CB7EB698CEDB88", "BD88A2E670661CE5", "C90792D034…
$ rideable_type <chr> "electric_bike", "classic_bike", "electric_bike", "classic_bike", "clas…
$ started_at <dttm> 2023-01-21 20:05:42, 2023-01-10 15:37:36, 2023-01-02 07:51:57, 2023-01…
$ ended_at <dttm> 2023-01-21 20:16:33, 2023-01-10 15:46:05, 2023-01-02 08:05:11, 2023-01…
$ start_station_name <chr> "Lincoln Ave & Fullerton Ave", "Kimbark Ave & 53rd St", "Western Ave & …
$ start_station_id <chr> "TA1309000058", "TA1309000037", "RP-005", "TA1309000037", "TA1309000037…
$ end_station_name <chr> "Hampden Ct & Diversey Ave", "Greenwood Ave & 47th St", "Valli Produce …
$ end_station_id <chr> "202480.0", "TA1308000002", "599", "TA1308000002", "TA1308000002", "202…
$ start_lat <dbl> 41.92407, 41.79957, 42.00857, 41.79957, 41.79957, 41.92607, 41.79955, 4…
$ start_lng <dbl> -87.64628, -87.59475, -87.69048, -87.59475, -87.59475, -87.63886, -87.5…
$ end_lat <dbl> 41.93000, 41.80983, 42.03974, 41.80983, 41.80983, 41.93000, 41.80983, 4…
$ end_lng <dbl> -87.64000, -87.59938, -87.69941, -87.59938, -87.59938, -87.64000, -87.5…
$ member_casual <chr> "member", "member", "casual", "member", "member", "member", "member", "…
$ start_date <date> 2023-01-21, 2023-01-10, 2023-01-02, 2023-01-22, 2023-01-12, 2023-01-31…
$ start_time <time> 20:05:42, 15:37:36, 07:51:57, 10:52:58, 13:58:01, 07:18:03, 21:18:36, …
$ end_date <date> 2023-01-21, 2023-01-10, 2023-01-02, 2023-01-22, 2023-01-12, 2023-01-31…
$ end_time <time> 20:16:33, 15:46:05, 08:05:11, 11:01:44, 14:13:20, 07:21:16, 21:32:36, …
$ trip_duration <dbl> 10.850000, 8.483333, 13.233333, 8.766667, 15.316667, 3.216667, 14.00000…
$ month <chr> "2023-01", "2023-01", "2023-01", "2023-01", "2023-01", "2023-01", "2023…
$ day_of_week <ord> Saturday, Tuesday, Monday, Sunday, Thursday, Tuesday, Sunday, Wednesday…
$ hour_of_day <chr> "20", "15", "07", "10", "13", "07", "21", "10", "20", "16", "17", "17",…