I need help extracting specific data from an HTML table. I want to extract the information from the columns with the text "Total" and the value "93" only, rather than extracting all column data as my current code does.
For example, the current output is:
Total
93
93
0
0
But I would like the output to be:
Total 93
Here is a snippet of my code:
def extract_total_from_report_htmltestrunner():
filename = (
r"C:\test_runners 2 edit project\selenium_regression_test\TestReport\ClearCore_Automated_GUI_Regression_TestReport.html")
html_report_part = open(filename, 'r')
soup = BeautifulSoup(html_report_part, "html.parser")
tr_total_row = soup.find('tr', {'id': 'total_row'})
tr_total_row.find(text=True, recursive=False)
print tr_total_row.text
return tr_total_row.text
And here is the relevant HTML snippet:
<table id='result_table'>
<tr id='total_row'>
<td>Total</td>
<td>93</td>
<td>93</td>
<td>0</td>
<td>0</td>
<td> </td>
</tr>
</table>
Can anyone suggest how I can specifically extract and print out "Total" and "93" in the same line?
Thank you, Riaz