Skip to content

Instantly share code, notes, and snippets.

@anujonthemove

anujonthemove/ds-util-exporting-pandas-df-to-pdf.ipynb

Created May 9, 2021 10:53
Show Gist options
  • Save anujonthemove/91358014b2121577e7a14b31f16b26a1 to your computer and use it in GitHub Desktop.
Save anujonthemove/91358014b2121577e7a14b31f16b26a1 to your computer and use it in GitHub Desktop.
Download ZIP
Exporting stylized pandas dataframe to a pdf
Display the source blob
Display the rendered blob
Raw
ds-util-exporting-pandas-df-to-pdf.ipynb
{
"cells": [
{
"metadata": {},
"id": "36e4046e",
"cell_type": "markdown",
"source": "Code taken from: https://stackoverflow.com/questions/38531367/how-do-i-save-a-pandas-dataframe-object-as-a-pdf-after-adding-style-to-it"
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2021-05-09T10:42:49.411020Z",
"start_time": "2021-05-09T10:42:49.388763Z"
},
"trusted": false
},
"id": "d85a1386",
"cell_type": "code",
"source": "import pandas as pd\nimport numpy as np\nnp.random.seed(24)\ndf = pd.DataFrame({'A':np.linspace(1,10,10)})\ndf = pd.concat([df, pd.DataFrame(np.random.randn(10, 4), columns=list('BCDE'))], axis=1)\ndf.iloc[0, 2] = np.nan\n\ndef color_negative_red(val):\n \"\"\"\n Takes a scalar and returns a string with\n the css property `'color: red'` for negative\n strings, black otherwise.\n \"\"\"\n color = 'red' if val < 0 else 'black'\n return 'color: %s' % color",
"execution_count": 3,
"outputs": []
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2021-05-09T10:42:49.539660Z",
"start_time": "2021-05-09T10:42:49.537089Z"
},
"trusted": false
},
"id": "6328b5b5",
"cell_type": "code",
"source": "s = df.style.applymap(color_negative_red)",
"execution_count": 4,
"outputs": []
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2021-05-09T10:42:49.717808Z",
"start_time": "2021-05-09T10:42:49.692287Z"
},
"trusted": false
},
"id": "0c507d54",
"cell_type": "code",
"source": "s",
"execution_count": 5,
"outputs": [
{
"data": {
"text/html": "<style type=\"text/css\" >\n#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col0,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col4{\n color: black;\n }#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col3,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col2,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col4,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col1,#T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col3{\n color: red;\n }</style><table id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46\" ><thead> <tr> <th class=\"blank level0\" ></th> <th class=\"col_heading level0 col0\" >A</th> <th class=\"col_heading level0 col1\" >B</th> <th class=\"col_heading level0 col2\" >C</th> <th class=\"col_heading level0 col3\" >D</th> <th class=\"col_heading level0 col4\" >E</th> </tr></thead><tbody>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row0\" class=\"row_heading level0 row0\" >0</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col0\" class=\"data row0 col0\" >1.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col1\" class=\"data row0 col1\" >1.329212</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col2\" class=\"data row0 col2\" >nan</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row1\" class=\"row_heading level0 row1\" >1</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col0\" class=\"data row1 col0\" >2.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col3\" class=\"data row1 col3\" >0.564417</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row1_col4\" class=\"data row1 col4\" >0.295722</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row2\" class=\"row_heading level0 row2\" >2</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col0\" class=\"data row2 col0\" >3.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col2\" class=\"data row2 col2\" >0.219565</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col3\" class=\"data row2 col3\" >0.678805</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row2_col4\" class=\"data row2 col4\" >1.889273</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row3\" class=\"row_heading level0 row3\" >3</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col0\" class=\"data row3 col0\" >4.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col1\" class=\"data row3 col1\" >0.961538</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col2\" class=\"data row3 col2\" >0.104011</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row3_col4\" class=\"data row3 col4\" >0.850229</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row4\" class=\"row_heading level0 row4\" >4</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col0\" class=\"data row4 col0\" >5.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col1\" class=\"data row4 col1\" >1.453425</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col2\" class=\"data row4 col2\" >1.057737</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col3\" class=\"data row4 col3\" >0.165562</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row4_col4\" class=\"data row4 col4\" >0.515018</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row5\" class=\"row_heading level0 row5\" >5</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col0\" class=\"data row5 col0\" >6.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col2\" class=\"data row5 col2\" >0.562861</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col3\" class=\"data row5 col3\" >1.392855</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row6\" class=\"row_heading level0 row6\" >6</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col0\" class=\"data row6 col0\" >7.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col1\" class=\"data row6 col1\" >0.121668</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col2\" class=\"data row6 col2\" >1.207603</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row6_col4\" class=\"data row6 col4\" >1.627796</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row7\" class=\"row_heading level0 row7\" >7</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col0\" class=\"data row7 col0\" >8.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col1\" class=\"data row7 col1\" >0.354493</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col2\" class=\"data row7 col2\" >1.037528</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row7_col4\" class=\"data row7 col4\" >0.519818</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row8\" class=\"row_heading level0 row8\" >8</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col0\" class=\"data row8 col0\" >9.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col1\" class=\"data row8 col1\" >1.686583</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col3\" class=\"data row8 col3\" >1.428984</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n </tr>\n <tr>\n <th id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46level0_row9\" class=\"row_heading level0 row9\" >9</th>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col0\" class=\"data row9 col0\" >10.000000</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col2\" class=\"data row9 col2\" >0.631523</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n <td id=\"T_4caeb670_b0b3_11eb_83e5_0242520a9d46row9_col4\" class=\"data row9 col4\" >0.290720</td>\n </tr>\n </tbody></table>",
"text/plain": "<pandas.io.formats.style.Styler at 0x7fea816755c0>"
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
]
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2021-05-09T10:42:53.412448Z",
"start_time": "2021-05-09T10:42:52.886384Z"
},
"trusted": false
},
"id": "894741f8",
"cell_type": "code",
"source": "import pdfkit\nimport tempfile\n\noptions = {\n 'page-size': 'Letter',\n 'margin-top': '0.75in',\n 'margin-right': '0.75in',\n 'margin-bottom': '0.75in',\n 'margin-left': '0.75in',\n 'encoding': \"UTF-8\",\n 'lowquality': False,\n 'quiet':'',\n 'custom-header' : [\n ('Accept-Encoding', 'gzip')\n ],\n 'cookie': [\n ('cookie-name1', 'cookie-value1'),\n ('cookie-name2', 'cookie-value2'),\n ],\n 'dump-outline':'a.txt'\n}\n\ntmp = tempfile.NamedTemporaryFile()\nwith open(tmp.name, 'w') as f:\n f.write(s._repr_html_())\nwith open(tmp.name, 'r') as f:\n pdfkit.from_file(f, \"s.pdf\",options=options)\nf.close()\n\n\ndisplay(s)",
"execution_count": 6,
"outputs": [
{
"data": {
"text/html": "<style type=\"text/css\" >\n#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col0,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col4{\n color: black;\n color: black;\n color: black;\n }#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col3,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col2,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col4,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col1,#T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col3{\n color: red;\n color: red;\n color: red;\n }</style><table id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46\" ><thead> <tr> <th class=\"blank level0\" ></th> <th class=\"col_heading level0 col0\" >A</th> <th class=\"col_heading level0 col1\" >B</th> <th class=\"col_heading level0 col2\" >C</th> <th class=\"col_heading level0 col3\" >D</th> <th class=\"col_heading level0 col4\" >E</th> </tr></thead><tbody>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row0\" class=\"row_heading level0 row0\" >0</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col0\" class=\"data row0 col0\" >1.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col1\" class=\"data row0 col1\" >1.329212</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col2\" class=\"data row0 col2\" >nan</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col3\" class=\"data row0 col3\" >-0.316280</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row0_col4\" class=\"data row0 col4\" >-0.990810</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row1\" class=\"row_heading level0 row1\" >1</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col0\" class=\"data row1 col0\" >2.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col1\" class=\"data row1 col1\" >-1.070816</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col2\" class=\"data row1 col2\" >-1.438713</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col3\" class=\"data row1 col3\" >0.564417</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row1_col4\" class=\"data row1 col4\" >0.295722</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row2\" class=\"row_heading level0 row2\" >2</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col0\" class=\"data row2 col0\" >3.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col1\" class=\"data row2 col1\" >-1.626404</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col2\" class=\"data row2 col2\" >0.219565</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col3\" class=\"data row2 col3\" >0.678805</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row2_col4\" class=\"data row2 col4\" >1.889273</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row3\" class=\"row_heading level0 row3\" >3</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col0\" class=\"data row3 col0\" >4.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col1\" class=\"data row3 col1\" >0.961538</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col2\" class=\"data row3 col2\" >0.104011</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col3\" class=\"data row3 col3\" >-0.481165</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row3_col4\" class=\"data row3 col4\" >0.850229</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row4\" class=\"row_heading level0 row4\" >4</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col0\" class=\"data row4 col0\" >5.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col1\" class=\"data row4 col1\" >1.453425</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col2\" class=\"data row4 col2\" >1.057737</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col3\" class=\"data row4 col3\" >0.165562</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row4_col4\" class=\"data row4 col4\" >0.515018</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row5\" class=\"row_heading level0 row5\" >5</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col0\" class=\"data row5 col0\" >6.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col1\" class=\"data row5 col1\" >-1.336936</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col2\" class=\"data row5 col2\" >0.562861</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col3\" class=\"data row5 col3\" >1.392855</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row5_col4\" class=\"data row5 col4\" >-0.063328</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row6\" class=\"row_heading level0 row6\" >6</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col0\" class=\"data row6 col0\" >7.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col1\" class=\"data row6 col1\" >0.121668</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col2\" class=\"data row6 col2\" >1.207603</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col3\" class=\"data row6 col3\" >-0.002040</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row6_col4\" class=\"data row6 col4\" >1.627796</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row7\" class=\"row_heading level0 row7\" >7</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col0\" class=\"data row7 col0\" >8.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col1\" class=\"data row7 col1\" >0.354493</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col2\" class=\"data row7 col2\" >1.037528</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col3\" class=\"data row7 col3\" >-0.385684</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row7_col4\" class=\"data row7 col4\" >0.519818</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row8\" class=\"row_heading level0 row8\" >8</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col0\" class=\"data row8 col0\" >9.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col1\" class=\"data row8 col1\" >1.686583</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col2\" class=\"data row8 col2\" >-1.325963</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col3\" class=\"data row8 col3\" >1.428984</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row8_col4\" class=\"data row8 col4\" >-2.089354</td>\n </tr>\n <tr>\n <th id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46level0_row9\" class=\"row_heading level0 row9\" >9</th>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col0\" class=\"data row9 col0\" >10.000000</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col1\" class=\"data row9 col1\" >-0.129820</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col2\" class=\"data row9 col2\" >0.631523</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col3\" class=\"data row9 col3\" >-0.586538</td>\n <td id=\"T_4e994a9b_b0b3_11eb_83e5_0242520a9d46row9_col4\" class=\"data row9 col4\" >0.290720</td>\n </tr>\n </tbody></table>",
"text/plain": "<pandas.io.formats.style.Styler at 0x7fea816755c0>"
},
"metadata": {},
"output_type": "display_data"
}
]
},
{
"metadata": {
"trusted": false
},
"id": "f00e706b",
"cell_type": "code",
"source": "pdfkit.from_url('google.com', 'out.pdf')",
"execution_count": 7,
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": "libpng warning: iCCP: known incorrect sRGB profile\nlibpng warning: iCCP: known incorrect sRGB profile\nLoading page (1/2)\n[> ] 0%\r[==================> ] 30%\r\n(gst-plugin-scanner:25612): GStreamer-WARNING **: 11:19:15.232: Failed to load plugin '/opt/intel/openvino_2021/data_processing/gstreamer/lib/gstreamer-1.0/libgstdirectfb.so': libdirectfb-1.7.so.7: cannot open shared object file: No such file or directory\n\n(gst-plugin-scanner:25612): GStreamer-WARNING **: 11:19:15.232: Failed to load plugin '/opt/intel/openvino_2021/data_processing/gstreamer/lib/gstreamer-1.0/libgstladspa.so': liblrdf.so.0: cannot open shared object file: No such file or directory\nDRM_IOCTL_I915_GEM_APERTURE failed: Invalid argument\nAssuming 131072kB available aperture size.\nMay lead to reduced performance or incorrect rendering.\nget chip id failed: -1 [22]\nparam: 4, val: 0\n\n(gst-plugin-scanner:25612): GStreamer-WARNING **: 11:19:15.544: Failed to load plugin '/opt/intel/openvino_2021/data_processing/gstreamer/lib/gstreamer-1.0/libgstneonhttpsrc.so': libneon.so.27: cannot open shared object file: No such file or directory\n\n** (gst-plugin-scanner:25612): CRITICAL **: 11:19:15.596: pygobject initialization failed\n\n(gst-plugin-scanner:25612): GStreamer-WARNING **: 11:19:15.616: Failed to load plugin '/opt/intel/openvino_2021/data_processing/gstreamer/lib/gstreamer-1.0/libgstopenni2.so': libOpenNI2.so.0: cannot open shared object file: No such file or directory\n\n(gst-plugin-scanner:25612): GLib-GObject-WARNING **: 11:19:15.664: cannot register existing type 'GstVideoAggregator'\n\n(gst-plugin-scanner:25612): GLib-GObject-CRITICAL **: 11:19:15.664: g_type_add_interface_static: assertion 'G_TYPE_IS_INSTANTIATABLE (instance_type)' failed\n\n(gst-plugin-scanner:25612): GLib-CRITICAL **: 11:19:15.664: g_once_init_leave: assertion 'result != 0' failed\n\n(gst-plugin-scanner:25612): GLib-GObject-CRITICAL **: 11:19:15.664: g_type_register_static: assertion 'parent_type > 0' failed\n\n(gst-plugin-scanner:25612): GLib-CRITICAL **: 11:19:15.664: g_once_init_leave: assertion 'result != 0' failed\n\n(gst-plugin-scanner:25612): GLib-GObject-CRITICAL **: 11:19:15.664: g_type_register_static: assertion 'parent_type > 0' failed\n\n(gst-plugin-scanner:25612): GLib-CRITICAL **: 11:19:15.664: g_once_init_leave: assertion 'result != 0' failed\n\n(gst-plugin-scanner:25612): GLib-GObject-CRITICAL **: 11:19:15.664: g_type_register_static: assertion 'parent_type > 0' failed\n\n(gst-plugin-scanner:25612): GLib-CRITICAL **: 11:19:15.664: g_once_init_leave: assertion 'result != 0' failed\n\n(gst-plugin-scanner:25612): GStreamer-CRITICAL **: 11:19:15.664: gst_element_register: assertion 'g_type_is_a (type, GST_TYPE_ELEMENT)' failed\n\n(gst-plugin-scanner:25612): GLib-GObject-WARNING **: 11:19:15.708: cannot register existing type 'GstStereo'\n\n(gst-plugin-scanner:25612): GLib-CRITICAL **: 11:19:15.708: g_once_init_leave: assertion 'result != 0' failed\n\n(gst-plugin-scanner:25612): GStreamer-CRITICAL **: 11:19:15.708: gst_element_register: assertion 'g_type_is_a (type, GST_TYPE_ELEMENT)' failed\n[=================================> ] 56%\r[======================================================> ] 90%\r[======================================================> ] 90%\r[============================================================] 100%\rPrinting pages (2/2) \n[> ] \rDone \n"
},
{
"data": {
"text/plain": "True"
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
]
},
{
"metadata": {
"trusted": false
},
"id": "e44d07af",
"cell_type": "code",
"source": "",
"execution_count": null,
"outputs": []
}
],
"metadata": {
"kernelspec": {
"name": "python3",
"display_name": "Python 3",
"language": "python"
},
"language_info": {
"name": "python",
"version": "3.6.9",
"mimetype": "text/x-python",
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"pygments_lexer": "ipython3",
"nbconvert_exporter": "python",
"file_extension": ".py"
},
"varInspector": {
"window_display": false,
"cols": {
"lenName": 16,
"lenType": 16,
"lenVar": 40
},
"kernels_config": {
"python": {
"library": "var_list.py",
"delete_cmd_prefix": "del ",
"delete_cmd_postfix": "",
"varRefreshCmd": "print(var_dic_list())"
},
"r": {
"library": "var_list.r",
"delete_cmd_prefix": "rm(",
"delete_cmd_postfix": ") ",
"varRefreshCmd": "cat(var_dic_list()) "
}
},
"types_to_exclude": [
"module",
"function",
"builtin_function_or_method",
"instance",
"_Feature"
]
},
"gist": {
"id": "b467852be6a776b32ee9526eda9328b6",
"data": {
"description": "Exporting stylized pandas dataframe to a pdf",
"public": true
}
},
"_draft": {
"nbviewer_url": "https://gist.github.com/b467852be6a776b32ee9526eda9328b6"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment