CSS 300 SXU Data Cleaning Process Lab

CSS 300 Module 2 Activity WorksheetUse 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