Click here to Skip to main content
15,794,593 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:
You are given an Excel file (“Patient_Information.xlsx”) that stores the Patient ID, Name, gender, age, weight and systolic blood pressure of patients. Write python codes to complete the following tasks.

Create a new column “Age Group”. If the “Age” of a patient is from 30 to 39 (including the boundaries), the value of “Age Group” will be “30 – 39”. Do similarly for the following “Age Group” values: “40 – 49”, “50 – 59”, “60 or above”. Print a table to show the number of values in each age group.

What I have tried:

import pandas as pd
df = pd.read_excel("Patient_Information.xlsx")
Updated 5-Dec-22 10:41am
Sandeep Mewara 5-Dec-22 0:21am    
And... what have you tried and where are you stuck with your homework?
Simon Cheung 5-Dec-22 0:22am    
Everything, but it is totally meaningless to post my wrong answer in the forum, right?
Richard Deeming 5-Dec-22 5:11am    
No. You include the code you've tried in your question, and explain what the problem with it is and where you are stuck.

Anything less is asking us to do your homework for you, which we won't do.

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900