Python hosting: Host, run, and code Python in the cloud!
Pandas, a data analysis library, has native support for loading excel data (xls and xlsx).
The method read_excel loads xls data into a Pandas dataframe:
If you have a large excel file you may want to specify the sheet:
Data Analysis with Python Pandas
Read excel with Pandas
The code below reads excel data into a Python dataset (the dataset can be saved below).
The dataframe can be used, as shown in the example below:
For purpose of demonstration, you can use the dataset from: depaul.edu.