Parse HTML table to Python list?

by

You should use some HTML parsing library like lxml:

from lxml import etree
s = """<table>
  <tr><th>Event</th><th>Start Date</th><th>End Date</th></tr>
  <tr><td>a</td><td>b</td><td>c</td></tr>
  <tr><td>d</td><td>e</td><td>f</td></tr>
  <tr><td>g</td><td>h</td><td>i</td></tr>
</table>
"""
table = etree.HTML(s).find("body/table")
rows = iter(table)
headers = [col.text for col in next(rows)]
for row in rows:
    values = [col.text for col in row]
    print dict(zip(headers, values))

prints

{'End Date': 'c', 'Start Date': 'b', 'Event': 'a'}
{'End Date': 'f', 'Start Date': 'e', 'Event': 'd'}
{'End Date': 'i', 'Start Date': 'h', 'Event': 'g'}

More Related Contents:

  1. Sending data from HTML form to a Python script in Flask
  2. Decode HTML entities in Python string?
  3. Extract part of a regex match
  4. How do I unescape HTML entities in a string in Python 3.1? [duplicate]
  5. Render HTML to PDF in Django site
  6. Checking if element exists with Python Selenium
  7. How to find children of nodes using BeautifulSoup
  8. How can I use the python HTMLParser library to extract data from a specific div tag?
  9. Python code to remove HTML tags from a string [duplicate]
  10. Download HTML page and its contents
  11. Convert a HTML Table to JSON
  12. How can I get text of an element in Selenium WebDriver, without including child element text?
  13. Change the color of text within a pandas dataframe html table python using styles and css
  14. How to find all comments with Beautiful Soup
  15. How to find tag with particular text with Beautiful Soup?
  16. Creating HTML in python
  17. How find specific data attribute from html tag in BeautifulSoup4?
  18. How to send a FastAPI response without redirecting the user to another page?
  19. How to delete all the entries from google datastore?
  20. How to save “complete webpage” not just basic html using Python
  21. How do I fix wrongly nested / unclosed HTML tags?
  22. How to find the comment tag with BeautifulSoup?
  23. Change a Django form field to a hidden field
  24. Flask css not updating [closed]
  25. HTML to IMAGE using Python
  26. How to store an image in a variable
  27. Python string operation, extract text between html tags
  28. Python CGI – UTF-8 doesn’t work
  29. Converting matplotlib png to base64 for viewing in html template
  30. Filter out HTML tags and resolve entities in python

Leave a Comment