I need a python scripts to load the multiple excel sheet data into hive table using python. Any one helping on this.
Yes, it is very easy!!
You should have pandas library installed or install it using pip if you don't have by typing this in the command prompt -     py -m pip install pandas
Then, use the following code -
import pandas as pd
df = pd.read_excel('', '')
print(df)
You will see that the table is available in excel.
How to load the excel data into hive using python script?