Choose the suitable data that can be represented using 'character' data type from the folllowing.

Answer the questions based on the given data frame:
students <- data.frame(
ID = c(101, 102, 103, 104, 105),
Name = c("Anu", "Bala", "Chitra", "Deepak", "Esha"),
Marks = c(85, 72, 90, 65, 78),
Grade = c("A", "B", "A", "C", "B")
)
A student wants to display the Grade column as a list for further calculations. Choose the most appropriate method.

Consider the following data frames: students(student_id, name, department); music(student_id, name, instrument); games(student_id, name, game). Identify the command that would list students who are there in both music and games.

Consider the following data frames: students(student_id, name, department); music(student_id, name, instrument); games(student_id, name, game). Choose the join that would list students in music club.

Consider the following data frames: students(student_id, name, department); music(student_id, name, instrument); games(student_id, name, game). Choose the join that would list students in not in the games club.

Identify the function that returns the number of rows and columns in a data frame.

Identify the function that finds the missing values in a column of a data frame.

Consider the following data frame: product <- data.frame(
product_code = c(101, 102, 103, 104, 105),
product_name = c("Laptop", "Mouse", "Keyboard", "Monitor", "Printer"),
category = c("Electronics", "Accessories", "Accessories", "Electronics", "Electronics"),
price = c(55000, 800, 1500, 12000, 9000),
availability = c("In Stock", "In Stock", "Out of Stock", "In Stock", "Out of Stock")
)
Identify the function that would display how many items are 'in stock' and how many items are 'out of stock'.

Identify the function that can be used to identify duplicate rows.

Name the observations that deviate significantly from other data values in a dataset.

Choose the function that searches for a pattern in a data frame.

Identify the function that is used to find the average price of each brand in a product table that contains the columns: product_code, product_name, brand, price.

Consider these dataframes for answering the questions:
orders <- data.frame(order_id = c(1, 2, 3), customer_id = c(101, 102, 103), amount = c(250, 300, 150) )
customers <- data.frame( customer_id = c(101, 102, 104), customer_name = c("Anu", "Bala", "Chitra") ). Display the orders without matching customer details.

Select the function that displays the names of the features or attributes in a dataset.

A health researcher is collecting data on individuals’ daily alcohol consumption. Some participants choose not to disclose their alcohol intake. It is suspected that those who consume very high amounts of alcohol are more likely to skip this question because they feel uncomfortable reporting it. What type of missing data does this scenario represent?

Identify an approach that is used to handle outliers.

Which of the following charts is used to identify outiers?

An HR manager has employee performance scores along with their department names. He needs to determine the average performance score for each department to support promotion decisions. Which R function should be used?

A marketing analyst stores campaign performance data (click rates) for different regions in a list. He wants to compute the average click rate for each region while keeping the results structured as a list for further detailed analysis. Which function should he use?