Home assignment 3

Last updated: 2024-05-12 09:35:29

---

Question 1

• Read the 'world_cities.csv' file into a DataFrame object.

• Calculate and print a new table, where each row represents a country, with the following columns:

  • 'country'—Country name

  • 'capital'—The name of the capital city

  • 'biggest_city'—The name of the biggest city, i.e., the city which has the largest population in that country

• Print the subset of countries where the capital is not the same as the biggest city.

• Note that for some countries there is more than one value marked as the capital! The resulting table still needs to have one row per country: capital name ('capital') should be the first if there is more than one.

	country	capital	biggest_city
3	American Samoa	Pago Pago	Tafuna
11	Australia	Canberra	Sydney
20	Belize	Belmopan	Belize
21	Benin	Porto Novo	Cotonou
22	Bermuda	Hamilton	Saint George
...	...	...	...
209	Turks and Caicos	Cockburn Town	Cockburn Harbour
213	USA	Washington	New York
216	United Arab Emirates	Abu Dhabi	Dubai
221	Venezuela	Caracas	Maracaibo
222	Vietnam	Ha Noi	Ho Chi Minh City

46 rows × 3 columns

Question 2

• The text file named 'bgu.wkt' (see Sample data) contains a WKT string representing the geometry of the BGU logo.

• Read the WKT string from the 'bgu.wkt' file, using the open and .readline methods (see Working with files). Convert the string into a shapely geometry

• Note: Do not copy and paste the WKT string into your code! You need to read it from the 'bgu.wkt' file.

• Display the logo graphically.

• Calculate the area of the logo.

0.21286694897980007

• Calculate a circle that is enclosing the logo. To do that, first calculate the average of x-axis bounds and the average of the y-axis bounds, then construct a point according to those x and y values, and finally buffer the point to a distance of your choice so that the logo is completely within the buffer.

• Calculate the geometry of the difference between the logo and the bouding circle you calculated, then plot it.