$9\mathrm{.}15$ pandas: Create Series from Dictionary

Using the same names and grades from the previous lab, create a Python dictionary of key value pairs with student name and grade. Then create a series from your dictionary and print it out.

Then create a Pandas Series that only selects students with a grade of $\text{'}$B$\text{'}$ or $\text{'}$C$\text{'}$ and print it out.

Sample output:

$```$

Fred $85$

Jacqui $96$

Tevon $75$

Amal $84$

Sarah $90$

dtype: int$64$

Fred $85$

Jacqui $96$

Amal $84$

Sarah $90$

dtype: int$64$

$```$

Remember to import pandas into your program. main.py

$```$

import pandas as pd

# create a dictionary containing names and grades of students

names$\_$grades $=\{\text{'}$Fred$\text{'}$: $85,$ 'Jacqui': $96,$ 'Tevon': $75,$ 'Amal': $84,$ 'Sarah': $90\}$

# create a pandas series from the dictionary

series $=$ pd$.$Series$($names$\_$grades$)$

# print the series

print$($series$)$

# print a blank line

print$()$

# create a series with grades of $\text{'}$B$\text{'}$ or $\text{'}$C$\text{'}$

# note: A is for $90-100,$ B is for $80-89,$ C is for $70-79,$ D is for $60-69,$ F is for $0-59..$

# so$,$ to fetch grades of B or C$,$ we need to fetch grades between $70$ and $89\mathrm{.}99,$ for that below statement

series$2=$ series$[($series $>=70)$ & $($series $<mtext></mtext><mn>9</mn><mn>0</mn><mi>)</mi><mi>]</mi>$

# print the series

print$($series$2)$

# note: sample output provided is not correct, because the question is to fetch students with grades B $($

# the sample output provided contains students with grades A as well.

# if you want to fetch students with at least grade B$,$ then the below statement can be used

# series$2=$ series$[$series $>=70]$

$```1$:Compare output

Output differs. See highlights below.

Special character legend

Your output

Expected output