text_plain_output_1.png
import pandas as pd

url = 'https://www.news18.com/cricketnext/ipl-auction-2022/'

a = pd.read_html(url)
a

GT = a[1]
GT['Team'] = 'GT'
GT.rename(columns={'2022 Squad GT': 'Players'}, inplace=True)
GT

CSK = a[2]
CSK['Team'] = 'CSK'
CSK.rename(columns={'2022 Squad CSK': 'Players'}, inplace=True)
CSK

final = GT.append(CSK, ignore_index=True)
final