Access and Read Excel using Python

https://automatetheboringstuff.com/chapter12/  ---- this website is really useful, it has theoretical information


http://stackoverflow.com/questions/17977584/how-to-read-data-from-excel-and-write-it-to-text-file-line-by-line ------ This has code written to open and read from excel

Editors for Python

- Pycharm
- Sublime
- Notepad++(command prompt)

How to install Python

http://www.annedawson.net/Python_Installation.htm


 

Automation scenarios

1. Automation Scenario#1:

• Parameterizing hive querying using python or shell scripting
• Read data(multiple rows) from Excel and put it in fields in API request
• Run multiple API requests
• Read data in the fields of API response and put it in excel
• Read entire data from excel and use it in hive query
• Run hive queries
• Read data from hive query output and put it in excel

Connecting Hive from Python??

http://stackoverflow.com/questions/21370431/how-to-access-hive-via-python