Avatar of Hiro 714
Hiro 714

asked on 

Python Selenium and Pandas question

When I append, only original df_data appears and unable to append df_data1.
Please advise.

Ticket_List = []
Ticket_Titles = driver.find_elements_by_xpath('//tbody/tr/td[2]/a')
Ticket_Discriptions = driver.find_elements_by_xpath('//tbody/tr/td[3]/a')
Ticket_Status = driver.find_elements_by_xpath('//tbody/tr/td[4]/a')
Ticket_Titles = Ticket_Titles[4:]
Ticket_List = []
for i in range(len(Ticket_Titles)):
    temporary_data={'Number': Ticket_Titles[i].text,
                   'Titles': Ticket_Discriptions[i].text,
                   'Status': Ticket_Status[i].text
                   }
    Ticket_List.append(temporary_data)
   
df_data = pd.DataFrame.from_dict(Ticket_List)
df_data.dtypes
print(df_data)

Open in new window

Ticket_Titles1 = driver.find_elements_by_xpath('//tbody/tr/td[2]/a')
Ticket_Discriptions1 = driver.find_elements_by_xpath('//tbody/tr/td[3]/a')
Ticket_Status1 = driver.find_elements_by_xpath('//tbody/tr/td[4]/a')

Ticket_Titles1 = Ticket_Titles1[4:]

Ticket_Titles.extend(Ticket_Titles1)
Ticket_Discriptions.extend(Ticket_Discriptions1)
Ticket_Status.extend(Ticket_Status1)

Open in new window

Ticket_List1 = []
for i in range(len(Ticket_Titles1)):
    temporary_data1={'Number': Ticket_Titles1[i].text,
                   'Titles': Ticket_Discriptions1[i].text,
                   'Status': Ticket_Status1[i].text
                   }
    Ticket_List1.append(temporary_data1)
   
df_data1 = pd.DataFrame.from_dict(Ticket_List1)

Open in new window

df_data.append(df_data1)

Open in new window


SeleniumPython

Avatar of undefined
Last Comment
Hiro 714

8/22/2022 - Mon