Home > Software design >  Getting empty list when scraping web page content using xpath in Python
Getting empty list when scraping web page content using xpath in Python

Time:10-20

When i try to import some data using xpath from the url in the following code i get an empty list:


    import requests
    from lxml import html
    
    url = 'https://www.sofascore.com/team/football/palmeiras/1963'
    browsers = {'User-Agent': "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 \(KHTML, like Gecko) Chrome / 86.0.4240.198Safari / 537.36"}
    page = requests.get(url, headers=browsers)
        
    tree = html.fromstring(page.content)
    elements = tree.xpath('//*[@id="__next"]/div/main/div/div[2]/div[2]/div/div[2]/div[3]/div[2]/div[2]/div[1]/span[1]')

    print(elements[0].text)

Output:

[]

What i expect:

'Matches'

It's for a project that analyzes the behavior of brazilian teams of football, so i want to import all the statistics of each team and create a data frame with those data, but i need to pull all the data from the site first.

CodePudding user response:

You are getting an empty list because //*[@id="__next"]/div/main/div/div[2]/div[2]/div/div[2]/div[3]/div[2]/div[2]/div[1]/span[1] XPath locator matches nothing on that page.
Long absolute XPath locators are extremely unreliable and fragile.

CodePudding user response:

Information in that page is being pulled by javascript (after initial html is loaded, so requests cannot see subsequent info) by accessing various API endpoints. You can see those APIs under Network Tab in Dev tools. Here is an example of scraping one such API endpoint (not sure if it's the one serving the info you're after, you can try the others as well):

import requests
import pandas as pd

pd.set_option('display.max_columns', None)
pd.set_option('display.max_colwidth', None)

headers = {
'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.79 Safari/537.36'
}

url = 'https://api.sofascore.com/api/v1/team/1963/events/last/0'

r = requests.get(url, headers=headers)
df = pd.json_normalize(r.json()['events'])
print(df)

Result in terminal:

customId    winnerCode  hasGlobalHighlights hasEventPlayerStatistics    hasEventPlayerHeatMap   id  homeRedCards    startTimestamp  slug    finalResultOnly tournament.name tournament.slug tournament.category.name    tournament.category.slug    tournament.category.sport.name  tournament.category.sport.slug  tournament.category.sport.id    tournament.category.id  tournament.category.flag    tournament.category.alpha2  tournament.uniqueTournament.name    tournament.uniqueTournament.slug    tournament.uniqueTournament.category.name   tournament.uniqueTournament.category.slug   tournament.uniqueTournament.category.sport.name tournament.uniqueTournament.category.sport.slug tournament.uniqueTournament.category.sport.id   tournament.uniqueTournament.category.id tournament.uniqueTournament.category.flag   tournament.uniqueTournament.category.alpha2 tournament.uniqueTournament.userCount   tournament.uniqueTournament.hasPositionGraph    tournament.uniqueTournament.id  tournament.uniqueTournament.hasEventPlayerStatistics    tournament.uniqueTournament.displayInverseHomeAwayTeams tournament.priority tournament.id   roundInfo.round status.code status.description  status.type homeTeam.name   homeTeam.slug   homeTeam.shortName  homeTeam.gender homeTeam.sport.name homeTeam.sport.slug homeTeam.sport.id   homeTeam.userCount  homeTeam.nameCode   homeTeam.disabled   homeTeam.national   homeTeam.type   homeTeam.id homeTeam.subTeams   homeTeam.teamColors.primary homeTeam.teamColors.secondary   homeTeam.teamColors.text    awayTeam.name   awayTeam.slug   awayTeam.shortName  awayTeam.gender awayTeam.sport.name awayTeam.sport.slug awayTeam.sport.id   awayTeam.userCount  awayTeam.nameCode   awayTeam.disabled   awayTeam.national   awayTeam.type   awayTeam.id awayTeam.subTeams   awayTeam.teamColors.primary awayTeam.teamColors.secondary   awayTeam.teamColors.text    homeScore.current   homeScore.display   homeScore.period1   homeScore.period2   homeScore.normaltime    awayScore.current   awayScore.display   awayScore.period1   awayScore.period2   awayScore.normaltime    time.injuryTime1    time.injuryTime2    time.currentPeriodStartTimestamp    changes.changes changes.changeTimestamp coverage    awayRedCards    roundInfo.name  roundInfo.slug  roundInfo.cupRoundType  aggregatedWinnerCode    previousLegEventId  homeScore.aggregated    awayScore.aggregated    homeScore.penalties awayScore.penalties
0   nOsHO   2   True    True    True    10114138    1.0 1655067600  coritiba-palmeiras  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  11  100 Ended   finished    Coritiba    coritiba    Coritiba    M   Football    football    1   29502   COR False   False   0   1982    []  #ffffff #009966 #009966 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   2   2   1.0 1.0 2   2   10.0    1655074949  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1655074952  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1   nOsoWc  1   True    True    True    10113875    NaN 1655413200  atletico-goianiense-palmeiras   False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  12  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Atlético Goianiense atletico-goianiense Atlético-GO M   Football    football    1   32941   GOI False   False   0   7314    []  #ff0000 #000000 #000000 4   4   4.0 0.0 4   2   2   1.0 1.0 2   4   4.0 1655419980  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1655419982  1.0 1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN
2   nOsGO   2   True    True    True    10113937    NaN 1655766000  sao-paulo-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  13  100 Ended   finished    São Paulo   sao-paulo   São Paulo   M   Football    football    1   137748  SPA False   False   0   1981    []  #ffffff #000000 #000000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   1.0 0.0 1   2   2   0.0 2.0 2   3   7.0 1655773291  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1655773295  1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
3   nOsGO   1   True    True    True    10366721    NaN 1656025200  sao-paulo-palmeiras False   Copa do Brasil  copa-do-brasil  Brazil  brazil  Football    football    1   13  brazil  BR  Copa do Brasil  copa-do-brasil  Brazil  brazil  Football    football    1   13  brazil  BR  119429  False   373 False   False   0   283 8   100 Ended   finished    São Paulo   sao-paulo   São Paulo   M   Football    football    1   137748  SPA False   False   0   1981    []  #ffffff #000000 #000000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   1.0 0.0 1   0   0   0.0 0.0 0   2   5.0 1656032409  [homeScore.period2, awayScore.period2]  1657698656  -1.0    NaN Round of 16 round-of-16 8.0 NaN NaN NaN NaN NaN NaN
4   nOspWc  3   True    True    True    10113904    NaN 1656270000  avai-palmeiras  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  14  100 Ended   finished    Avaí    avai    Avaí    M   Football    football    1   20083   AVA False   False   0   7315    []  #0066ff #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 2   2   1.0 1.0 2   2   2   0.0 2.0 2   5   5.0 1656277177  [homeScore.period2, awayScore.period2]  1665242507  1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
5   nOsQuc  2   True    True    True    10341622    NaN 1656540900  cerro-porteno-palmeiras False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 8   100 Ended   finished    Cerro Porteño   cerro-porteno   Cerro Porteño   M   Football    football    1   19852   CPO NaN False   0   5991    []  #cc0000 #003366 #003366 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   3   3   0.0 3.0 3   2   4.0 1656547691  [homeScore.period2, awayScore.period2]  1662625197  1.0 NaN Round of 16 round-of-16 8.0 NaN NaN NaN NaN NaN NaN
6   nOsrO   2   True    True    True    10114178    1.0 1656806400  athletico-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  15  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Athletico   athletico   Athletico   M   Football    football    1   57052   CAP False   False   0   1967    []  #000000 #cc0000 #cc0000 0   0   0.0 0.0 0   2   2   1.0 1.0 2   3   7.0 1656813370  [homeScore.period2, awayScore.period2]  1665242508  1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
7   nOsQuc  1   True    True    True    10341627    NaN 1657145700  cerro-porteno-palmeiras False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 8   100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Cerro Porteño   cerro-porteno   Cerro Porteño   M   Football    football    1   19852   CPO NaN False   0   5991    []  #cc0000 #003366 #003366 5   5   1.0 4.0 5   0   0   0.0 0.0 0   2   2.0 1657152360  [homeScore.period2, awayScore.period2]  1662625197  1.0 NaN Round of 16 round-of-16 8.0 1.0 10341622.0  8.0 0.0 NaN NaN
8   nOsvP   3   True    True    True    10114100    NaN 1657486800  fortaleza-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  16  100 Ended   finished    Fortaleza   fortaleza   Fortaleza   M   Football    football    1   57572   FOR False   False   0   2020    []  #0000ff #ff0000 #ff0000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   0   0   0.0 0.0 0   5   NaN 1657495856  [homeScore.period2, awayScore.period2]  1665242510  1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
9   nOsGO   0   True    True    True    10366728    NaN 1657839600  sao-paulo-palmeiras False   Copa do Brasil  copa-do-brasil  Brazil  brazil  Football    football    1   13  brazil  BR  Copa do Brasil  copa-do-brasil  Brazil  brazil  Football    football    1   13  brazil  BR  119429  False   373 False   False   0   283 8   120 AP  finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 São Paulo   sao-paulo   São Paulo   M   Football    football    1   137748  SPA False   False   0   1981    []  #ffffff #000000 #000000 2   2   NaN NaN 2   1   1   NaN NaN 1   3   5.0 1657847241  [homeScore.current, awayScore.current]  1660983567  -1.0    NaN Round of 16 round-of-16 8.0 2.0 10366721.0  2.0 2.0 3.0 4.0
10  nOscJu  1   True    True    True    10114052    NaN 1658185200  cuiaba-palmeiras    False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  17  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Cuiabá  cuiaba  Cuiabá  M   Football    football    1   24818   CUI False   False   0   49202   []  #ffffff #006600 #006600 1   1   0.0 1.0 1   0   0   0.0 0.0 0   3   5.0 1658192125  [time.currentPeriodStart, status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime]   1658192131  1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
11  nOsyO   2   True    True    True    10113922    NaN 1658444400  america-mineiro-palmeiras   False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  18  100 Ended   finished    América Mineiro america-mineiro América-MG  M   Football    football    1   33986   AMG False   False   0   1973    []  #056635 #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   1   1   0.0 1.0 1   2   4.0 1658451192  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1658451194  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
12  nOsqO   1   True    True    True    10114118    NaN 1658689200  internacional-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  19  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Internacional   internacional   Internacional   M   Football    football    1   75718   INT False   False   0   1966    []  #cc0000 #cc0000 #cc0000 2   2   1.0 1.0 2   1   1   0.0 1.0 1   3   4.0 1658696058  [time.currentPeriodStart, status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime]   1658696066  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
13  nOsbP   2   True    True    True    10113779    1.0 1659209400  ceara-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  20  100 Ended   finished    Ceará   ceara   Ceará   M   Football    football    1   49805   CEA False   False   0   2001    []  #000000 #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   0.0 1.0 1   2   2   2.0 0.0 2   7   8.0 1659216904  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1659216908  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
14  nOsCO   3   True    True    True    10445784    NaN 1659573000  atletico-mineiro-palmeiras  False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 4   100 Ended   finished    Atlético Mineiro    atletico-mineiro    Atlético-MG M   Football    football    1   110163  ATL False   False   0   1977    []  #000000 #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 2   2   1.0 1.0 2   2   2   0.0 2.0 2   2   5.0 1659579833  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1659579836  NaN NaN Quarterfinal    quarterfinal    4.0 NaN NaN NaN NaN NaN NaN
15  kOsnO   1   True    True    True    10113929    NaN 1659898800  palmeiras-goias False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  21  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Goiás   goias   Goiás   M   Football    football    1   27727   GGO False   False   0   1960    []  #006633 #ffffff #ffffff 3   3   2.0 1.0 3   0   0   0.0 0.0 0   7   4.0 1659905886  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1659905888  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
16  nOsCO   1   True    True    True    10445780    2.0 1660177800  atletico-mineiro-palmeiras  False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 4   120 AP  finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Atlético Mineiro    atletico-mineiro    Atlético-MG M   Football    football    1   110163  ATL False   False   0   1977    []  #000000 #ffffff #ffffff 0   0   NaN NaN 0   0   0   NaN NaN 0   2   5.0 1660185718  [homeScore.normaltime, awayScore.normaltime]    1660185810  NaN 1.0 Quarterfinal    quarterfinal    4.0 1.0 10445784.0  2.0 2.0 NaN NaN
17  hOsnO   2   True    True    True    10113914    NaN 1660428000  palmeiras-corinthians   False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  22  100 Ended   finished    Corinthians corinthians Corinthians M   Football    football    1   147056  COR False   False   0   1957    []  #ffffff #000000 #000000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   1   1   0.0 1.0 1   2   4.0 1660434828  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1660434830  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
18  nOsGuc  3   True    True    True    10114106    NaN 1661108400  flamengo-palmeiras  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  23  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Flamengo    flamengo    Flamengo    M   Football    football    1   267868  FLA False   False   0   5981    []  #ff0000 #000000 #000000 1   1   0.0 1.0 1   1   1   1.0 0.0 1   4   5.0 1661115271  [time.currentPeriodStart, status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime]   1661115278  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
19  lOsnO   3   True    True    True    10113999    NaN 1661637600  palmeiras-fluminense    False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  24  100 Ended   finished    Fluminense  fluminense  Fluminense  M   Football    football    1   74968   FLU False   False   0   1961    []  #660000 #006633 #006633 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   1.0 0.0 1   1   1   1.0 0.0 1   3   5.0 1661644648  [time.currentPeriodStart, status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime]   1661644654  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
20  nOsrO   1   True    True    True    10583051    1.0 1661905800  athletico-palmeiras False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 2   100 Ended   finished    Athletico   athletico   Athletico   M   Football    football    1   57052   CAP False   False   0   1967    []  #000000 #cc0000 #cc0000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   1.0 0.0 1   0   0   0.0 0.0 0   1   8.0 1661912725  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1661912728  NaN NaN Semifinal   semifinal   2.0 NaN NaN NaN NaN NaN NaN
21  nOsZO   3   True    True    True    10113917    NaN 1662242400  red-bull-bragantino-palmeiras   False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  25  100 Ended   finished    Red Bull Bragantino red-bull-bragantino RB Bragantino   M   Football    football    1   50450   BRA False   False   0   1999    []  #363636 #d8d8d6 #d8d8d6 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 2   2   2.0 0.0 2   2   2   1.0 1.0 2   3   5.0 1662249371  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1662249374  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
22  nOsrO   0   True    True    True    10583052    1.0 1662510600  athletico-palmeiras False   CONMEBOL Libertadores, Knockout stage   conmebol-libertadores-knockout-stage    South America   south-america   Football    football    1   1470    south-america   NaN CONMEBOL Libertadores   conmebol-libertadores   South America   south-america   Football    football    1   1470    south-america   NaN 185738  False   384 True    False   465 309 2   100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Athletico   athletico   Athletico   M   Football    football    1   57052   CAP False   False   0   1967    []  #000000 #cc0000 #cc0000 2   2   1.0 1.0 2   2   2   0.0 2.0 2   1   5.0 1662517463  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1662517466  NaN NaN Semifinal   semifinal   2.0 2.0 10583051.0  2.0 3.0 NaN NaN
23  nOsFO   1   True    True    True    10114160    NaN 1662854400  juventude-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  26  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Juventude   juventude   Juventude   M   Football    football    1   23571   JUV False   False   0   1980    []  #006600 #ffffff #ffffff 2   2   0.0 2.0 2   1   1   0.0 1.0 1   3   4.0 1662861282  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1662861286  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
24  nOstO   1   True    True    True    10114023    1.0 1663536600  santos-palmeiras    False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  27  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Santos  santos  Santos  M   Football    football    1   78113   SAN False   False   0   1968    []  #ffffff #ffffff #ffffff 1   1   0.0 1.0 1   0   0   0.0 0.0 0   2   6.0 1663543460  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1663543463  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
25  nOsCO   2   True    True    True    10114171    NaN 1664412300  atletico-mineiro-palmeiras  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  28  100 Ended   finished    Atlético Mineiro    atletico-mineiro    Atlético-MG M   Football    football    1   110163  ATL False   False   0   1977    []  #000000 #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 0   0   0.0 0.0 0   1   1   0.0 1.0 1   1   9.0 1664419409  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1664419411  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
26  iOsnO   2   True    True    True    10114062    NaN 1664838000  palmeiras-botafogo  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  29  100 Ended   finished    Botafogo    botafogo    Botafogo    M   Football    football    1   50996   BOT False   False   0   1958    []  #000000 #ffffff #ffffff Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   1.0 0.0 1   3   3   2.0 1.0 3   4   5.0 1664844924  [time.currentPeriodStart, status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime]   1664844933  NaN 1.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN
27  nOsHO   1   True    True    True    10114159    NaN 1665093600  coritiba-palmeiras  False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  30  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 Coritiba    coritiba    Coritiba    M   Football    football    1   29502   COR False   False   0   1982    []  #ffffff #009966 #009966 4   4   2.0 2.0 4   0   0   0.0 0.0 0   3   4.0 1665100390  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1665100395  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
28  nOsoWc  3   True    True    True    10113668    NaN 1665437400  atletico-goianiense-palmeiras   False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  31  100 Ended   finished    Atlético Goianiense atletico-goianiense Atlético-GO M   Football    football    1   32941   GOI False   False   0   7314    []  #ff0000 #000000 #000000 Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 1   1   0.0 1.0 1   1   1   0.0 1.0 1   1   4.0 1665444055  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1665444058  NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
29  nOsGO   3   True    True    True    10113670    NaN 1665946800  sao-paulo-palmeiras False   Brasileiro Serie A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  Brasileiro Série A  brasileiro-serie-a  Brazil  brazil  Football    football    1   13  brazil  BR  241156  True    325 True    False   266 83  32  100 Ended   finished    Palmeiras   palmeiras   Palmeiras   M   Football    football    1   184430  PAL False   False   0   1963    []  #339966 #336633 #336633 São Paulo   sao-paulo   São Paulo   M   Football    football    1   137748  SPA False   False   0   1981    []  #ffffff #000000 #000000 0   0   0.0 0.0 0   0   0   0.0 0.0 0   4   10.0    1665954058  [status.code, status.description, status.type, homeScore.period2, homeScore.normaltime, awayScore.period2, awayScore.normaltime, time.currentPeriodStart]   1665954061  NaN 2.0 NaN NaN NaN NaN NaN NaN NaN NaN NaN

  • Related