Creating a numpy array from specific values of a spreadsheet column

[JulianZ]

I have a spreadsheet that I have to calculate the average rainfall for each of the days of the week over a period of a year.

I am having trouble trying to figure out an effective way to collect all the rainfall information for the each day of the week and putting each days' value of rainfall into a numpy array.

This is how the spreadsheet is set out:


if that link doesn't work, I have attached the picture.

So essentially day 1 refers to monday and day 7 refers to sunday .

I need to collect all the rainfall values for each day, put that rainfall value into its own specific numpy array for its respected day.


Could somebody please help me out?

Thanks!