text_html_output_1.png
import pandas as pd

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

a = pd.read_html(url)
a

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