Question: ### Note that the Code Grade virtual machine ( computer ) already has the Wine.csv file in its working directory. #### Do not submit code
### Note that the Code Grade virtual machine computer already has the Wine.csv file in its working directory.
#### Do not submit code with setwd or that has a path for example: UsersfirstlastDesktop in it
CG Qa # How many observations rows are available to you? Use the nrow function.
CG Qb # How many variables columns are collected on each rated wine? Use the ncol function.
$#### Io is important to find the exact spellings of column names and entries within columns in the wine dataframe.
CG Qa Use the names or str function on the wine dataframe to view the exact spellings of the column names. ##### You will use this strategy of "looking" in a column to get exact sepllings to answer questions on this quiz.
##### It is important to know whether there are missing values NAs in your data
#### since NAs need to be addressed for certain functions to work correctly.
# CG Qa # Use the sum and
isna functions to find the number of missing values in the wine dataframe.
# CG Qb # Use the sum and
isna functions to count the number of missing values in the points column.
# CG QC # Use the sum and
isna functions to count the number of missing values in the price column.
# CG Qd # Use the sum and
isna functions to count the number of observations that have a price.
##### Hint: Since the means "not", putting an in front of
isna counts the nonmissing values.
# CG Qa # Use the mean function to calculate the average points for the wines in the dataset.
# CG Qb # Use the mean function to calculate the average price for the wines in the dataset.
# CG Qa # Use the mean function to calculate the average points for the Napa Sonoma subregion.
##### Your code should be a single line and will use the square brackets for subsetting..
# CG Q # Now we practice our counting skills again.
##### The rating scale being used by these tasters orignally had as the highest possible score
##### and now goes to for exceedingly delicious wines.
$$$$# Use the sum function on a logical vector that checks for whether points are greater than or not
### to count the number of wine ratings with more than points.
# CG Qa # Now we practice subsetting on more than one criteria.
##### Use the mean function to compute the average points for wines
$#### that are chardonnay and from the Napa Sonoma subregion.
# CG Qb # More practice subsetting on more than one criteria.
###### Use the mean function to compute the average price for wines that are
$#### either chardonnay or are from the finger lakes subregion.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
