{"id":50813,"date":"2022-08-19T00:00:00","date_gmt":"2022-08-19T07:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/"},"modified":"2025-11-14T07:55:34","modified_gmt":"2025-11-14T15:55:34","slug":"exploring-consumer-purchases-patterns-using-griddb-and-python","status":"publish","type":"post","link":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/","title":{"rendered":"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22"},"content":{"rendered":"<p>\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057\u3001\u5206\u6790\u3057\u3001\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u4f01\u696d\u306f\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3059\u308b\u6d88\u8cbb\u8005\u3092\u3088\u308a\u3088\u304f\u7406\u89e3\u3057\u3001\u30ea\u30fc\u30c1\u3092\u62e1\u5927\u3067\u304d\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u306e\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u30d6\u30ed\u30b0\u3067\u7d39\u4ecb\u3057\u3066\u3044\u308b\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u306f\u3053\u3061\u3089\u3067\u3059\u3002 <a href=\"https:\/\/github.com\/griddbnet\/Blogs\/tree\/exploring_consumer_purchases\">https:\/\/github.com\/griddbnet\/Blogs\/tree\/exploring_consumer_purchases<\/a><\/p>\n<p>\u3053\u306e\u30d6\u30ed\u30b0\u306e\u76ee\u7684\u306f\u3001Google Merchandise Store\u306e\u9867\u5ba2\u306e\u8cfc\u8cb7\u884c\u52d5\u3092GridDB\u306e\u529b\u3092\u4f7f\u3063\u3066\u5206\u6790\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u5206\u6790\u7d50\u679c\u306f\u3001Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u30c7\u30fc\u30bf\u306e\u4e0a\u306b\u30c7\u30fc\u30bf\u5206\u6790\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3092\u9078\u629e\u3057\u305f\u4f01\u696d\u306b\u3068\u3063\u3066\u3001\u3088\u308a\u5b9f\u884c\u53ef\u80fd\u306a\u696d\u52d9\u6539\u9769\u3084\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u4e88\u7b97\u306e\u6709\u52b9\u6d3b\u7528\u306b\u3064\u306a\u304c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n<p><a href=\"https:\/\/github.com\/griddbnet\/Blogs\/blob\/exploring_consumer_purchases\/Exploring%20Consumer%20Purchases%20Patterns%20using%20GridDB%20and%20Python\/Exploring%20Consumer%20Purchases%20Patterns%20using%20GridDB%20and%20Python.ipynb\"> Jupyter\u30d5\u30a1\u30a4\u30eb\uff08\u5168\u6587\uff09\u306f\u3053\u3061\u3089 <\/a><\/p>\n<p>\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306e\u6982\u8981\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<ol>\n<li>\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u6982\u8981<\/li>\n<li>\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30dd\u30fc\u30c8<\/li>\n<li>\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u8aad\u307f\u8fbc\u307f<\/li>\n<li>\u30c7\u30fc\u30bf\u306e\u30af\u30ea\u30fc\u30cb\u30f3\u30b0\u3068\u524d\u51e6\u7406<\/li>\n<li>\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u306b\u3088\u308b\u5206\u6790<\/li>\n<li>\u307e\u3068\u3081<\/li>\n<\/ol>\n<h2>\u524d\u63d0\u6761\u4ef6\u3068\u74b0\u5883\u8a2d\u5b9a<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306f\u3001Windows \u30aa\u30da\u30ec\u30fc\u30c6\u30a3\u30f3\u30b0\u30b7\u30b9\u30c6\u30e0\u4e0a\u306e Anaconda Navigator (Python \u30d0\u30fc\u30b8\u30e7\u30f3 &#8211; 3.8.3) \u3067\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u7d9a\u3051\u308b\u524d\u306b\u3001\u4ee5\u4e0b\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ol>\n<li>Pandas<\/li>\n<li>NumPy<\/li>\n<li>plotly<\/li>\n<li>Matplotlib<\/li>\n<li>Seaborn<\/li>\n<li>griddb_python<\/li>\n<li>scipy<\/li>\n<li>json<\/li>\n<li>squarify<\/li>\n<li>random<\/li>\n<\/ol>\n<p>\u3053\u308c\u3089\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u306f Conda \u306e\u4eee\u60f3\u74b0\u5883\u306b <code>conda install package-name<\/code> \u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u30bf\u30fc\u30df\u30ca\u30eb\u3084\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089\u76f4\u63a5Python\u3092\u4f7f\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001 <code>pip install package-name<\/code> \u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>GridDB\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u30ed\u30fc\u30c9\u3059\u308b\u969b\u306b\u3001GridDB \u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3068\u3001Pandas \u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u306e 2 \u7a2e\u985e\u3092\u53d6\u308a\u4e0a\u3052\u307e\u3059\u3002Python\u3092\u4f7f\u7528\u3057\u3066GridDB\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3082\u4e88\u3081\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ol>\n<li><a href=\"https:\/\/github.com\/griddb\/c_client\">GridDB C\u30af\u30e9\u30a4\u30a2\u30f3\u30c8<\/a><\/li>\n<li>SWIG (Simplified Wrapper and Interface Generator)<\/li>\n<li><a href=\"https:\/\/github.com\/griddb\/python_client\">GridDB Python\u30af\u30e9\u30a4\u30a2\u30f3\u30c8<\/a><\/li>\n<\/ol>\n<h2>1&#46; \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u6982\u8981<\/h2>\n<p>\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u306fGStore\uff08Google swag\u30aa\u30f3\u30e9\u30a4\u30f3\u30b9\u30c8\u30a2\uff09\u3078\u306e\u8a2a\u554f\u306b\u95a2\u3059\u308b\u60c5\u5831\u304c\u542b\u307e\u308c\u3066\u304a\u308a\u3001\u5404\u884c\u306f\u4e00\u610f\u306e\u8a2a\u554f\u3067\u3042\u308a\u3001\u5404\u30e6\u30fc\u30b6\u30fc\u306f\u4e00\u610f\u306e\u300cfullVisitorId\u300d\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>1) <code>fullVisitorId<\/code>&#8211; Google Merchandise Store\u306e\u5404\u30e6\u30fc\u30b6\u30fc\u306b\u4e00\u610f\u306a\u8b58\u5225\u5b50\u3002<\/p>\n<p>2) <code>channelGrouping<\/code> &#8211; \u30e6\u30fc\u30b6\u30fc\u304c\u30b9\u30c8\u30a2\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u7d4c\u8def\u3002<\/p>\n<p>3) <code>date<\/code> &#8211; \u30e6\u30fc\u30b6\u30fc\u304c\u30b9\u30c8\u30a2\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u65e5\u4ed8\u3002<\/p>\n<p>4) <code>device<\/code> &#8211; \u30b9\u30c8\u30a2\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u30c7\u30d0\u30a4\u30b9\u306e\u4ed5\u69d8\u3067\u3059\u3002<\/p>\n<p>5) <code>geoNetwork<\/code> &#8211; \u30e6\u30fc\u30b6\u30fc\u306e\u5730\u7406\u306b\u95a2\u3059\u308b\u60c5\u5831\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>6) <code>socialEngagementType<\/code> &#8211; \u30a8\u30f3\u30b2\u30fc\u30b8\u30e1\u30f3\u30c8\u306e\u30bf\u30a4\u30d7\u3001\u300c\u30bd\u30fc\u30b7\u30e3\u30eb\u306b\u53c2\u52a0\u3057\u3066\u3044\u308b\u300d\u307e\u305f\u306f\u300c\u30bd\u30fc\u30b7\u30e3\u30eb\u306b\u53c2\u52a0\u3057\u3066\u3044\u306a\u3044\u300d\u306e\u3069\u3061\u3089\u304b\u3002<\/p>\n<p>7) <code>totals<\/code> &#8211; \u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u306f\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u5168\u4f53\u306e\u96c6\u8a08\u5024\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<p>8) <code>trafficSource<\/code> &#8211; \u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306f\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u306e\u767a\u4fe1\u5143\u3067\u3042\u308b\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u30bd\u30fc\u30b9\u306b\u95a2\u3059\u308b\u60c5\u5831\u3092\u542b\u3093\u3067\u3044\u307e\u3059\u3002<\/p>\n<p>9) <code>visitId<\/code> &#8211; \u3053\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u306e\u8b58\u5225\u5b50\u3002\u3053\u308c\u306f\u3001\u901a\u5e38_utmb\u30af\u30c3\u30ad\u30fc\u3068\u3057\u3066\u4fdd\u5b58\u3055\u308c\u308b\u5024\u306e\u4e00\u90e8\u3067\u3059\u3002\u3053\u308c\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u5bfe\u3057\u3066\u306e\u307f\u4e00\u610f\u3067\u3042\u308b\u3002\u5b8c\u5168\u306b\u4e00\u610f\u306aID\u306e\u305f\u3081\u306b\u306f\u3001fullVisitorId\u3068visitId\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>10) <code>visitNumber<\/code> &#8211; \u3053\u306e\u30e6\u30fc\u30b6\u30fc\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u756a\u53f7\u3067\u3059\u3002\u3053\u308c\u304c\u6700\u521d\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u3067\u3042\u308b\u5834\u5408\u3001\u3053\u308c\u306f1\u306b\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>11) <code>visitStartTime<\/code> &#8211; \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\uff08POSIX\u6642\u9593\u3068\u3057\u3066\u8868\u73fe\u3055\u308c\u308b\uff09\u3002<\/p>\n<p>12) <code>hits<\/code> &#8211; \u3053\u306e\u884c\u3068\u30cd\u30b9\u30c8\u3055\u308c\u305f\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u3001\u3042\u3089\u3086\u308b\u7a2e\u985e\u306e\u30d2\u30c3\u30c8\u306b\u3064\u3044\u3066\u5165\u529b\u3055\u308c\u307e\u3059\u3002\u3059\u3079\u3066\u306e\u30da\u30fc\u30b8\u8a2a\u554f\u306e\u8a18\u9332\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<p>13) <code>customDimensions<\/code> &#8211; \u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306b\u306f\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u306b\u8a2d\u5b9a\u3055\u308c\u305f\u30e6\u30fc\u30b6\u30fb\u30ec\u30d9\u30eb\u307e\u305f\u306f\u30bb\u30c3\u30b7\u30e7\u30f3\u30fb\u30ec\u30d9\u30eb\u306e\u30ab\u30b9\u30bf\u30e0\u30fb\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u304c\u542b\u307e\u308c\u307e \u3059\u3002\u3053\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u7e70\u308a\u8fd4\u3057\u4f7f\u7528\u3055\u308c\u3001\u8a2d\u5b9a\u3055\u308c\u305f\u5404\u30c7\u30a3\u30e1\u30f3\u30b8\u30e7\u30f3\u306e\u30a8\u30f3\u30c8\u30ea\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>14) <code>totals<\/code> &#8211; \u3053\u306e\u30ab\u30e9\u30e0\u306e\u30bb\u30c3\u30c8\u306b\u306f\u3001\u4e3b\u306b\u30cf\u30a4\u30ec\u30d9\u30eb\u306a\u96c6\u8a08\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.kaggle.com\/competitions\/ga-customer-revenue-prediction\/data?select=train.csv\">https:\/\/www.kaggle.com\/competitions\/ga-customer-revenue-prediction\/data?select=train.csv<\/a><\/p>\n<h2>2&#46; \u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30dd\u30fc\u30c8<\/h2>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">import griddb_python as griddb\n\nimport gc\nimport numpy as np\nimport pandas as pd\nfrom pandas.io.json import json_normalize\nfrom scipy.stats import norm\nimport json\nimport datetime\nimport random\n\nimport squarify\nimport seaborn as sns\nimport matplotlib.pyplot as plt\nfrom plotly.offline import init_notebook_mode, iplot\nimport plotly.graph_objs as go\nfrom plotly import tools\n\nimport warnings\nwarnings.filterwarnings('ignore')\n%matplotlib inline<\/code><\/pre>\n<\/div>\n<h2>3&#46; \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u8aad\u307f\u8fbc\u307f<\/h2>\n<p>\u7d9a\u3051\u3066\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u306b\u30ed\u30fc\u30c9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<h3>3&#46;a GridDB\u3092\u5229\u7528\u3059\u308b<\/h3>\n<p>\u6771\u829dGridDB\u2122\u306f\u3001IoT\u3084\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306b\u6700\u9069\u306a\u9ad8\u30b9\u30b1\u30fc\u30e9\u30d6\u30ebNoSQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3002GridDB\u306e\u7406\u5ff5\u306e\u6839\u5e79\u306f\u3001IoT\u306b\u6700\u9069\u5316\u3055\u308c\u305f\u6c4e\u7528\u6027\u306e\u9ad8\u3044\u30c7\u30fc\u30bf\u30b9\u30c8\u30a2\u306e\u63d0\u4f9b\u3001\u9ad8\u3044\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3001\u9ad8\u6027\u80fd\u306a\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3001\u9ad8\u3044\u4fe1\u983c\u6027\u306e\u78ba\u4fdd\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3059\u308b\u5834\u5408\u3001CSV\u30d5\u30a1\u30a4\u30eb\u3067\u306f\u9762\u5012\u306a\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002GridDB\u306f\u3001\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u3067\u30b9\u30b1\u30fc\u30e9\u30d6\u30eb\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u3057\u3066\u3001\u5b8c\u74a7\u306a\u4ee3\u66ff\u624b\u6bb5\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002GridDB\u306f\u3001\u30b9\u30b1\u30fc\u30e9\u30d6\u30eb\u3067\u30a4\u30f3\u30e1\u30e2\u30ea\u306aNo SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u7c21\u5358\u306b\u4fdd\u5b58\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002GridDB\u3092\u521d\u3081\u3066\u4f7f\u3046\u5834\u5408\u306f\u3001<a href=\"https:\/\/griddb.net\/ja\/blog\/using-pandas-dataframes-with-griddb\/\">GridDB\u3078\u306e\u8aad\u307f\u66f8\u304d<\/a>\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u304c\u5f79\u306b\u7acb\u3061\u307e\u3059\u3002<\/p>\n<p>\u3059\u3067\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u304c\u5b8c\u4e86\u3057\u3066\u3044\u308b\u3068\u4eee\u5b9a\u3057\u3066\u3001\u4eca\u5ea6\u306f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u30ed\u30fc\u30c9\u3059\u308b\u305f\u3081\u306eSQL\u30af\u30a8\u30ea\u3092python\u3067\u66f8\u3044\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">factory = griddb.StoreFactory.get_instance()\n\nInitialize the GridDB container (enter your database credentials)\ntry:\n    gridstore = factory.get_store(host=host_name, port=your_port, \n            cluster_name=cluster_name, username=admin, \n            password=admin)\n\n    info = griddb.ContainerInfo(\"customer_data\",\n                    [[\"channelGrouping\", griddb.Type.STRING],[\"geoNetwork\", griddb.Type.STRING],[\"device\", griddb.Type.STRING],\n                     [\"date\", griddb.Type.TIMESTAMP],[\"sessionId\", griddb.Type.STRING],[\"socialEngagementType\", griddb.Type.STRING],\n                     [\"totals\", griddb.Type.STRING],[\"trafficSource\", griddb.Type.STRING],[\"visitStartTime\", griddb.Type.TIMESTAMP],\n                     [\"fullVisitorId\", griddb.Type.INTEGER],[\"visitNumber\", griddb.Type.INTEGER],[\"visitId\", griddb.Type.INTEGER],\n                    griddb.ContainerType.COLLECTION, True)\n    cont = gridstore.put_container(info) \n    data = pd.read_csv(\"False.csv\")\n    #Add data\n    for i in range(len(data)):\n        ret = cont.put(data.iloc[i, :])\n        print(\"Data added successfully\")<\/code><\/pre>\n<\/div>\n<pre><code>Data added successfully\n<\/code><\/pre>\n<p>pandas\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u63d0\u4f9b\u3059\u308bread_sql_query\u95a2\u6570\u306f\u3001\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092pandas\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306b\u5909\u63db\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u4f5c\u696d\u3057\u3084\u3059\u3044\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">sql_statement = ('SELECT * FROM customer_data.csv')\ndf = pd.read_sql_query(sql_statement, cont)<\/code><\/pre>\n<\/div>\n<p>\u5909\u6570 <code>cont<\/code> \u306b\u306f\u3001\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30b3\u30f3\u30c6\u30ca\u60c5\u5831\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<code>credit_card_dataset<\/code> \u3092\u30b3\u30f3\u30c6\u30ca\u306e\u540d\u524d\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002\u8a73\u7d30\u306f\u3001\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb<a href=\"https:\/\/griddb.net\/ja\/blog\/using-pandas-dataframes-with-griddb\/\">GridDB\u3078\u306e\u8aad\u307f\u66f8\u304d<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>IoT\u3084\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306b\u95a2\u3057\u3066\u8a00\u3048\u3070\u3001GridDB\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u3084NoSQL\u306e\u9818\u57df\u306e\u4ed6\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e2d\u3067\u660e\u3089\u304b\u306b\u969b\u7acb\u3063\u3066\u3044\u307e\u3059\u3002\u5168\u4f53\u3068\u3057\u3066\u3001GridDB\u306f\u9ad8\u53ef\u7528\u6027\u3068\u30c7\u30fc\u30bf\u4fdd\u6301\u3092\u5fc5\u8981\u3068\u3059\u308b\u30df\u30c3\u30b7\u30e7\u30f3\u30af\u30ea\u30c6\u30a3\u30ab\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u305f\u3081\u306b\u3001\u8907\u6570\u306e\u4fe1\u983c\u6027\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<h3>3&#46;b pandas\u306eread_csv\u3092\u4f7f\u7528\u3059\u308b<\/h3>\n<p>\u307e\u305f\u3001Pandas\u306e <code>read_csv<\/code> \u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u3069\u3061\u3089\u306e\u65b9\u6cd5\u3092\u4f7f\u3063\u3066\u3082\u3001\u30c7\u30fc\u30bf\u306fpandas\u306edataframe\u306e\u5f62\u3067\u8aad\u307f\u8fbc\u307e\u308c\u308b\u306e\u3067\u3001\u4e0a\u8a18\u306e\u3069\u3061\u3089\u306e\u65b9\u6cd5\u3082\u540c\u3058\u51fa\u529b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">df = pd.read_csv(\"customer_data.csv\")<\/code><\/pre>\n<\/div>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">df.head()<\/code><\/pre>\n<\/div>\n<div style=\"overflow: auto;\">\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }<\/p>\n<p>    .dataframe tbody tr th {\n        vertical-align: top;\n    }<\/p>\n<p>    .dataframe thead th {\n        text-align: right;\n    }\n  <\/style>\n<table border=\"1\" class=\"dataframe\" style=\"white-space: nowrap;\">\n<thead>\n<tr style=\"text-align: right;\">\n<th>\n        <\/th>\n<th>\n          channelGrouping\n        <\/th>\n<th>\n          date\n        <\/th>\n<th>\n          device\n        <\/th>\n<th>\n          fullVisitorId\n        <\/th>\n<th>\n          geoNetwork\n        <\/th>\n<th>\n          sessionId\n        <\/th>\n<th>\n          socialEngagementType\n        <\/th>\n<th>\n          totals\n        <\/th>\n<th>\n          trafficSource\n        <\/th>\n<th>\n          visitId\n        <\/th>\n<th>\n          visitNumber\n        <\/th>\n<th>\n          visitStartTime\n        <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>\n          0\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          {&#8220;browser&#8221;: &#8220;Chrome&#8221;, &#8220;browserVersion&#8221;: &#8220;not a&#8230;\n        <\/td>\n<td>\n          1131660440785968503\n        <\/td>\n<td>\n          {&#8220;continent&#8221;: &#8220;Asia&#8221;, &#8220;subContinent&#8221;: &#8220;Western&#8230;\n        <\/td>\n<td>\n          1131660440785968503_1472830385\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          {&#8220;visits&#8221;: &#8220;1&#8221;, &#8220;hits&#8221;: &#8220;1&#8221;, &#8220;pageviews&#8221;: &#8220;1&#8221;,&#8230;\n        <\/td>\n<td>\n          {&#8220;campaign&#8221;: &#8220;(not set)&#8221;, &#8220;source&#8221;: &#8220;google&#8221;, &#8230;\n        <\/td>\n<td>\n          1472830385\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472830385\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          1\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          {&#8220;browser&#8221;: &#8220;Firefox&#8221;, &#8220;browserVersion&#8221;: &#8220;not &#8230;\n        <\/td>\n<td>\n          377306020877927890\n        <\/td>\n<td>\n          {&#8220;continent&#8221;: &#8220;Oceania&#8221;, &#8220;subContinent&#8221;: &#8220;Aust&#8230;\n        <\/td>\n<td>\n          377306020877927890_1472880147\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          {&#8220;visits&#8221;: &#8220;1&#8221;, &#8220;hits&#8221;: &#8220;1&#8221;, &#8220;pageviews&#8221;: &#8220;1&#8221;,&#8230;\n        <\/td>\n<td>\n          {&#8220;campaign&#8221;: &#8220;(not set)&#8221;, &#8220;source&#8221;: &#8220;google&#8221;, &#8230;\n        <\/td>\n<td>\n          1472880147\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472880147\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          2\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          {&#8220;browser&#8221;: &#8220;Chrome&#8221;, &#8220;browserVersion&#8221;: &#8220;not a&#8230;\n        <\/td>\n<td>\n          3895546263509774583\n        <\/td>\n<td>\n          {&#8220;continent&#8221;: &#8220;Europe&#8221;, &#8220;subContinent&#8221;: &#8220;South&#8230;\n        <\/td>\n<td>\n          3895546263509774583_1472865386\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          {&#8220;visits&#8221;: &#8220;1&#8221;, &#8220;hits&#8221;: &#8220;1&#8221;, &#8220;pageviews&#8221;: &#8220;1&#8221;,&#8230;\n        <\/td>\n<td>\n          {&#8220;campaign&#8221;: &#8220;(not set)&#8221;, &#8220;source&#8221;: &#8220;google&#8221;, &#8230;\n        <\/td>\n<td>\n          1472865386\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472865386\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          3\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          {&#8220;browser&#8221;: &#8220;UC Browser&#8221;, &#8220;browserVersion&#8221;: &#8220;n&#8230;\n        <\/td>\n<td>\n          4763447161404445595\n        <\/td>\n<td>\n          {&#8220;continent&#8221;: &#8220;Asia&#8221;, &#8220;subContinent&#8221;: &#8220;Southea&#8230;\n        <\/td>\n<td>\n          4763447161404445595_1472881213\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          {&#8220;visits&#8221;: &#8220;1&#8221;, &#8220;hits&#8221;: &#8220;1&#8221;, &#8220;pageviews&#8221;: &#8220;1&#8221;,&#8230;\n        <\/td>\n<td>\n          {&#8220;campaign&#8221;: &#8220;(not set)&#8221;, &#8220;source&#8221;: &#8220;google&#8221;, &#8230;\n        <\/td>\n<td>\n          1472881213\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472881213\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          4\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          {&#8220;browser&#8221;: &#8220;Chrome&#8221;, &#8220;browserVersion&#8221;: &#8220;not a&#8230;\n        <\/td>\n<td>\n          27294437909732085\n        <\/td>\n<td>\n          {&#8220;continent&#8221;: &#8220;Europe&#8221;, &#8220;subContinent&#8221;: &#8220;North&#8230;\n        <\/td>\n<td>\n          27294437909732085_1472822600\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          {&#8220;visits&#8221;: &#8220;1&#8221;, &#8220;hits&#8221;: &#8220;1&#8221;, &#8220;pageviews&#8221;: &#8220;1&#8221;,&#8230;\n        <\/td>\n<td>\n          {&#8220;campaign&#8221;: &#8220;(not set)&#8221;, &#8220;source&#8221;: &#8220;google&#8221;, &#8230;\n        <\/td>\n<td>\n          1472822600\n        <\/td>\n<td>\n          2\n        <\/td>\n<td>\n          1472822600\n        <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>4&#46; \u30c7\u30fc\u30bf\u30af\u30ea\u30fc\u30cb\u30f3\u30b0\u3068\u524d\u51e6\u7406<\/h2>\n<p>\u5143\u306e\u30ab\u30e9\u30e0\u306f12\u500b\u3067\u3059\u304c\u3001\u305d\u306e\u3046\u30614\u500b\u306f\u5909\u63db\u53ef\u80fd\u306ajson\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>device: 16\u500b\u306e\u65b0\u3057\u3044\u30ab\u30e9\u30e0\u3001geoNetwork: 11\u500b\u306e\u65b0\u3057\u3044\u30ab\u30e9\u30e0\u3001totals: 6\u500b\u306e\u65b0\u3057\u3044\u30ab\u30e9\u30e0\u3001trafficSource: 14\u500b\u306e\u65b0\u3057\u3044\u30ab\u30e9\u30e0<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">def load_df(nrows=None):\n    \n    Columns = ['device', 'geoNetwork', 'totals', 'trafficSource']\n    df = pd.read_csv('customer_data.csv',\n                     converters={column: json.loads for column in Columns}, \n                     dtype={'fullVisitorId': 'str'}, nrows=nrows)\n    \n    for column in Columns:\n        column_as_df = json_normalize(df[column])\n        column_as_df.columns = [f\"{column}_{subcolumn}\" for subcolumn in column_as_df.columns]\n        df = df.drop(column, axis=1).merge(column_as_df, right_index=True, left_index=True)\n    return df<\/code><\/pre>\n<\/div>\n<p>2\u3064\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u30921\u3064\u306b\u307e\u3068\u3081\u3001\u30c6\u30ad\u30b9\u30c8\u3068\u30bf\u30a4\u30c8\u30eb\u30921\u3064\u306e\u30ab\u30e9\u30e0\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">df = load_df()\ndf.head()<\/code><\/pre>\n<\/div>\n<div style=\"overflow: auto;\">\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }<\/p>\n<p>    .dataframe tbody tr th {\n        vertical-align: top;\n    }<\/p>\n<p>    .dataframe thead th {\n        text-align: right;\n    }\n  <\/style>\n<table border=\"1\" class=\"dataframe\" style=\"white-space: nowrap;\">\n<thead>\n<tr style=\"text-align: right;\">\n<th>\n        <\/th>\n<th>\n          channelGrouping\n        <\/th>\n<th>\n          date\n        <\/th>\n<th>\n          fullVisitorId\n        <\/th>\n<th>\n          sessionId\n        <\/th>\n<th>\n          socialEngagementType\n        <\/th>\n<th>\n          visitId\n        <\/th>\n<th>\n          visitNumber\n        <\/th>\n<th>\n          visitStartTime\n        <\/th>\n<th>\n          device_browser\n        <\/th>\n<th>\n          device_browserVersion\n        <\/th>\n<th>\n          &#8230;\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.criteriaParameters\n        <\/th>\n<th>\n          trafficSource_isTrueDirect\n        <\/th>\n<th>\n          trafficSource_referralPath\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.page\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.slot\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.gclId\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.adNetworkType\n        <\/th>\n<th>\n          trafficSource_adwordsClickInfo.isVideoAd\n        <\/th>\n<th>\n          trafficSource_adContent\n        <\/th>\n<th>\n          trafficSource_campaignCode\n        <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th>\n          0\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          1131660440785968503\n        <\/td>\n<td>\n          1131660440785968503_1472830385\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          1472830385\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472830385\n        <\/td>\n<td>\n          Chrome\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          &#8230;\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          1\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          377306020877927890\n        <\/td>\n<td>\n          377306020877927890_1472880147\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          1472880147\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472880147\n        <\/td>\n<td>\n          Firefox\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          &#8230;\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          2\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          3895546263509774583\n        <\/td>\n<td>\n          3895546263509774583_1472865386\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          1472865386\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472865386\n        <\/td>\n<td>\n          Chrome\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          &#8230;\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          3\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          4763447161404445595\n        <\/td>\n<td>\n          4763447161404445595_1472881213\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          1472881213\n        <\/td>\n<td>\n          1\n        <\/td>\n<td>\n          1472881213\n        <\/td>\n<td>\n          UC Browser\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          &#8230;\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<\/tr>\n<tr>\n<th>\n          4\n        <\/th>\n<td>\n          Organic Search\n        <\/td>\n<td>\n          20160902\n        <\/td>\n<td>\n          27294437909732085\n        <\/td>\n<td>\n          27294437909732085_1472822600\n        <\/td>\n<td>\n          Not Socially Engaged\n        <\/td>\n<td>\n          1472822600\n        <\/td>\n<td>\n          2\n        <\/td>\n<td>\n          1472822600\n        <\/td>\n<td>\n          Chrome\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          &#8230;\n        <\/td>\n<td>\n          not available in demo dataset\n        <\/td>\n<td>\n          True\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<td>\n          NaN\n        <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\n    5 rows \u00d7 55 columns\n  <\/p>\n<\/div>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\"># converting date column into a proper format\ndef convert_to_datetime(frame):\n    frame['date'] = frame['date'].astype(str)\n    frame['date'] = frame['date'].apply(lambda x : x[:4] + \"-\" + x[4:6] + \"-\" + x[6:])\n    frame['date'] = pd.to_datetime(frame['date'])\n    return frame\n\ndf = convert_to_datetime(df)<\/code><\/pre>\n<\/div>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">#converting totals_transactionRevenue into int64 datatype and filling missing values as 0\ndf['totals_transactionRevenue'] = df['totals_transactionRevenue'].fillna(0).astype('int64')<\/code><\/pre>\n<\/div>\n<h2>5&#46; \u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3057\u3066\u5206\u6790\u3059\u308b<\/h2>\n<p>\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3059\u308b\u305f\u3081\u306b\u3001plotly, matplotlib, seaborn\u306a\u3069\u306e\u8907\u6570\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u3066\u3001\u65e2\u5b58\u306e\u5c5e\u6027\u3092\u3059\u3079\u3066\u4f7f\u3063\u3066\u69d8\u3005\u306a\u30d7\u30ed\u30c3\u30c8\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">#Analysing missing data\ndef missing_plot(frame, set_name, palette):\n    nan_ratio = frame.isna().sum()\/len(frame)\n    nan_ratio = nan_ratio.to_frame().reset_index().rename({'index': 'column', 0: 'Percentage'},axis=1)\n    nan_ratio.sort_values(by=['Percentage'], ascending=False, inplace=True)\n    plt.figure(figsize=(8,6))\n    plt.title(\"% Columns Missing Values\")\n    ax = sns.barplot(x='Percentage', y='column', orient='h',\n                     data=nan_ratio[nan_ratio['Percentage'] > 0],\n                     palette= palette)\n\nmissing_plot(df, 'df', 'Greens_d')<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_30_0.png\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_30_0.png\" alt=\"\" width=\"715\" height=\"387\" class=\"aligncenter size-full wp-image-28547\" srcset=\"\/wp-content\/uploads\/2022\/07\/output_30_0.png 715w, \/wp-content\/uploads\/2022\/07\/output_30_0-300x162.png 300w, \/wp-content\/uploads\/2022\/07\/output_30_0-600x325.png 600w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p>\u307b\u3068\u3093\u3069\u306e\u6b20\u640d\u5024\u306ftrafficSource\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\"># This plot shows the number of visits for each channel\ndef barplot_percentage(count_feat, color1= 'rgb(55, 83, 109)', \n                       color2= 'rgb(26, 118, 255)',num_bars= None):\n\n    df_channel = 100*df[count_feat].value_counts()\/len(df)\n    df_channel = df_channel.to_frame().reset_index()\n    if num_bars:\n        df_channel = df_channel.head(num_bars)\n\n    trace0 = go.Bar(\n        x=df_channel['index'],\n        y=df_channel[count_feat],\n        name='df set',\n        marker=dict(color=color1)\n    )\n\n    layout = go.Layout(\n        title='{} grouping'.format(count_feat),\n        xaxis=dict(\n            tickfont=dict(size=14, color='rgb(107, 107, 107)')\n        ),\n        yaxis=dict(\n            title='Percentage of visits',\n            titlefont=dict(size=16, color='rgb(107, 107, 107)'),\n            tickfont=dict(size=14, color='rgb(107, 107, 107)')\n        ),\n        legend=dict(\n            x=1.0,\n            y=1.0,\n            bgcolor='rgba(255, 255, 255, 0)',\n            bordercolor='rgba(255, 255, 255, 0)'\n        ),\n        barmode='group',\n        bargap=0.15,\n        bargroupgap=0.1\n    )\n\n    fig = go.Figure(data=[trace0], layout=layout)\n    iplot(fig)\n\nbarplot_percentage('channelGrouping')<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_29.png\"><img decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_29.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" srcset=\"\/wp-content\/uploads\/2022\/07\/Screenshot_29.png 1424w, \/wp-content\/uploads\/2022\/07\/Screenshot_29-300x136.png 300w, \/wp-content\/uploads\/2022\/07\/Screenshot_29-1024x464.png 1024w, \/wp-content\/uploads\/2022\/07\/Screenshot_29-768x348.png 768w, \/wp-content\/uploads\/2022\/07\/Screenshot_29-600x272.png 600w\" sizes=\"(max-width: 1424px) 100vw, 1424px\" \/><\/a><\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\"># Now we will analyse the time series data\n\ntmp_df = df['date'].value_counts().to_frame().reset_index().sort_values('index')\ntmp_df = tmp_df.rename(columns = {\"date\" : \"visits\"}).rename(columns = {\"index\" : \"date\"})\n\n# Plot visits\ntrace1 = go.Scatter(x=tmp_df.date.astype(str), y=tmp_df.visits,\n                    opacity = 0.8, line = dict(color = '#ff751a'), name= 'df')\n\ntraces = [trace1]\n\nlayout = dict(\n    title= \"Visits by date\",\n    xaxis=dict(\n        rangeselector=dict(\n            buttons=list([\n                dict(count=1, label='1m', step='month', stepmode='backward'),\n                dict(count=3, label='3m', step='month', stepmode='backward'),\n                dict(count=6, label='6m', step='month', stepmode='backward'),\n                dict(step='all')\n            ])\n        ),\n        rangeslider=dict(visible = True),\n        type='date'\n    )\n)\n\nfig = dict(data= traces, layout=layout)\niplot(fig)\n\n\n# Revenue by time\ndf_date_sum = df.groupby('date')['totals_transactionRevenue'].sum().to_frame().reset_index()\n# Plot\ntrace_date = go.Scatter(x=df_date_sum.date.astype(str), \n                        y=df_date_sum['totals_transactionRevenue'].apply(lambda x: np.log(x)), opacity = 0.8)\nlayout = dict(\n    title= \"Log Revenue by date\",\n    xaxis=dict(\n        rangeselector=dict(\n            buttons=list([\n                dict(count=1, label='1m', step='month', stepmode='backward'),\n                dict(count=3, label='3m', step='month', stepmode='backward'),\n                dict(count=6, label='6m', step='month', stepmode='backward'),\n                dict(step='all')\n            ])\n        ),\n        rangeslider=dict(visible = True),\n        type='date'\n    )\n)\n\nfig = dict(data= [trace_date], layout=layout)\niplot(fig)<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_30.png\"><img decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_30.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" \/><\/a><\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_31.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_31.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" \/><\/a><\/p>\n<h2>\u53ce\u76ca\u306e\u5206\u6790<\/h2>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\"># Flag visits with revenue\ndf['has_revenue'] = df['totals_transactionRevenue'].apply(lambda x: 1 if x > 0 else 0)<\/code><\/pre>\n<\/div>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">channel_order = ['Referral', 'Display', 'Paid Search', 'Direct', 'Organic Search', '(Other)', 'Social', 'Affiliates']\nplt.figure(figsize=(10,4))\nplt.title(\"% visits with revenue \/ channel\")\nsns.barplot(x='channelGrouping', y='has_revenue', data=df, order=channel_order, palette='Greens_d')\nrevenue_channel = df.groupby('channelGrouping')['totals_transactionRevenue'].sum()\nrevenue_channel = revenue_channel.to_frame().reset_index()\nplt.figure(figsize=(10,4))\nplt.title(\"Mean revenue \/ channel\")\nax = sns.barplot(x='channelGrouping', y='totals_transactionRevenue', data=revenue_channel, order=channel_order, palette='Greens_d')<\/code><\/pre>\n<\/div>\n<p>[<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_36_0.png\" alt=\"\" width=\"600\" height=\"278\" class=\"aligncenter size-full wp-image-28551\" \/><\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_36_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_36_1.png\" alt=\"\" width=\"600\" height=\"278\" class=\"aligncenter size-full wp-image-28551\" srcset=\"\/wp-content\/uploads\/2022\/07\/output_36_1.png 600w, \/wp-content\/uploads\/2022\/07\/output_36_1-300x139.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">df['revenue_status']=df.totals_transactionRevenue.apply(lambda x: 0 if x==0 else 1)\n\n#Revenue generated by different Operating systems\n\ndf_OS=df[['device_operatingSystem','totals_transactionRevenue','revenue_status']].groupby(df.device_operatingSystem).aggregate({'totals_transactionRevenue':['mean'],\n                                                                                                              'revenue_status':['count']}).reset_index()\ndf_OS.columns=['device_operatingSystem','totals_transactionRevenue_mean','revenue_status_count']\ndf1=df_OS.sort_values(by='totals_transactionRevenue_mean',ascending=False)[df_OS.totals_transactionRevenue_mean>0]\ndisplay(df1.style.format(formatter))\n\nplt.subplots(figsize=(20,5))\nplt.subplot(1,2,1)\nplt.title('REVENUE MEAN BY OPERATING SYSTEM',color='b',fontsize=12)\nplt.xlabel('Operating Systems',color='b',fontsize=12)\nplt.ylabel('Mean Revenue',color='b',fontsize=12)\nplt.bar(range(len(df1)),df1.totals_transactionRevenue_mean,color='grey')\nplt.xticks(range(len(df1)),df1.device_operatingSystem,rotation=90,fontsize=12)\nplt.yticks(fontsize=12)\n\n\nplt.subplot(1,2,2)\nplt.title('NUMBER OF TRANSACTIONS WITH REVENUE BY OPERATING SYSTEM',color='b',fontsize=12)\nplt.xlabel('Operating Systems',color='b',fontsize=12)\nplt.ylabel('Count of Transactions with Revenue',color='b',fontsize=12)\nplt.bar(range(len(df1)),df1.revenue_status_count,color='orange')\nplt.yticks(fontsize=12)\nplt.xticks(range(len(df1)),df1.device_operatingSystem,rotation=90,fontsize=12)\nplt.show()<\/code><\/pre>\n<\/div>\n<p><style type=\"text\/css\">\n<\/style>\n<\/p>\n<table id=\"T_f34ae_\">\n<thead>\n<tr>\n<th class=\"blank level0\">\n        \u00a0\n      <\/th>\n<th class=\"col_heading level0 col0\">\n        device_operatingSystem\n      <\/th>\n<th class=\"col_heading level0 col1\">\n        totals_transactionRevenue_mean\n      <\/th>\n<th class=\"col_heading level0 col2\">\n        revenue_status_count\n      <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th id=\"T_f34ae_level0_row0\" class=\"row_heading level0 row0\">\n        3\n      <\/th>\n<td id=\"T_f34ae_row0_col0\" class=\"data row0 col0\">\n        Chrome OS\n      <\/td>\n<td id=\"T_f34ae_row0_col1\" class=\"data row0 col1\">\n        6984005.39\n      <\/td>\n<td id=\"T_f34ae_row0_col2\" class=\"data row0 col2\">\n        26337\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row1\" class=\"row_heading level0 row1\">\n        7\n      <\/th>\n<td id=\"T_f34ae_row1_col0\" class=\"data row1 col0\">\n        Macintosh\n      <\/td>\n<td id=\"T_f34ae_row1_col1\" class=\"data row1 col1\">\n        3372381.41\n      <\/td>\n<td id=\"T_f34ae_row1_col2\" class=\"data row1 col2\">\n        253938\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row2\" class=\"row_heading level0 row2\">\n        6\n      <\/th>\n<td id=\"T_f34ae_row2_col0\" class=\"data row2 col0\">\n        Linux\n      <\/td>\n<td id=\"T_f34ae_row2_col1\" class=\"data row2 col1\">\n        1253365.30\n      <\/td>\n<td id=\"T_f34ae_row2_col2\" class=\"data row2 col2\">\n        35034\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row3\" class=\"row_heading level0 row3\">\n        16\n      <\/th>\n<td id=\"T_f34ae_row3_col0\" class=\"data row3 col0\">\n        Windows\n      <\/td>\n<td id=\"T_f34ae_row3_col1\" class=\"data row3 col1\">\n        1134945.73\n      <\/td>\n<td id=\"T_f34ae_row3_col2\" class=\"data row3 col2\">\n        350072\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row4\" class=\"row_heading level0 row4\">\n        1\n      <\/th>\n<td id=\"T_f34ae_row4_col0\" class=\"data row4 col0\">\n        Android\n      <\/td>\n<td id=\"T_f34ae_row4_col1\" class=\"data row4 col1\">\n        293330.32\n      <\/td>\n<td id=\"T_f34ae_row4_col2\" class=\"data row4 col2\">\n        123892\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row5\" class=\"row_heading level0 row5\">\n        19\n      <\/th>\n<td id=\"T_f34ae_row5_col0\" class=\"data row5 col0\">\n        iOS\n      <\/td>\n<td id=\"T_f34ae_row5_col1\" class=\"data row5 col1\">\n        205887.71\n      <\/td>\n<td id=\"T_f34ae_row5_col2\" class=\"data row5 col2\">\n        107665\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_f34ae_level0_row6\" class=\"row_heading level0 row6\">\n        17\n      <\/th>\n<td id=\"T_f34ae_row6_col0\" class=\"data row6 col0\">\n        Windows Phone\n      <\/td>\n<td id=\"T_f34ae_row6_col1\" class=\"data row6 col1\">\n        21710.53\n      <\/td>\n<td id=\"T_f34ae_row6_col2\" class=\"data row6 col2\">\n        1216\n      <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_37_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_37_1.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" \/><\/a><\/p>\n<h2>\u30d6\u30e9\u30a6\u30b6\u30fc\u5225\u306e\u58f2\u4e0a\u9ad8<\/h2>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">\ndf_browser=df[['device_browser','totals_transactionRevenue','revenue_status']].groupby(df.device_browser).aggregate({'totals_transactionRevenue':['mean'],\n                                                                                                              'revenue_status':['count']}).reset_index()\ndf_browser.columns=['device_browser','totals_transactionRevenue_mean','revenue_status_count']\ndf1=df_browser.sort_values(by='totals_transactionRevenue_mean',ascending=False)[df_browser.totals_transactionRevenue_mean>0]\nformatter = {'totals_transactionRevenue_mean':'{:4.2f}'}\ndisplay(df1.style.format(formatter))\n\nplt.subplots(figsize=(20,5))\nplt.subplot(1,2,1)\nplt.title('REVENUE MEAN BY BROWSER',color='b',fontsize=12)\nplt.xlabel('Browsers',color='b',fontsize=12)\nplt.ylabel('Mean Revenue',color='b',fontsize=12)\nplt.bar(range(len(df1)),df1.totals_transactionRevenue_mean,color='grey')\nplt.xticks(range(len(df1)),df1.device_browser,rotation=90,fontsize=12)\nplt.yticks(fontsize=12)\n\n\nplt.subplot(1,2,2)\nplt.title('NUMBER OF TRANSACTIONS WITH REVENUE BY BROWSER',color='b',fontsize=12)\nplt.xlabel('Browsers',color='b',fontsize=12)\nplt.ylabel('Count of Transactions with Revenue',color='b',fontsize=12)\nplt.bar(range(len(df1)),df1.revenue_status_count,color='orange')\nplt.xticks(range(len(df1)),df1.device_browser,rotation=90,fontsize=12)\nplt.yticks(fontsize=12)\nplt.show()\n<\/code><\/pre>\n<\/div>\n<p><style type=\"text\/css\">\n<\/style>\n<\/p>\n<table id=\"T_0fe27_\">\n<thead>\n<tr>\n<th class=\"blank level0\">\n        \u00a0\n      <\/th>\n<th class=\"col_heading level0 col0\">\n        device_browser\n      <\/th>\n<th class=\"col_heading level0 col1\">\n        totals_transactionRevenue_mean\n      <\/th>\n<th class=\"col_heading level0 col2\">\n        revenue_status_count\n      <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th id=\"T_0fe27_level0_row0\" class=\"row_heading level0 row0\">\n        16\n      <\/th>\n<td id=\"T_0fe27_row0_col0\" class=\"data row0 col0\">\n        Firefox\n      <\/td>\n<td id=\"T_0fe27_row0_col1\" class=\"data row0 col1\">\n        2409461.27\n      <\/td>\n<td id=\"T_0fe27_row0_col2\" class=\"data row0 col2\">\n        37069\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row1\" class=\"row_heading level0 row1\">\n        11\n      <\/th>\n<td id=\"T_0fe27_row1_col0\" class=\"data row1 col0\">\n        Chrome\n      <\/td>\n<td id=\"T_0fe27_row1_col1\" class=\"data row1 col1\">\n        2229505.52\n      <\/td>\n<td id=\"T_0fe27_row1_col2\" class=\"data row1 col2\">\n        620364\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row2\" class=\"row_heading level0 row2\">\n        15\n      <\/th>\n<td id=\"T_0fe27_row2_col0\" class=\"data row2 col0\">\n        Edge\n      <\/td>\n<td id=\"T_0fe27_row2_col1\" class=\"data row2 col1\">\n        635273.89\n      <\/td>\n<td id=\"T_0fe27_row2_col2\" class=\"data row2 col2\">\n        10205\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row3\" class=\"row_heading level0 row3\">\n        20\n      <\/th>\n<td id=\"T_0fe27_row3_col0\" class=\"data row3 col0\">\n        Internet Explorer\n      <\/td>\n<td id=\"T_0fe27_row3_col1\" class=\"data row3 col1\">\n        426092.90\n      <\/td>\n<td id=\"T_0fe27_row3_col2\" class=\"data row3 col2\">\n        19375\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row4\" class=\"row_heading level0 row4\">\n        40\n      <\/th>\n<td id=\"T_0fe27_row4_col0\" class=\"data row4 col0\">\n        Safari\n      <\/td>\n<td id=\"T_0fe27_row4_col1\" class=\"data row4 col1\">\n        287511.21\n      <\/td>\n<td id=\"T_0fe27_row4_col2\" class=\"data row4 col2\">\n        182245\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row5\" class=\"row_heading level0 row5\">\n        3\n      <\/th>\n<td id=\"T_0fe27_row5_col0\" class=\"data row5 col0\">\n        Amazon Silk\n      <\/td>\n<td id=\"T_0fe27_row5_col1\" class=\"data row5 col1\">\n        53458.11\n      <\/td>\n<td id=\"T_0fe27_row5_col2\" class=\"data row5 col2\">\n        561\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row6\" class=\"row_heading level0 row6\">\n        36\n      <\/th>\n<td id=\"T_0fe27_row6_col0\" class=\"data row6 col0\">\n        Opera\n      <\/td>\n<td id=\"T_0fe27_row6_col1\" class=\"data row6 col1\">\n        38162.33\n      <\/td>\n<td id=\"T_0fe27_row6_col2\" class=\"data row6 col2\">\n        5643\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row7\" class=\"row_heading level0 row7\">\n        41\n      <\/th>\n<td id=\"T_0fe27_row7_col0\" class=\"data row7 col0\">\n        Safari (in-app)\n      <\/td>\n<td id=\"T_0fe27_row7_col1\" class=\"data row7 col1\">\n        22448.18\n      <\/td>\n<td id=\"T_0fe27_row7_col2\" class=\"data row7 col2\">\n        6850\n      <\/td>\n<\/tr>\n<tr>\n<th id=\"T_0fe27_level0_row8\" class=\"row_heading level0 row8\">\n        6\n      <\/th>\n<td id=\"T_0fe27_row8_col0\" class=\"data row8 col0\">\n        Android Webview\n      <\/td>\n<td id=\"T_0fe27_row8_col1\" class=\"data row8 col1\">\n        14602.67\n      <\/td>\n<td id=\"T_0fe27_row8_col2\" class=\"data row8 col2\">\n        7865\n      <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_38_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_38_1.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" \/><\/a><\/p>\n<h2>\u7570\u306a\u308b\u5834\u6240\u3067\u306e\u8907\u6570\u5c5e\u6027\u306e\u5206\u6790<\/h2>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">def plotmap(frame, z_var, countries_col, title, colorscale, rcolor=True):\n\n    data = [ dict(\n            type = 'choropleth',\n            autocolorscale = False,\n            colorscale = colorscale,\n            showscale = True,\n            reversescale = rcolor,\n            locations = frame[countries_col],\n            z = frame[z_var],\n            locationmode = 'country names',\n            text = frame[countries_col],\n            marker = dict(line = dict(color = '#fff', width = 2))\n        )           \n    ]\n\n    layout = dict(\n        height=680,\n        #width=1200,\n        title = title,\n        geo = dict(\n            showframe = False,\n            showcoastlines = False,\n            projection = dict(type = 'mercator'),\n        ),\n    )\n    fig = dict(data=data, layout=layout)\n    iplot(fig)\n\ncolorscale = [[0, 'rgb(102,194,165)'], [0.005, 'rgb(102,194,165)'], \n              [0.01, 'rgb(171,221,164)'], [0.02, 'rgb(230,245,152)'], \n              [0.04, 'rgb(255,255,191)'], [0.05, 'rgb(254,224,139)'], \n              [0.10, 'rgb(253,174,97)'], [0.25, 'rgb(213,62,79)'], [1.0, 'rgb(158,1,66)']]\n    \n# Plot world map - total visits\ntmp = df[\"geoNetwork_country\"].value_counts().to_frame().reset_index()\nplotmap(tmp, 'geoNetwork_country', 'index', 'Total visits by Country', colorscale, False)\n\ncolorscale = [[0,\"rgb(5, 10, 172)\"],[0.35,\"rgb(40, 60, 190)\"],[0.5,\"rgb(70, 100, 245)\"],\n        [0.6,\"rgb(90, 120, 245)\"],[0.7,\"rgb(106, 137, 247)\"],[1,\"rgb(220, 220, 220)\"]]\n\n# Plot world map - total revenue\ntmp = df.groupby(\"geoNetwork_country\").agg({\"totals_transactionRevenue\" : \"sum\"}).reset_index()\nplotmap(tmp, 'totals_transactionRevenue','geoNetwork_country', 'Total revenue by country', colorscale)<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_35.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_35.png\" alt=\"\" width=\"1665\" height=\"982\" class=\"aligncenter size-full wp-image-28562\" srcset=\"\/wp-content\/uploads\/2022\/07\/Screenshot_35.png 1665w, \/wp-content\/uploads\/2022\/07\/Screenshot_35-300x177.png 300w, \/wp-content\/uploads\/2022\/07\/Screenshot_35-1024x604.png 1024w, \/wp-content\/uploads\/2022\/07\/Screenshot_35-768x453.png 768w, \/wp-content\/uploads\/2022\/07\/Screenshot_35-1536x906.png 1536w, \/wp-content\/uploads\/2022\/07\/Screenshot_35-600x354.png 600w\" sizes=\"(max-width: 1665px) 100vw, 1665px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_36.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_36.png\" alt=\"\" width=\"1646\" height=\"889\" class=\"aligncenter size-full wp-image-28563\" srcset=\"\/wp-content\/uploads\/2022\/07\/Screenshot_36.png 1646w, \/wp-content\/uploads\/2022\/07\/Screenshot_36-300x162.png 300w, \/wp-content\/uploads\/2022\/07\/Screenshot_36-1024x553.png 1024w, \/wp-content\/uploads\/2022\/07\/Screenshot_36-768x415.png 768w, \/wp-content\/uploads\/2022\/07\/Screenshot_36-1536x830.png 1536w, \/wp-content\/uploads\/2022\/07\/Screenshot_36-600x324.png 600w\" sizes=\"(max-width: 1646px) 100vw, 1646px\" \/><\/a><\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\"># Using squarify to plot an interesting distribution\ndf.loc[df[\"geoNetwork_city\"] == \"not available in demo dataset\", 'geoNetwork_city'] = np.nan\nnumber_of_colors = 20 \ncolor = [\"#\"+''.join([random.choice('0123456789ABCDEF') for j in range(6)])\n             for i in range(number_of_colors)]\n\ncity_tree = df[\"geoNetwork_city\"].value_counts() #counting \n\nprint(\"Description most frequent Citys: \" )\nprint(city_tree[:15])\n\ncity_tree = round((city_tree[:30] \/ len(df['geoNetwork_city']) * 100),2)\n\nplt.figure(figsize=(14,5))\ng = squarify.plot(sizes=city_tree.values, label=city_tree.index, \n                  value=city_tree.values,\n                  alpha=.4, color=color)\ng.set_title(\"'TOP 30 Citys - % size of total\",fontsize=20)\ng.set_axis_off()\nplt.show()<\/code><\/pre>\n<\/div>\n<pre><code>    Description most frequent Cities: \n    Mountain View       40884\n    (not set)           34262\n    New York            26371\n    San Francisco       20329\n    Sunnyvale           13086\n    London              12607\n    San Jose            10295\n    Los Angeles          8670\n    Bangkok              7709\n    Chicago              7444\n    Ho Chi Minh City     7342\n    Istanbul             6330\n    Bengaluru            5468\n    Toronto              5223\n    Hanoi                5032\n    Name: geoNetwork_city, dtype: int64\n<\/code><\/pre>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_41_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_41_1.png\" alt=\"\" width=\"1424\" height=\"645\" class=\"aligncenter size-full wp-image-28556\" \/><\/a><\/p>\n<p>\u5e97\u8217\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u9867\u5ba2\u6570\u306f\u304d\u308c\u3044\u306b\u5206\u6563\u3057\u3066\u3044\u307e\u3059\u3002\u4e0a\u4f4d5\u90fd\u5e02\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<p>\u30de\u30a6\u30f3\u30c6\u30f3\u30d3\u30e5\u30fc\u3001\u30cb\u30e5\u30fc\u30e8\u30fc\u30af\u3001\u30b5\u30f3\u30d5\u30e9\u30f3\u30b7\u30b9\u30b3\u3001\u30b5\u30cb\u30fc\u30d9\u30fc\u30eb\u3001\u30ed\u30f3\u30c9\u30f3<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">barplot_percentage('geoNetwork_networkDomain', num_bars= 10, \n                   color1='rgb(38, 115, 77)', color2='rgb(102, 204, 153)')<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_38.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/Screenshot_38.png\" alt=\"\" width=\"1646\" height=\"889\" class=\"aligncenter size-full wp-image-28563\" \/><\/a><\/p>\n<p>\u30c7\u30d0\u30a4\u30b9\u30ab\u30c6\u30b4\u30ea\u30fc\u3092\u5206\u6790\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<div class=\"clipboard\">\n<pre><code class=\"language-py\">plt.figure(figsize=(14,5))\n\nplt.subplot(1,2,1)\nsns.countplot(df[\"device_deviceCategory\"], palette=\"hls\") \nplt.title(\"Device Category Count\", fontsize=10)\nplt.xlabel(\"Category\", fontsize=12) \nplt.ylabel(\"Count\", fontsize=12) \nplt.xticks(fontsize=10)\n\nplt.subplot(1,2,2)\nsns.boxenplot(x=\"device_deviceCategory\", y = 'totals_transactionRevenue', \n              data=df[df['totals_transactionRevenue'] > 0], palette=\"hls\")\nplt.title(\"Device Category Revenue Distribuition\", fontsize=10)\nplt.xlabel(\"Category\", fontsize=12) \nplt.ylabel(\"Revenue(Log)\", fontsize=12) \nplt.xticks(fontsize=10) \n\nplt.subplots_adjust(hspace = 0.9, wspace = 0.5)\n\nplt.show() <\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_45_0.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/07\/output_45_0.png\" alt=\"\" width=\"1646\" height=\"889\" class=\"aligncenter size-full wp-image-28563\" \/><\/a><\/p>\n<p>\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u304c73.5\uff05\u3001\u30e2\u30d0\u30a4\u30eb\u304c23.12\uff05\u3001\u30bf\u30d6\u30ec\u30c3\u30c8\u304c3.38\uff05\u3067\u3059\u3002<\/p>\n<h2>6&#46; \u7d50\u8ad6<\/h2>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001Python\u3068GridDB\u3092\u4f7f\u7528\u3057\u3066\u9867\u5ba2\u306e\u8cfc\u8cb7\u30c7\u30fc\u30bf\u3092\u5206\u6790\u30fb\u8abf\u67fb\u3057\u307e\u3057\u305f\u3002\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3068\u3057\u3066\u3001(1) GridDB \u3068 (2) Pandas \u306e2\u3064\u306e\u65b9\u6cd5\u3092\u691c\u8a0e\u3057\u307e\u3057\u305f\u3002GridDB\u306f\u3001\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u3067\u62e1\u5f35\u6027\u304c\u9ad8\u3044\u305f\u3081\u3001\u5927\u304d\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u5834\u5408\u3001\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u306b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u512a\u308c\u305f\u4ee3\u66ff\u624b\u6bb5\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/github.com\/griddbnet\/Blogs\/blob\/exploring_consumer_purchases\/Exploring%20Consumer%20Purchases%20Patterns%20using%20GridDB%20and%20Python\/Exploring%20Consumer%20Purchases%20Patterns%20using%20GridDB%20and%20Python.ipynb\"> Jupyter\u30d5\u30a1\u30a4\u30eb\uff08\u5168\u6587\uff09\u306f\u3053\u3061\u3089 <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057\u3001\u5206\u6790\u3057\u3001\u6e2c\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u4f01\u696d\u306f\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3059\u308b\u6d88\u8cbb\u8005\u3092\u3088\u308a [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":49401,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1005],"tags":[],"class_list":["post-50813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1005"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT<\/title>\n<meta name=\"description\" content=\"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"og:description\" content=\"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057\" \/>\n<meta property=\"og:url\" content=\"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\" \/>\n<meta property=\"og:site_name\" content=\"GridDB: Open Source Time Series Database for IoT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/griddbcommunity\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-19T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-14T15:55:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/griddb.net\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"griddb-admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:site\" content=\"@GridDBCommunity\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"griddb-admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"10\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\"},\"author\":{\"name\":\"griddb-admin\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\"},\"headline\":\"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22\",\"datePublished\":\"2022-08-19T07:00:00+00:00\",\"dateModified\":\"2025-11-14T15:55:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\"},\"wordCount\":459,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg\",\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\",\"url\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\",\"name\":\"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT\",\"isPartOf\":{\"@id\":\"https:\/\/griddb.net\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg\",\"datePublished\":\"2022-08-19T07:00:00+00:00\",\"dateModified\":\"2025-11-14T15:55:34+00:00\",\"description\":\"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057\",\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage\",\"url\":\"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/griddb.net\/en\/#website\",\"url\":\"https:\/\/griddb.net\/en\/\",\"name\":\"GridDB: Open Source Time Series Database for IoT\",\"description\":\"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL\",\"publisher\":{\"@id\":\"https:\/\/griddb.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/griddb.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/griddb.net\/en\/#organization\",\"name\":\"Fixstars\",\"url\":\"https:\/\/griddb.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"contentUrl\":\"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png\",\"width\":200,\"height\":83,\"caption\":\"Fixstars\"},\"image\":{\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/griddbcommunity\/\",\"https:\/\/x.com\/GridDBCommunity\",\"https:\/\/www.linkedin.com\/company\/griddb-by-toshiba\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233\",\"name\":\"griddb-admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g\",\"caption\":\"griddb-admin\"},\"url\":\"https:\/\/griddb.net\/ja\/author\/griddb-admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT","description":"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057","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:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/","og_locale":"ja_JP","og_type":"article","og_title":"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT","og_description":"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057","og_url":"https:\/\/griddb.net\/ja\/\u672a\u5206\u985e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/","og_site_name":"GridDB: Open Source Time Series Database for IoT","article_publisher":"https:\/\/www.facebook.com\/griddbcommunity\/","article_published_time":"2022-08-19T07:00:00+00:00","article_modified_time":"2025-11-14T15:55:34+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/griddb.net\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg","type":"image\/jpeg"}],"author":"griddb-admin","twitter_card":"summary_large_image","twitter_creator":"@GridDBCommunity","twitter_site":"@GridDBCommunity","twitter_misc":{"\u57f7\u7b46\u8005":"griddb-admin","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"10\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#article","isPartOf":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/"},"author":{"name":"griddb-admin","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233"},"headline":"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22","datePublished":"2022-08-19T07:00:00+00:00","dateModified":"2025-11-14T15:55:34+00:00","mainEntityOfPage":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/"},"wordCount":459,"commentCount":0,"publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"image":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg","inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/","url":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/","name":"GridDB\u3068Python\u3092\u7528\u3044\u305f\u6d88\u8cbb\u8005\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u306e\u63a2\u7d22 | GridDB: Open Source Time Series Database for IoT","isPartOf":{"@id":"https:\/\/griddb.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage"},"image":{"@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg","datePublished":"2022-08-19T07:00:00+00:00","dateModified":"2025-11-14T15:55:34+00:00","description":"\u6d88\u8cbb\u8005\u884c\u52d5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u62c5\u5f53\u8005\u304c\u6d88\u8cbb\u8005\u306e\u8cfc\u8cb7\u610f\u6b32\u3092\u7406\u89e3\u3059\u308b\u4e0a\u3067\u91cd\u8981\u3067\u3059\u3002\u6d88\u8cbb\u8005\u306f\u305d\u308c\u305e\u308c\u72ec\u81ea\u306e\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u8cfc\u8cb7\u30d1\u30bf\u30fc\u30f3\u3092\u8a8d\u8b58\u3057","inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/exploring-consumer-purchases-patterns-using-griddb-and-python\/#primaryimage","url":"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg","contentUrl":"\/wp-content\/uploads\/2022\/04\/ecommerce-buying-on-a-mac_2560x1707.jpg","width":2560,"height":1707},{"@type":"WebSite","@id":"https:\/\/griddb.net\/en\/#website","url":"https:\/\/griddb.net\/en\/","name":"GridDB: Open Source Time Series Database for IoT","description":"GridDB is an open source time-series database with the performance of NoSQL and convenience of SQL","publisher":{"@id":"https:\/\/griddb.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/griddb.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/griddb.net\/en\/#organization","name":"Fixstars","url":"https:\/\/griddb.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","contentUrl":"https:\/\/griddb.net\/wp-content\/uploads\/2019\/04\/fixstars_logo_web_tagline.png","width":200,"height":83,"caption":"Fixstars"},"image":{"@id":"https:\/\/griddb.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/griddbcommunity\/","https:\/\/x.com\/GridDBCommunity","https:\/\/www.linkedin.com\/company\/griddb-by-toshiba"]},{"@type":"Person","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/4fe914ca9576878e82f5e8dd3ba52233","name":"griddb-admin","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/griddb.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bceca1cafc06886a7ba873e2f0a28011a1176c4dea59709f735b63ae30d0342?s=96&d=mm&r=g","caption":"griddb-admin"},"url":"https:\/\/griddb.net\/ja\/author\/griddb-admin\/"}]}},"_links":{"self":[{"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/comments?post=50813"}],"version-history":[{"count":1,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50813\/revisions"}],"predecessor-version":[{"id":51643,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/posts\/50813\/revisions\/51643"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/media\/49401"}],"wp:attachment":[{"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/media?parent=50813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/categories?post=50813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/griddb.net\/ja\/wp-json\/wp\/v2\/tags?post=50813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}