Парсер сайта Selenium данные с двух столбцов

from selenium import webdriver
from selenium.webdriver.chrome.service import Service
from webdriver_manager.chrome import ChromeDriverManager
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
import pandas as pd
 
url = 'https://www.whoscored.com/Teams/30/Show/England-Tottenham'
 
s = Service(ChromeDriverManager().install())
driver = webdriver.Chrome(service=s)
 
# web driver goes to page
driver.get(url)
 
WebDriverWait(driver, 15).until(
        EC.presence_of_element_located((By.ID, 'team-squad-stats'))
    )
 
Players_list = []
Player_rating = []
 
for nme in driver.find_elements(By.CSS_SELECTOR, 'a.player-link span.iconize.iconize-icon-left'):
    Players_list.append(nme.text)
for rat in driver.find_elements(By.CSS_SELECTOR, 'td.rating_sorted'):
    Player_rating.append(rat.text)
data = {'name': Players_list, 'rating_sorted': Player_rating}
df = pd.DataFrame(data)
print(df)
df.to_csv('England-Tottenham.csv')
 
 

...
from collections import defaultdict
import pandas as pd
 
driver = webdriver.Chrome()
 
driver.get('https://www.whoscored.com/Teams/30/Show/England-Tottenham')  
players_lines = driver.find_elements(By.XPATH,"//tbody[@id='player-table-statistics-body']/tr")
results = defaultdict(list)
for player in players_lines:
    name = player.find_element(By.XPATH, './/span').text
    rating = player.find_element(By.XPATH, ".//td[contains(@class,'rating')]").text
    results['name'].append(name)
    #results['rating'].append(rating)
    results['rating'].append(rating.replace('.', ',')) #если нужны числовые данные в excel
driver.close()
df = pd.DataFrame (results)
print(df)
#df.to_csv('England-Tottenham.csv', index=False) # если нужен формат csv-файла
df.to_excel('England-Tottenham.xlsx', index=False)
...

from selenium import webdriver
driver = webdriver.Chrome()
import csv
import pandas as pd
 
driver.get('https://www.whoscored.com/Teams/30/Show/England-Tottenham')  
from selenium.webdriver.common.by import By
players_lines = driver.find_elements(By.XPATH,"//tbody[@id='player-table-statistics-body']/tr")
results = {}
for player in players_lines:
    name = player.find_element(By.XPATH, './/span').text
    rating = player.find_element(By.XPATH, ".//td[contains(@class,'rating')]").text
    results[rating] = [name]
 
 
df = pd.DataFrame.from_dict (results, orient='index'). reset_index()
print(df)
df.to_csv('England-TottenhamCSV.csv')