$1$

PandasA$3-$ FOR CREDIT

$$ Create a $.$ipynb file called PandasA$3$credit.ipynb and complete the following.

$$ For this assignment load but DO NOT INSTALL NumPy and Pandas: run the following at

the top of your script and then complete the questions:

import numpy as np

import pandas as pd

$$ Assume all arrays are NumPy arrays, all Series are Pandas series, etc., unless

otherwise specified

$$ Everything is case sensitive$,$ so BE CAREFUL

$$ After you create the object $($e$.$g$.,$ Q$1),$ DO NOT PRINT! Your file should something look

like this:

Q$1=[$Hello$]$

Q$2=$ x$[3$:$]$

Before attempting these make sure to watch $$CodeGrade

Walkthrough$$ in module $1-$ if you do not you will not

understand how assignments work!

For reference:

CodeGrade tips and FAQ

CodeGrade $-$ What to do if my code doesn$$t work?

$$ Create series from the following two dictionaries:

From those series create a dataframe called q$1,$ such that the first series represents the

$$lowercase$$ column and the second series represents the $$numbers$$ column.

$$ Index that dataframe to obtain the following:

Assign it to Q$1.$

$$ Slice the dataframe to obtain the following:

Assign it to Q$2.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$3.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$4.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$5.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$6.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$7.$

$$ Using $.$loc, obtain the following from q$1$:

Assign it to Q$8.$

$$ Using $.$loc, obtain the rows from q$1$ with numbers less than three. Assign it to

Q$9.$

$$ Using $.$iloc, obtain the following from q$1$:

Assign it to Q$10.$

$$ Using $.$iloc, obtain the following from q$1$:

Assign it to Q$11.$

$$ Using $.$iloc, obtain the following from q$1$:

Assign it to Q$12.$