Question: You are given two files, 'Top 2 0 0 Universities.html ' and 'StateAbbreviations.html ' . You need to read relevant data from those files so

You are given two files, 'Top200Universities.html' and 'StateAbbreviations.html'. You need to read relevant data from those files so that:
* for each US university, you need to find the abbreviation for the state the university is located in.
* if the state cannot be determined, use 'UNKNOWN' as the abbreviation.
* universities in Canada can be neglected.
For example, for 'Arizona State University', you should determine that the state is 'Arizona' and the abbreviation is 'AZ'. For 'Purdue University', you can determine that the state is unknown and the abbreviation is thus 'UNKNOWN'.
All abbreviations should be placed in a new column called "ABBR" along with other information in a pd dataframe.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!