Homework 8

Due by Tuesday, April 8 at 11:59pm

Skills challenge

Navigate to GitHub Classroom. This will create a Github repository for you. Clone this repository to your local machine using Github Desktop (click Set up in Desktop). Set the Local Path to your homework folder in your class folder.

There are two tasks and thus they are separated into two files. You are expected to completed both tasks.

• Web Scraping Open HW8_Part1.qmd. This will involve scraping data from cheese.com.
• Database SQL. Open HW8_Part2.qmd. This will involve developing SQL queries to explore StackOverflow user activity and badges.

Project Milestone 4: See information on our Project page.

Concepts to Know

• Use CSS Selectors and the Selector Gadget tool to locate data of interest within a HTML webpage
• Use the html_elements() and html_text() functions within the rvest packages to scrape data from webpage using CSS selectors
• Develop comfort in composing SQL queries
• See the connections between tidyverse verbs and SQL clauses

Optional

If you are aiming for an A in the course, recall from our syllabus that participating in 3 Tidy Tuesday challenges can move you toward this goal. These are great to include in your digital portfolio.

• I encourage you to participate in the most recent Tidy Tuesday challenge.
• To turn in your work, share an image of a visual that you are proud of in the #sharing-is-caring channel on Slack and a link to a Github repository created for your Tidy Tuesday work. I encourage you to make the repo public; if you choose to keep it private, add the instructor as a collaborator.