{"id":17125,"date":"2019-10-09T14:47:33","date_gmt":"2019-10-09T18:47:33","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=17125"},"modified":"2019-10-16T11:59:33","modified_gmt":"2019-10-16T15:59:33","slug":"who-bikes-more-in-nyc-citi-bike-trips-of-january-2018","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/who-bikes-more-in-nyc-citi-bike-trips-of-january-2018\/","title":{"rendered":"Who bikes more in nyc: Citi Bike trips of january 2018"},"content":{"rendered":"\n<p class=\"has-text-color has-black-color\"><strong>Introduction<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-black-color\">Biking is a great and cost-effective way to get around a city, especially since more people today are cognizant of the causes behind climate change and are looking to reduce their carbon footprint. Citi Bike makes easy for New York city residents to commute to and from work everyday because of the many start and end stations provided. Thus, this visualization uses Citi Bike trip data to provide useful insights such as who bikes more between gender groups, what are the most popular start stations and more. <\/p>\n\n\n\n<p class=\"has-text-color has-black-color\"><strong>Inspiration<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-black-color\">The inspiration for this visualization comes from an <a href=\"https:\/\/towardsdatascience.com\/citi-bike-2017-analysis-efd298e6c22c\">operating report of Citi Bike post<\/a> on Medium. I appreciate how the charts and graphs included in the post were aesthetically minimal and simple to comprehend. From the data visualizations, it answered many valuable questions about NYC Citi Bike ridership for the year of 2017.<\/p>\n\n\n\n<p class=\"has-text-color has-black-color\"><strong>Materials Used<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-black-color\">I used <a href=\"https:\/\/toolbox.google.com\/datasetsearch\">Google\u2019s Beta Data Search tool<\/a> to search for Citi Bike trip data, which was then sourced from a site called <a href=\"https:\/\/data.world\/\">data.world<\/a>. Data.world is a data catalog that allows individuals and teams to work seamlessly on the same data and share data analysis in an efficient way. The Citi Bike trip data I found only included data about ridership during the month of January 2018.\u00a0Then, after retrieving the data from the site. I used Tableau to create charts and graphs to highlight different insights about NYC Citi Bike riders in January 2018. I did not restructure or clean the dataset because I thought that the dataset was already structured well. <\/p>\n\n\n\n<p class=\"has-text-color has-black-color\"><strong>Results<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-black-color\">For the data visualizations, I wanted to first highlight differences in ridership between genders in order to gain more insight on the biggest Citi Bike user groups. The first visualization (Figure 1) uses a simple packed bubble graph to exemplify the total number of male vs. female who used the bike share during January 2018. I used simple colors, shades of blue and pink, to represent the two genders clearly. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?fit=840%2C784&amp;ssl=1\" alt=\"\" class=\"wp-image-17128\" width=\"427\" height=\"399\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?w=1332&amp;ssl=1 1332w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?resize=300%2C280&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?resize=768%2C717&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?resize=1024%2C956&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?resize=800%2C747&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Male-v.-Female-total.png?resize=193%2C180&amp;ssl=1 193w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><figcaption>Figure 1: Graph that displays the total number of men and women who used Citi Bike in Jan. 2018<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"has-text-color has-black-color\">Figure 2 is a line graph that displays the average number of Citi Bike starts during a given week in January. At first, it was a bit challenging to get the correct dimensions and filter because there seemed to have been an excessive number starting trips on Wednesday compared to other days. With some help, I realized that the data set included more Wednesdays than other days. So to make each day accounted for equally, I used a filter to only include dates from the 1st to the 27th of January. But overall, the line graph still showed that Wednesday is a peak day for Citi Bike for both men and women. And unsurprisingly, there are less bikers during the weekend. This insight can mean many things, but one thing I took away from this was that in NYC Citi Bike may be more likely used for commuting to and from work during the week rather than for leisure. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1924\" height=\"1242\" src=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?fit=840%2C542&amp;ssl=1\" alt=\"\" class=\"wp-image-17210\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?w=1924&amp;ssl=1 1924w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?resize=300%2C194&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?resize=768%2C496&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?resize=1024%2C661&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?resize=800%2C516&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?resize=279%2C180&amp;ssl=1 279w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/City-Bikers-during-the-week.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption><em>Figure 2: A line graph that visualizes Citi Bike peak days for me and women.<\/em><\/figcaption><\/figure>\n\n\n\n<p class=\"has-text-color has-black-color\"><a href=\"https:\/\/public.tableau.com\/profile\/olaide.ajomagberin#!\/vizhome\/CitibikeTrips2_0\/CitiBikeTripVis\">Dashboard of the visualization<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"2306\" height=\"1400\" src=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?fit=840%2C510&amp;ssl=1\" alt=\"\" class=\"wp-image-17208\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?w=2306&amp;ssl=1 2306w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?resize=300%2C182&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?resize=768%2C466&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?resize=1024%2C622&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?resize=800%2C486&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?resize=296%2C180&amp;ssl=1 296w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Dashboard-4.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"has-text-color has-black-color\"><strong>Reflections<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-black-color\">Overall, the most challenging part about this assignment was learning and getting familiar with Tableau. This was my first time using the tool, and I found it difficult to create different visualizations that would highlight insights in the Citi Bike dataset while also learning the tool. I would also like to create a spatial map since the dataset included longitude and latitude coordinates for both start and end stations. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Biking is a great and cost-effective way to get around a city. This visualization uses Citi Bike trip data to provide useful insights such as who bikes more between gender groups, what are the most popular start stations and more. <\/p>\n","protected":false},"author":629,"featured_media":17137,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[340,149],"tags":[],"coauthors":[456],"class_list":["post-17125","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/citi-bike-photo.png?fit=1200%2C537&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-4sd","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/17125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/629"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=17125"}],"version-history":[{"count":3,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/17125\/revisions"}],"predecessor-version":[{"id":17209,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/17125\/revisions\/17209"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/17137"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=17125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=17125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=17125"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=17125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}