Interview Query

Good Grades and Favorite Colors

0
Have you seen this question before?

You’re given a dataframe of students named students_df:

students_df table

name age favorite_color grade
Tim Voss 19 red 91
Nicole Johnson 20 yellow 95
Elsa Williams 21 green 82
John James 20 blue 75
Catherine Jones 23 green 93

Write a function named grades_colors to select only the rows where the student’s favorite color is green or red and their grade is above 90.

Example:

Input:

import pandas as pd

students = {"name" : ["Tim Voss", "Nicole Johnson", "Elsa Williams", "John James", "Catherine Jones"], "age" : [19, 20, 21, 20, 23], "favorite_color" : ["red", "yellow", "green", "blue", "green"], "grade" : [91, 95, 82, 75, 93]}

students_df = pd.DataFrame(students)

Output:

def grades_colors(students_df) ->
name age favorite_color grade
Tim Voss 19 red 91
Catherine Jones 23 green 93
Next question: 5th Largest Number
.....
Python 3.9.6
Loading editor
Use Shift + Enter to run code