Course Materials

• Handout #15: R Shiny App: Link | Code
• Texas School Data: CSV


• Handout #14: R - APIs: Link(Updated 4/25)
• BLS API: Link
• NOAA API: Link
• College Board: Link


• Handout #13: R - dplyr: Link | Code
• Fligth Delay Data: Link


• Handout #12: R - Data Management: Link | Code
• Baby Name Wizard: Link
• Social Security - Baby Names: Link
• State-Regions Data: CSV


• Handout #11: R - ggplot: Link
  • Ames Housing: CSV | Data Dictionary
  
  
• Handout #10: R - Introduction: Link
  • Data: Citi Bike: Link
  
  ==================================
  
• Midterm Takehome: WORD | PDF; Due Friday 4/6 by 5:00PM; 125 points;


• Walmart Problem: Data


• Nursing Home Problem:
  • SQL Code: Code
  • Datasets: ElderlyData.csv | SSA_FIPS_Crosswalk.csv | ProviderInfo_Download.csv (same as your copy)
  • Article: CMS Minimum Standards
  
  
  ==================================
  
• Midterm Redo: Code
  • Data: Car Accidents: Link
  • Data: Phone Data: Link
  • Data: DSCI 210 Folder Contents: Link
  
  ==================================
  
• Handout #9: Additional SQL: Link | Code


• Handout #8: Intro to SQL: Link | Code (Updated 3/16, 6PM)
• Nursing Home Compare Data: Link


• Handout #7: Streaming Data Summaries: Link (Updated on 3/12)| Code | PPT
• Medicare / Medicaid Data: Link


• Handout #6: Custom Reports: Link | Code
• Course Enrollments: Data


• Handout #5: IF-THEN Statements: Link | Code (Updated 2/26)
• Grades: Data
• Grades_Missing: Data


• Handout #4: Functions in the Data Step : Link (Updated 2/19)
• NYC_Trees: Data
• Grades: Data
• Contact Info: Data

• Handout #3: Reading in partial data: Link
• NC_Birth: Data


• Handout #2: Reading in data -- INFILE: Link (Updated 2/8)
• NC_Birth: Data
• NC_Birth_Multiline: Data
• CourseData_CSV: Data
• CourseData: Data
• FacultyData: Data
• NationalParks: Data
• LogFile: Data
• Sample XML: Data


• Handout #1: Reading in data -- PROC IMPORT: Link (Updated)
• Car Accidents: Data



• Syllabus: Link

Homework Assignments

• Task from Handout #8 is due Monday, 5:00PM: Link
• HW #1: Link
• Log Files: Link