Download excel file, read and create a json using the file data and store the output.
Steps:
- Download the xlsx from - https://www.iso20022.org/sites/default/files/ISO10383_MIC/ISO10383_MIC.xls
- Store the xlsx
- Read the tab titled "MICs List by CC"
- Create a list of dict containing all rows (except row 1). The values in row 1 would be the keys for in each dict.
- Store the list from step 4 as a .json file in aws s3
Prerequisites:
- Packages
- os
- json
- requests
- sys
- time
- uuid
- boto3
- xlrd
- botocore
- Create the amazone aws credential file in your local system. By default, its location is at ~/.aws/credentials (http://boto3.readthedocs.io/en/latest/guide/quickstart.html)
- Please provide bucketname in the code.