Homework 08

ImportantHW Instructions

Before starting, review the HW Instructions ⭐ for details on submission procedure.

Main Goals

The main goals of this homework assignment are:

  • 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

Non-TidyTuesday Section

This section of this homework consists of 2 challenge:

  • The first challenge involves scraping data from cheese.com. See the first NTT Template file for details and expectations.
  • The second challenge involves developing SQL queries to explore StackOverflow user activity and badges. See the second NTT Template file for details and expectations.

TidyTuesday Section (optional)

ImportantInstructions

You can count work on this week’s TidyTuesday toward the exceptional work required for an A in the Homework component.

Explore the week’s TidyTuesday challenge. Develop a research question, then answer it through a short data story with effective visualization(s). Provide sufficient background for readers to grasp your narrative.