import pandas as pd
xls_file = pd.ExcelFile('/Users/chrisralbon/Dropbox (Personal)/Public/example.xls')
xls_file
<pandas.io.excel.ExcelFile at 0x10742f210>
xls_file.sheet_names
['Sheet1', 'Sheet2']
df = xls_file.parse('Sheet1')
df
FirstName | LastName | Location | Age | |
---|---|---|---|---|
0 | Jason | Miller | USA | 43 |
1 | Bill | Macoi | USA | 25 |
2 | Jane | Modi | UK | 25 |
3 | Sara | Mosi | UK | 62 |
4 rows × 4 columns