it displays the following error this is the error well i have already tried with diffrent file but it doesnt work
data1=pd.read_excel('second.xlsx',sheet_name="Sheet1")
it displays the following error this is the error well i have already tried with diffrent file but it doesnt work
data1=pd.read_excel('second.xlsx',sheet_name="Sheet1")
have you tried passing engine="openpyxl"
argument?
P.S this is where I found the answer https://stackoverflow.com/a/50815107