(a) Write commands to create an R data frame out of the data in the following table. Manager Sales Gender 25 T23EE2 Tito Emily 31 Justice Vincent 52 Todani 76 Shandu 49 F F M M F M

Problem 2: Create a Dataframe whose index is winery and whose values is the maximum number of points a wine costing that much was given in a review. Sort the values by points, descending (so that 80 points is at the bottom and 100 points is at the top).

de Show Review View Tell me whatyou want to do. Sign in & Share less you need to edit, it's safer to stay in Protected View. Enable Editing Calculate mean value Mean Amean value Ex = sum of all data values (x,, X, X3,) n= number of data values

q4

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

Read the data into a DataFrame with ID as the index. Convert the “Hired” column into Date/Time data type Create a new column with years of experience with the company at present without rounding. Create a new Boolean column for senior status with employees with at least 10 years of experience as senior and others are not. Create a new column for longevity pay equal to $150 per whole year of experience in the company. Create a list of column names for each data type in the DataFrtame.

q15- Please choose all that apply

Create a view to show the total number of staff for each city with more than 1 staff. The output column header should be city, number_of_staff, sorted by the total number of staff from high to low.

Create a VIEW named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name, balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.

a. Create table "STUDENT" with attributes "STUDENT_ID", "STUDENT_NAME", "STUDENT_GPA". 1 b. Use appropriate datatype for each attribute. c. Insert details of three students. Use FOR loop to print these details in the descending order (Highest first and Lowest last) of 2 their GPA.