Python Forum
Creating a numpy array from specific values of a spreadsheet column
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Creating a numpy array from specific values of a spreadsheet column
#1
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:
[Image: Xbcv2dj]

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!



   
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Get an average of the unique values of a column with group by condition and assign it klllmmm 0 220 Feb-17-2024, 05:53 PM
Last Post: klllmmm
  Convert numpy array to image without loading it into RAM. DreamingInsanity 7 5,725 Feb-08-2024, 09:38 AM
Last Post: paul18fr
  Converting column of values into muliple columns of counts highland44 0 205 Feb-01-2024, 12:48 AM
Last Post: highland44
  IPython errors for numpy array min/max methods muelaner 1 508 Nov-04-2023, 09:22 PM
Last Post: snippsat
  Returning Column and Row Data From Spreadsheet knight2000 0 413 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Editing spreadsheet/csv BSDevo 6 969 Sep-01-2023, 05:47 PM
Last Post: BSDevo
  Printing specific values out from a dictionary mcoliver88 6 1,317 Apr-12-2023, 08:10 PM
Last Post: deanhystad
  Transposing a dataframe without creating NaN values doug2019 2 932 Mar-18-2023, 03:14 PM
Last Post: jefsummers
  Looking to automate updating a spreadsheet with image from email cubangt 2 943 Feb-14-2023, 03:43 PM
Last Post: cubangt
  Expand the range of a NumPy array? PythonNPC 0 707 Jan-31-2023, 02:41 AM
Last Post: PythonNPC

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020