Dear Nils,

Import pandas package and for excel file create data frame as

df = pd.read_excel('Filename.xlsx', sheetname='Sheet1')

or for CSV file you can use

df = pd.read_csv('Filename.CSV', sep=',')

More example links:

https://pythonspot.com/read-excel-with-pandas/

Hope this will help you.

https://www.udemy.com/data-analysis-in-python-with-pandas/?siteID=ENhIHOsZQ7Y-I8jaq3QQ6ixi9P8Oeonh2A&LSNPUBID=ENhIHOsZQ7Y

Hi Nils,

You cab use csv or openpyxl libraries.

One of them should do the job

data = pd.read_csv('yourFileName.csv', error_bad_lines=False);