Import a CSV or Excel file into a Pandas DataFrame by Patrick Harris April 8, 2018 4 On the go? Have Polly read to you. The easiest way to import the data from an excel file into Python is by using the Pandas library. You can install Panda’s with pip by passing in the following sudo pip install pandas By convention, it’s abbreviated as pd when imported: import pandas as pd Once imported, use Panda’s read_excel attribute to load the excel file as a Pandas Dataframe: df = pd.read_excel('path/to/xlxs_file/') df.head() Or df = pd.read_excel('path/to/xlxs_file/') df[:10] Read more on Pandas here. All together now: Pandas has a both read_excel() and read_csv() attributes for the respective file types. You call them both the same way: I have a CSV file called ‘GMAD.csv’ in the same directory that I launched the Jupyter Notebook from.