Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- xls = pd.ExcelFile("C:\Users\Documents\Interview_data.xlsm")
- words = []
- interviewlen = len(xls.sheet_names)
- for i in range(0,interviewlen):
- sheet = xls.parse(i)
- column = sheet.iloc[:,1].to_string(na_rep='',index=False)
- print(xls.sheet_names[i])
- print(column)
- The quick brown fox jumped over the fence and ...
- Each of the business areas must conform is the...
- His heart is in the right place but in order f...
- The quick brown fox jumped over the fence and then she fell
- Each of the business areas must conform is they are going to survive
- His heart is in the right place but in order for the business to thrive we must make change
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement