Assignment 2: COVID-19 Data Wrangling Name: The purpose of this assignment is to hone your data wrangling skills. Your task for this assignment is to perform the data preparation as instructed in the DTSC670_Assignment_2 pdf listed in Brightspace. After performing all the data preparation tasks outlined in the document, run the code in the "Prepare DataFrames for Grading" section. You are supplied an Excel file called BrazilcOVIDData.xlsx - be sure to put the data file in the same directory as this Jupyter Notebook. Please note that it may take around 5 minutes to read-in all of the data in this file. ]: ### ENTER CODE HERE ### # Insert as many cells as you need, but be sure your code is very neat and very well documented. ]: # Get Final Features DataFrame # features = ### ENTER CODE HERE ### # Get Final Response DataFrame # response = ### ENTER CODE HERE ###

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.   ANSWER IN MYSQL PLEASE

Data base

In the Testa EV database described in the previous question, fill in the blanks in the following MySQL statement to list (in this order) all the part numbers of components of 'EV Dashboard' (with Part_No=1) and their quantities; sort the results in ascending order of quantity of components (i.e., components with small quantities are listed first). (Please ensure correctness in the spelling of all names and commands. Do not enter unnecessary symbols such as spaces or commas)

Grade Roster Sort (file I/O) The file RosterScores.txt contains student test scores with comma-delimited data similar to what is shown in the screen snip below. Names, Scores Marie Curie, 89 Caroline Herschel, 70 Mary Anning, 93 Barbara McClintock, 99 Dorothy Hodkin, 85 My Solutions > Write a script that loads the data from this file into a table array variable named RosterScores and sorts the rows in order of the test scores running highest to lowest. Save the result in a new text file named RosterScores Sorted.txt.

I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all.   Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW

Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.

How well do you understand the differences between data definition, data manipulation and data control commands, and when to use each of these commands?

Why is data validation important? Pick one of the data validation tips: How does this tip validate the input data? When and why would you use this tip?

What's "metadata"? Metadata in a dataset: Metadata from a result set—useful?