Python Challenge: Calculate Average Score

Calculate the average score for each project, but only include projects where more than one team member has provided a score. Your output should include the project ID and the calculated average score for each qualifying project.

Python Challenge: Calculate Average Score

Calculate the average score for each project, but only include projects where more than one team member has provided a score. Your output should include the project ID and the calculated average score for each qualifying project.

Let’s dive into a medium-level Python interview question used by Deloitte. It will test your skills in data manipulation, filtering, and aggregation, using tools like Pandas to generate precise and insightful output.

Approach Hints:?

To help you think through this problem on your own, here are the technical concepts and steps used in this solution:

1. Grouping Data: Start by grouping project_data by project_id. Grouping allows us to perform aggregate functions on each project individually.?
2. Aggregation Functions: Use .agg() to calculate two things in one go:?
3. Filtering for Qualified Projects: Only projects with scores from more than one unique team member are included. Use grouped[grouped['team_member_id'] > 1] to filter out projects with fewer than two contributors.?
4. Column Renaming for Clarity: Rename score to average_score to make the output clear and user-friendly.?
5. Final Output: After all the calculations and filtering, the result will show only the project_id and the average_score for each qualifying project.

Take the challenge →

??? We Value Your Feedback!

We’re always looking to enhance your experience, and we’d love your feedback! Are there any features you’d like to see on the platform? How can we make your learning journey even smoother?

Take a few minutes to share your thoughts in our quick survey.

Take the Survey →

??? More Education Resources

For those looking to deepen their knowledge, here are two valuable reads to enhance your skills and stay competitive:

How to Maximize Your Impact as a Data Scientist

Discover practical ways to make a greater impact in your data science role by focusing on high-impact projects and aligning with business goals.

What do you want to specialize in?

In a data science career, you'll eventually face the question, "What do you want to specialize in?" This article explores why specialization matters, helps you identify the right path, and provides practical steps to get started in your chosen area.