Python script to export excel file data to amazon dynamoDB table
Python Script which read an excel file and upload its data to DynamoDB . This script will take input of file-name as a command line argument. It’ll prepare list of data which needs to be stored, and finally these data will be uploaded to dynamoDB. Required python library: xlrd , boto3 , os, sys. i am assuming reader is not a experienced or pro developer, so i’ll go step by step. Please read till end for complete understanding. Before going to implementation part, lets take a look at excel file. This file contains a catalog of products, categorized in different Product category. But we don’t need to bother about category of product. our final goal is to fetch required data from this file and add these data to our dynamoDB table. fig 1: Excel file Finally, This is how our dynamoDB table will look like after running this script: fig 2: dynamoDB table Now lets get started, Step 1: Login to aws console. Create a dynamoDB table, name- “Product-table”...