Python Forum
How can I add certain elements in this 2d data structure and calculate a mean
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How can I add certain elements in this 2d data structure and calculate a mean
#4
I would have done something like:
import numpy as np
myClass = [["Lang", "Carla", 49, 71, 95, 50],
           ["Bucklund", "Pia", 86, 78, 83, 64],
           ["Lang", "Jason", 95, 57, 92, 62],
           ["Dimitrousis", "Hector", 93, 45, 89, 96],
           ["Owens", "Sunna", 45, 50, 46, 54],
           ["Goldin", "Sandra", 25, 60, 45, 55],
           ["Giles", "Seth", 67, 73, 93, 64],
           ["Gurillo", "Melanie", 88, 88, 62, 79],
           ["Rykiel", "Kari", 67, 92, 54, 86],
           ["Shailes", "Dennis", 56, 70, 84, 62]]
 
myClass = np.asarray(myClass)

# get numbers only + mean calculations
Notes = myClass[:, 2:].astype(float)
Mean = np.mean(Notes, axis = 1).reshape(-1, 1)


# check status (pass by default)
Status = np.empty( (10,1), dtype='object')
Status[:] = 'Pass'

# now we can look for 'failed' status
t = np.where(Mean < 50)
Status[t] = 'Fail'

# Concat results
myClass = np.hstack((myClass, Mean, Status))
print(f"{myClass}")
Providing:
Output:
[['Lang' 'Carla' '49' '71' '95' '50' 66.25 'Pass'] ['Bucklund' 'Pia' '86' '78' '83' '64' 77.75 'Pass'] ['Lang' 'Jason' '95' '57' '92' '62' 76.5 'Pass'] ['Dimitrousis' 'Hector' '93' '45' '89' '96' 80.75 'Pass'] ['Owens' 'Sunna' '45' '50' '46' '54' 48.75 'Fail'] ['Goldin' 'Sandra' '25' '60' '45' '55' 46.25 'Fail'] ['Giles' 'Seth' '67' '73' '93' '64' 74.25 'Pass'] ['Gurillo' 'Melanie' '88' '88' '62' '79' 79.25 'Pass'] ['Rykiel' 'Kari' '67' '92' '54' '86' 74.75 'Pass'] ['Shailes' 'Dennis' '56' '70' '84' '62' 68.0 'Pass']]
penultimate column = mean
Last column = status
Reply


Messages In This Thread
RE: How can I add certain elements in this 2d data structure and calculate a mean - by paul18fr - May-27-2022, 09:09 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  script to calculate data in csv-files ledgreve 0 1,055 May-19-2023, 07:24 AM
Last Post: ledgreve
  ValueError: Length mismatch: Expected axis has 8 elements, new values have 1 elements ilknurg 1 5,013 May-17-2022, 11:38 AM
Last Post: Larz60+
Question Change elements of array based on position of input data Cola_Reb 6 2,062 May-13-2022, 12:57 PM
Last Post: Cola_Reb
  calculate data using 1 byte checksum korenron 2 2,876 Nov-23-2021, 07:17 AM
Last Post: korenron
  Appropriate data-structure / design for business-day relations (week/month-wise) sx999 2 2,750 Apr-23-2021, 08:09 AM
Last Post: sx999
  what data structure to use? Winfried 4 2,783 Mar-16-2021, 12:11 PM
Last Post: buran
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 7,559 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  Sorting Elements via parameters pointing to those elements. rpalmer 3 2,549 Feb-10-2021, 04:53 PM
Last Post: rpalmer
  How to use Bunch data structure moish 2 2,830 Dec-24-2020, 06:25 PM
Last Post: deanhystad
  Correct data structure for this problem Wigi 13 4,501 Oct-09-2020, 11:09 AM
Last Post: buran

Forum Jump:

User Panel Messages

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