{"id":8268,"date":"2024-02-29T20:55:29","date_gmt":"2024-02-29T11:55:29","guid":{"rendered":"https:\/\/arakoki70.com\/?p=8268"},"modified":"2024-12-15T15:54:02","modified_gmt":"2024-12-15T06:54:02","slug":"python%e3%81%a7-matplotlib-%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6-mariadb%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%82%b0%e3%83%a9%e3%83%95%e8%a1%a8%e7%a4%ba","status":"publish","type":"post","link":"https:\/\/arakoki70.com\/?p=8268","title":{"rendered":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a"},"content":{"rendered":"<div style=\"background: #f5f5f5; padding: 10px; border: 2px solid #800000; text-align: center; box-shadow: 5px 5px 5px #aaa; font-size: 16px;\"><span style=\"font-size: 14pt;\"><strong><span style=\"font-size: 12pt;\">Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6<\/span><br \/>\r\nPython + MariaDB<br \/>\r\nmatplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a<\/strong><\/span><\/div>\r\n<div>\u00a0<\/div>\r\n<div>Mariadb\u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Python\u306e matplotlib \u3092\u4f7f\u3063\u3066\u30b0\u30e9\u30d5\u306b\u8868\u793a\u3057\u3066\u307f\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png\" data-rel=\"lightbox-gallery-E6UyepDS\" data-rl_title=\"matplot_1011\" data-rl_caption=\"\" title=\"matplot_1011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8269\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png\" alt=\"matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\" width=\"800\" height=\"402\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4ee5\u4e0b\u3001Python\u3067\u306e matplotlib \u306e\u4f7f\u3044\u65b9\u3092\u8a18\u9332\u3002<\/div>\r\n<div><!--more--><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #c0c0c0; padding: 7px; background: #f5f5f5; border-radius: 8px; position: relative; top: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 16px;\">\r\n<div><strong><span style=\"font-size: 14pt;\">\u3000\u76ee\u3000\u6b21<\/span><\/strong><\/div>\r\n<div style=\"margin-left: 20pt; line-height: 200%;\"><span style=\"color: magenta;\">1.\u3000<\/span><a href=\"#title1\"><strong>\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">2.\u3000<\/span><a href=\"#title2\"><strong>Python\u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">3.\u3000<\/span><a href=\"#title3\"><strong>\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u8aac\u660e<\/strong><\/a><\/div>\r\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title1\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>1. \u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>pip install matplotlib mysql-connector-python<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title2\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>2. Python\u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<pre><code class=\u201dhljs python\"><span class=\"hljs-comment\"># -*- coding: utf-8 -*-<\/span>\r\n\r\n<span class=\"hljs-keyword\">import<\/span> mysql.connector\r\n<span class=\"hljs-keyword\">import<\/span> matplotlib.pyplot <span class=\"hljs-keyword\">as<\/span> plt\r\n\r\n<span class=\"hljs-comment\"># Mariadb\u3078\u306e\u63a5\u7d9a\u60c5\u5831<\/span>\r\ndb_config = {\r\n    <span class=\"hljs-string\">'host'<\/span>: <span class=\"hljs-string\">'localhost'<\/span>,\r\n    <span class=\"hljs-string\">'user'<\/span>: <span class=\"hljs-string\">'flaskpy'<\/span>,\r\n    <span class=\"hljs-string\">'password'<\/span>: <span class=\"hljs-string\">'password'<\/span>,\r\n    <span class=\"hljs-string\">'database'<\/span>: <span class=\"hljs-string\">'ondodb'<\/span>,\r\n}\r\n\r\n<span class=\"hljs-comment\"># Mariadb\u3078\u306e\u63a5\u7d9a<\/span>\r\nconnection = mysql.connector.connect(**db_config)\r\ncursor = connection.cursor()\r\n\r\n<span class=\"hljs-comment\"># \u6e29\u5ea6\u3068\u6e7f\u5ea6\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/span>\r\nquery = <span class=\"hljs-string\">\"SELECT nitiji, temp1, temp2, temp3, temp4 FROM meas_value\"<\/span>\r\ncursor.execute(query)\r\nresult = cursor.fetchall()\r\n\r\n<span class=\"hljs-comment\"># \u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u30ea\u30b9\u30c8\u306b\u683c\u7d0d<\/span>\r\ntimestamps, temperature1, temperature2, temperature3, temperature4 = zip(*result)\r\n\r\n<span class=\"hljs-comment\"># \u30b0\u30e9\u30d5\u306e\u63cf\u753b<\/span>\r\nplt.figure(figsize=(<span class=\"hljs-number\">18<\/span>, <span class=\"hljs-number\">8<\/span>))\r\nplt.plot(timestamps, temperature1, label=<span class=\"hljs-string\">'\u5ba4\u5185'<\/span>, marker=<span class=\"hljs-string\">'o'<\/span>, markersize=<span class=\"hljs-number\">2<\/span>)\r\nplt.plot(timestamps, temperature2, label=<span class=\"hljs-string\">'\u30ab\u30fc\u30c6\u30f3'<\/span>, marker=<span class=\"hljs-string\">'o'<\/span>, markersize=<span class=\"hljs-number\">1<\/span>)\r\nplt.plot(timestamps, temperature3, label=<span class=\"hljs-string\">'\u5185\u7a93'<\/span>, marker=<span class=\"hljs-string\">'o'<\/span>, markersize=<span class=\"hljs-number\">1<\/span>)\r\nplt.plot(timestamps, temperature4, label=<span class=\"hljs-string\">'\u7a93\u969b'<\/span>, marker=<span class=\"hljs-string\">'o'<\/span>, markersize=<span class=\"hljs-number\">2<\/span>)\r\n\r\n<span class=\"hljs-comment\"># \u30b0\u30e9\u30d5\u306e\u8a2d\u5b9a<\/span>\r\nplt.title(<span class=\"hljs-string\">'Temperature and Humidity Over Time'<\/span>)\r\nplt.xlabel(<span class=\"hljs-string\">'Timestamp'<\/span>)\r\nplt.ylabel(<span class=\"hljs-string\">'Value'<\/span>)\r\nplt.legend()\r\nplt.grid(<span class=\"hljs-literal\">True<\/span>)\r\nplt.xticks(rotation=<span class=\"hljs-number\">45<\/span>)\r\nplt.yticks(range(<span class=\"hljs-number\">0<\/span>, <span class=\"hljs-number\">40<\/span>, <span class=\"hljs-number\">2<\/span>))  <span class=\"hljs-comment\"># \u76ee\u76db\u308a\u30920\u304b\u3089\u6700\u5927\u5024\u307e\u30672\u523b\u307f\u3067\u8868\u793a<\/span>\r\nplt.tight_layout()\r\n\r\n<span class=\"hljs-comment\"># \u30b0\u30e9\u30d5\u3092\u8868\u793a<\/span>\r\nplt.show()\r\n\r\n<span class=\"hljs-comment\"># Mariadb\u3068\u306e\u63a5\u7d9a\u3092\u30af\u30ed\u30fc\u30ba<\/span>\r\ncursor.close()\r\nconnection.close()\r\n<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u8868\u793a\u3055\u308c\u305f\u30b0\u30e9\u30d5\u3002<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png\" data-rel=\"lightbox-gallery-E6UyepDS\" data-rl_title=\"matplot_1011\" data-rl_caption=\"\" title=\"matplot_1011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8269\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png\" alt=\"matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\" width=\"800\" height=\"402\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title3\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>3. \u30b9\u30af\u30ea\u30d7\u30c8\u306e\u8aac\u660e<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div><strong>SELECT\u6587\u3002<\/strong><\/div>\r\n<pre><code class=\u201dhljs python\">query = <span class=\"hljs-string\">\"SELECT nitiji, temp1, temp2, temp3, temp4 FROM meas_value\"<\/span><\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>SELECT\u6587\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u53d6\u5f97\u3057\u305f\u3044\u5217\u306e\u30ab\u30e9\u30e0\u540d\u3092\u5909\u6570query\u306b\u4ee3\u5165\u3057\u3066\u3044\u307e\u3059\u3002\u3002<br \/>\r\n\u4e0a\u8a18\u306f\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3001\u6e29\u5ea61\u3001\u6e29\u5ea62\u3001\u6e29\u5ea63\u304a\u3088\u3073\u6e29\u5ea64\u306e\u30c7\u30fc\u30bf\u3092\u30c6\u30fc\u30d6\u30eb\u300cmeas_value\u300d\u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div><strong>\u5909\u6570\u3078\u306e\u30a2\u30f3\u30d1\u30c3\u30ad\u30f3\u30b0\u3002<\/strong><\/div>\r\n<pre><code class=\u201dhljs python\">timestamps, temperature1, temperature2, temperature3, temperature4 = zip(*result)<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u3053\u3067\u306f\u3001zip\u3068\u30a2\u30f3\u30d1\u30c3\u30ad\u30f3\u30b0\uff08*\u6f14\u7b97\u5b50\uff09\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\r\n<strong>zip(*result)<\/strong><br \/>\r\nzip\u95a2\u6570\u306f\u3001\u4e0e\u3048\u3089\u308c\u305f\u8907\u6570\u306e\u30a4\u30c6\u30e9\u30d6\u30eb\uff08\u3053\u3053\u3067\u306fresult\uff09\u304b\u3089\u8981\u7d20\u3092\u53d6\u308a\u51fa\u3057\u3001\u305d\u308c\u3089\u3092\u30bf\u30d7\u30eb\u3068\u3057\u3066\u307e\u3068\u3081\u308b\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002<br \/>\r\n*\u6f14\u7b97\u5b50\u306f\u3001\u30bf\u30d7\u30eb\u306e\u8981\u7d20\u3092\u30a2\u30f3\u30d1\u30c3\u30af\u3057\u3066\u3001\u305d\u308c\u305e\u308c\u306e\u30a4\u30c6\u30e9\u30d6\u30eb\u306e\u5bfe\u5fdc\u3059\u308b\u4f4d\u7f6e\u306b\u3042\u308b\u8981\u7d20\u3092\u500b\u5225\u306e\u5f15\u6570\u3068\u3057\u3066\u6e21\u3057\u307e\u3059\u3002<br \/>\r\n\u4e0a\u8a18\u306e\u884c\u3067\u306f\u3001zip(*result)\u306e\u7d50\u679c\u3092\u305d\u308c\u305e\u308c5\u3064\u306e\u5909\u6570\u306b\u30a2\u30f3\u30d1\u30c3\u30ad\u30f3\u30b0\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\r\n\u3053\u308c\u306b\u3088\u308a\u3001result\u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u304c\u305d\u308c\u305e\u308c\u306e\u30ea\u30b9\u30c8\u306b\u5206\u5272\u3055\u308c\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div><strong>\u30b0\u30e9\u30d5\u306e\u30b5\u30a4\u30ba\u8a2d\u5b9a\u3002<\/strong><\/div>\r\n<pre><code class=\u201dhljs python\">plt.figure(figsize=(<span class=\"hljs-number\">18<\/span>, <span class=\"hljs-number\">8<\/span>))<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>plt.figure()\u306f\u3001\u65b0\u3057\u3044\u56f3\uff08figure\uff09\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306e\u95a2\u6570\u3067\u3059\u3002<br \/>\r\nfigsize\u306f\u3001\u4f5c\u6210\u3055\u308c\u308b\u56f3\u306e\u30b5\u30a4\u30ba\u3092\u6307\u5b9a\u3059\u308b\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u3059\u3002<br \/>\r\n\u3053\u3053\u3067\u306f\u3001(18, 8)\u3068\u3044\u3046\u30bf\u30d7\u30eb\u304c\u6307\u5b9a\u3055\u308c\u3066\u304a\u308a\u3001\u6a2a\u5e45\u304c18\u30a4\u30f3\u30c1\u3001\u9ad8\u3055\u304c8\u30a4\u30f3\u30c1\u306e\u56f3\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<br \/>\r\n\u3053\u306e\u5bf8\u6cd5\u306f\u3001\u30b0\u30e9\u30d5\u306e\u63cf\u753b\u9818\u57df\u5168\u4f53\u306e\u7269\u7406\u7684\u306a\u30b5\u30a4\u30ba\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div><strong>marker\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u8a2d\u5b9a\u3002<\/strong><\/div>\r\n<pre><code class=\u201dhljs python\">plt.plot(timestamps, temperature1, label=<span class=\"hljs-string\">'\u5ba4\u5185'<\/span>, marker=<span class=\"hljs-string\">'o'<\/span>, markersize=<span class=\"hljs-number\">2<\/span>)\r\n<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>marker\u306f\u6298\u308c\u7dda\u30b0\u30e9\u30d5\u4e0a\u3067\u306e\u5404\u30c7\u30fc\u30bf\u30dd\u30a4\u30f3\u30c8\u3092\u793a\u3059\u30de\u30fc\u30ab\u30fc\u306e\u7a2e\u985e\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u4e00\u822c\u7684\u306b\u306f\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u70b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u305d\u306e\u30b5\u30a4\u30ba\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br \/>\r\nmarkersize\u3092\u8abf\u6574\u3057\u3066\u70b9\u306e\u30b5\u30a4\u30ba\u3092\u5c0f\u3055\u304f\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div><strong>Y\u8ef8\u306e\u76ee\u76db\u5e45\u306e\u8a2d\u5b9a\u3002<\/strong><\/div>\r\n<pre><code class=\u201dhljs python\">plt.yticks(range(<span class=\"hljs-number\">0<\/span>, <span class=\"hljs-number\">40<\/span>, <span class=\"hljs-number\">2<\/span>))  <span class=\"hljs-comment\"># \u76ee\u76db\u308a\u30920\u304b\u308940\u307e\u30672\u523b\u307f\u3067\u8868\u793a<\/span><\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>Y\u8ef8\u306e\u76ee\u76db\u5e45\u3092\u62e1\u5927\u3059\u308b\u306b\u306f\u3001matplotlib\u306eyticks\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u76ee\u76db\u308a\u306e\u7bc4\u56f2\u3084\u9593\u9694\u3092\u8abf\u6574\u3057\u307e\u3059\u3002<br \/>\r\nrange(0, 40, 2)\u3067\u3001\u76ee\u76db\u308a\u30920\u304b\u308940\u307e\u30672\u523b\u307f\u3067\u8868\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<p>&nbsp;<\/p>\r\n<p style=\"text-align: right;\">\u4ee5\u4e0a\u3002<br \/>\r\n(2024.02.29)<\/p>\r\n<div style=\"clear: both;\">\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\n\t<p>&nbsp;<\/p>\n\n\t<p align=\"center\">\n\t<amp-social-share type=\"email\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"facebook\" data-param-app_id=\"131027923993169\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"linkedin\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"pinterest\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"tumblr\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"twitter\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"whatsapp\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"line\"><\/amp-social-share>\n\t<\/p>\n\n\t<p>&nbsp;<\/p>\n\t\n\t<!-- \u95a2\u9023\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6 kanren-70 -->\n\t<div align=\"center\">\n\t\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-format=\"autorelaxed\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"8839675487\"><\/ins>\n\t<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t\n\t<amp-ad width=\"100vw\" height=\"320\"\n\t\ttype=\"adsense\"\n\t\tdata-ad-client=\"ca-pub-3816629014893825\"\n\t\tdata-ad-slot=\"8839675487\"\n\t\tdata-auto-format=\"mcrspv\"\n\t\tdata-full-width=\"\">\n\t\t<div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t\n\t<\/div>\n\t\n\t<div> <\/div>\n\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>","protected":false},"excerpt":{"rendered":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a \u00a0 Mariadb\u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Python\u306e &hellip; <p class=\"link-more\"><a href=\"https:\/\/arakoki70.com\/?p=8268\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>","protected":false},"author":1,"featured_media":8269,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[],"class_list":["post-8268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-02python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arakoki70.com\/?p=8268\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"og:description\" content=\"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a \u00a0 Mariadb\u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Python\u306e &hellip; &quot;Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a&quot; \u306e\u7d9a\u304d\u3092\u8aad\u3080\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arakoki70.com\/?p=8268\" \/>\n<meta property=\"og:site_name\" content=\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-29T11:55:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-15T06:54:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"402\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"tacsan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:site\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"tacsan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268\"},\"author\":{\"name\":\"tacsan\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"headline\":\"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\",\"datePublished\":\"2024-02-29T11:55:29+00:00\",\"dateModified\":\"2024-12-15T06:54:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268\"},\"wordCount\":53,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/matplot_1011.png\",\"articleSection\":[\"02 Python + MariaDB\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8268#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268\",\"name\":\"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/matplot_1011.png\",\"datePublished\":\"2024-02-29T11:55:29+00:00\",\"dateModified\":\"2024-12-15T06:54:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8268\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#primaryimage\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/matplot_1011.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/matplot_1011.png\",\"width\":800,\"height\":402,\"caption\":\"matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8268#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/arakoki70.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/\",\"name\":\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"description\":\"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f\",\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/arakoki70.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\",\"name\":\"tacsan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"width\":80,\"height\":102,\"caption\":\"tacsan\"},\"logo\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\"},\"sameAs\":[\"https:\\\/\\\/arakoki70.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/arakoki70.com\/?p=8268","og_locale":"ja_JP","og_type":"article","og_title":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","og_description":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a \u00a0 Mariadb\u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Python\u306e &hellip; \"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a\" \u306e\u7d9a\u304d\u3092\u8aad\u3080","og_url":"https:\/\/arakoki70.com\/?p=8268","og_site_name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","article_published_time":"2024-02-29T11:55:29+00:00","article_modified_time":"2024-12-15T06:54:02+00:00","og_image":[{"width":800,"height":402,"url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png","type":"image\/png"}],"author":"tacsan","twitter_card":"summary_large_image","twitter_creator":"@hermione2207","twitter_site":"@hermione2207","twitter_misc":{"\u57f7\u7b46\u8005":"tacsan","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"7\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arakoki70.com\/?p=8268#article","isPartOf":{"@id":"https:\/\/arakoki70.com\/?p=8268"},"author":{"name":"tacsan","@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"headline":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a","datePublished":"2024-02-29T11:55:29+00:00","dateModified":"2024-12-15T06:54:02+00:00","mainEntityOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8268"},"wordCount":53,"commentCount":0,"publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8268#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png","articleSection":["02 Python + MariaDB"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arakoki70.com\/?p=8268#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arakoki70.com\/?p=8268","url":"https:\/\/arakoki70.com\/?p=8268","name":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","isPartOf":{"@id":"https:\/\/arakoki70.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8268#primaryimage"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8268#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png","datePublished":"2024-02-29T11:55:29+00:00","dateModified":"2024-12-15T06:54:02+00:00","breadcrumb":{"@id":"https:\/\/arakoki70.com\/?p=8268#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arakoki70.com\/?p=8268"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/?p=8268#primaryimage","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/matplot_1011.png","width":800,"height":402,"caption":"matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a"},{"@type":"BreadcrumbList","@id":"https:\/\/arakoki70.com\/?p=8268#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/arakoki70.com\/"},{"@type":"ListItem","position":2,"name":"Python\u3067 matplotlib \u3092\u4f7f\u3063\u3066 Mariadb\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u8868\u793a"}]},{"@type":"WebSite","@id":"https:\/\/arakoki70.com\/#website","url":"https:\/\/arakoki70.com\/","name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","description":"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f","publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/arakoki70.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451","name":"tacsan","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","width":80,"height":102,"caption":"tacsan"},"logo":{"@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png"},"sameAs":["https:\/\/arakoki70.com\/"]}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8268"}],"version-history":[{"count":0,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/media\/8269"}],"wp:attachment":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}