Pretty straight forward with the read_html method.
import pandas as pd
sandp = pd.read_html("https://en.wikipedia.org/wiki/List_of_S%26P_500_companies")
print(sandp) # will print out how many tables on the site
print(sandp[0]) # will print first table