build a windows application - python or similar

Job ID: 31188575

Budget: $30 – $250 AUD

I require a standalone windows application (exe file) that allows a user to specify a csv file.

Once the user specifies the csv file, the application should open it, parse its contents and run a number of reports.

The CSV file is a list of resevation data. It can be up to 500,000 records long. I can provide a small sample on request.

There are various reports I would like to create from this data. For the moment, just focus on one report below.

1. Cancellation Rate by Country.

Should be a table showing each country, total value of reservations, total value of status 'OK', average lead time, and percentage of total value.

User should have option to show table in chart or scatter plot format (lead time x axis, cancel rate y axis). (if using python, matplotlib etc).

Data should be filtered to min 50 reservations countries or minim total value.

2. Cancellation rate by day (second project)