Developing Data products

Spandana Makeneni
08/04/2020

Dashboard for exploring college and tuition data

Assignment

The goal of this assignment is to build:

  • A shiny application that has widget input, ui input in server.R, reactive output using server calculations, and supporting documentation
  • A reproducible pitch presentation that contains five slides in either Slidify or Rstudio presenter that is pushed to and hosted on GitHub or RPubs and contains embedded R code
  • Links to App & Code :

Data

  • The dataset consists of college tuition data and salaries for 2018 across the United states.
  • The data was downloaded from:
  • I decided to explore correlation between college tuition and early/mid career pay and create an interactive dashboard

Dashboard

  • The dashboard consists of two elements - a scatter plot and a table
  • Selecting the state from the first drop down will update the chart and allows the user to explore the correlation between pay and tuition in that state
  • Selecting a specific college/university from the second drop down will update the table below the chart and display the tuition, room and board cost

Code example - Plot on the dashboard

btc_esp_plot <- ggplot(df,aes(Name=Name))+ 
geom_segment(aes(x=Outstate,xend=Outstate,y=early_career_pay,
yend=mid_career_pay),color="gray")+ 
geom_point(aes(x=Outstate,y=early_career_pay,color="Earlycareer"),size=3)+ geom_point(aes(x=Outstate,mid_career_pay,color="Midcareer"),size=3)+
theme_classic()+xlab("Out of state tuition")+ylab("Pay") 

Thanks