Bike Stats - correlation with weather: rides vs rainfall

All rides 1 Oct 2011 to 2 Feb 2013 (491 days)

A very quick & dirty comparison of cycle hire data with rainfall figures from the Met Office. There's lots of variability inherent in the data (for example weekdays vs weekends, and annual trends, plus of course rainfall isn't everything as you should really take into account temperature, sunshine, daylight hours ...) but there is certainly a suggestion that we are indeed a ~~nation~~ city of fair-weather cyclists - days with some rain, but less than 1mm, saw over 5,000 fewer journeys compared to totally dry days. That siad, there's still a large hardcore group - even the wettest day, with 26.7mm of rain, recorded over 8,000 rides. And the rain doesn't appear to reduce average journey length either.

Raw data

Rainfall

Date	Rainfall (mm)	Rides	Ave distance (miles)
2011-10-01	0.03	26,313	1.47
2011-10-02	0.03	26,291	1.44
2011-10-03	0.03	27,098	1.53
2011-10-04	0.25	25,687	1.52
2011-10-05	2.91	25,916	1.51
2011-10-06	0.24	24,619	1.51
2011-10-07	1.08	24,087	1.48
2011-10-08	2.31	17,689	1.40
2011-10-09	0.01	17,257	1.41
2011-10-10	0.03	23,727	1.49
2011-10-11	0.00	25,717	1.51
2011-10-12	0.48	25,832	1.51
2011-10-13	0.02	24,668	1.50
2011-10-14	0.02	25,860	1.48
2011-10-15	0.11	23,047	1.45
2011-10-16	0.14	18,157	1.44
2011-10-17	4.48	23,263	1.50
2011-10-18	0.04	23,378	1.51
2011-10-19	0.32	22,902	1.50
2011-10-20	0.12	22,812	1.51
2011-10-21	0.00	22,806	1.48
2011-10-22	0.00	20,032	1.44
2011-10-23	0.07	18,180	1.41
2011-10-24	3.44	22,487	1.50
2011-10-25	5.86	22,434	1.50
2011-10-26	8.28	17,315	1.51
2011-10-27	1.71	19,034	1.51
2011-10-28	0.16	22,717	1.46
2011-10-29	0.07	17,723	1.42
2011-10-30	0.59	15,163	1.40
2011-10-31	0.99	22,185	1.52
2011-11-01	0.39	22,443	1.50
2011-11-02	3.67	23,445	1.51
2011-11-03	19.48	18,391	1.50
2011-11-04	1.11	18,441	1.44
2011-11-05	0.63	16,038	1.40
2011-11-06	0.07	13,997	1.37
2011-11-07	0.64	20,078	1.50
2011-11-08	1.51	18,964	1.49
2011-11-09	0.15	22,192	1.52
2011-11-10	0.21	23,076	1.51
2011-11-11	0.93	20,815	1.47
2011-11-12	0.11	18,534	1.43
2011-11-13	0.04	17,476	1.44
2011-11-14	0.04	19,676	1.50
2011-11-15	0.01	22,007	1.52
2011-11-16	0.04	21,376	1.52
2011-11-17	0.08	22,552	1.51
2011-11-18	0.11	22,157	1.49
2011-11-19	0.32	18,429	1.44
2011-11-20	0.21	14,607	1.40
2011-11-21	0.84	20,604	1.52
2011-11-22	0.71	20,090	1.51
2011-11-23	0.12	21,596	1.50
2011-11-24	0.61	21,600	1.50
2011-11-25	0.07	21,333	1.48
2011-11-26	0.14	15,579	1.42
2011-11-27	0.23	14,155	1.40
2011-11-28	1.28	19,926	1.51
2011-11-29	2.12	18,523	1.50
2011-11-30	3.32	20,711	1.51
2011-12-01	11.20	16,279	1.48
2011-12-02	2.94	18,901	1.49
2011-12-03	0.09	13,595	1.38
2011-12-04	0.79	10,142	1.40
2011-12-05	0.02	17,990	1.51
2011-12-06	0.85	18,758	1.51
2011-12-07	0.17	19,063	1.50
2011-12-08	3.39	17,105	1.50
2011-12-09	0.05	18,210	1.47
2011-12-10	0.70	11,681	1.40
2011-12-11	6.04	8,262	1.38
2011-12-12	18.47	16,355	1.50
2011-12-13	2.49	16,917	1.47
2011-12-14	1.98	17,317	1.48
2011-12-15	11.59	16,881	1.48
2011-12-16	2.20	11,634	1.40
2011-12-17	0.59	8,776	1.36
2011-12-18	0.44	7,388	1.38
2011-12-19	5.68	11,170	1.49
2011-12-20	3.93	15,472	1.48
2011-12-21	0.08	13,937	1.46
2011-12-22	0.09	14,910	1.44
2011-12-23	6.57	9,002	1.38
2011-12-24	0.19	4,808	1.23
2011-12-25	0.02	17,621	1.42
2011-12-26	0.00	10,771	1.50
2011-12-27	0.15	7,928	1.32
2011-12-28	0.37	9,758	1.38
2011-12-29	2.99	8,233	1.39
2011-12-30	6.70	6,805	1.40
2011-12-31	0.93	7,666	1.32
2012-01-01	10.00	5,071	1.35
2012-01-02	3.81	8,940	1.38
2012-01-03	11.14	9,981	1.50
2012-01-04	2.25	13,766	1.53
2012-01-05	0.32	14,025	1.50
2012-01-06	0.03	17,485	1.50
2012-01-07	0.00	12,378	1.38
2012-01-08	0.02	10,330	1.36
2012-01-09	0.15	19,196	1.51
2012-01-10	0.03	20,279	1.53
2012-01-11	0.08	20,682	1.52
2012-01-12	0.07	20,630	1.51
2012-01-13	0.11	19,447	1.49
2012-01-14	0.24	13,614	1.39
2012-01-15	0.05	11,967	1.40
2012-01-16	0.05	18,925	1.52
2012-01-17	0.48	19,955	1.52
2012-01-18	3.84	17,768	1.49
2012-01-19	1.25	15,225	1.45
2012-01-20	1.44	18,435	1.50
2012-01-21	0.04	13,122	1.36
2012-01-22	0.00	12,635	1.39
2012-01-23	1.68	19,932	1.52
2012-01-24	6.44	13,067	1.51
2012-01-25	2.94	20,559	1.50
2012-01-26	0.68	19,244	1.48
2012-01-27	0.64	20,486	1.47
2012-01-28	0.53	13,042	1.35
2012-01-29	0.76	10,772	1.36
2012-01-30	0.32	18,700	1.50
2012-01-31	0.28	17,957	1.51
2012-02-01	0.02	18,027	1.49
2012-02-02	0.00	16,751	1.47
2012-02-03	0.00	16,010	1.43
2012-02-04	12.19	8,196	1.29
2012-02-05	0.09	3,442	1.29
2012-02-06	0.35	15,032	1.49
2012-02-07	0.00	17,500	1.48
2012-02-08	0.01	16,238	1.48
2012-02-09	0.71	16,145	1.47
2012-02-10	0.37	14,907	1.43
2012-02-11	0.02	9,734	1.33
2012-02-12	0.31	7,865	1.34
2012-02-13	0.77	13,003	1.49
2012-02-14	0.01	17,726	1.48
2012-02-15	0.06	19,132	1.49
2012-02-16	0.07	19,283	1.49
2012-02-17	0.00	19,150	1.47
2012-02-18	3.26	9,312	1.38
2012-02-19	0.04	12,451	1.41
2012-02-20	0.05	18,618	1.51
2012-02-21	0.00	20,595	1.53
2012-02-22	0.92	17,906	1.53
2012-02-23	0.02	23,022	1.49
2012-02-24	0.12	21,739	1.48
2012-02-25	0.07	19,035	1.41
2012-02-26	0.17	17,335	1.40
2012-02-27	0.12	20,629	1.52
2012-02-28	0.04	23,090	1.53
2012-02-29	0.11	46,746	1.52
2012-03-01	0.07	49,511	1.50
2012-03-02	0.17	43,240	1.48
2012-03-03	2.95	34,772	1.37
2012-03-04	11.54	4,988	1.34
2012-03-05	3.67	19,084	1.50
2012-03-06	0.09	20,793	1.50
2012-03-07	3.71	16,879	1.51
2012-03-08	0.02	23,731	1.51
2012-03-09	0.00	23,254	1.52
2012-03-10	0.04	24,281	1.46
2012-03-11	0.12	27,201	1.44
2012-03-12	0.09	28,387	1.54
2012-03-13	0.01	27,051	1.54
2012-03-14	0.17	27,840	1.53
2012-03-15	0.00	29,481	1.51
2012-03-16	0.31	26,089	1.50
2012-03-17	4.27	13,135	1.40
2012-03-18	0.20	18,800	1.44
2012-03-19	0.06	27,943	1.55
2012-03-20	0.01	30,343	1.55
2012-03-21	0.04	30,731	1.55
2012-03-22	0.04	30,648	1.54
2012-03-23	0.08	33,109	1.52
2012-03-24	0.04	34,455	1.49
2012-03-25	0.06	28,119	1.45
2012-03-26	0.03	31,887	1.54
2012-03-27	0.00	34,089	1.57
2012-03-28	0.00	36,008	1.56
2012-03-29	0.01	35,478	1.54
2012-03-30	0.01	35,078	1.53
2012-03-31	0.05	22,705	1.43
2012-04-01	0.01	28,310	1.51
2012-04-02	0.00	29,302	1.63
2012-04-03	3.34	23,458	1.65
2012-04-04	1.23	25,218	1.64
2012-04-05	0.03	21,923	1.59
2012-04-06	0.07	20,602	1.49
2012-04-07	0.87	15,434	1.45
2012-04-08	1.68	14,500	1.44
2012-04-09	6.58	5,474	1.47
2012-04-10	1.05	22,596	1.62
2012-04-11	2.69	26,613	1.64
2012-04-12	2.79	23,287	1.64
2012-04-13	0.57	25,014	1.62
2012-04-14	0.36	23,939	1.54
2012-04-15	0.29	8,755	1.56
2012-04-16	2.65	25,679	1.68
2012-04-17	5.42	17,892	1.62
2012-04-18	7.47	14,787	1.63
2012-04-19	4.48	16,869	1.65
2012-04-20	4.35	20,453	1.65
2012-04-21	0.91	20,060	1.52
2012-04-22	3.50	17,987	1.53
2012-04-23	10.25	17,372	1.70
2012-04-24	10.29	24,911	1.67
2012-04-25	11.88	11,326	1.63
2012-04-26	1.89	19,467	1.63
2012-04-27	5.04	21,998	1.62
2012-04-28	22.79	6,932	1.47
2012-04-29	5.97	8,778	1.45
2012-04-30	11.53	29,078	1.66
2012-05-01	0.42	22,256	1.63
2012-05-02	6.82	25,717	1.67
2012-05-03	0.88	21,244	1.65
2012-05-04	1.69	22,873	1.63
2012-05-05	0.96	14,275	1.51
2012-05-06	0.42	15,620	1.52
2012-05-07	5.88	13,807	1.49
2012-05-08	2.77	26,052	1.66
2012-05-09	10.24	19,576	1.66
2012-05-10	2.95	23,815	1.64
2012-05-11	0.00	28,539	1.64
2012-05-12	0.01	28,253	1.57
2012-05-13	0.22	26,568	1.56
2012-05-14	4.62	20,979	1.69
2012-05-15	1.67	16,331	1.61
2012-05-16	0.03	28,745	1.67
2012-05-17	0.04	28,307	1.66
2012-05-18	0.70	28,133	1.63
2012-05-19	0.28	26,063	1.56
2012-05-20	0.02	20,272	1.55
2012-05-21	0.01	28,114	1.65
2012-05-22	0.02	34,377	1.66
2012-05-23	0.00	37,298	1.66
2012-05-24	0.00	38,780	1.67
2012-05-25	0.00	38,172	1.63
2012-05-26	0.00	36,654	1.56
2012-05-27	0.00	36,284	1.54
2012-05-28	0.49	37,686	1.66
2012-05-29	0.00	35,527	1.68
2012-05-30	0.44	35,729	1.66
2012-05-31	0.01	32,654	1.65
2012-06-01	0.69	31,506	1.62
2012-06-02	10.31	23,131	1.51
2012-06-03	10.24	11,064	1.48
2012-06-04	0.09	20,827	1.49
2012-06-05	9.06	14,108	1.54
2012-06-06	2.89	27,622	1.64
2012-06-07	13.74	20,846	1.67
2012-06-08	0.73	19,872	1.56
2012-06-09	0.06	26,735	1.53
2012-06-10	24.03	19,020	1.53
2012-06-11	19.45	9,034	1.64
2012-06-12	1.11	21,443	1.64
2012-06-13	0.00	31,365	1.67
2012-06-14	6.28	28,722	1.67
2012-06-15	1.63	28,162	1.64
2012-06-16	0.19	23,864	1.54
2012-06-17	3.59	26,326	1.57
2012-06-18	0.03	28,364	1.64
2012-06-19	0.00	34,359	1.68
2012-06-20	7.52	36,161	1.66
2012-06-21	2.71	24,592	1.63
2012-06-22	1.22	29,970	1.61
2012-06-23	12.70	24,684	1.54
2012-06-24	0.59	21,540	1.48
2012-06-25	0.00	33,345	1.65
2012-06-26	0.18	34,499	1.66
2012-06-27	0.17	33,756	1.65
2012-06-28	0.17	36,416	1.65
2012-06-29	1.17	32,272	1.62
2012-06-30	0.65	30,476	1.53
2012-07-01	0.98	25,110	1.54
2012-07-02	6.50	22,583	1.63
2012-07-03	6.87	24,993	1.62
2012-07-04	1.43	29,538	1.63
2012-07-05	3.25	37,208	1.65
2012-07-06	8.52	22,395	1.59
2012-07-07	14.06	22,504	1.53
2012-07-08	3.17	14,349	1.47
2012-07-09	0.48	27,754	1.63
2012-07-10	4.77	26,734	1.65
2012-07-11	7.74	27,673	1.65
2012-07-12	11.42	22,353	1.65
2012-07-13	6.95	26,079	1.61
2012-07-14	7.10	16,133	1.53
2012-07-15	0.75	27,560	1.55
2012-07-16	2.21	21,882	1.68
2012-07-17	0.49	33,506	1.68
2012-07-18	2.23	27,053	1.65
2012-07-19	1.57	33,714	1.68
2012-07-20	3.22	28,238	1.64
2012-07-21	0.06	31,931	1.57
2012-07-22	0.00	35,847	1.58
2012-07-23	0.00	38,997	1.68
2012-07-24	0.01	42,188	1.70
2012-07-25	0.01	41,521	1.72
2012-07-26	0.50	43,108	1.69
2012-07-27	0.53	39,228	1.70
2012-07-28	0.12	41,163	1.63
2012-07-29	3.73	23,884	1.59
2012-07-30	2.76	38,338	1.74
2012-07-31	0.51	32,436	1.69
2012-08-01	1.77	37,884	1.71
2012-08-02	1.88	39,523	1.69
2012-08-03	2.19	39,373	1.68
2012-08-04	1.37	35,823	1.62
2012-08-05	2.95	27,479	1.57
2012-08-06	3.56	33,879	1.68
2012-08-07	1.13	34,580	1.69
2012-08-08	0.29	38,691	1.69
2012-08-09	0.04	42,323	1.68
2012-08-10	0.01	43,343	1.67
2012-08-11	0.00	40,748	1.62
2012-08-12	0.08	38,736	1.60
2012-08-13	4.35	32,987	1.65
2012-08-14	0.10	38,080	1.67
2012-08-15	2.44	33,288	1.68
2012-08-16	0.56	34,772	1.68
2012-08-17	0.00	37,293	1.63
2012-08-18	0.06	37,584	1.59
2012-08-19	0.11	33,956	1.50
2012-08-20	0.01	36,713	1.60
2012-08-21	0.36	37,833	1.60
2012-08-22	0.01	38,661	1.62
2012-08-23	0.00	35,408	1.60
2012-08-24	4.18	32,253	1.55
2012-08-25	5.51	17,047	1.44
2012-08-26	0.04	30,577	1.53
2012-08-27	2.59	26,435	1.48
2012-08-28	0.15	36,064	1.58
2012-08-29	5.52	29,863	1.61
2012-08-30	1.18	29,353	1.56
2012-08-31	0.04	35,999	1.55
2012-09-01	0.05	31,754	1.48
2012-09-02	0.18	26,863	1.46
2012-09-03	0.08	38,622	1.59
2012-09-04	0.00	38,986	1.61
2012-09-05	0.00	39,257	1.62
2012-09-06	0.06	38,656	1.61
2012-09-07	0.02	39,992	1.59
2012-09-08	0.07	39,395	1.53
2012-09-09	0.09	37,454	1.49
2012-09-10	0.33	34,398	1.58
2012-09-11	0.00	36,097	1.61
2012-09-12	3.40	34,478	1.61
2012-09-13	0.03	36,748	1.60
2012-09-14	0.00	35,523	1.57
2012-09-15	0.03	35,032	1.53
2012-09-16	0.00	28,607	1.50
2012-09-17	0.12	34,777	1.60
2012-09-18	0.01	35,844	1.61
2012-09-19	0.00	35,485	1.60
2012-09-20	0.00	34,806	1.59
2012-09-21	1.01	31,325	1.55
2012-09-22	0.47	32,599	1.51
2012-09-23	26.72	8,135	1.48
2012-09-24	6.55	20,485	1.59
2012-09-25	5.98	32,584	1.60
2012-09-26	5.04	26,247	1.56
2012-09-27	0.33	31,334	1.57
2012-09-28	1.10	30,857	1.54
2012-09-29	0.12	30,028	1.49
2012-09-30	2.60	24,211	1.48
2012-10-01	2.41	22,984	1.56
2012-10-02	4.06	29,736	1.60
2012-10-03	2.38	31,866	1.58
2012-10-04	9.74	34,203	1.58
2012-10-05	20.04	23,146	1.51
2012-10-06	0.16	29,462	1.50
2012-10-07	1.88	26,298	1.53
2012-10-08	5.13	22,377	1.61
2012-10-09	2.23	32,617	1.58
2012-10-10	0.59	34,379	1.59
2012-10-11	7.06	24,665	1.57
2012-10-12	0.97	30,912	1.54
2012-10-13	1.77	25,529	1.48
2012-10-14	0.37	24,656	1.50
2012-10-15	3.01	29,839	1.59
2012-10-16	9.23	32,375	1.58
2012-10-17	5.82	29,504	1.56
2012-10-18	2.89	31,620	1.57
2012-10-19	6.64	20,410	1.54
2012-10-20	7.75	24,538	1.50
2012-10-21	2.14	15,028	1.45
2012-10-22	0.34	26,447	1.58
2012-10-23	0.04	30,949	1.58
2012-10-24	0.29	32,826	1.57
2012-10-25	1.34	28,747	1.57
2012-10-26	0.71	25,684	1.51
2012-10-27	1.33	16,582	1.41
2012-10-28	2.97	14,797	1.42
2012-10-29	1.62	23,641	1.55
2012-10-30	0.61	29,452	1.58
2012-10-31	17.12	28,452	1.58
2012-11-01	1.45	26,095	1.56
2012-11-02	2.26	27,911	1.53
2012-11-03	10.37	20,787	1.46
2012-11-04	5.87	11,317	1.42
2012-11-05	0.12	26,901	1.59
2012-11-06	0.45	26,280	1.59
2012-11-07	0.02	28,772	1.57
2012-11-08	0.02	29,148	1.57
2012-11-09	3.36	28,647	1.55
2012-11-10	0.98	17,378	1.44
2012-11-11	0.11	20,219	1.48
2012-11-12	2.35	23,010	1.60
2012-11-13	0.13	29,628	1.59
2012-11-14	0.07	30,615	1.59
2012-11-15	0.00	29,396	1.58
2012-11-16	0.47	27,416	1.55
2012-11-17	0.46	19,681	1.44
2012-11-18	0.10	20,917	1.51
2012-11-19	2.33	27,485	1.59
2012-11-20	7.50	25,281	1.56
2012-11-21	5.28	20,004	1.57
2012-11-22	12.33	26,998	1.56
2012-11-23	0.66	27,244	1.54
2012-11-24	14.31	8,579	1.39
2012-11-25	7.57	16,291	1.49
2012-11-26	9.36	20,063	1.56
2012-11-27	1.98	19,752	1.57
2012-11-28	0.09	20,854	1.56
2012-11-29	0.01	25,556	1.57
2012-11-30	0.22	24,163	1.53
2012-12-01	0.15	15,510	1.42
2012-12-02	6.29	14,722	1.45
2012-12-03	0.70	22,962	1.57
2012-12-04	1.03	25,436	1.58
2012-12-05	0.24	22,487	1.54
2012-12-06	8.98	22,063	1.54
2012-12-07	1.70	19,616	1.49
2012-12-08	0.14	17,241	1.45
2012-12-09	0.04	13,702	1.45
2012-12-10	0.09	23,307	1.57
2012-12-11	0.22	22,877	1.55
2012-12-12	0.10	21,760	1.54
2012-12-13	0.91	21,172	1.53
2012-12-14	14.40	16,641	1.53
2012-12-15	2.01	16,376	1.44
2012-12-16	2.97	13,633	1.50
2012-12-17	0.06	22,255	1.55
2012-12-18	0.12	23,003	1.55
2012-12-19	25.80	16,366	1.55
2012-12-20	5.52	12,061	1.50
2012-12-21	10.89	19,737	1.48
2012-12-22	11.47	5,435	1.37
2012-12-23	5.86	8,847	1.41
2012-12-24	12.06	7,705	1.34
2012-12-25	3.24	15,951	1.59
2012-12-26	6.65	9,994	1.66
2012-12-27	4.81	8,686	1.44
2012-12-28	1.40	10,526	1.43
2012-12-29	3.04	8,211	1.39
2012-12-30	0.47	10,878	1.43
2012-12-31	7.45	8,556	1.35
2013-01-01	0.00	11,606	1.41
2013-01-02	1.14	15,728	1.57
2013-01-03	0.02	20,601	1.57
2013-01-04	0.14	21,819	1.56
2013-01-05	0.15	15,633	1.43
2013-01-06	0.15	13,116	1.46
2013-01-07	0.05	22,730	1.60
2013-01-08	4.13	25,198	1.60
2013-01-09	0.19	24,655	1.59
2013-01-10	0.67	23,694	1.59
2013-01-11	3.05	23,213	1.56
2013-01-12	3.56	13,082	1.43
2013-01-13	0.05	11,830	1.43
2013-01-14	5.26	16,966	1.60
2013-01-15	0.10	22,119	1.56
2013-01-16	0.07	21,782	1.57
2013-01-17	0.45	21,510	1.57
2013-01-18	0.83	12,716	1.56
2013-01-19	0.50	7,580	1.35
2013-01-20	0.39	3,563	1.41
2013-01-21	1.01	12,936	1.56
2013-01-22	5.21	17,491	1.55
2013-01-23	1.04	18,772	1.56
2013-01-24	0.06	20,097	1.55
2013-01-25	5.29	19,536	1.53
2013-01-26	10.07	13,969	1.46
2013-01-27	0.71	13,152	1.44
2013-01-28	5.83	18,176	1.57
2013-01-29	7.27	20,607	1.57
2013-01-30	1.64	22,696	1.57
2013-01-31	6.67	21,265	1.55
2013-02-01	1.60	17,477	1.49
2013-02-02	0.00	15,160	1.45

Summary stats - by date

All rides 1 Oct 2011 to 2 Feb 2013 (491 days)

Rides per day

Average journey distance (miles)