Load & check the data:
1. Load the data into a pandas dataframe named data_firstname where first name is you name.
2. Carryout some initial investigations:
a. Check the names and types of columns.
b. Check the missing values.
c. Check the statistics of the numeric fields (mean, min, max, median, count..etc.)
d. In you written response write a paragraph explaining your findings about each column.
Pre-process and visualize the data
3. Replace the ‘?’ mark in the ‘bare’ column by np.nan and change the type to ‘float’
4. Fill any missing data with the median of the column.
5. Drop the ID column
6. Using Pandas, Matplotlib, seaborn (you can use any or a mix) generate 3-5 plots and add them
to your written response explaining what are the key insights and findings from the plots.
7. Separate the features from the class.
8. Split your data into train 80% train and 20% test, use the last two digits of your student number
for the seed.
Build Classification Models
Support
breast cancer problem : I have already answered 1 to 3. Please provide solution from 4,5,6,7.
Programming
Step by stepSolved in 3 steps with 4 images
- 4. Write a SQL statement to create a view named 'Employees_Purchase which will contain First Name, Last name and Salary of employees who are working in the Purchasing department.arrow_forwardWhat's "metadata"? Metadata in a dataset: Metadata from a result set—useful?arrow_forwardanybodyarrow_forward
- What is metadata, exactly? For a result set, what is metadata? Result set information might be helpful in some situations.arrow_forwardWhat is metadata, exactly? What is metadata in the context of a result set? When is it useful to use metadata from a result set?arrow_forward28-Create a SQL statement to Display the RID, RType and a new column that will multiply the RATE to 30 in the ROOMS table. Use the alias "30-day Rental Fee".arrow_forward
- What exactly is the Data view?arrow_forwardYou have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table? You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?arrow_forwardLAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your guidance) SUBTASK 2: Build the tables in Oracle Live SQL with your account according to the tables above. SUBTASK 3: Build the relations among the tables. Addresses Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry address_id V NO 1234567890 Customers Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry customer id V number NO Good_groups Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry good_group_id V number varchar2(10) NOarrow_forward
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY