Appending currency based on location

The resulting CSV file from the previous recipe doesn't contain currency information, even though the location can indicate different places with different currencies. In this recipe, we will process a CSV file to add extra information: the currency the prices are in, and a conversion into US dollars.

Getting ready

We will use the resulting CSV file from the previous recipe that receives and transforms logs to the following format:

[<Timestamp>] - SALE - PRODUCT: <product id> - PRICE: <price>

Each line will represent a sale log.

We will use the parse module. We should install the module, adding it to our requirements.txt file as follows:

$ echo "parse==1.14.0" >> requirements.txt
$ pip install -r requirements.txt

In the GitHub repository, there are some log files to process with the following structure:

sale_logs/
  OH
    logs.txt
  ON
    logs.txt

The code can be found...