Download copies of the following Portal Teaching Database tables:
Load them into R using read.csv().
inner_join() to create a table that contains the information from both
the surveys table and the species table.inner_join() twice to create a table that contains the information from
all three tables.inner_join() and filter() to get a data frame with the information
from the surveys and plots tables where the plot_type is Control.Control
plots to the Long-term Krat Exclosures. Create a data frame with the
year, genus, species, weight and plot_type for all cases where the
plot type is either Control or Long-term Krat Exclosure. Only include
cases where Taxa is Rodent. Remove any records where the weight is
missing.