My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 6: Data consilidation and ranking mapping
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  rui.m...@gmail.com


 
Project Member Reported by rui.m...@gmail.com, Jan 7, 2009
Consolidate data retrieved from USNews and Petersons.

Map the ranking of major from USnews  to programs in the database.


Jan 12, 2009
Project Member #1 rui.m...@gmail.com

1. RankingParser.py to generate USNews ranking in /home/rma/qifei/ranking

2. Execute 'stale_prognames.sql' to adjust stale school names in programs

2. Run 'python runclr.py' to change schools in USNews to the same in Petersons

3. Run 'python change_ranking.py' to adjust some non existing ranking

4. Run 'ProgAdder.py' to duplicate programs whose majors don't exsit. Run
TestlogMatcher.py to check if there are still majors which have not duplicated. 

5. Lastly, run 'RankingUpdater.py' to update all the rankings to programs table.

Jan 12, 2009
Project Member #2 rui.m...@gmail.com

1. RankingParser.py to generate USNews ranking in /home/rma/qifei/ranking

2. Execute 'stale_prognames.sql' to adjust stale school names in programs

2. Run 'python runclr.py' to change schools in USNews to the same in Petersons

3. Run 'python change_ranking.py' to adjust some non existing ranking

4. Run 'ProgAdder.py' to duplicate programs whose majors don't exsit. Run
TestlogMatcher.py to check if there are still majors which have not duplicated. 

5. Lastly, run 'RankingUpdater.py' to update all the rankings to programs table.

Jan 28, 2009
Project Member #3 rui.m...@gmail.com
When built from scratch, remember to import the new mapping (major_map.sql) before
assigning ranking. 
Jan 28, 2009
Project Member #4 rui.m...@gmail.com
Total assigned programs: 27208

Powered by Google Project Hosting