University Faculty Information Web Scraping (267 Universities)

I have a CSV file containing a list of 267 universities. The file has two columns: Column A: University Name Column B: University Website URL I need someone to scrape each university's website and extract faculty/professor information wherever available. For each faculty member, please collect the following information: Full Name Email Address Department Subjects/Courses Taught (if available) Research Interests / Specialization Designation (Professor, Associate Professor, Assistant Professor, Lecturer, etc.) Office Phone (if available) Office Location (if available) Faculty Profile URL Any other publicly available academic information Output Requirements: Create a separate Excel (.xlsx) file for each university. Name each Excel file exactly the same as the university name from Column A. Include one worksheet containing all faculty members for that university. Use consistent column names across all Excel files. Leave cells blank if a particular piece of information is not available. Ensure duplicate faculty records are removed and the extracted data is as accurate and complete as possible. Also share source code