iterate through list of number in dataframes python

Question

I have a list number data frame and I want to calculate the average using Python language enter image description here

Does this answer your question? Pandas mean of list within dataframe — bluevulture
– bluevulture, Commented Dec 21, 2021 at 12:20
You want to calculate the average within each semester, I suppose? — Niqua
– Niqua, Commented Dec 21, 2021 at 12:24
Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Dec 29, 2021 at 23:20

Sam · Accepted Answer · 2021-12-21 13:55:02Z

0

You can use .apply here with a lambda function.

df["Course Final Score"] = df["Course Final Score"].apply(lambda x: sum(x)/len(x))

Essentially your applying the function sum(x)/len(x) to every x in your column "Course Final Score", i.e replacing the list with the sum of that list divided by the length of that list which will give you the mean.

EDIT

If your list contains a string of a list, you can use json to decode it as follows:

import json
df["Score"].apply(lambda x: sum(json.loads(x))/len(json.loads(x)))

edited Dec 21, 2021 at 13:55

answered Dec 21, 2021 at 12:24

Sam

9138 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

hana Over a year ago

TypeError: unsupported operand type(s) for +: 'int' and 'str'

Sam Over a year ago

Does your list of Scores contain strings at any point?

Sam Over a year ago

I've edited a solution for if your scores are string values.

hana Over a year ago

ValueError: could not convert string to float: '['

hana Over a year ago

ValueError: could not convert string to float: '['

|

Collectives™ on Stack Overflow

iterate through list of number in dataframes python

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related