tungwaiyip.info

home

about me

links

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

 

Ukraine war: Russian missile strikes kill 19 in Odesa region - emergency service (01 Jul 2022)

 

Xi defends Hong Kong rule on handover anniversary (01 Jul 2022)

 

Brittney Griner: Detained US basketball star appears in Russian court on drug charges (01 Jul 2022)

 

Technoblade: Minecraft YouTuber dies from cancer aged 23 (01 Jul 2022)

 

Missing Cryptoqueen: FBI adds Ruja Ignatova to top ten most wanted (01 Jul 2022)

 

Nupur Sharma: India court says Prophet row 'set country on fire' (01 Jul 2022)

 

Bison attacks woman at Yellowstone National Park (01 Jul 2022)

 

Supreme Court limits Biden's power to cut emissions (30 Jun 2022)

 

North Korea claims Covid arrived on 'alien things' near border (01 Jul 2022)

 

US stocks see worst first half drop in more than 50 years (01 Jul 2022)

more »

 

SF Gate

 

'This will be somewhat painful': Elon Musk talks Twitter takeover in extended interview at TED2022 Vancouver (14 Apr 2022)

 

Best Background Check Services in 2022, Top 13 People Finder Sites Reviewed (5 Apr 2022)

 

Better.com employees got severance checks before they were laid off (9 Mar 2022)

 

Apple joins other Bay Area tech giants in responding to Russian invasion of Ukraine (1 Mar 2022)

 

Uber will now show you how you’re rated by drivers (18 Feb 2022)

 

The man behind Google’s Silicon Valley headquarters says fancy tech offices are ‘dangerous’ (24 Jan 2022)

more »


Site feed Updated: 2022-Jul-01 07:00