Using Pandas in CSV

Question

I am new to Python, kindly help me to understand and go forward in python learning. Find below the sample data:

Country Age Sal OnWork
USA 52 12345 No
UK 23 1142 Yes
MAL 25 4456 No

I would like to find the mean value in SAL column if OnWork is NO

County Age Salary OnWork USA 52 11456 No UK 25 1235 Yes Singapore 45 4456 No Not sure how to update Table format here..... — Mariappan M
– Mariappan M, Commented Sep 21, 2019 at 0:48
Welcome to StackOverflow. Please follow the posting guidelines in the help documentation, as suggested when you created this account. On topic, how to ask, and ... the perfect question apply here. StackOverflow is not a design, coding, research, or tutorial resource. However, if you follow whatever resources you find on line, make an honest solution attempt, and run into a problem, you'd have a good example to post. — Pedro Rodrigues
– Pedro Rodrigues, Commented Sep 21, 2019 at 0:50

αԋɱҽԃ αмєяιcαη · Accepted Answer · 2019-09-21 01:18:37Z

1

Let's Say that your data looks like the following,

{'Country': 'USA', 'Age': '52', 'Sal': '12345', 'OnWork': 'No'}
{'Country': 'UK', 'Age': '23', 'Sal': '1142', 'OnWork': 'Yes'}
{'Country': 'MAL', 'Age': '25', 'Sal': '4456', 'OnWork': 'No'}

The below code will be of help in your case:

df = your_dataframe
df[df["OnWork"]=="No"]["Sal"].mean()

edited Sep 21, 2019 at 1:18

αԋɱҽԃ αмєяιcαη

11.6k3 gold badges23 silver badges58 bronze badges

answered Sep 21, 2019 at 1:03

Deven

7411 gold badge7 silver badges22 bronze badges

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

4 Comments

Mariappan M Over a year ago

Whether I can use IF of Where class to find YES and NO values mean.

Deven Over a year ago

You can use df.filter(items = ["OnWork","Sal"],axis=1).groupby(by = ["OnWork"]).mean()

Mariappan M Over a year ago

I am getting IndentationError: unexpected indent error. The real spreadsheet has more than 10k lines in 7coloums

Deven Over a year ago

please check your code indentation, if problem still persists please post the complete traceback by editing the question.

Collectives™ on Stack Overflow

Using Pandas in CSV

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related