Try to simplify your code as
row1 = table.find_all("tr") for r1 in row1[1:]: data = r1.find("a", class_="ab1").text.strip() df.loc[len(df), 'Column_Name'] = data