text_html_output_1.png
import pandas as pd

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

a = pd.read_html(url)
a

test = a[11]

test.rename(columns={'Base Price IN ₹ (CR.)': 'Base Price'}, inplace=True)
test.rename(columns={'Player': 'Players'}, inplace=True)
test.drop('Base Price IN $ (000)', axis=1, inplace=True)

test