carlos-i-martinez / ds_xml_exercise

DS_XML_Exercise

XML Based Data Exercise

This exercise focuses on working with data in files. And this exercise focuses on XML data files.

Objective:

1. Get familiar with python packages and dealing with XML
2. Practice accessing nodes in XML Tree Structure
3. Complete the exercise

reference: https://docs.python.org/2.7/library/xml.etree.elementtree.html

data source: http://www.dbis.informatik.uni-goettingen.de/Mondial

Using data in 'mondial_database.xml', the examples above, and refering to https://docs.python.org/2.7/library/xml.etree.elementtree.html, find

1. 10 countries with the lowest infant mortality rates
2. 10 cities with the largest population
3. 10 ethnic groups with the largest overall populations (sum of best/latest estimates over all countries)
4. name and country of a) longest river, b) largest lake and c) airport at highest elevation

Process:

Please refer to the solution python document(xml_exercise_solution.ipynb) for python code and detailed comments explaining how the exercise was solved.