Lecture 10
Cornell University
INFO 2951 - Spring 2025
February 25, 2025
Data is organized in tables
Databases run on database management systems (DBMS’s)
SQL | {dplyr} |
---|---|
SELECT |
select() , mutate() , rename() , relocate() , summarize() |
FROM |
N/A |
GROUP BY |
group_by() |
WHERE |
filter() |
ORDER BY |
arrange() |
Objective: make interacting with databases as seamless as possible
ae-08
Instructions
ae-08
(repo name will be suffixed with your GitHub name).renv::restore()
to install the required packages, open the Quarto document in the repo, and follow along and complete the exercises.