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

 

Canadians Michael Spavor and Michael Kovrig freed by China arrive home (25 Sep 2021)

 

Meng Wanzhou: The PowerPoint that sparked an international row (24 Sep 2021)

 

Germany elections: Merkel backs 'bridge-builder' Laschet as successor (25 Sep 2021)

 

Foreign visas planned to ease UK lorry driver shortage (25 Sep 2021)

 

Afghanistan: Taliban hang bodies as warning in city of Herat, say reports (25 Sep 2021)

 

Afghanistan: Inside the prison staffed by former inmates released by the Taliban (24 Sep 2021)

 

Prince Andrew's lawyers accept he was served with US case papers (24 Sep 2021)

 

Music company buys NFT of 'Side-eyeing Chloe' meme (25 Sep 2021)

 

R. Kelly trial: A look at the key moments as jury deliberates (24 Sep 2021)

 

Quad countries vow to work for freedom in region (25 Sep 2021)

more »

 

SF Gate

 

13 Best Background Check Sites & Services: Search Criminal Records and Social Media Accounts Online (28 Jul 2021)

 

It pays to search for top-quality auto shop (6 Feb 2021)

 

Fired Boeing CEO is now working with Bay Area tractor startup (14 Dec 2020)

 

PG&E bills to rise over per year on average to fund wildfire risk reduction (5 Dec 2020)

 

Nasdaq seeks more diversity on boards of companies listed on exchange (2 Dec 2020)

 

Elizabeth Holmes Prosecutors Say Texts Show Theranos Beset With Problems (24 Nov 2020)

more »


Site feed Updated: 2021-Sep-21 07:00