MacOS High Sierra Version 10.13.6

Python over 3.5

cd to the project installation path

$python3 -m venv eventfilter_env

$source ~/.venv/eventfilter_env/bin/activate

$pip install -r requirements.txt

$python setup.py install

$python -m solution

Two files will be generated under solution folder.

solution/result.csv

solution/summary.csv

As requested, it is very convenient to use the library pandas to merge, filter and sort the data. As the csv and json files can be directly parsed into DataFrame of pandas.

I am using the library Element Tree XML API to parse the xml file and transform it to the DataFrame of pandas as well.

Using pytz to convert the time to the correct timezone.