Cargo Bike

By Andres on 6 April 2021

Richmond Council is asking for bids for their Active Richmond Fund and we are gauging your interest in PRS making a submission to set up an electric cargo bike share scheme for residents.

Cargo bikes are bikes with a container attached. An electric bike still keeps you fit but makes light work of heavy loads and hills, making it accessible to a wider range of people. The bid would include funding for the bike, secure storage and setting up an online booking system. It may include offering some match funding, in the form of residents time (rather than money) setting the scheme up and maintenance.

We would appreciate your feedback.

import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv("CargoBike_(1-8).csv")
pd.set_option('display.max_rows', None)
pd.set_option('display.max_colwidth', -1)

Would you be interested in using a cargo bike if it was available?

Q1=df['Would you be interested in using a cargo bike if it was available?'].value_counts()
Q1.plot.pie()
plt.ylabel('')
plt.title('Question 1');

If you answered yes, what would you use if for? Select as many as you want.

col_name2="If you answered yes what would you use if for?  Select as many as you want."
df.rename(columns={col_name2:'Q_2'}, inplace=True)
q2_df = pd.DataFrame(df['Q_2'])
Q2_df=q2_df.assign(Q_2=q2_df.Q_2.str.split(';')).explode('Q_2')
Q2=Q2_df['Q_2'].value_counts()
Q2.plot.pie()
plt.ylabel('')
plt.title('Question 2');

If other what would you use if for?

Q3=pd.DataFrame(df["If other what would you use if for?"]).dropna()
Q3

	If other what would you use if for?
0	Picnics. moving things around the borough.
1	package delivery for possible business.
3	Kids maybe and big shop items eg plants
4	allotment
7	Garden centre stuff
10	Carrying things to and from my allotment Also picnics!

Q4=df['Would you be happy to subscribe a small amount to pay for insurance and repairs?'].value_counts()
Q4.plot.pie()
plt.ylabel('')
plt.title('Question 4');

Would you be happy to book the bike via an online system?

Q5=df['Would you be happy to book the bike via an online system?'].value_counts()
Q5.plot.pie()
plt.ylabel('')
plt.title('Question 5');

How frequently would you use a cargo bike?

Q6=df['How frequently would you use a cargo bike?'].value_counts()
Q6.plot.pie()
plt.ylabel('')
plt.title('Question 6');

How far would you travel? In Miles

Q7=df['Points - How far would you travel? Miles'].value_counts()
Q7.plot.bar()
plt.ylabel('Number of responses')
plt.xlabel('Miles')
plt.title('Question 7');

Which form of transport do you currently use, that the bike would replace?

Q8=df['Which form of transport do you currently use that the bike would replace?'].value_counts()
Q8.plot.pie()
plt.ylabel('')
plt.title('Question 8');

Would you be interested in joining a community activity to build the secure storage shed and/or the bike?

Q9=df['Would you be interested in joining a community activity to build the secure storage shed and/or the bike?'].value_counts()
Q9.plot.pie()
plt.ylabel('')
plt.title('Question 9');

The shed might be used to store other bikes and have space for tools etc. Select any of the below that you agree with.

Q10=df['Select any of the below that you agree with.'].value_counts()
Q10.plot.pie()
plt.ylabel('')
plt.title('Question 10');