<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Dmitry Semashkov on Medium]]></title>
        <description><![CDATA[Stories by Dmitry Semashkov on Medium]]></description>
        <link>https://medium.com/@sedim?source=rss-f1c21a3b03ba------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*mGKKNCzN5Mc8RwpLUnIfYg.jpeg</url>
            <title>Stories by Dmitry Semashkov on Medium</title>
            <link>https://medium.com/@sedim?source=rss-f1c21a3b03ba------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 21:21:19 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sedim/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Let’s Look at Oslo City Bike Data]]></title>
            <link>https://medium.com/3-min/lets-look-at-oslo-city-bike-data-490a60a024ce?source=rss-f1c21a3b03ba------2</link>
            <guid isPermaLink="false">https://medium.com/p/490a60a024ce</guid>
            <category><![CDATA[oslo]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[open-data]]></category>
            <category><![CDATA[cycling]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Dmitry Semashkov]]></dc:creator>
            <pubDate>Fri, 12 Jan 2018 13:52:33 GMT</pubDate>
            <atom:updated>2019-09-30T17:11:47.116Z</atom:updated>
            <content:encoded><![CDATA[<h4>With more than 50,000 members and 2.7 million rides made in 2017, Oslo City Bike has long been an important part of the local transport system.</h4><figure><a href="https://shkov.carto.com/builder/32a92174-2f34-47e8-b25f-248efd6d587d/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D"><img alt="" src="https://cdn-images-1.medium.com/max/808/1*BJq2eF_2XdOcK0VJoVJR0g.png" /></a><figcaption>Olso City Bike stations</figcaption></figure><p>The company that runs the service regularly releases historic trip data. That gives us an opportunity to explore and visualize bike rides and quite possibly get an insight into some patterns of usage.</p><h3>“When”</h3><p>The animation below displays all of the bicycle trips that occurred on a specific day, 15 September 2017. Since the data only contains the station where each journey started and the station where it finished, I created an estimated path which follows the cycling directions from Google Maps from start to finish.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fsshkov.carto.com%2Fviz%2F13974308-48fe-456f-9dbd-eb19ea4e7b16%2Fembed_map&amp;url=https%3A%2F%2Fsshkov.carto.com%2Fbuilder%2F13974308-48fe-456f-9dbd-eb19ea4e7b16%2Fembed&amp;image=https%3A%2F%2Fcartocdn-gusc.global.ssl.fastly.net%2Fsshkov%2Fapi%2Fv1%2Fmap%2Fstatic%2Fnamed%2Ftpl_13974308_48fe_456f_9dbd_eb19ea4e7b16%2F1200%2F630.png&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=carto" width="800" height="600" frameborder="0" scrolling="no"><a href="https://medium.com/media/272814b5efc2f13d079061c8f59b5d83/href">https://medium.com/media/272814b5efc2f13d079061c8f59b5d83/href</a></iframe><p>It is possible to notice some regular patterns. First, we can notice two busy periods — in the morning from 8:00 to 9:00 and in the evening from 15:00 to 19:00. The rest of the day is less busy.</p><p>We can find this trend in the data, if we plot the number of bike rides by hour of the day. It makes sense to look at the data for weekdays separately, since the behavior is quite different during weekends.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*Lwqb1CoL3ndFnfFCB2bwIw.png" /></figure><h3>“Where”</h3><p>Another trend is a little bit more subtle and relates to the direction of travel. Let’s have a look at the number of bike journeys started at specific stations throughout the day:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fshkov.carto.com%2Fviz%2F758a4368-98b0-4a5a-be36-0e78ce67993f%2Fembed_map&amp;url=https%3A%2F%2Fshkov.carto.com%2Fbuilder%2F758a4368-98b0-4a5a-be36-0e78ce67993f%2Fembed%3Fstate%3D%257B%2522map%2522%253A%257B%2522zoom%2522%253A13%257D%257D&amp;image=https%3A%2F%2Fcartocdn-gusc.global.ssl.fastly.net%2Fshkov%2Fapi%2Fv1%2Fmap%2Fstatic%2Fnamed%2Ftpl_758a4368_98b0_4a5a_be36_0e78ce67993f%2F1200%2F630.png&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=carto" width="800" height="600" frameborder="0" scrolling="no"><a href="https://medium.com/media/5a5d25d3c963d69c3b6bd9184f2b4fc9/href">https://medium.com/media/5a5d25d3c963d69c3b6bd9184f2b4fc9/href</a></iframe><p>In the morning we can see how areas outside of city center light up. Then in the evening the same happens in the central areas. Clearly there are more bikes used outside of city center in the morning and in the center in the evening. But we have seen where the journey starts. Let’s have a look where it ends.</p><p>But before we check the data, let’s have one more look at our original animation. We can paint the bikes going in and out of the city center with different colors:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fshkov.carto.com%2Fviz%2Fda528cc4-9534-482c-bce8-f8f45b536fb1%2Fembed_map&amp;url=https%3A%2F%2Fshkov.carto.com%2Fbuilder%2Fda528cc4-9534-482c-bce8-f8f45b536fb1%2Fembed%3Fstate%3D%257B%2522map%2522%253A%257B%2522zoom%2522%253A13%257D%257D&amp;image=https%3A%2F%2Fcartocdn-gusc.global.ssl.fastly.net%2Fshkov%2Fapi%2Fv1%2Fmap%2Fstatic%2Fnamed%2Ftpl_da528cc4_9534_482c_bce8_f8f45b536fb1%2F1200%2F630.png&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=carto" width="800" height="600" frameborder="0" scrolling="no"><a href="https://medium.com/media/f5391d97dadbc01610c0cfd50abea1c5/href">https://medium.com/media/f5391d97dadbc01610c0cfd50abea1c5/href</a></iframe><p>We can clearly see more green dots during the morning peak (meaning more trips to the center) and more purple dots during the evening peak (out of center). Let’s verify this by checking the data:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*0uSj8ysm9Uf6KH-XCmPOZg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*VtSGCBPZo9neQ9zl0Oh8eA.png" /></figure><p>Again, we found evidence. Interesting, that a lot of people seem to travel both in and out of city during evening peak. I speculate that while some people use city bikes to commute to/from work, other people are attracted to the city center and all the services it offers — be it restaurants, shopping etc. but that’s just a guess.</p><h3>“How long”</h3><p>Let’s have look at other usage statistics to get an idea about how the Oslo City Bike operates.</p><p>If we look at the number of trips made in 2017 we can clearly see seasonal variations:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*0yi1zTHIQJzDK3q1vx-wiA.png" /></figure><p>At the same time, there is not much variation in the number of trips taken on a day to day basis, except for weekends, when people seem to take the city bike less often…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*aAMCBymiwFAzajHOTQ-MXg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*xsipRWVan71YhIB1oQf7oA.png" /></figure><p>…but for longer periods:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*VtkVvHhZAxUevwGjYsBldg.png" /></figure><p>Also, I was quite surprised to find out that short trips are much more common than long trips. Trips lasting 4–10 minutes happen much more often than any other trips:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*rMGk6-UMWDsw5ifhaneRyw.png" /><figcaption>Horizontal axis — duration of trip in minutes; vertical axis — number of trips with specific duration</figcaption></figure><h3>“How many”</h3><p>Probably unsurprising is the distribution between the most used and the least used stations — it seems that stations closer to center are used most. Usage during one day:</p><figure><a href="https://shkov.carto.com/builder/6e3680f8-243a-49b2-a0da-bf2d55166d30/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D"><img alt="" src="https://cdn-images-1.medium.com/max/790/1*_cTVbonAtTDl9dXRDUPxZw.png" /></a><figcaption>Stations used to start journey on 15 September 2017</figcaption></figure><p>It seems that the pattern does not change much if we “zoom out” and collect statistics for the whole month:</p><figure><a href="https://shkov.carto.com/builder/16627950-0498-42c6-8d3d-3e7b4214a265/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D"><img alt="" src="https://cdn-images-1.medium.com/max/824/1*Zqaozo5tXKspluyn8rAN9A.png" /></a><figcaption>Stations used to start journey in September 2017</figcaption></figure><p>This last map is the heatmap which approximates the roads most frequently used by cyclists in September 2017. As before, the precise route is not known, so every rider is assumed to use Google Maps to navigate from pickup station to the return station).</p><figure><a href="https://shkov.carto.com/builder/ef239953-6deb-4cfe-9c4a-7f0995c2feb5/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D"><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rjk9W-M-EJ8E1LVtHrHGGA.png" /></a><figcaption>Most frequently used roads by Oslo City Bike members in September 2017 (approximated) — clickable</figcaption></figure><p>Yet again, the statistics, collected for the <a href="https://shkov.carto.com/builder/b426f096-e278-4891-ad4d-34a756a8084d/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D">whole month</a> only differ from the <a href="https://shkov.carto.com/builder/ef239953-6deb-4cfe-9c4a-7f0995c2feb5/embed?state=%7B%22map%22%3A%7B%22zoom%22%3A13%7D%7D">daily statistics</a> in minor details, which can be easily observed if you follow the links and compare the maps.</p><h3>That’s it</h3><p>It’s quite interesting to see how things are changing with time. If you look at the excellent <a href="https://medium.com/@jonolave/exploring-open-data-from-oslo-city-bike-67985a101268">analysis of 2016 bike data</a> made by <a href="https://medium.com/u/b7c281c05d83">Jon Olav H. Eikenes</a>, you can see that while some patterns didn’t change, there is a tendency for shorter bike trips in 2017 compared to 2016.</p><p>There is always room for further analysis: correlation to weather and air quality, traffic conditions, predicting the journeys on station levels, analyzing the need for new stations, comparing bike systems to public transport data or taxi etc. etc. etc. — just a short list of topics this study could be extended to. Maybe next time!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=490a60a024ce" width="1" height="1" alt=""><hr><p><a href="https://medium.com/3-min/lets-look-at-oslo-city-bike-data-490a60a024ce">Let’s Look at Oslo City Bike Data</a> was originally published in <a href="https://medium.com/3-min">Bransjebloggen 3min</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>