'File A' has list of university ranked in year let's say 2018, 'File B' has list of university ranked in year 2017,
File A (2018 Rankings):
University of Oxford University of Cambridge California Institute of Technology Stanford University Massachusetts Institute of Technology
File B (2017 Rankings):
University of Oxford California Institute of Technology Stanford University University of Cambridge Massachusetts Institute of Technology
'Stanford University' is ranked 4th in 2018, whereas it was 3rd in 2017. So, I want an output of files which contains only the university ranked in 2017, which went above Stanford in 2018 rankings, similarly, list of university which was ranked in 2017 which went below Stanford in 2018 rankings.
Expected output should contain two files having data on,
**Ranked above Stanford: ** University of Cambridge **Ranked below Stanford: ** NONE
NONE - As no university was ranked above stanford in 2017 rankings went below standford in 2018 rankings.
I want to be able to do this for any university mentioned in the list.
Data entered here are snippets from huge data files, they contain 1000+ lists of university ranked. I want to analyze this for few university only.