Skip to content

Instantly share code, notes, and snippets.

@zgulde

zgulde/00_readme.md

Created July 20, 2022 02:31
Show Gist options
  • Save zgulde/1f0d74ec4576448f7c46f4028cd48001 to your computer and use it in GitHub Desktop.
Save zgulde/1f0d74ec4576448f7c46f4028cd48001 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
00_readme.md

Random Utilities

Display the source blob
Display the rendered blob
Raw
cat_scatter.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
market_basket_analysis.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
pptx.ipynb
{
"cells": [
{
"cell_type": "markdown",
"id": "8dc88fad",
"metadata": {},
"source": [
"```\n",
"pip install python-pptx\n",
"```"
]
},
{
"cell_type": "code",
"execution_count": 29,
"id": "e2d6cf62",
"metadata": {},
"outputs": [],
"source": [
"import matplotlib.pyplot as plt\n",
"from pptx import Presentation\n",
"from pptx.util import Inches\n",
"import io\n",
"import plotly.express as px"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "3b378336",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Title Slide',\n",
" 'Title and Content',\n",
" 'Section Header',\n",
" 'Two Content',\n",
" 'Comparison',\n",
" 'Title Only',\n",
" 'Blank',\n",
" 'Content with Caption',\n",
" 'Picture with Caption',\n",
" 'Title and Vertical Text',\n",
" 'Vertical Title and Text']"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"[l.name for l in prs.slide_layouts]"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "f1606d8c",
"metadata": {},
"outputs": [],
"source": [
"prs = Presentation()\n",
"title_slide_layout = prs.slide_layouts[0]\n",
"slide = prs.slides.add_slide(title_slide_layout)\n",
"title = slide.shapes.title\n",
"subtitle = slide.placeholders[1]\n",
"\n",
"title.text = \"Hello, World!\"\n",
"subtitle.text = \"python-pptx was here!\""
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "857e1989",
"metadata": {},
"outputs": [],
"source": [
"bullet_slide_layout = prs.slide_layouts[1]\n",
"\n",
"slide = prs.slides.add_slide(bullet_slide_layout)\n",
"shapes = slide.shapes\n",
"\n",
"title_shape = shapes.title\n",
"body_shape = shapes.placeholders[1]\n",
"\n",
"title_shape.text = 'Adding a Bullet Slide'\n",
"\n",
"tf = body_shape.text_frame\n",
"tf.text = 'Find the bullet slide layout'\n",
"\n",
"p = tf.add_paragraph()\n",
"p.text = 'Use _TextFrame.text for first bullet'\n",
"p.level = 1\n",
"\n",
"p = tf.add_paragraph()\n",
"p.text = 'Use _TextFrame.add_paragraph() for subsequent bullets'\n",
"p.level = 2"
]
},
{
"cell_type": "code",
"execution_count": 36,
"id": "2ed41c26",
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAEICAYAAABRSj9aAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAvDklEQVR4nO3dd3xUZdbA8d9JCL2EEiBCQm+hJIQICEpxFQFRsFN0V9eVBeEF1BfFXld313dRkeKytnVBbICyCgI2EBQwCSR0CD20RAKhlyTn/WOG3RgTMoHJ3MnM+X4+82HmeZ6Ze+Z6PbnzzJ3ziKpijDEmcIU4HYAxxpjSZYneGGMCnCV6Y4wJcJbojTEmwFmiN8aYAGeJ3hhjApwlehPQROQZEZnhdBzGOMkSvQkqBRO/iNwqIqtF5KiIrBGRzvn67haRZfke9xKR5SKSLSJbRaR/gb70fI9jRWSxiGSJyB4RuTtfX2MRUREp537cSETmikimiGSIyKMFYlYRae6+Hy4i74nIPvdrvy4i4uXdZAKMJXoT7CKB+4CawPvAuxcYGw08AdR2/zvrfLIuRBQwxf36dwB/F5HLLhDDZ0Bj4Ergkfx/cAqoBawGYty3AcBtF4jZGEv0xj+JyE4RGS8iqSJyQkTeEpF6IrJARI6JyFciUjPf2fFw91nufhF5yNPtqOrrqpqoqrnA90C9C4x9T1W/VdUcYClQDahcxNjPVfVTVT0DrALO4foDUdjYFar6rqqeUNUtwMGi4lDV7ar6iqoeUdUDwJYLxWwMWKI3/u0W4FqgJXADsAB4DKiD69gdk29sb6AF0AeYICLXlGRDIlIFmMiFz+jPjw0FpgJzVfWoBy8/EdgArPfgtR8CKgDfejD2VuBy4FMPYjBBzBK98Wevq+pBVd2L62x7paqudp8lzwU65hv7rPuMeC3wDjCkhNv6CNgHPOJJXEBd4HfFDRSRh4HrgBtVNa+YsXcA44G+qnq8mLFXAv9wv+4eD2I2Qayo+UVj/MHBfPdPFfK4ar7H+ZPdLqC9pxsRkZZAT6Cue1rmQmMrAX8EmhSXjN3GAYPd0yzFGQs8rKqbPBh7P/CKqi4rdqQJepboTaCIAs4nyGhcZ+e/oqrPFNIcCRxR1ZMFxr7Lr6dy6uL6JLyvwNjvgIZFvHbBsTuBwq6U+dVY9/iixn5TSLsxv2KJ3gSKJ0XkPqAJcA9wZwme+yO/nAa6kHQgsrgz/3wigUwPx3YGsj0cewuuTzXGFMvm6E2gWAKkAV8D/6eqiwobJCKPicibBZq7AL+aAhGRYSJS8HUaAGnuL2Tzj71KRDYXssk0oFGBsdEicrzgawDfAd0KieO4iDQt0DwTuL2Q7RnzK2ILj5iyTEQaAzuAsBKcZRsTVOyM3hhjApwlemOMCXA2dWOMMQHOzuiNMSbA+eXllXXq1NHGjRs7HYYxxpQZSUlJP6tqRGF9fpnoGzduTGJiotNhGGNMmSEiu4rqs6kbY4wJcJbojTEmwFmiN8aYAGeJ3hhjApwlemOMCXDFJnoRqSgiq0QkRUTWi8izhYwREZkkImnupd/i8/X1FZHN7r4J3n4DxhhjLsyTM/ozwNWqGgvEAX1FpGuBMf1wLePWAhgOTIP/LLk2xd0fAwwRkRjvhG6MMcYTxSZ6dTm/kk6Y+1awbsJA4D332BVAuIhE4qqvneZe0Pgs8IF7rNfl5SlTvk1jbbqn5byNMSY4eDRHLyKhIrIGyAAWq+rKAkMa8Mul3NLdbUW1F7aN4SKSKCKJmZmertPwX8dO5zBzxS5GzkziyMmzJX6+McYEKo8SvarmqmocrqXSOotIuwJDClvqTC/QXtg2pqtqgqomREQU+iveC6pROYypd3bi4NHTPPhRCnl5VqzNGGOghFfdqOoRXKvg9C3QlY5rzc7zGuJa+7Ko9lIRFxXOkwNi+GZTBtOWbCutzRhjTJniyVU3ESIS7r5fCbiG/y7CfN484Lfuq2+6Atmquh/4CWghIk1EpDww2D221NzVtRE3xl7G3xZtZnnaz6W5KWOMKRM8OaOPBL4VkVRciXuxqn4uIiNEZIR7zHxgO671Mf8B3A/gXtptNLAQ2Ah8pKrrvfwefkFEeOnm9jSNqMqYWas5kH26NDdnjDF+zy8XHklISNBLrV6ZlnGMGycvJyayOrOGdyUs1H4bZowJXCKSpKoJhfUFbPZrXrcaf7mlA4m7DvPnBQVnmowxJngEbKIHuCH2Mu7u1pi3lu1g/tr9TodjjDGOCOhED/BY/zZ0jA5n/McpbMs8XvwTjDEmwAR8oi9fLoQpQ+OpEBbKyBlJnDyb43RIxhjjUwGf6AEuC6/Ea4Pj2JpxnMfnrsMfv4A2xpjSEhSJHuCqFhE8cE1L5q7ey8yVu50OxxhjfCZoEj3A6N7N6dUqguf+vYHU9CNOh2OMMT4RVIk+JER45fY4IqpVYOSMZA6fsOJnxpjAF1SJHqBmlfJMHRZP5rEzPPDRGit+ZowJeEGX6AFio8J58oYYvtucyZRv05wOxxhjSlVQJnqAO7tEMyjuMiZ+tYVlW634mTEmcAVtohcRXry5PS3qVmXMB6vZn33K6ZCMMaZUBG2iB6hcvhzT7uzEmXO5jJqZzNmcPKdDMsYYrwvqRA/QLKIqf701luTdR3hx/kanwzHGGK8L+kQPcH2HSO7p3ph3f9jJv1NKbQEsY4xxhCV6t0f7tSE+OpwJs1NJy7DiZ8aYwOHJUoJRIvKtiGwUkfUiMraQMeNFZI37tk5EckWklrtvp4isdfdd2moipah8uRCmDIunorv42YkzVvzMGBMYPDmjzwEeUtU2QFdglIjE5B+gqi+rapyqxgGPAktUNSvfkN7u/kJXP/EXkTUqMWlIR7ZlHuexuWut+JkxJiAUm+hVdb+qJrvvH8O19muDCzxlCDDLO+H5XvfmdXjw2pZ8tmYfM1bscjocY4y5ZCWaoxeRxkBHYGUR/ZWBvsDsfM0KLBKRJBEZfoHXHi4iiSKSmJmZWZKwvO7+Xs25unVdnvt8A2v2HHE0FmOMuVQeJ3oRqYorgY9T1aNFDLsBWF5g2qa7qsYD/XBN+/Qo7ImqOl1VE1Q1ISIiwtOwSkVIiDDx9ljqVa/IqJlW/MwYU7Z5lOhFJAxXkp+pqnMuMHQwBaZtVHWf+98MYC7Q+eJC9a3wyv8tfjbuQyt+Zowpuzy56kaAt4CNqjrxAuNqAD2Bz/K1VRGRaufvA32AdZcatK90aBjO0zfGsGRLJq9/Y8XPjDFlUzkPxnQH7gLWisgad9tjQDSAqr7hbrsJWKSqJ/I9tx4w1/W3gnLA+6r6pRfi9pmhnaNJ2nmYV7/eQsfocHq0dHZayRhjSkr88RLChIQETUz0n0vuT53NZdCU5WQcO83nY66iQXglp0MyxphfEJGkoi5ht1/GeqBS+VCm3RnPuVy14mfGmDLHEr2HmkZU5a+3dmDNniP86YsNTodjjDEes0RfAv3bR3LvlU3454+7mGfFz4wxZYQl+hKa0K81CY1qMmF2KlsPHnM6HGOMKZYl+hIKC3UVP6tcPpSRM5Ot+Jkxxu9Zor8I9apXZNKQjmzPPM6EOVb8zBjj3yzRX6RuzerwUJ9W/DtlH+/9aMXPjDH+yxL9JRjZsxm/aV2XF77YQPLuw06HY4wxhbJEfwlcxc/iqF+jIqNnJpNlxc+MMX7IEv0lqlE5jGnDOvHzibOM/WA1uVb8zBjjZyzRe0G7BjV49sa2fL/1ZyZ9vdXpcIwx5hcs0XvJ4MujuCW+IZO+2cp3mzOcDscYY/7DEr2XiAgvDGpHq3rVGPfhGtIPn3Q6JGOMASzRe5Wr+Fknct3Fz87k5DodkjHGWKL3tiZ1qvDybR1ISc/mhc83Oh2OMcZYoi8NfdtFct9VTfjXil18tmav0+EYY4KcJ0sJRonItyKyUUTWi8jYQsb0EpFsEVnjvj2Vr6+viGwWkTQRmeDtN+CvHu7bms6NazFh9lq2WPEzY4yDPDmjzwEeUtU2QFdglIjEFDLue1WNc9+eAxCRUGAK0A+IAYYU8dyAExYawuShHalSoRwjZiRx3IqfGWMcUmyiV9X9qprsvn8M2Ag08PD1OwNpqrpdVc8CHwADLzbYsqZu9Yq8PqQjO38+wSOzU634mTHGESWaoxeRxkBHYGUh3VeISIqILBCRtu62BsCefGPSKeKPhIgMF5FEEUnMzMwsSVh+7YpmtRl/XWu+SN3Puz/sdDocY0wQ8jjRi0hVYDYwTlWPFuhOBhqpaizwOvDp+acV8lKFntaq6nRVTVDVhIiICE/DKhNG9GzKNW3q8acvNpK0y4qfGWN8y6NELyJhuJL8TFWdU7BfVY+q6nH3/flAmIjUwXUGH5VvaEMg6NbgExH+dnssl4VXYtTMZA4dP+N0SMaYIOLJVTcCvAVsVNWJRYyp7x6HiHR2v+4h4CeghYg0EZHywGBgnreCL0tqVApj6rB4sk6eZYwVPzPG+JAnZ/TdgbuAq/NdPtlfREaIyAj3mFuBdSKSAkwCBqtLDjAaWIjrS9yPVHV9KbyPMqFdgxo8P7Aty9MO8epXW5wOxxgTJMoVN0BVl1H4XHv+MZOByUX0zQfmX1R0AeiOy6NJ3HmY179JIz66Jr1b13U6JGNMgLNfxjrg+UHtaBNZnXEfrmFPlhU/M8aULkv0DqgYFsq0YfHk5Smj3rfiZ8aY0mWJ3iGN61Th/26PJTU9m+f+vcHpcIwxAcwSvYOua1ufP/ZsysyVu5m7Ot3pcIwxAcoSvcPG92lFlya1eHTOWjYfsOJnxhjvs0TvsHKhIbw+tCPVKoYxckYSx06fczokY0yAsUTvB+pWq8jkIR3ZlXXSip8ZY7zOEr2f6NK0Ng9f14r5aw/w9vKdTodjjAkgluj9yPAeTekTU4+X5m8kcWeW0+EYYwKEJXo/IiK8fFssDWpWYtT7yfxsxc+MMV5gid7P1KgUxrRhnThy8hxjZlnxM2PMpbNE74diLqvO84Pa8cO2Q0xcvNnpcIwxZZwlej91e0IUdyREMeXbbXy98aDT4RhjyjBL9H7s2YFtiYmszgNW/MwYcwks0fuximGhvHFnJxQYOTOJ0+es+JkxpuQ8WWEqSkS+FZGNIrJeRMYWMmaYiKS6bz+ISGy+vp0ista9YEmit99AoIuuXZmJt8exbu9RnrXiZ8aYi+DJGX0O8JCqtgG6AqNEJKbAmB1AT1XtADwPTC/Q31tV41Q14ZIjDkLXxtRjZK9mzFq1m9lJVvzMGFMyxSZ6Vd2vqsnu+8dwLQnYoMCYH1T1sPvhClyLgBsveujallzRtDaPf7qWTQeOOh2OMaYMKdEcvYg0BjoCKy8w7F5gQb7HCiwSkSQRGX6B1x4uIokikpiZmVmSsIJCudAQJg3pSPWKYYyckcxRK35mjPGQx4leRKoCs4FxqlroKaWI9MaV6B/J19xdVeOBfrimfXoU9lxVna6qCaqaEBER4fEbCCYR1SoweWg8u7NO8vDHVvzMGOMZjxK9iIThSvIzVXVOEWM6AG8CA1X10Pl2Vd3n/jcDmAt0vtSgg1nnJrWY0Lc1X64/wJvf73A6HGNMGeDJVTcCvAVsVNWJRYyJBuYAd6nqlnztVUSk2vn7QB9gnTcCD2Z/uKoJfdvW589fbmLVDit+Zoy5ME/O6LsDdwFXuy+RXCMi/UVkhIiMcI95CqgNTC1wGWU9YJmIpACrgC9U9Utvv4lgIyL89bYORNWsxOj3k8k4dtrpkIwxfkz8cZ43ISFBExPtkvvibNx/lJumLicuKpwZ93ahXKj9/s2YYCUiSUVdwm6ZoQxrE1mdFwa1Z8X2LP62eEvxTzDGBCVL9GXcrZ0aMqRzFNO+28biDVb8zBjza5boA8DTN7SlXYPqPPjRGnYfsuJnxphfskQfACqGhTJtWCcEK35mjPk1S/QBIqpWZV65I471+47yzLz1TodjjPEjlugDyG/a1GNU72Z88NMePk7c43Q4xhg/YYk+wDx4bSu6NavNE5+uY8M+K35mjLFEH3BCQ4RJQzoSXjmMkTOTyD5lxc+MCXaW6ANQnaoVmDI0nr2HTzH+4xQrfmZMkLNEH6ASGtdiQr/WLNpwkOlLtzsdjjHGQZboA9i9Vzahf/v6/HXhZlZuP1T8E4wxAckSfQATEf5ySwca1arM6FmryThqxc+MCUaW6ANctYphTL0znmOnzzF61mpycvOcDskY42OW6INA6/rVefGm9qzakcXLizY7HY4xxscs0QeJm+MbMrRLNH9fsp1F6w84HY4xxocs0QeRpwbE0L5BDR76OIVdh044HY4xxkc8WUowSkS+FZGNIrJeRMYWMkZEZJKIpIlIqojE5+vrKyKb3X0TvP0GjOcqhoUydVg8ISKMmJFsxc+MCRKenNHnAA+pahugKzBKRGIKjOkHtHDfhgPTAEQkFJji7o8BhhTyXONDUbUq8+odcWzcf5SnPrPle40JBsUmelXdr6rJ7vvHgI1AgwLDBgLvqcsKIFxEIoHOQJqqblfVs8AH7rHGQb1b1+V/rm7OR4npfPjTbqfDMSboqSofrNrN+I9TSuX1SzRHLyKNgY7AygJdDYD85RLT3W1FtRf22sNFJFFEEjMzM0sSlrkI465pyZXN6/DkZ+tZtzfb6XCMCVq7D51k2JsrmTBnLbuzTnLybI7Xt+FxoheRqsBsYJyqFiyLKIU8RS/Q/utG1emqmqCqCREREZ6GZS5SaIjw2uA4alUuz/0zk634mTE+lpunvPn9dvq8uoTU9GxevKk9s+7rSuXy5by+LY8SvYiE4UryM1V1TiFD0oGofI8bAvsu0G78QO2qFZgyLJ59R07x0Ecp5OVZ8TNjfGHLwWPcMu0HXvhiI92a1WHxgz0Y2iWakJDCzo0vnSdX3QjwFrBRVScWMWwe8Fv31TddgWxV3Q/8BLQQkSYiUh4Y7B5r/ESnRjV5rH8bvtp4kL9b8TNjStXZnDxe+2or10/6nt1ZJ3ltcBxv/S6ByBqVSnW7nnxG6A7cBawVkTXutseAaABVfQOYD/QH0oCTwD3uvhwRGQ0sBEKBt1XV1rnzM/d0b0zS7sO8vHATcVHhXNGsttMhGRNwUvYc4eFPUtl88BgD4y7jqQEx1K5awSfbFn+sVZ6QkKCJiYlOhxFUjp/J4cbJyzh6Kof5Y66kbvWKTodkTEA4dTaXiYs389ayHdStVpEXBrXjmph6Xt+OiCSpakJhffbLWANA1QrleOPOTpw4k8Po91dzzoqfGXPJftx2iL6vLeUf3+9gcOdoFj3Yo1SSfHEs0Zv/aFmvGi/d3J5VO7N4eaEVPzPmYh09fY5H56xlyD9WAPD+fV148ab2VK8Y5kg83r+Ox5Rpgzo2IHFXFtOXbic+uiZ929V3OiRjypSvNx7k8bnryDh2muE9mvLANS2pVD7U0Zgs0ZtfeXJADGvTsxn/cQqt6lejSZ0qTodkjN87dPwMz/57A/NS9tG6fjX+flcnYqPCnQ4LsKkbU4gK5UKZMiye0FBh5IwkTp214mfGFEVV+WzNXq59ZSkL1u3ngWtaMm/0lX6T5MESvSlCw5qu4mebDx7jiU/X4Y9XZxnjtP3Zp/jDPxMZ+8EaomtV5osxVzH2mhaUL+dfqdWmbkyRerWqy/9c3YJJX28loXFNhnSOdjokY/xCXp4y66fdvDR/Ezl5eTxxfRvu6d6E0FL6ZeulskRvLmjsb1qwevdhnp63nvYNatCuQQ2nQzLGUTt/PsGEOams2J5Ft2a1+fPNHYiuXdnpsC7Ivz5fGL/jKn7WkdpVyjNiRhLZJ634mQlOObl5TF+6jeteXcr6fUf5yy3tmfmHLn6f5MESvfFArSrlmTIsnoNHT/PgR2us+JkJOpsOHOWWaT/w4vxN9GgZwVcP9uSOy6NxlQLzf5bojUfio2vyeP82fL0pg2lLtjkdjjE+cSYnl4mLtzBg0jLSD59i8tCOTL+rE/XKWIkQm6M3Hvtdt8Yk7T7C3xZtpmN0ON2a1XE6JGNKTfLuwzzySSpbM45zU8cGPDUghppVyjsd1kWxM3rjMRHhzze3p0mdKoyZtZoD2aedDskYrzt5NofnP9/ALdN+4PiZHN65+3JeuSOuzCZ5sERvSqiKu/jZybO5jH4/2YqfmYCyPO1nrnt1KW8t28GwLtEseqAHvVvXdTqsS2aJ3pRYC3fxs8Rdh/nLgk1Oh2PMJcs+dY4Js1MZ9uZKyoWE8OHwrrwwqD3VHCpC5m02R28uysC4BiTtOsyby3YQ36gm/dtHOh2SMRdl0foDPPHpOg6dOMuIns0Yd00LKoY5W4TM24pN9CLyNjAAyFDVdoX0jweG5Xu9NkCEqmaJyE7gGJAL5BRVFN+UTY9f34aU9Gwe/iSV1vWr0TSiqtMhGeOxzGNneObf6/kidT9tIqvz1u8up33DwPxBoCdTN+8CfYvqVNWXVTVOVeOAR4ElqpqVb0hvd78l+QBToVwoU4fFExYqjJyRzMmzOU6HZEyxVJW5q9O59pUlLF5/kP/t05J5o7sHbJIHDxK9qi4Fsoob5zYEmHVJEZkypUF4JV4b3JEtGcd4Yq4VPzP+be+RU9zz7k888GEKTetUYf7YKxl9dQvCQgP760qvvTsRqYzrzH92vmYFFolIkogML+b5w0UkUUQSMzMzvRWW8YEeLSMY+5sWzFm9l/dX7XY6HGN+JS9P+deKXfSZuISV27N4+oYYPh7RjeZ1qzkdmk9488vYG4DlBaZtuqvqPhGpCywWkU3uTwi/oqrTgengWhzci3EZHxhzdQuSdx/h2XkbaN+gBh0ahjsdkjEAbM88zoTZa1m1M4urWtThxZvaE1XL/+vTeJM3P68MpsC0jaruc/+bAcwFOntxe8aPhIQIr94RR52q5Rk5I5kjJ886HZIJcjm5ebyxZBv9XvueTQeO8vKtHXjv952DLsmDlxK9iNQAegKf5WurIiLVzt8H+gDrvLE9459qVSnP1Ds7kXHsNA98aMXPjHM27DvKoKnL+fOCTfRq5SpCdltCVJkpQuZtnlxeOQvoBdQRkXTgaSAMQFXfcA+7CVikqifyPbUeMNe9Y8sB76vql94L3fijuKhwnhwQw1OfrWfqd2mMvrqF0yGZIHL6XC6Tv0njjSXbCK9cnmnD4ulnv/EoPtGr6hAPxryL6zLM/G3bgdiLDcyUXXd1bUTizsNMXLyFjtE16d7cip+Z0pe0K4uHP0llW+YJbolvyJMD2hBeuezWp/GmwL6myDhCRHjp5vY0jahqxc9MqTtxJodn5q3n1jd+5PS5PP75+8787fZYS/L5WKI3pcJV/CyeU+dyGWXFz0wpWbolkz6vLOWfP+7kt10bsfCBHvRsGeF0WH7HEr0pNc3rVuMvt3QgaddhXppvxc+M92SfPMf/fpzCb99eRYWwED764xU8O7AdVStY+a7C2F4xpeqG2MtI2nWYt5fvIL5ROAM6XOZ0SKaM+3Ldfp78bD1ZJ85yf69mjPlN4BUh8zZL9KbUPda/DSnpR3jkk1Ra169O87pW/MyUXMax0zz92XoWrDtATGR13rn7cto1CNz6NN5kUzem1JUvF8LUYfFUCAvl/plJVvzMlIiq8klSOtdOXMrXmzIYf10rPhvd3ZJ8CViiNz4RWaMSrw2OY2vGcR6bs9aKnxmPpB8+ye/e+Yn//TiFFnWrMn/MVYzq3Tzgi5B5m03dGJ+5qkUED1zTkomLt9CpcS3u6trI6ZCMnzpfhOwvX25CgOcGtuXOLo0ICQnOX7ZeKkv0xqdG925O8u7DPP/vDXRoUIPYqHCnQzJ+Ji3jOBNmp5K46zA9Wkbw4k3taFgz+OrTeJN9/jE+FRIivHJ7HBHVKnD/zGQOn7DiZ8blXG4eU75No/9r37M14zh/uy2Wf95zuSV5L7BEb3yuZpXyTB0WT+axMzzwkRU/M7BubzYDJy/n5YWbuSamLl892JNbOjUM2iJk3maJ3jgiNiqcJ2+I4bvNmUz+Ns3pcIxDTp/L5S9fbmLglOVkHj/DG3fGM3VYJyKqVXA6tIBic/TGMXd2iSZpZxavfLWFjtHhXNXCfroeTH7amcUjn6Sy/ecT3NapIU9cH0ONymFOhxWQ7IzeOEZEePHm9rSoW5WxH6xh35FTTodkfOD4mRye+mwdt73xI2dz8/jXvZ15+bZYS/KlyBK9cVTl8uWYdmcnzpzL5f6ZyZzNseJngey7zRlc98pS/rViF/d0b8zCcT3sk5wPFJvoReRtEckQkUJXhxKRXiKSLSJr3Len8vX1FZHNIpImIhO8GbgJHM0iqvLXW2NZs+cIL87f6HQ4phQcPnGWBz9aw93v/ESl8qF8MqIbT9/QlipWhMwnPNnL7wKTgfcuMOZ7VR2Qv0FEQoEpwLVAOvCTiMxT1Q0XGasJYNd3iCRpVxN38bOa3Bhrxc8CgaqyYN0BnvpsHUdOnuN/rm7O6KubU6GcFSHzJU9WmFoqIo0v4rU7A2nulaYQkQ+AgYAlelOoR/u3JiX9CBNmpxITWY3mdas5HZK5BBlHT/PkZ+tYuP4g7RvU4L3fdyHmsupOhxWUvDVHf4WIpIjIAhFp625rAOzJNybd3VYoERkuIokikpiZmemlsExZEhYawpSh8VQKC2XEjGROnLHiZ2WRqvLRT3u4ZuISvtucyaP9WjP3/m6W5B3kjUSfDDRS1VjgdeBTd3thv3Qo8pcxqjpdVRNUNSEiwr6cCVb1a1Rk0pCObM88zqNW/KzM2ZN1krveWsXDs1NpHVmdBWOv4o89m1HOipA56pL3vqoeVdXj7vvzgTARqYPrDD4q39CGwL5L3Z4JfN2b1+HBa1syL2Uf/1qxy+lwjAdy85S3l+2gzytLWbPnCC8MascH93WlaYStPeAPLvkrbxGpDxxUVRWRzrj+eBwCjgAtRKQJsBcYDAy91O2Z4HB/r+Yk7z7C859voH2DGnSMrul0SKYIWw8e45HZqSTvPkKvVhG8eFN7Lguv5HRYJh9PLq+cBfwItBKRdBG5V0RGiMgI95BbgXUikgJMAgarSw4wGlgIbAQ+UtX1pfM2TKAJCREm3h5LveoVGTUzmSwrfuZ3zuXm8frXW7l+0jJ2/HyCV++I4527L7ck74fEH+dAExISNDEx0ekwjB9ITT/CrdN+pGuz2rxz9+WEWj1yv7A2PZvxn6Sw6cAxBnSI5Jkb21KnqtWncZKIJKlqQmF99g2J8WsdGobz9I0xLN2SyevfbHU6nKB3+lwuLy3YyMApyzh88izT7+rE5KHxluT9nP0szfi9oZ2jSdp5mNe+3kpcVDi9WtV1OqSgtGL7ISbMTmXnoZMM6RzFhH5tqFHJ6tOUBXZGb/yeiPCnm9rTsm41xn24hr1W/Mynjp0+x+Nz1zJ4+gryFN7/QxdeurmDJfkyxBK9KRMqlQ9l2p3x5OQq989M5kxOrtMhBYVvN2XQ55WlzFq1mz9c2YQvx11Ft+Z1nA7LlJAlelNmNI2oyl9v7UDKniP86Qsrflaask6cZdwHq7nn3Z+oWqEcs0d244kBMVQub7O9ZZH9VzNlSv/2kfzhyia8uWwHnRrVZGBckVU1zEVQVT5P3c8z89aTfeocY3/Tgvt7N7MiZGWcJXpT5jzS73zxs7XERFanRT0rfuYNB7JP88Sn6/hq40FiG9Zg5n1daF3f6tMEApu6MWVOWGgIk4fGU6VCKCNmJHHcip9dElVl1qrdXDtxCcvSMnm8fxvm3N/dknwAsURvyqR61V3Fz3b8fIIJs1Ot+NlF2nXoBEP/sZJH56ylbYPqfDm2B/f1aGo/TAswNnVjyqxuzerwUJ9WvLxwMwmNanJ39yZOh1Rm5OYp7yzfwf8t2kxYSAgv3tSewZdHEWIJPiBZojdl2siezUjedZg/zd9Ih6hw4q34WbE2HzjGw7NTSdlzhN+0rssLN7UjsobVpwlkNnVjyjRX8bM46tdwFT87dPyM0yH5rbM5ebz61RYGvP49e7JO8trgON78XYIl+SBgid6UeTUqhzFtWCcOnTjLuA/XkJtn8/UFrdlzhBteX8arX22lf/tIFj/Qg4FxDRCxqZpgYIneBIR2DWrw7I1t+X7rz7z21Ranw/Ebp87m8qcvNnDz1OVknzrHW79L4LXBHaltRciCis3Rm4Ax+PIoEnceZtI3aXRsVJPeQV787IdtPzNh9lp2Z51kaJdoJvRrTfWKVp8mGNkZvQkYIsILg9rRun41HvhwDemHTzodkiOOnj7Ho3PWMvQfKxGBWfd15cWb2luSD2KerDD1tohkiMi6IvqHiUiq+/aDiMTm69spImtFZI2I2EoiptS5ip91IjdIi599teEg105cwoc/7WZ4j6Z8ObYHVzSr7XRYxmGenNG/C/S9QP8OoKeqdgCeB6YX6O+tqnFFrXxijLc1qVOFl2+LJTU9m+c/3+B0OD5x6PgZxsxazR/eS6Rm5fLMvb87j/VvQ6XyVqPGeDBHr6pLRaTxBfp/yPdwBdDQC3EZc0n6tqvP8B5Nmb50OwmNajGoY2AWP1NV5qXs45l56zl+JocHr23JiJ7NKF/OZmXNf3n7y9h7gQX5HiuwSEQU+LuqFjzb/w8RGQ4MB4iOjvZyWCYYPXxdK9bsPsKjc9YSc1l1WgZY8bN9R07xxKfr+GZTBnFR4fz11g4B9x6Nd3jtz76I9MaV6B/J19xdVeOBfsAoEelR1PNVdbqqJqhqQkREhLfCMkGsXGgIk4d2pEqFcgFV/CwvT5m5chd9XlnKj9sO8eSAGGaP7GZJ3hTJK4leRDoAbwIDVfXQ+XZV3ef+NwOYC3T2xvaM8VTd6hV5fUhHdv58gkc+KfvFz3b8fIIh/1jB43PXERtVg4XjenDvlU2sCJm5oEtO9CISDcwB7lLVLfnaq4hItfP3gT5AoVfuGFOarmhWm/HXteaLtft5Z/lOp8O5KDm5eUxfuo2+ry5lw/6j/OWW9sy4twvRtSs7HZopA4qdoxeRWUAvoI6IpANPA2EAqvoG8BRQG5jq/jl1jvsKm3rAXHdbOeB9Vf2yFN6DMcUa0bMpSbsO8+L8jcRG1aBTo1pOh+SxjfuP8sjsVFLTs7k2ph4vDGpHveoVnQ7LlCHijx9lExISNDHRLrs33pV96hw3vL6MMzm5fDHmKur4eRmAMzm5TPkmjanfbSO8chjP3tiO/u3rW30aUygRSSrqMna7BssEjRqVwpg6LJ7DJ88x9oPVfl38LHn3YQZMWsakb9K4MfYyFj/Qk+s7RFqSNxfFEr0JKu0a1OD5gW1ZnnaIVxb7X/Gzk2dzeO7fG7hl2g+cOJPDO/dczsQ74qhZpbzToZkyzIqamaBzx+XRJO48zORv04hvFM7Vres5HRIAy9N+ZsKcVPZkneKuro14uG8rqll9GuMFdkZvgtLzg9rRJrI6D3yYwp4sZ4ufZZ86xyOfpDLszZWUCwnhw+FdeX5QO0vyxmss0ZugVDEslGnD4snLcxU/O33OmeJnC9cf4NqJS/gkOZ0RPZuxYOxVdGlqRciMd1miN0GrcZ0q/O32WNbuzeY5Hxc/yzx2hlEzk/njv5KoXbUCn97fnQn9WlMxzIqQGe+zOXoT1Pq0rc8fezbl70u2k9CoJjfHl25NPlVl7uq9PPf5Bk6eyWX8da0Y3qMpYaF2zmVKjyV6E/TG93EVP3tsrqv4Wev61UtlO3uPnOLxuWv5bnMm8dGuImTN61p9GlP67DTCBL1yoSG8PrQj1SqGMXJGMsdOn/Pq6+flKf/6cSd9Ji5h1Y4snrkhho9HdLMkb3zGEr0xQN1qFZk8pCO7s07ysBeLn23LPM7g6St48rP1xDeqycJxPbi7uxUhM75lid4Yty5Na/Pwda1YsO4Aby3bcUmvlZObx9Tv0uj32vdsOnCUl2/twHu/70xULStCZnzP5uiNyWd4D1fxs5cWbCI2KpzLG5e8+Nn6fdk8MjuVdXuP0rdtfZ4b1Ja61awImXGOndEbk4+I8PJtsTSsWYlRM5PJPHbG4+eePpfLyws3cePk5RzIPsO0YfG8cVcnS/LGcZbojSmgRqUwpg3rRPapc4yZtZqc3Lxin5O0K4vrJ33PlG+3MSiuAV892IN+7SN9EK0xxbNEb0whYi6rzvOD2vHj9kNMvEDxsxNncnhm3npufeNHTp/L45+/78zfbo8lvLIVITP+w+bojSnC7QlRJO08zNTvthEfXZNrYn5Z/GzplkwenbOWfdmn+G3XRozv25qqFex/KeN/ij2jF5G3RSRDRApdBlBcJolImoikikh8vr6+IrLZ3TfBm4Eb4wvPDmxLTGR1HvxoDbsPuYqfHTl5lv/9OIXfvr2KCmEhfPzHK3h2YDtL8sZveTJ18y7Q9wL9/YAW7ttwYBqAiIQCU9z9McAQEYm5lGCN8bWKYaG8cWcnAEbOTGJeyj6umbiUuav3Mqp3M+aPuYqEi7gyxxhfKjbRq+pSIOsCQwYC76nLCiBcRCKBzkCaqm5X1bPAB+6xxpQp0bUrM/H2ONbvO8qYWaupV70C80Z3Z/x1VoTMlA3e+KzZANiT73G6u62w9i5FvYiIDMf1iYDo6GgvhGWM91wTU4+Xbm7PiTM5/K5bYytCZsoUbyT6wn7LrRdoL5SqTgemg2txcC/EZYxXDelsJyCmbPJGok8HovI9bgjsA8oX0W6MMcaHvPH5cx7wW/fVN12BbFXdD/wEtBCRJiJSHhjsHmuMMcaHij2jF5FZQC+gjoikA08DYQCq+gYwH+gPpAEngXvcfTkiMhpYCIQCb6vq+lJ4D8YYYy6g2ESvqkOK6VdgVBF983H9ITDGGOMQu3TAGGMCnCV6Y4wJcJbojTEmwFmiN8aYACfeWhvTm0QkE9h1kU+vA/zsxXC8xeIqGYurZCyukgnEuBqpakRhHX6Z6C+FiCSqaoLTcRRkcZWMxVUyFlfJBFtcNnVjjDEBzhK9McYEuEBM9NOdDqAIFlfJWFwlY3GVTFDFFXBz9MYYY34pEM/ojTHG5GOJ3hhjAlyZSfT+uki5B3ENc8eTKiI/iEhsvr6dIrJWRNaISKKP4+olItnuba8Rkafy9Tm5v8bni2mdiOSKSC13X2nurygR+VZENorIehEZW8gYnx9jHsbl82PMw7h8fox5GJfPjzERqSgiq0QkxR3Xs4WMKb3jS1XLxA3oAcQD64ro7w8swLWyVVdgpbs9FNgGNMW1GEoKEOPDuLoBNd33+52Py/14J1DHof3VC/i8kHZH91eBsTcA3/hof0UC8e771YAtBd+3E8eYh3H5/BjzMC6fH2OexOXEMeY+Zqq674cBK4Guvjq+yswZvfrpIuXFxaWqP6jqYffDFbhW2ip1Huyvoji6vwoYAszy1rYvRFX3q2qy+/4xYCOudY/z8/kx5klcThxjHu6voji6vwrwyTHmPmaOux+GuW8Fr4QpteOrzCR6D5RkkXJPD0hvuxfXX+zzFFgkIkniWhzd165wf5RcICJt3W1+sb9EpDLQF5idr9kn+0tEGgMdcZ115efoMXaBuPLz+TFWTFyOHWPF7S9fH2MiEioia4AMYLGq+uz48saasf7CK4uUlxYR6Y3rf8Ir8zV3V9V9IlIXWCwim9xnvL6QjKs2xnER6Q98CrTAT/YXro/Uy1U1/9l/qe8vEamK63/8cap6tGB3IU/xyTFWTFznx/j8GCsmLseOMU/2Fz4+xlQ1F4gTkXBgroi0U9X831WV2vEVSGf0RS1SXlS7z4hIB+BNYKCqHjrfrqr73P9mAHNxfUTzCVU9ev6jpLpWAgsTkTr4wf5yG0yBj9Slvb9EJAxXcpipqnMKGeLIMeZBXI4cY8XF5dQx5sn+cvP5MeZ+7SPAd7g+TeRXeseXt75s8MUNaEzRXy5ezy+/yFjlbi8HbAea8N8vMtr6MK5oXOvpdivQXgWolu/+D0BfH8ZVn//+YK4zsNu97xzdX+7+Grjm8av4an+53/t7wKsXGOPzY8zDuHx+jHkYl8+PMU/icuIYAyKAcPf9SsD3wABfHV9lZupG/HSRcg/iegqoDUwVEYAcdVWnq4fr4xu4/kO+r6pf+jCuW4GRIpIDnAIGq+uocnp/AdwELFLVE/meWqr7C+gO3AWsdc+jAjyGK4k6eYx5EpcTx5gncTlxjHkSF/j+GIsE/ikiobhmUj5S1c9FZES+uErt+LISCMYYE+ACaY7eGGNMISzRG2NMgLNEb4wxAc4SvTHGBDhL9MYYE+As0RtjTICzRG+MMQHu/wHKiOxZp9sMCQAAAABJRU5ErkJggg==\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {
"needs_background": "light"
},
"output_type": "display_data"
}
],
"source": [
"fig = plt.figure()\n",
"plt.plot([1, 2, 3], [3, 1, 2])\n",
"plt.title('mpl!?!?!?!?!?')\n",
"f = io.BytesIO()\n",
"plt.savefig(f, format='png')\n",
"f.seek(0)\n",
"\n",
"img_path = f\n",
"\n",
"prs = Presentation()\n",
"blank_slide_layout = prs.slide_layouts[6]\n",
"slide = prs.slides.add_slide(blank_slide_layout)\n",
"\n",
"left = top = Inches(1)\n",
"pic = slide.shapes.add_picture(img_path, left, top)"
]
},
{
"cell_type": "code",
"execution_count": 37,
"id": "2cad1a4f",
"metadata": {},
"outputs": [],
"source": [
"df = px.data.tips().head()"
]
},
{
"cell_type": "code",
"execution_count": 38,
"id": "f1a40ffa",
"metadata": {},
"outputs": [],
"source": [
"title_only_slide_layout = prs.slide_layouts[5]\n",
"slide = prs.slides.add_slide(title_only_slide_layout)\n",
"shapes = slide.shapes\n",
"\n",
"shapes.title.text = 'Adding a Table'\n",
"\n",
"rows = df.shape[0] + 1\n",
"cols = df.shape[1]\n",
"left = top = Inches(2.0)\n",
"width = Inches(6.0)\n",
"height = Inches(0.8)\n",
"\n",
"table = shapes.add_table(rows, cols, left, top, width, height).table\n",
"\n",
"# set column widths\n",
"# table.columns[0].width = Inches(2.0)\n",
"# table.columns[1].width = Inches(4.0)\n",
"\n",
"# write column headings\n",
"for i, column in enumerate(df):\n",
" table.cell(0, i).text = column\n",
" \n",
"for i, (_, row) in enumerate(df.iterrows(), start=1):\n",
" for j, x in enumerate(row.tolist()):\n",
" table.cell(i, j).text = str(x)"
]
},
{
"cell_type": "code",
"execution_count": 15,
"id": "643e8ebd",
"metadata": {},
"outputs": [],
"source": [
"prs.save('test.pptx')"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "b00d4699",
"metadata": {},
"outputs": [],
"source": [
"fig = plt.figure()\n",
"plt.plot([1, 2, 3], [3, 1, 2])\n",
"plt.title('mpl!?!?!?!?!?')\n",
"f = io.BytesIO()\n",
"plt.savefig(f, format='png')\n",
"f.seek(0)"
]
},
{
"cell_type": "code",
"execution_count": 40,
"id": "0a0d55f4",
"metadata": {},
"outputs": [],
"source": [
"from subprocess import check_output"
]
},
{
"cell_type": "code",
"execution_count": 46,
"id": "27451e7c",
"metadata": {},
"outputs": [],
"source": [
"f = io.BytesIO()\n",
"diagram = '''\n",
"graph g {\n",
" dpi=255\n",
" a -- b\n",
" b -- c\n",
" a -- c\n",
"}\n",
"'''\n",
"svg = check_output('dot -Tpng'.split(), input=diagram.encode())\n",
"f.write(svg)\n",
"f.seek(0)\n",
"\n",
"prs = Presentation()\n",
"blank_slide_layout = prs.slide_layouts[6]\n",
"slide = prs.slides.add_slide(blank_slide_layout)\n",
"\n",
"left = top = Inches(.25)\n",
"pic = slide.shapes.add_picture(f, left, top)\n",
"prs.save('test.pptx')"
]
},
{
"cell_type": "code",
"execution_count": 61,
"id": "394e9b97",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['__class__',\n",
" '__delattr__',\n",
" '__dict__',\n",
" '__dir__',\n",
" '__doc__',\n",
" '__eq__',\n",
" '__format__',\n",
" '__ge__',\n",
" '__getattribute__',\n",
" '__gt__',\n",
" '__hash__',\n",
" '__init__',\n",
" '__init_subclass__',\n",
" '__le__',\n",
" '__lt__',\n",
" '__module__',\n",
" '__ne__',\n",
" '__new__',\n",
" '__reduce__',\n",
" '__reduce_ex__',\n",
" '__repr__',\n",
" '__setattr__',\n",
" '__sizeof__',\n",
" '__str__',\n",
" '__subclasshook__',\n",
" '__weakref__',\n",
" '_element',\n",
" 'element',\n",
" 'idx',\n",
" 'type']"
]
},
"execution_count": 61,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"slide = prs.slides.add_slide(prs.slide_layouts[1])\n",
"dir(slide.shapes[0].placeholder_format)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.9.7"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment