tungwaiyip.info

home

about me

links

Media

Yucatán Photos

St Lucia Photos

Photo Album

Videos

Blog

< February 2014 >
SuMoTuWeThFrSa
       1
2 3 4 5 6 7 8
9101112131415
16171819202122
232425262728 

past articles »

Click for San Francisco, California Forecast

San Francisco, USA

 

Make Useful Charts

Having been with Bay Area Bike Share for a few month, I am glad with their green bikes available around downtown. I also appreciate Bay Area Bike Share's openness in sharing their system metrics. However the system chart on their web page do not provide much useful information.

Official Chart

The slowly raise bar chart shows cumulative trips taken since launch. The chart may look boring, but as least the upward trend looks comforting, right? Wrong! A cumulative chart by construction can only go up. The comfort feeling is misleading. A more useful way is to chart the number of trips taken by week. Also, data from 5 cities are available individually. So why not plot them side by side for comparison. I did a little work to make an improved chart below.

Improved Chart

Some information immediate obvious from the chart is that nearly all trips were made in San Francisco, despite it only has half of the resources deployed. Clearly the bike share program is not working out in the Peninsula at all given their negligible usage. Secondly, there are ups and downs in usage that cannot be observed from the upward looking bar chart. After the first few months the usage has peaked at about 6,000 to 7,000 trips per week, then fallen sharply in December due to holidays. The January number has yet to recover to reach the usage last year.

This is not mean to be critical. It is just to demonstrate how an useful chart can inform us.

This is the link to the simple source code by Pandas.

2014.02.24 [] - comments

 

 

blog comments powered by Disqus

past articles »

 

BBC News

 

Russia 'tried to hijack US election', says US senator (30 Mar 2017)

 

Brexit: UK sets out plans to replace all EU laws (30 Mar 2017)

 

Kim Jong-nam's body to be released to North Korea (30 Mar 2017)

 

Ronaldo statue: Sculptor Emanuel Santos defends his bizarre work (30 Mar 2017)

 

Campaigners seek 'to sell US politicians' browsing data' (30 Mar 2017)

 

US Kabul embassy fires staff over drugs (30 Mar 2017)

 

US hails Turkey as 'a trusted ally' in Ankara talks (30 Mar 2017)

 

Insurer Lloyd's of London confirms new Brussels subsidiary (30 Mar 2017)

 

American Airlines pilot dies on Dallas-Albuquerque flight (30 Mar 2017)

 

Italian police in Venice arrest three Jihadists (30 Mar 2017)

more »

 

SF Gate

 

Bay Area News (7 Jan 2012)

 

City Insider (11 Feb 2012)

 

Crime Scene (13 Feb 2012)

 

C.W Newius Column (10 Jan 2012)

 

C.W. Nevius Blog (11 Feb 2012)

 

Education News (10 Jan 2012)

 

KALW (11 Feb 2012)

 

Matier and Ross Blog (11 Feb 2012)

 

Pizza by robot, Apple’s brand less hot, and BuzzFeed’s IPO shot (30 Mar 2017)

 

App store sales for Android to overtake Apple’s iOS, report says (30 Mar 2017)

 

Business News Roundup, March 30 (29 Mar 2017)

 

Bill to let bars serve alcohol until 4 a.m. advances (29 Mar 2017)

 

Man sentenced in iPhone frauds (29 Mar 2017)

 

PG&E agrees to .5m penalty in San Bruno fallout; bills to drop (29 Mar 2017)

more »

 


Site feed Updated: 2017-Mar-30 09:00