text_html_output_1.png
import pandas as pd

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

a = pd.read_html(url)
a

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