Skip to content

Latest commit

 

History

History
20 lines (16 loc) · 703 Bytes

R-sql-export-to-database-R.md

File metadata and controls

20 lines (16 loc) · 703 Bytes
Raw
layout topic title language
exercise
R-SQL
Export to Database
R

Dr. Undómiel has decided to focus on the change in size of a few target rodent species over the course of the experiment(1977-2002). She has chosen , Dipodymys spectabilis, Onychomys torridus, Perymiscus erimicus, Chaetodipus penicillatus.

Write a script that uses R and SQL to:

  1. Connect to the portal_mammals.sqlite.
  2. Generate a data frame with year, species_id, and the average weight per year (avg_weight) for each target species.
  3. Use dbWriteTable() to include your new data frame in the portal_mammals.sqlite. Call it something informative so that Dr. Undómiel can find it easily.