Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Conduct Data Cleansing: Implement the following tasks: . . Drop the Class column from the created Business Class passenger satisfaction survey (df_Business). Rename

image text in transcribed

2. Conduct Data Cleansing: Implement the following tasks: . . Drop the Class column from the created Business Class passenger satisfaction survey ("df_Business"). Rename "df_Business" columns by making all the columns' names in lowercase, and if the column name has whitespace, replace it with an underscore. (For example: "Customer Type" will be renamed to "customer_type"). Modify improperly formatted data and handle bad data. Handle the missing values (You should have zero missing values in your cleaned dataset). Remove the fully duplicated observations. Fix the columns datatypes. 3. Export the cleaned dataset to CSV file. . Use the following naming convention: Project_2_Group#.csv 4. Compare the Data Characteristics Before and After Data Cleansing. . At the end of the Jupyter Notebook, provide a brief write-up annotation to compare the characteristics of each column before and after data cleansing (this includes, the column name, datatype, unique values, and the number of missing values).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Engineering Mechanics Statics

Authors: R. C. Hibbeler

12th Edition

136077900, 978-0136077909

More Books

Students also viewed these Mechanical Engineering questions