search

TZstatsADS / Spr2017-proj2-grp10

Spr2017-proj2-proj2_team10 created by GitHub Classroom
1 stars 4 forks source link

Meeting minutes 15 Feb 2017 (Variables and UI) #8

Open jt2929 opened 7 years ago

jt2929 commented 7 years ago

Sketch look of UI:

"Basic variables" (i.e. simple filtering, factor variables)

  1. Major (using the variables in the excel file i.e. bachelor's degree in architecture, education), format will be a select drop down
  2. Type of City (using the variable in the excel file 'degree_urbanization')
  3. Type of school (using the variable in the excel file 'ownership')
  4. Race (using UGDS_white, UGDS_black etc), will probably define the cut off points ourselves

"Advanced" (i.e. regression, weighting)

  1. Academic Performance
  2. Average cost of attendance (i.e. COSTT4_A)
  3. Earnings (i.e. the Mean Earnings of students working and not enrolled 8 years after entry) (or whatever year we want) - i realized the dataset for 2014/15 and 2013/14 do not contain this data so i guess we can just use the data from 2012/13 for this?
  4. Crime (safety) - need to collate by state
  5. Happiness index - need to collate by state https://wallethub.com/edu/happiest-states/6959/#main-findings

UI will have a map in the middle, then sidebar panel on the left for the options sidebar panel on the right for the table pop up/ and maybe a data visualization of bargraphs or something?

Jobs assigned: Yijia to filter out all the relevant variables Yuejin to sort out the rankings and filter out the top 200 schools after Yijia Jiahui to merge in the crime and happiness index data after Yuejin

Amanda and Tongyue to figure out what data visualization/how to add it in

jt2929 commented 7 years ago

Hi there,

after all the updated data from everyone, i have uploaded the (hopefully) final dataset (i.e. finaldata.csv) with the happiness score, happiness ranking, and crime score merged into the datafile in data. I edited abit of Amanda's DataCleaning.R file as i don't think the 'setting' variable was what we were going for... it was more of the "LOCALE" variable which I added it in as 'Citytype' and removed the 'setting' column. Thus the DataWithRank file in doc has also been naturally updated.