CSS 300 Module 3 Activity Worksheet

CSS 300 Module 3 Activity Worksheet

Use this worksheet to complete your lab activity. Submit it to the applicable assignment submission folder when complete.

Deliverable:

· A word document summarizing the following steps

Using the dataset ramen-ratings.csv dataset

1. Import the dataset.

2. Get to know the dataset by using the following code samples. Do any of these hint at something being incorrect with the dataset? If so, explain.

df.head()

df.dtypes

df.info()

3. Get the shape of the dataset:

df.shape

4. Remove rows where at least one missing values is found using the following code sample:

dfNew = df.dropna(subset=["Review Number", "Brand", “Variety”, “Style”, “Country”, “Stars”])

5. Get the shape of the dataset post drops of nulls

6. Remove duplicate records using the following code sample:

df.drop_duplicates(keep = False, inplace = True)

7. Get the shape of the dataset post drops of duplicates

8. Take a look at the “Pandas Salaries Exercise.ipynb” file and answer the questions in the Jupyter Notebook as noted. These exercises use the dataset “Salaries.csv”)

9. Submit both ramen-ratings and Pandas Salaries Exercise (Salaries.csv) Jupyter Notebooks (ipynb files) for grading.