The idea was to convert the PDF into a CSV file for further operations.
So I first used an open source library PDFminer but it had problems in recognising GOPENS etc as individual entities.
Then I used online PDF to CSV converter ZAMZAR
Then usual data cleaning using Pandas DataFrame attributes(Explained in code)
After fetching the row indexes for the given Home University query, I searched the corresponding branch query.
Getting the lists of College names and GOPENS/GOPENH corresponding to above data I constructed a DataFrame using the two lists.
Then I sorted the DataFrame using the cutoff rank as the key column to get the desired result.
For the Bonus Task along with GOPENS, I took the other queries as well(GSCS GSTS etc) and made a custom DataFrame and sorted it with multiple columns.