{"id":2420,"date":"2019-07-22T15:37:53","date_gmt":"2019-07-22T13:37:53","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=2420"},"modified":"2019-07-22T19:34:44","modified_gmt":"2019-07-22T17:34:44","slug":"python-to-make-html-tables-code","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/python-to-make-html-tables-code\/","title":{"rendered":"Python to make html tables code"},"content":{"rendered":"

I think that to make a table in html is really boring. So I thought it could be nice to use Python to avoid having to write all those html tags.<\/p>\n

The simpliest table in the world would be like this:<\/p>\n

<table border=1>\r\n<tr><td>Name<\/td><td>Surname<\/td><td>Age<\/td><\/tr>\r\n<tr><td>John<\/td><td>Marr<\/td><td>18<\/td><\/tr>\r\n<tr><td>Marion<\/td><td>Sally<\/td><td>28<\/td><\/tr>\r\n<\/table><\/pre>\n
This is it:<\/p>\n\n\n\n\n\n
Name<\/td>\nSurname<\/td>\nAge<\/td>\n<\/tr>\n
John<\/td>\nMarr<\/td>\n18<\/td>\n<\/tr>\n
Marion<\/td>\nSally<\/td>\n28<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Using Python to do the boring stuffs<\/h2>\n
\"\"<\/a><\/p>\n
Imagine having to do more complex tables. So, here is the code to avoid all this.<\/p>\n
First, we write the data in this simple way<\/p>\n
data = \"\"\"\r\n\r\n        Name,    Surname,    Age\r\n        John,    Smith,      18\r\n        Mary,    Luise,      24\r\n             \r\n\"\"\"<\/pre>\n
Then we split the lines and delete the empty ones, adding also the tr and some td tags.<\/p>\n
data = data.splitlines()\r\ndata = [d.strip() for d in data]\r\ndata = [f\"<tr><td>{d}<\/tr>\" for d in data if d.strip() != \"\"]<\/pre>\n
Then we let python add the table tag at the end and the beginnig<\/p>\n
data = \"<table border=1>\" + \"\".join(data) + \"<\/table>\"<\/pre>\n
We replace the commas with something useful (the rest of the tags we need)<\/p>\n
data = data.replace(\",\",\"<\/td><td>\")<\/pre>\n
And we save our code in an html file, we’re done<\/p>\n
with open(\"table.html\", \"w\", encoding=\"utf-8\") as file:\r\n    file.write(data)<\/pre>\n
The final output<\/h3>\n
\"\"<\/a><\/p>\n
The entire code<\/h2>\n
This is the whole code (made in jupyter lab, so you’ll find something more, watch the video to understand why there are those other lines of code).<\/p>\n
from IPython.core.interactiveshell import InteractiveShell\r\nInteractiveShell.ast_node_interactivity = \"all\"\r\nfrom IPython.display import display, HTML\r\n\r\nimport os\r\n\r\ndata = \"\"\"\r\n\r\n        Name,    Surname,    Age\r\n        John,    Smith,      18\r\n        Mary,    Luise,      24\r\n             \r\n\"\"\"\r\ndata = data.splitlines()\r\ndata = [d.strip() for d in data]\r\ndata = [f\"<tr><td>{d}<\/tr>\" for d in data if d.strip() != \"\"]\r\ndata = \"<table border=1>\" + \"\".join(data) + \"<\/table>\"\r\n#display(HTML(data))\r\ndata = data.replace(\"    \",\"\")\r\ndata = data.replace(\",\",\"<\/td><td>\")\r\ndata\r\n# Comment this if you don't use jupyter\r\ndisplay(HTML(data))\r\nwith open(\"table.html\", \"w\", encoding=\"utf-8\") as file:\r\n    file.write(data)\r\nos.startfile(\"table.html\")<\/pre>\n
The video about making an html table with Python<\/p>\n