{"id":7744,"date":"2020-11-29T08:45:41","date_gmt":"2020-11-29T07:45:41","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=7744"},"modified":"2021-09-23T21:55:53","modified_gmt":"2021-09-23T19:55:53","slug":"pandas-html-table-from-excel","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/pandas-html-table-from-excel\/","title":{"rendered":"Pandas html table from excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A little <strong>script<\/strong> to make an html table out of <strong>pandas<\/strong>. I made this type of stuff before, but I tried a different approach that maybe could bring to something more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/formazione\/utilities\">Github repository<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to change the style of the table, there&#8217;s a lot of stuff on the net. You can use this tool too <a href=\"https:\/\/divtable.com\/table-styler\/\">https:\/\/divtable.com\/table-styler\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Update: <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I changed the line in which I read excel this argument: engine=&#8217;openpyxl&#8217; because with this engine there are no problem (like with xlrd).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport os\n\n\ntable_class = \"rwd-table\"\n\nhtml = \"\"\"&lt;style>\n@import \"https:\/\/fonts.googleapis.com\/css?family=Montserrat:300,400,700\";\n.rwd-table {\n  margin: 1em 0;\n\tborder: 1px;\n  min-width: 300px;\n}\n.rwd-table tr {border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; } \n.rwd-table th {display: none; } \n.rwd-table td {border:1; display: block; } \n.rwd-table td:first-child {padding-top: .5em; } \n.rwd-table td:last-child {padding-bottom: .5em; } \n.rwd-table td:before {content: attr(data-th) \": \"; font-weight: bold; width: 6.5em; display: inline-block; } \n@media (min-width: 480px) {\n\t.rwd-table td:before {display: none; } \n\t} .rwd-table th, .rwd-table td {text-align: left; \n\t} \n@media (min-width: 480px) {\n\t.rwd-table th, .rwd-table td {\n\tdisplay: table-cell; padding: .25em .5em; }\n\t.rwd-table th:first-child, \n\t.rwd-table td:first-child {padding-left: 0; } \n\t.rwd-table th:last-child, .rwd-table td:last-child {padding-right: 0; } } \n\th1 {font-weight: normal; letter-spacing: -1px; color: #34495E; } \n\t.rwd-table {background: #34495E; color: #fff; border-radius: .4em; overflow: hidden; } \n\t.rwd-table tr {border-color: #46637f; } \n\t.rwd-table th, \n\t.rwd-table td {margin: .5em 1em; } @media (min-width: 480px) {\n\t.rwd-table th, .rwd-table td {padding: 1em !important; } } \n\t.rwd-table th, .rwd-table td:before {color: #dd5; } &lt;\/style>\n\n&lt;script>\n  window.console = window.console || function(t) {};\n&lt;\/script>\n&lt;script>\n  if (document.location.search.match(\/type=embed\/gi)) {\n    window.parent.postMessage(\"resize\", \"*\");\n  }\n&lt;\/script>\"\"\"\n\n\n\n# df = pd.read_excel(filename, index=1)\ndf = pd.read_excel(\"001.xlsx\", engine='openpyxl')\nprint(type(df))\nprint()\n# df.to_html(\"data.html\")\nhtml += \"&lt;table class='rwd-table'>\"\nhtml2 = \"\"\nadd = \"\"\n\ndef header():\n\t\"Create the header of the column\"\n\tadd = \"\"\n\tfor d in df:\n\t\tadd += f\"&lt;th>{d}&lt;\/th>\"\n\tadd += \"&lt;tr>\"\n\treturn add\n\ndef content_of_table():\n\t\"This are the tds\"\n\tcount = len(df)\n\tadd = \"\"\n\tcount = 0\n\tfor i in range(0, len(df)):\n\t\tfor d in df:\n\t\t\tadd += f\"&lt;td>{df&#091;d]&#091;i]}&lt;\/td>\"\n\t\tadd += \"&lt;tr>\"\n\n\treturn add\n\n\ndef main(html):\n\t\"Builds up the table with the functions made for it\"\n\thtml += header()\n\thtml += content_of_table()\n\n\treturn html\n\nhtml = main(html)\n\nhtml += add\nhtml += \"&lt;\/table>\"\nprint(html)\n\nwith open(\"file.html\", \"w\") as file:\n\tfile.write(html)\nos.startfile(\"file.html\")\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The data were like this<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/001.png\"><img loading=\"lazy\" decoding=\"async\" width=\"505\" height=\"328\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/001.png\" alt=\"\" class=\"wp-image-7745\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/001.png 505w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/001-320x208.png 320w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The output is this<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/output.png\"><img loading=\"lazy\" decoding=\"async\" width=\"316\" height=\"228\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/11\/output.png\" alt=\"\" class=\"wp-image-7746\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Changing style<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can easily change the style, like I show in the video<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">import pandas as pd\nimport os\n\n\ntable_class = \"rwd-table\"\n\nhtml = \"\"\"&lt;style>\n@import \"https:\/\/fonts.googleapis.com\/css?family=Montserrat:300,400,700\";\n.rwd-table {\n  margin: 1em 0;\n\tborder: 1px;\n  min-width: 300px;\n}\n.rwd-table tr {border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; } \n.rwd-table th {display: none; } \n.rwd-table td {border:1; display: block; } \n.rwd-table td:first-child {padding-top: .5em; } \n.rwd-table td:last-child {padding-bottom: .5em; } \n.rwd-table td:before {content: attr(data-th) \": \"; font-weight: bold; width: 6.5em; display: inline-block; } \n@media (min-width: 480px) {\n\t.rwd-table td:before {display: none; } \n\t} .rwd-table th, .rwd-table td {text-align: left; \n\t} \n@media (min-width: 480px) {\n\t.rwd-table th, .rwd-table td {\n\tdisplay: table-cell; padding: .25em .5em; }\n\t.rwd-table th:first-child, \n\t.rwd-table td:first-child {padding-left: 0; } \n\t.rwd-table th:last-child, .rwd-table td:last-child {padding-right: 0; } } \n\th1 {font-weight: normal; letter-spacing: -1px; color: #34495E; } \n\t.rwd-table {background: #34495E; color: #fff; border-radius: .4em; overflow: hidden; } \n\t.rwd-table tr {border-color: #46637f; } \n\t.rwd-table th, \n\t.rwd-table td {margin: .5em 1em; } @media (min-width: 480px) {\n\t.rwd-table th, .rwd-table td {padding: 1em !important; } } \n\t.rwd-table th, .rwd-table td:before {color: #dd5; } &lt;\/style>\n\n&lt;script>\n  window.console = window.console || function(t) {};\n&lt;\/script>\n&lt;script>\n  if (document.location.search.match(\/type=embed\/gi)) {\n    window.parent.postMessage(\"resize\", \"*\");\n  }\n&lt;\/script>\"\"\"\n\nhtml += \"\"\"\n&lt;style>\ntable, td, th {\n  border: 1px solid black;\n}\n\ntable {\n  width: 0;\n  border-collapse: collapse;\n}\n&lt;\/style>\n\"\"\"\n\n\nhtml += \"\"\"&lt;style>\ntable.blueTable {\n  border: 1px solid #1C6EA4;\n  background-color: #EEEEEE;\n  width: 0%;\n  text-align: left;\n  border-collapse: collapse;\n}\ntable.blueTable td, table.blueTable th {\n  border: 1px solid #AAAAAA;\n  padding: 3px 2px;\n}\ntable.blueTable tbody td {\n  font-size: 13px;\n}\ntable.blueTable tr:nth-child(even) {\n  background: #D0E4F5;\n}\ntable.blueTable thead {\n  background: #1C6EA4;\n  background: -moz-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n  background: -webkit-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n  background: linear-gradient(to bottom, #5592bb 0%, #327cad 66%, #1C6EA4 100%);\n  border-bottom: 2px solid #444444;\n}\ntable.blueTable thead th {\n  font-size: 15px;\n  font-weight: bold;\n  color: #FFFFFF;\n  border-left: 2px solid #D0E4F5;\n}\ntable.blueTable thead th:first-child {\n  border-left: none;\n}\n\ntable.blueTable tfoot {\n  font-size: 14px;\n  font-weight: bold;\n  color: #FFFFFF;\n  background: #D0E4F5;\n  background: -moz-linear-gradient(top, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);\n  background: -webkit-linear-gradient(top, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);\n  background: linear-gradient(to bottom, #dcebf7 0%, #d4e6f6 66%, #D0E4F5 100%);\n  border-top: 2px solid #444444;\n}\ntable.blueTable tfoot td {\n  font-size: 14px;\n}\ntable.blueTable tfoot .links {\n  text-align: right;\n}\ntable.blueTable tfoot .links a{\n  display: inline-block;\n  background: #1C6EA4;\n  color: #FFFFFF;\n  padding: 2px 8px;\n  border-radius: 5px;\n}\n&lt;\/style>\n\"\"\"\n\n# df = pd.read_excel(filename, index=1)\ndf = pd.read_excel(\"001.xlsx\", engine='openpyxl')\n# df.to_html(\"001.html\")\nhtml += \"&lt;table class='blueTable'>\"\n# html += \"&lt;table>\"\nhtml2 = \"\"\nadd = \"\"\n\ndef header():\n\t\"Create the header of the column\"\n\tadd = \"\"\n\tfor d in df:\n\t\tadd += f\"&lt;th>{d}&lt;\/th>\"\n\tadd += \"&lt;tr>\"\n\treturn add\n\ndef content_of_table():\n\t\"This are the tds\"\n\tadd = \"\"\n\tfor i in range(0, len(df)):\n\t\tfor d in df:\n\t\t\tadd += f\"&lt;td>{df[d][i]}&lt;\/td>\"\n\t\tadd += \"&lt;tr>\"\n\treturn add\n\n\ndef main(html):\n\t\"Builds up the table with the functions made for it\"\n\thtml += header()\n\thtml += content_of_table()\n\treturn html\n\nhtml = main(html)\n\n\nhtml += \"&lt;\/table>\"\nprint(html)\n\nwith open(\"file.html\", \"w\") as file:\n\tfile.write(html)\nos.startfile(\"file.html\")\n<\/pre>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Pandas tables in html from excel data\" width=\"747\" height=\"560\" src=\"https:\/\/www.youtube.com\/embed\/ZZ_KGNfoHzI?feature=oembed&amp;enablejsapi=1\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n<\/div><\/figure>\n\n\n<!-- se vuoi mettere un testo scorrevole\r\n[hoops name=\"typeWriterGen\"]\r\n\r\npoi metti un id diverso per ogni testo nella stessa pagina\r\n\r\n<div id=\"div01\">\r\n<script>\r\n\r\ntypeWriterGen(\"div01\",\"Esempio di testo scorrevole\");\r\n<\/script>\r\n\r\n-->\r\n<style>\r\n.avatar {\r\n  vertical-align: middle;\r\n  width: 100px;\r\n  height: 100px;\r\n  border-radius: 50%;\r\n}\r\n<\/style>\r\n\r\n<hr>\r\n\r\n<!-- NEWSLETTER LINK -->\r\n<a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSf7TniIPCWHDzCSGh2dYZaCwDvi9yLKS5ovFdKuK1sdfOvwEg\/viewform\">\r\n<img decoding=\"async\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2023\/08\/image-13.png\" class=\"avatar\">\r\nSubscribe to the <b>newsletter<\/b> for updates<\/a><br>\r\n\r\n<!-- TKINTER TEMPLATE LINK -->\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/tkinter-templates\/\">\r\n<img decoding=\"async\" src=\"https:\/\/i0.wp.com\/pythonprogramming.altervista.org\/wp-content\/uploads\/2023\/07\/image-26.png\" class=\"avatar\">\r\nTkinter templates<\/a><br>\r\n\r\n<!-- MY AVATAR PUT A LINK TO YOUTUBE CHANNEL-->\r\n<iframe loading=\"lazy\" frameborder=\"0\" src=\"https:\/\/itch.io\/embed\/711828\" width=\"552\" height=\"167\"><a href=\"https:\/\/pythonprogrammi.itch.io\/pysnake\">PySnake by PythonProgrammi<\/a><\/iframe>\r\n<br>\r\n<style>\r\n.avatar {\r\n  vertical-align: middle;\r\n  width: 100px;\r\n  height: 100px;\r\n  border-radius: 50%;\r\n}\r\n<\/style>\r\n\r\n\r\n<a href=\"https:\/\/www.youtube.com\/channel\/UCzbxq5e9gLiY-je2-br1rvg\">\r\n\t<img decoding=\"async\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/10\/avatar64x64.png\" alt=\"Avatar\" class=\"avatar\">\r\n\t My youtube channel<\/a><br>\r\n\r\n<br>\r\n\r\nTwitter: <a href=\"https:\/\/twitter.com\/pythonprogrammi\">@pythonprogrammi - python_pygame<\/a>\r\n<h3>Claude's Games<\/h3>\r\n<p><a href=\"https:\/\/pythonprogramming.altervista.org\/random-daily-game-1-arkanoid\/\">Arkanoid<\/a><br>\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/platform-2d-with-pygame-made-with-claude\/\">Platform 2d<\/a><\/p> <!-- videogames made with claude -->\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/artifacts-games-day-1-memory-game\/\">1. Memory game<\/a>\r\n<h4>Videos<\/h4>\r\n<a href=\"https:\/\/youtu.be\/ciLjWWw5pLY\">Speech recognition game<\/a>\r\n<h3>Pygame's Platform Game<\/h3>\r\n\r\n<a href=\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-5-sounds-and-mixer\/\"><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/pythonprogramming.altervista.org\/wp-content\/uploads\/2020\/01\/climbercover.png?w=557&ssl=1\"\/ width=\"50%\"><\/a>\r\n<script>\r\nvar title = \"Platform Pygame\";\r\n\t\tvar links = [\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-animation-of-a-sprite-v-1-3\/\",\"Animation 1.3\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-sprite-animation-v-2-better-coding-test-it-checking-fps-on-the-screen\/\",\"Animation 1.2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-how-to-display-the-frame-rate-fps-on-the-screen\/\",\"Display Frame rate\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-sprite-animation-update\/\",\"Animation 1.1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platformer-1\/\",\"Pygame Platform Game 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-platform-game-2\/\",\"Pygame Platform 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-3-recap-cheatsheet\/\",\"Pygame PLatform 3 - recap and some Cheat Sheet\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-4-background-and-stuffs\/\",\"Pygame Platform 4 - Background & organizing code\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platform-game-5-sounds-and-mixer\/\",\"Pygame Platform 5 - Sounds\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/platform-game-in-detail-part-1\/\",\"Game in detail part 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/map-maker-1-2\/\", \"Map maker 1.2\"]\r\n\t\t];\r\n\t\t<\/script>\r\n<script>\r\n\t\r\nif (typeof next2 != \"undefined\"){let next2 = 0;}\r\n\t\r\nnext2 = 0;\r\n\thtml = \"\";\/\/<b style='color:coral;font-size:1.2em'>Other posts about \" + title + \"<\/b><br>\";\r\nfor (address of links) \r\n{\r\n\r\n\tif (next2 == 1){\r\n\t\thtml += \"<div style='background:coral'>\";\r\n\t\thtml += \"Next link => <a href='\" + address[0] + \"'>\" + address[1] + \"<\/a>\";\r\n\t\thtml += \"<\/div><br>\";\r\n\t\tnext2 = 0;\r\n\t}\r\n\tif (address[0] == document.URL) {\r\n\t\tnext2 = 1;\r\n\t}\r\n}\r\n\r\nif (typeof next != \"undefined\") {let next = 0;}\r\nif (typeof addressStart != \"undefined\") {let addressStart = \"\";}\r\nnext = 0;\r\naddressStart = \"<a href='\";\r\nfor (address of links) {\r\n\tif (next == 1){\r\n\t\thtml += \">>>\" + addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t\tnext = 0;\r\n\t}\r\n\telse if (addressStart + address[0] != document.URL)\r\n\t{\r\n\t\thtml += addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t}\r\n\telse\r\n\t{\r\n\t\tnext = 1;\r\n\t\tnext_address = address[0]\r\n\t\tnext_title = address[1]\r\n\t\thtml += \"<span style='color:gray'>\" + address[1] + \"<\/span><br>\";\r\n\t}\r\n\r\n}\r\n\r\n\thtml += `<span style=\"font-size:8px\">Powered by <a href=\"https:\/\/pythonprogramming.altervista.org\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2673\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png\" alt=\"\" width=\"70\" height=\"25\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png 156w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2-150x56.png 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/>pythonprogramming.altervista.org<\/a><\/span>`\r\n\thtml = \"<div style='background:yellow'>\" + html + \"<\/div>\";\r\n\tdocument.write(html)\r\n<\/script>\r\n\r\n<h3>Other Pygame's posts<\/h3>\r\n\r\n<script>\r\nvar title = \"Pygame's Posts\"\r\nvar links = [\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-platformer-1\/\",\"Platform game 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/make-a-platform-game-with-pygame-dafluffypotato\/\",\"DaFluffyPotato Platform Tutorials\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-and-classic-arcade-games-pong\/\",\"Pong Game Full\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/python-draws-in-colors-app-to-draw-with-pygame\/\",\"PyGameGIF 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-draw-app-with-animation\/\",\"PyGameGIF 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pydraw-2-0-app-to-draw-gif\/\",\"PyDraw 2.0\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-drawing-2\/\",\"Draw with Pygame\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/animation-with-pygame\",\"Sprite animation 1\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/animation-on-pygame-2-free-characters-and-more-actions\/\",\"Sprite animation 2\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/starting-with-pygame\/\",\"Starting movements with Pygame\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-3-move-sprite\/\", \"Move a Sprite\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-4-fonts\/\",\"Text and Fonts\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-animate-a-sprite\/\", \"Animate a sprite\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pygame-and-mouse-events\/\",\"Mouse events\"],\r\n[\"https:\/\/pythonprogramming.altervista.org\/pgp-aka-pygamepresentation-project\/\",\"Pygame presentation\"],\r\n\t[\"https:\/\/pythonprogramming.altervista.org\/moving-the-player-in-pygame-with-key-get_pressed\/\",\"How to use key.get_pressed()\"]\r\n]\r\n<\/script>\r\n\r\n\r\n<script>\r\n\t\r\nif (typeof next2 != \"undefined\"){let next2 = 0;}\r\n\t\r\nnext2 = 0;\r\n\thtml = \"\";\/\/<b style='color:coral;font-size:1.2em'>Other posts about \" + title + \"<\/b><br>\";\r\nfor (address of links) \r\n{\r\n\r\n\tif (next2 == 1){\r\n\t\thtml += \"<div style='background:coral'>\";\r\n\t\thtml += \"Next link => <a href='\" + address[0] + \"'>\" + address[1] + \"<\/a>\";\r\n\t\thtml += \"<\/div><br>\";\r\n\t\tnext2 = 0;\r\n\t}\r\n\tif (address[0] == document.URL) {\r\n\t\tnext2 = 1;\r\n\t}\r\n}\r\n\r\nif (typeof next != \"undefined\") {let next = 0;}\r\nif (typeof addressStart != \"undefined\") {let addressStart = \"\";}\r\nnext = 0;\r\naddressStart = \"<a href='\";\r\nfor (address of links) {\r\n\tif (next == 1){\r\n\t\thtml += \">>>\" + addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t\tnext = 0;\r\n\t}\r\n\telse if (addressStart + address[0] != document.URL)\r\n\t{\r\n\t\thtml += addressStart + address[0] + \"'>\" + address[1] + \"<\/a><br>\";\r\n\t}\r\n\telse\r\n\t{\r\n\t\tnext = 1;\r\n\t\tnext_address = address[0]\r\n\t\tnext_title = address[1]\r\n\t\thtml += \"<span style='color:gray'>\" + address[1] + \"<\/span><br>\";\r\n\t}\r\n\r\n}\r\n\r\n\thtml += `<span style=\"font-size:8px\">Powered by <a href=\"https:\/\/pythonprogramming.altervista.org\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2673\" src=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png\" alt=\"\" width=\"70\" height=\"25\" srcset=\"https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2.png 156w, https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/06\/altervista2-150x56.png 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/>pythonprogramming.altervista.org<\/a><\/span>`\r\n\thtml = \"<div style='background:yellow'>\" + html + \"<\/div>\";\r\n\tdocument.write(html)\r\n<\/script>\n","protected":false},"excerpt":{"rendered":"Html table from Excel with Pandas\n<a class=\"moretag\" href=\"https:\/\/pythonprogramming.altervista.org\/pandas-html-table-from-excel\/\"> [...]<\/a>","protected":false},"author":1,"featured_media":7747,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[542,683],"tags":[181,489,257,321,495,320],"class_list":["post-7744","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-html-with-python","category-pandas-2","tag-convert","tag-data","tag-excel","tag-html","tag-pandas","tag-table"],"avopt_banners_inside_post":true,"avopt_banners_on_page":true,"av_copy_from":"","av_sharing_message":"","av_sharing_allowed":true,"av_sharing_on":{"fb":[],"tw":[]},"av_allow_affiliate_banner":false,"av_allow_affiliate_multi_banner":false,"av_show_affiliation_buy_button":false,"av_post_rating":true,"av_have_post_rating_value":false,"av_is_artificial_intelligence_content":false,"_links":{"self":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/7744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/comments?post=7744"}],"version-history":[{"count":4,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/7744\/revisions"}],"predecessor-version":[{"id":10484,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/posts\/7744\/revisions\/10484"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/media\/7747"}],"wp:attachment":[{"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/media?parent=7744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/categories?post=7744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pythonprogramming.altervista.org\/wp-json\/wp\/v2\/tags?post=7744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}