{"id":4607,"date":"2024-02-11T15:00:33","date_gmt":"2024-02-11T06:00:33","guid":{"rendered":"https:\/\/jfs.or.jp\/jfs-cs\/?p=4607"},"modified":"2024-02-22T10:31:01","modified_gmt":"2024-02-22T01:31:01","slug":"db001","status":"publish","type":"post","link":"https:\/\/jfs.or.jp\/jfs-cs\/db001\/","title":{"rendered":"\u30d5\u30ea\u30fc\u30bd\u30d5\u30c8\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u3000\u4f7f\u3063\u3066\u307f\u3088\u3046"},"content":{"rendered":"

\u92f3\u9020<\/em>\u306a\u3089\u3070\u3001\u88fd\u54c1\u30de\u30b9\u30bf\u30fc\u3068\u88fd\u9020\u5b9f\u7e3e\u3084\u4e0d\u826f\u767a\u751f\u3092\u30ea\u30f3\u30af\u3057\u3066\u3001\u5358\u91cdx\u751f\u7523\u6570\uff1d\u91cd\u91cf \u306e\u9805\u76ee\u3092\u4f5c\u308a\u3001\u305d\u308c\u3092\u96c6\u8a08\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u54c1\u306e\u751f\u7523\u91cf\u3084\u4e0d\u826f\u91cd\u91cf\u3092\u51fa\u3059\u3053\u3068\u3082\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u306e\u6a5f\u80fd\u3092\u4f7f\u3048\u3070\u7c21\u5358\u3067\u3059\u3002
\n\u54c1\u8cea\u7ba1\u7406\u3067\u306f\u3001\u4e0d\u826f\u5185\u5bb9\u3092\u307e\u3068\u3081\u305f\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u81a8\u5927\u306a\u4ef6\u6570\u306b\u306a\u308b\u306e\u3067\u5206\u6790\u30fb\u5206\u985e\u30fb\u96c6\u8a08\u306f\u5927\u5909\u3067\u3059\u304c\u3001\u30a8\u30af\u30bb\u30eb\u3092Access\u306b\u30ea\u30f3\u30af\u3057\u305f\u308a\u3001polars\u3084pandas\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u306b\u53d6\u308a\u8fbc\u3081\u308b\u3068\u3001\u305d\u308c\u305e\u308c\u306e\u4fbf\u5229\u306a\u6a5f\u80fd\u3092\u4f7f\u3048\u3001\u5bb9\u6613\u306b\u5206\u6790\u30fb\u5206\u985e\u30fb\u89e3\u6790\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b7\u30b9\u30c6\u30e0\u3092\u4f5c\u308b\u306e\u306f\u30d7\u30ed\u306e\u4ed5\u4e8b\u3067\u3059\u304c\u3001\u30b7\u30b9\u30c6\u30e0\u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3059\u308b\u306e\u306f\u610f\u5916\u3068\u7c21\u5358\u3067\u3059\u3002
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u51fa\u3066\u304f\u308b\u306e\u306f\u8868\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3002\u4ee3\u8868\u306f\u30a8\u30af\u30bb\u30eb\u3084CSV\u30d5\u30a1\u30a4\u30eb\u306e\u5f62\u5f0f\u3067\u3059\u3002
\nMicrosoft\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8Access\u306f\u3001\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u30ea\u30f3\u30af\u3067\u304d\u691c\u7d22\u30d7\u30ed\u30b0\u30e9\u30e0\uff08\u30af\u30a8\u30ea\u30fc\uff09\u304c\u9805\u76ee\u30c9\u30e9\u30c3\u30b0\u3059\u308b\u30de\u30a6\u30b9\u64cd\u4f5c\u3067\u81ea\u52d5\u751f\u6210\u3002
\nExcel\u306e\u5206\u6790\uff08\u9805\u76ee\u62bd\u51fa\u30fb\u884c\u62bd\u51fa\u30fb\u30de\u30b9\u30bf\u9023\u643a\uff09\u304cAccess\u304b\u3089\u4f7f\u3048\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4f5c\u6210\u52b9\u7387\u306f\u629c\u7fa4\u3067\u3001\u4e00\u5ea6\u4f5c\u308b\u3068\u3044\u3064\u3067\u3082\u518d\u5229\u7528\u3067\u304d\u308b\u3002
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u6163\u308c\u308b\u3001\u4f7f\u3044\u65b9\u3092\u5b66\u3076\u306b\u3082\u4f7f\u3048\u307e\u3059\u3002
\n\u4f5c\u6210\u3057\u305f\u30af\u30a8\u30ea\u30fc\u306f\u4ed6\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u5171\u901a\u3067\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/strong><\/span>Update\u3055\u308c\u308b\u3068\u904e\u53bb\u306e\u3082\u306e\u304c\u4f7f\u3048\u306a\u304f\u306a\u308b\u3053\u3068\u3082\u3002<\/p>\n

\u4e00\u65b9\u3067\u3001\u6700\u8fd1\u7d9a\u3005\u3068\u51fa\u3066\u304d\u305f\u9ad8\u6027\u80fd\u30d5\u30ea\u30fc\u30bd\u30d5\u30c8\uff08\u7121\u6599\uff09\u306e\u8868\u5f62\u5f0f\u6d3b\u7528\u30fb\u5206\u6790\u30bd\u30d5\u30c8\u306epolars\u3084\u3001\u9ad8\u6027\u80fd\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9duckdb\u3092\u3054\u7d39\u4ecb\u3002
\n\u3084\u308a\u65b9\u306f\u3001
\n\u30a8\u30af\u30bb\u30eb\u3092\u7121\u6599\u3067\u4f7f\u3048\u308b\u8868\u5f62\u5f0f\u30bd\u30d5\u30c8\u3000Pandas\u3084Polars\u3084Duckdb\u306b<\/span>\u8aad\u307f\u8fbc\u307f\u3001\u7121\u6599\u3067\u5229\u7528\u3067\u304d\u308b\u9ad8\u6027\u80fdDB\u30bd\u30d5\u30c8\u306e\u3000duckdb\u3000<\/span>\u3068\u9023\u643a\u3055\u305b\u308b\u3068DB\u6a5f\u80fd\u306eSQL\u306e\u30af\u30a8\u30ea\u304c\u4f7f\u3048\u307e\u3059\u3002<\/strong><\/span><\/p>\n

\uff11\uff0epython,\u00a0 polars\u3000pandas\u3000duckdb \u3092\u30d1\u30bd\u30b3\u30f3\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
\n\u3000\uff08\uff11\uff09 python<\/a>\u3001duckdb<\/a>\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
\n\u3000\uff08\uff12\uff09\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3067\u3001\u4e0b\u8a18\u3092python\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3000
\n\u00a0\u3000\u3000\u3000\u00a0 py -m pip install polars
\n\u3000\u3000\u3000\u3000py -m pip install pandas
\n\u3000\u3000\u3000\u3000py -m pip install duckdb<\/p>\n

\uff12\uff0e\u5206\u6790\u3057\u305f\u3044\u30a8\u30af\u30bb\u30eb\u3084\uff43\uff53\uff56\u30d5\u30a1\u30a4\u30eb\u3092\u6e96\u5099<\/p>\n

\uff13\uff0epython\u3000\u306e\u7d71\u5408\u958b\u767a\u74b0\u5883\u306e\u3000IDLE\u3000\u3067python\u3000\u7acb\u3061\u4e0a\u3052\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306bimport\u3059\u308b\u3002
\n\u3000\u3000\u3000import\u00a0 polars\u00a0 as\u00a0 pl
\n\u00a0 \u00a0 \u00a0 \u3000import\u00a0 duckdb<\/p>\n

\uff14\uff0epolars\u3000\u3067\u5206\u6790\u3057\u305f\u3044\u30a8\u30af\u30bb\u30eb\u3084\uff43\uff53\uff56\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080\u3002
\n\u3000\u3000\u203bpolars\u306e\u8aad\u307f\u8fbc\u307f\u4e0d\u5b89\u5b9a\u306a\u5834\u5408\u306f\u8aad\u307f\u8fbc\u307f\u884c\u6570\u5236\u9650\u3092\u89e3\u9664\u3001duckdb\u306e read_csv()\u3082\u5229\u7528\u3067\u304d\u308b\u3002
\n\u3000\u3000duckdb\u3067\u3001polars \u3067\u8aad\u307f\u8fbc\u3093\u3060DataFrame\u3092\u30c6\u30fc\u30d6\u30eb\u3068\u898b\u306a\u3057\u3066SQL\u30af\u30a8\u30ea\u30fc\u3092\u5b9f\u884c\u3057\u3001\u305d\u306e\u7d50\u679c\u3092\u8868\u793a\u3057\u305f\u308a\u3001polars\u306eDataFrame\u306b\u53d6\u308a\u3053\u3080\u3002\u7d50\u679c\u3092\u30d7\u30ea\u30f3\u30c8\u3057\u305f\u308a\u3001\u3067\u304d\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u3055\u3089\u306b\u518d\u5229\u7528\u3059\u308b\u3002
\n\u3000\u3000duckdb\u3092csv\u306e\u8aad\u307f\u8fbc\u307f\u88c5\u7f6e\u3068\u3057\u3066\u3001\u305d\u306e\u7d50\u679c\u3092polars\u306b\u6e21\u3059\u3053\u3068\u3082\u53ef\u80fd\u3002<\/p>\n

\u3000\u3000polars\u306f\u6271\u3044\u3084\u3059\u304f\u9ad8\u901f\u306a\u306e\u3067\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3081\u308c\u3070\u7c21\u5358\u306a\u624b\u9806\u3067\u30af\u30a8\u30ea\u30fc\u76f8\u5f53\u304c\u3067\u304d\u3001\u307e\u305f\u30af\u30a8\u30ea\u30fc\u3082\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n

duckdb\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u3066\u5916\u90e8\u306e\u30d5\u30a1\u30a4\u30eb\u3092table\u3068\u3057\u3066\u8aad\u307f\u8fbc\u3093\u3044\u304f\u901a\u5e38\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u624b\u9806\u304c\u3042\u308b\u304c\u3001
\n\u305d\u308c\u4ee5\u5916\u306b\u5916\u90e8\u306e\u30a8\u30af\u30bb\u30eb\u3084CSV\u30d5\u30a1\u30a4\u30eb\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6a5f\u80fd\u3092\u4f7f\u3046\u3053\u3068\u3082\u3067\u304d\u308b\u3002
\n\u4e0b\u8a18\u3067\u306f\u3001\u5f8c\u8005\u306e\u65b9\u6cd5\u4f8b\u3068\u3057\u3066\u3001polars\u3067\u5916\u90e8\u306e\u30a8\u30af\u30bb\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u3001polars\u306eDataFrame\u3092duckdb\u306etable\u3068\u3057\u3066\u5229\u7528\u3057\u3001\u305d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30af\u30a8\u30ea\u30fc\u6a5f\u80fd\u3092\u5229\u7528\u3067\u304d\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3002\u4e0b\u8a18\u306f\u3001\u89e3\u8aac\u30b5\u30a4\u30c8\u304b\u3089\u5f15\u7528\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u5206\u304b\u308a\u3084\u3059\u3044\u95a2\u4fc2\u56f3\u3067\u3059\u3002<\/p>\n

Python\u30c7\u30fc\u30bf\u5206\u6790\u306e\u305f\u3081\u306eDuckDB\uff08\u7d44\u307f\u8fbc\u307f\u7528\u9014\u306eOLAP\u7cfb\u306eRDBMS\uff09<\/a><\/p>\n

<\/p>\n

duckdb\u3092\u77e5\u308b\u306b\u306f\u3001\u672c\u5bb6\u30b5\u30a4\u30c8\u306e\u89e3\u8aac<\/a>\u304c\u8a73\u3057\u3044\u3002\u82f1\u6587\u3060\u304cWeb\u306e\u30da\u30fc\u30b8\u7ffb\u8a33\u5229\u7528\u3067\u304d\u308b\u306e\u3067\u3001\u65e5\u672c\u8a9e\u3067\u3082\u8aad\u3081\u308b\u3002<\/p>\n

\u65e5\u672c\u8a9e\u3067\u306e\u89e3\u8aac\u30b5\u30a4\u30c8\u306f\u3001\u3053\u3061\u3089\u304c\u89e3\u308a\u3084\u3059\u3044\u3002\u3044\u308d\u3044\u308d\u63a2\u3057\u3066duckdb\u306b\u305f\u3069\u308a\u7740\u3044\u305f\u3068\u3002
\nhttps:\/\/zenn.dev\/kyami\/articles\/0189f25846bbba<\/a><\/p>\n

\u30b3\u30fc\u30c9\u4f8b<\/h3>\n
\u5206\u6790\u3059\u308b\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u5185\u5bb9\r\ntest.xlsx \/ sheet = 'test_data'\u3000\r\nAA\u00a0 \u00a0BB\u00a0 \u00a0CC\r\n2\u00a0 \u00a0 20\u00a0 \u00a0200\r\n3\u00a0 \u00a0 30\u00a0 \u00a0300\r\n1\u00a0 \u00a0 10\u00a0 \u00a0100\r\n\r\nPython\u3092\u7d71\u5408\u74b0\u5883IDLE\u3067\u7acb\u3061\u4e0a\u3052\u3001python\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u30d5\u30a1\u30a4\u30eb\u3000\r\ntest.py\uff08text file\uff09\u4f5c\u6210\u3057\u4e0b\u8a18\u3092\u66f8\u304d\u8fbc\u3080\r\n\u4ee5\u4e0bcode\u5185\u5bb9\r\n\r\n#----------------------------------------------------\r\nimport polars as pl\r\nimport pandas as pd\r\nimport duckdb\r\n\r\nfilepath = \"c:\/test\/test.xlsx<\/strong><\/span>\"   #\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\r\nsheet = \"test_data\"              #\u30a8\u30af\u30bb\u30eb\u306e\u30b7\u30fc\u30c8\u540d\r\n                                 #polars\u3067\u30a8\u30af\u30bb\u30eb\u3092\u8aad\u307f\u8fbc\u3080\r\npl_data<\/span><\/strong> = pl.read_excel(\r\n\u00a0 \u00a0 source = filepath,\r\n\u00a0 \u00a0 sheet_name = sheet,\r\n\u00a0 \u00a0 )\r\nprint(pl_data, columns)  # ['AA', 'BB', 'CC']\u3000\u30af\u30a8\u30ea\u30fc\u4f5c\u6210\u306b\u5229\u7528\r\n\r\n#-----pl_data \u3092teble\u3068\u3057<\/strong><\/span>\u3001\u90e8\u5206\u3092\u62bd\u51fa\u3059\u308b\u30af\u30a8\u30ea\u30fc(\u6587\u5b57\u5217\uff09\u3092\u4f5c\u6210<\/strong><\/span>\u3001\r\n      \u8907\u6570\u9078\u629e\u9805\u76ee\u306f\u533a\u5207\u308a\u6587\u5b57\u300c,\u300d\u3092\u4f7f\u7528\u3001\u7d42\u4e86\u306f \u300c;\u300d\r\n#-----\u8907\u6570\u884c\u306e\u5834\u5408\u306f\u3001\u524d\u5f8c\u3092\u3000\u300c\"\"\"<\/strong><\/span>\u300d\u3067\u56f2\u3080\u3068\u898b\u3084\u3059\u304f\u3067\u304d\u308b\r\n\r\nq<\/strong><\/span> = \"\"\"<\/span>\r\n\u00a0 \u00a0 select AA, BB\r\n\u00a0 \u00a0 from\u00a0 pl_data<\/strong><\/span>\r\n\u00a0 \u00a0 group by AA, BB\r\n\u00a0 \u00a0 order by AA ;\r\n\u00a0 \u00a0 \"\"\"<\/strong><\/span>\r\n#-----------------------------\r\npl_data2<\/strong><\/span> = duckdb.sql(q<\/strong><\/span>).pl()\u00a0 \u00a0 #\u30af\u30a8\u30ea\u30fc\u7d50\u679c\u3092pl\u306eDataFrame \u3078\r\nprint(pl_data2) \r\nAA\u00a0 \u00a0BB\r\n1\u00a0 \u00a0 10\r\n2\u00a0 \u00a0 20\r\n3\u00a0 \u00a0 30\r\n#----------\r\n\u9078\u629e\u3057\u305f\u9805\u76ee\u3060\u3051\u306b\u306a\u308a\u3001\u30c7\u30fc\u30bf\u306e\u5927\u304d\u3055\u9806\u306b\u30bd\u30fc\u30c8\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/pre>\n
\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u3001\u30a8\u30af\u30bb\u30eb\u306e\u7279\u5b9a\u306e\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092polars\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306b\u8aad\u307f\u8fbc\u307f\u3001 
\n\u5206\u6790\u306b\u7528\u3044\u308b\u9805\u76ee\u540d\u4e00\u89a7\u3092\u30d7\u30ea\u30f3\u30c8\u3057\u3001 
\n\u305d\u308c\u3092duckdb\u306etable\u3068\u3057\u3066\u5229\u7528\u3057\u3001sql\u3067\u5fc5\u8981\u306a\u9805\u76ee\u540d\u3092\u9078\u629e\u62bd\u51fa\u3057\u3001
\n\u30c7\u30fc\u30bf\u3092\u7279\u5b9a\u306e\u9805\u76ee\u3067\u4e26\u3073\u66ff\u3048\u3066\u3044\u307e\u3059\u3002
\n\u30a8\u30af\u30bb\u30eb\u306e\u90e8\u5206\u96c6\u5408\u3092\u5bb9\u6613\u306b\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\n<\/span>\u4f5c\u3063\u305f\u90e8\u5206\u96c6\u5408\u3092polars\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u306b\u8aad\u307f\u8fbc\u3080\u3053\u3068\u3067\u3001
\n\u72ec\u7acb\u3057\u305f\u30d5\u30a1\u30a4\u30eb\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u3068\u3057\u3066\u518d\u5229\u7528\u3082\u3067\u304d\u307e\u3059\u3002
\n\u307e\u305f\u3001polars\u306e\u884c\u9078\u629e\uff08filter\uff09\u3084duckdb\u306e\u884c\u9078\u629e\uff08where, having\uff09\u3092\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u307e\u305f\u3001\u5225\u306e\u8868\u3068\u30ad\u30fc\u9805\u76ee\u3067\u30ea\u30f3\u30af\u3057\u3066\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u306b\u5206\u6790\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002
\n\u92f3\u9020\u306a\u3089\u3070\u3001\u88fd\u54c1\u30de\u30b9\u30bf\u30fc\u306e\u5358\u91cd\u3068\u88fd\u9020\u6570\u5b9f\u7e3e\u3092\u5171\u901a\u3059\u308b\u54c1\u7a2e\u30b3\u30fc\u30c9\u3067\u30ea\u30f3\u30af\u3057\u3066\u3001\u5358\u91cd\uff58\u751f\u7523\u6570\uff1d\u91cd\u91cf\u3000\u306e\u9805\u76ee\u3092\u4f5c\u308a\u3001\u305d\u308c\u3092\u96c6\u8a08\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u54c1\u306e\u751f\u7523\u91cf\u3092\u51fa\u3059\u3053\u3068\u3082\u5bb9\u6613\u3067\u3059\u3002
\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u306b\u5229\u7528\u3059\u308b\u306b\u306f\u3001\uff12\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30ad\u30fc\u9805\u76ee\u4e00\u81f4\u3067\u3064\u306a\u304e\u5408\u308f\u305b\u307e\u3059\u3002<\/p>\n
SQL\u7d20\u4eba\u3067\u3082\u5206\u304b\u308b\u30c6\u30fc\u30d6\u30eb\u7d50\u5408(inner join\u3068outer join)<\/a>\u3000\u304c\u89e3\u308a\u3084\u3059\u3044\u3002\u4ed6\u306b\u3082\u89e3\u8aac\u306f\u591a\u6570\u3042\u308a\u307e\u3059\u3002\u7814\u7a76\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u3053\u308c\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u751f\u7523\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u3084\u3001\u54c1\u8cea\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u5206\u3067\u5206\u6790\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u5143\u306e\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306f\u305d\u306e\u307e\u307e\u3067\u3001\u3044\u308d\u3044\u308d\u306a\u5206\u6790\u304c\u9ad8\u901f\u3067\u3067\u304d\u308b\u3063\u3066\u3001\u3042\u308a\u304c\u305f\u3044\u3067\u3059\u306d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u92f3\u9020\u306a\u3089\u3070\u3001\u88fd\u54c1\u30de\u30b9\u30bf\u30fc\u3068\u88fd\u9020\u5b9f\u7e3e\u3084\u4e0d\u826f\u767a\u751f\u3092\u30ea\u30f3\u30af\u3057\u3066\u3001\u5358\u91cdx\u751f\u7523\u6570\uff1d\u91cd\u91cf \u306e\u9805\u76ee\u3092\u4f5c\u308a\u3001\u305d\u308c\u3092\u96c6\u8a08\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u54c1\u306e\u751f\u7523\u91cf\u3084\u4e0d\u826f\u91cd\u91cf\u3092\u51fa\u3059\u3053\u3068\u3082\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bd\u30d5\u30c8\u306e\u6a5f\u80fd\u3092\u4f7f\u3048\u3070\u7c21\u5358\u3067\u3059\u3002 \u54c1\u8cea\u7ba1\u7406\u3067\u306f\u3001\u4e0d\u826f\u5185\u5bb9\u3092\u307e …","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"vk-ltc-link":"","vk-ltc-target":"0","footnotes":""},"categories":[24],"tags":[],"class_list":["post-4607","post","type-post","status-publish","format-standard","hentry","category-iot-it"],"_links":{"self":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/4607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/comments?post=4607"}],"version-history":[{"count":41,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/4607\/revisions"}],"predecessor-version":[{"id":4656,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/posts\/4607\/revisions\/4656"}],"wp:attachment":[{"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/media?parent=4607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/categories?post=4607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jfs.or.jp\/jfs-cs\/wp-json\/wp\/v2\/tags?post=4607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}