{"id":3476,"date":"2025-01-16T06:58:50","date_gmt":"2025-01-15T21:58:50","guid":{"rendered":"https:\/\/secondlife.lol\/?p=3476"},"modified":"2025-01-16T21:51:27","modified_gmt":"2025-01-16T12:51:27","slug":"excel-to-r-sqlite-data-analysis-guide","status":"publish","type":"post","link":"https:\/\/secondlife.lol\/ja\/excel-to-r-sqlite-data-analysis-guide\/","title":{"rendered":"Excel\u304b\u3089R SQLite DB\u3078\uff1a\u30c7\u30fc\u30bf\u5206\u6790\u306e\u65b0\u3057\u3044\u5730\u5e73\u7dda"},"content":{"rendered":"<style>.kb-image3476_07e492-ed .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image3476_07e492-ed img.kb-img, .kb-image3476_07e492-ed .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}<\/style>\n<div class=\"wp-block-kadence-image kb-image3476_07e492-ed\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"699\" height=\"402\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-8.png\" alt=\"\uc5d1\uc140\uc5d0\uc11c R SQLite DB\ub85c \ub2e8\uacc4 \uc694\uc57d \uc774\ubbf8\uc9c0\" class=\"kb-img wp-image-4475\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-8.png 699w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-8-300x173.png 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-8-600x345.png 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-8-18x10.png 18w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><figcaption>( \u30a8\u30af\u30bb\u30eb\u304b\u3089R SQLite DB\u3078\u306e\u30b9\u30c6\u30c3\u30d7\u307e\u3068\u3081 )<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u3053\u3093\u306b\u3061\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3092\u611b\u3059\u308b\u7686\u3055\u3093\uff01\u4eca\u65e5\u306f\u3001\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u7720\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u547c\u3073\u899a\u307e\u3057\u3066 <a href=\"https:\/\/www.r-project.org\/\" target=\"_blank\" rel=\"noopener\">R<\/a> SQLite\u306e\u9b54\u6cd5\u3067\u5206\u6790\u3057\u3001\u7d20\u6575\u306a\u30b0\u30e9\u30d5\u3067\u8868\u73fe\u3059\u308b\u65b9\u6cd5\u3092\u5b66\u3073\u307e\u3059\u3002 \"\u3048\u3063\u3001\u305d\u3093\u306a\u3053\u3068\u3067\u304d\u308b\u306e\uff1f\"\u3068\u601d\u3063\u305f\u65b9\u3001\u3088\u3046\u3053\u305d\uff01 <\/p>\n\n\n\n<p>\u3053\u306e\u30dd\u30b9\u30c8\u306b\u5f93\u3048\u3070\u3001\u7686\u3055\u3093\u3082\u3059\u3050\u306b\u30c7\u30fc\u30bf\u5206\u6790\u30a6\u30a3\u30b6\u30fc\u30c9\u306b\u306a\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305d\u308c\u3067\u306f\u3001\u79c1\u305f\u3061\u306eR SQLite\u3092\u5229\u7528\u3057\u3066Excel\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3059\u308b\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u59cb\u3081\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n<style>.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-right:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);padding-left:var(--global-kb-spacing-sm, 1.5rem);border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title-wrap{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title-wrap{color:var(--global-palette2, #2B6CB0);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{color:var(--global-palette2, #2B6CB0);font-size:28px;font-weight:regular;font-style:normal;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap .kb-table-of-content-list{color:var(--global-palette1, #3182CE);line-height:2em;font-weight:regular;font-style:normal;margin-top:var(--global-kb-spacing-sm, 1.5rem);margin-right:0px;margin-bottom:0px;margin-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap .kb-table-of-content-list .kb-table-of-contents__entry:hover{color:var(--global-palette6, #718096);}@media all and (max-width: 1024px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);}}@media all and (max-width: 1024px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{font-size:28px;}}@media all and (max-width: 767px){.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-content-wrap{border-top:3px solid var(--global-palette2, #2B6CB0);border-right:3px solid var(--global-palette2, #2B6CB0);border-bottom:3px solid var(--global-palette2, #2B6CB0);border-left:3px solid var(--global-palette2, #2B6CB0);}.kb-table-of-content-nav.kb-table-of-content-id83_5f28a6-34 .kb-table-of-contents-title{font-size:28px;}}<\/style>\n\n\n<h2 class=\"wp-block-heading\">\u7528\u610f\u3059\u308b\u3082\u306e: \u79c1\u305f\u3061\u306e\u9b54\u6cd5\u306e\u9053\u5177<\/h2>\n\n\n\n<p>\u307e\u305a\u3001\u79c1\u305f\u3061\u306e\u9b54\u6cd5\u306e\u30c4\u30fc\u30eb\u3092\u6e96\u5099\u3057\u307e\u3057\u3087\u3046\u3002R SQLite\u3001readxl\u3001\u305d\u3057\u3066\u3044\u304f\u3064\u304b\u306e\u5fc5\u9808\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\ninstall.packages(c(\"RSQLite\", \"readxl\", \"ggplot2\", \"dplyr\"))\n\n#\u30d1\u30c3\u30b1\u30fc\u30b8\u8aad\u307f\u8fbc\u307f\nlibrary(RSQLite)\nlibrary(readxl)\nlibrary(ggplot2)\nlibrary(dplyr)<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>install.packages()<\/code>: \u5b9f\u884c\u3057\u3088\u3046\u3068\u3059\u308b\u4f5c\u696d\u306b\u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>\u30e9\u30a4\u30d6\u30e9\u30ea()<\/code>: \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u30d1\u30c3\u30b1\u30fc\u30b8\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u304b\u3089\u3068\u3044\u3063\u3066\u305d\u306e\u307e\u307e\u4f7f\u3048\u308b\u308f\u3051\u3067\u306f\u306a\u304f\u3001library()\u3092\u4f7f\u3063\u3066\u305d\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u547c\u3073\u51fa\u3057\u3066\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">R SQLite\u306e\u7d20\u6674\u3089\u3057\u3044\u30b3\u30e9\u30dc\u30ec\u30fc\u30b7\u30e7\u30f3\uff1a\u306a\u305c\u826f\u3044\u306e\u304b\uff1f<\/h2>\n\n\n<style>.kb-image3476_929b26-2a .kb-image-has-overlay:after{opacity:0.3;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;}.kb-image3476_929b26-2a img.kb-img, .kb-image3476_929b26-2a .kb-img img{border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-right-radius:5px;border-bottom-left-radius:5px;box-shadow:0px 0px 14px 0px rgba(0, 0, 0, 0.2);}<\/style>\n<div class=\"wp-block-kadence-image kb-image3476_929b26-2a\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"758\" height=\"503\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-7.png\" alt=\"R SQLite \ucf5c\ub77c\ubcf4 \uc7a5\uc810 \uc694\uc57d \uc774\ubbf8\uc9c0\" class=\"kb-img wp-image-4472\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-7.png 758w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-7-300x199.png 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-7-600x398.png 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/image-7-18x12.png 18w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><figcaption>( R SQLite\u30b3\u30e9\u30dc\u306e\u30e1\u30ea\u30c3\u30c8\u307e\u3068\u3081 )<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u7686\u3055\u3093\u3001\u5f85\u3063\u3066\u304f\u3060\u3055\u3044\uff01\u79c1\u305f\u3061\u304c\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3092SQLite\u306b\u79fb\u3057\u3066R\u3068\u9023\u52d5\u3059\u308b\u7406\u7531\u304c\u6c17\u306b\u306a\u308a\u307e\u305b\u3093\u304b\uff1f \u3053\u308c\u304c\u306a\u305c\u826f\u3044\u65b9\u6cd5\u306a\u306e\u304b\u4e00\u7dd2\u306b\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u51e6\u7406\u901f\u5ea6\u304c\u901f\u304f\u306a\u308a\u307e\u3059<\/strong>: SQLite\u306f\u5927\u5bb9\u91cf\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u3001Excel\u3088\u308a\u306f\u308b\u304b\u306b\u9ad8\u901f\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30e1\u30e2\u30ea\u4f7f\u7528\u304c\u52b9\u7387\u7684\u3067\u3059<\/strong>\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3060\u3051\u3092\u30e1\u30e2\u30ea\u306b\u8f09\u305b\u3066\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3092\u5b88\u3063\u3066\u304f\u308c\u308b<\/strong>: \u8aa4\u3063\u3066\u30c7\u30fc\u30bf\u3092\u58ca\u3057\u3066\u3057\u307e\u3046\u5fc3\u914d\u304c\u6e1b\u308a\u307e\u3057\u305f\u3002<\/li>\n\n\n\n<li><strong>\u8907\u96d1\u306a\u30af\u30a8\u30ea\u304c\u53ef\u80fd\u3067\u3059<\/strong>: SQL\u306e\u5f37\u529b\u306a\u6a5f\u80fd\u306b\u3088\u308a\u3001\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u64cd\u4f5c\u3082\u7c21\u5358\u306b\u884c\u3048\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u518d\u73fe\u6027\u306e\u3042\u308b\u5206\u6790\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059<\/strong>: \u5206\u6790\u306e\u904e\u7a0b\u3092\u7c21\u5358\u306b\u8a18\u9332\u3057\u3001\u518d\u73fe\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30b3\u30e9\u30dc\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u697d\u306b\u306a\u308b<\/strong>: SQLite\u30d5\u30a1\u30a4\u30eb\u306f\u5171\u6709\u3057\u3084\u3059\u304f\u3001\u4e00\u7dd2\u306b\u4f5c\u696d\u3059\u308b\u306e\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u69d8\u3005\u306a\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3068\u306e\u63a5\u7d9a\u304c\u53ef\u80fd\u3067\u3059<\/strong>: \u3055\u307e\u3056\u307e\u306a\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3092SQLite\u3067\u53ce\u96c6\u3057\u3066R\u3068\u63a5\u7d9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d71\uff1a\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f<\/h2>\n\n\n\n<p>\u305d\u308c\u3067\u306f\u3001\u79c1\u305f\u3061\u306e\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3092R\u306b\u53d6\u308a\u8fbc\u3093\u3067\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\nexcel_data &lt;- read_excel(&quot;your_data.xlsx&quot;)\n\n# \u30c7\u30fc\u30bf\u78ba\u8a8d\nhead(excel_data)<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>read_excel()<\/code>.excel\u30d5\u30a1\u30a4\u30eb\u3092R\u3067\u8aad\u307f\u8fbc\u307f\u307e\u3059\uff1aExcel\u30d5\u30a1\u30a4\u30eb\u3092R\u3067\u8aad\u307f\u8fbc\u307f\u307e\u3059\u3002 your_data.xlsx\u30d5\u30a1\u30a4\u30eb\u304cR\u30d5\u30a1\u30a4\u30eb\u3068\u540c\u3058\u4f4d\u7f6e\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308c\u3070OK\u3067\u3059\u3002<\/li>\n\n\n\n<li><code>head()<\/code>.excel\u30d5\u30a1\u30a4\u30eb\u3092\u8868\u793a\u3057\u307e\u3059\uff1a\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u304c\u6b63\u3057\u304f\u8aad\u307f\u8fbc\u307e\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306b\u3001\u30c7\u30fc\u30bf\u306e\u5148\u982d\u90e8\u5206\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d72\uff1aSQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u63a5\u7d9a\u3059\u308b<\/h2>\n\n\n\n<p>\u4eca\u5ea6\u306f\u79c1\u305f\u3061\u306e\u30c7\u30fc\u30bf\u3092SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\ncon &lt;- dbConnect(RSQLite::SQLite(), &quot;my_database.db&quot;)\n\n# \u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3092SQLite\u30c6\u30fc\u30d6\u30eb\u306b\u4fdd\u5b58\u3059\u308b\ndbWriteTable(con, &quot;my_table&quot;, excel_data, overwrite = TRUE)<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>dbConnect()<\/code>: SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>dbWriteTable()<\/code>\uff1aExcel\u30c7\u30fc\u30bf\u3092SQLite\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d73\uff1aSQL\u30af\u30a8\u30ea\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/h2>\n\n\n\n<p>\u3055\u3042\u3001SQL\u306e\u9b54\u6cd5\u3092\u304b\u3051\u308b\u6642\u9593\u3067\u3059\uff01<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># SQL\u30af\u30a8\u30ea\u5b9f\u884c\nquery  100\"\nresult &lt;- dbGetQuery(con, query)\n\n# \u7d50\u679c\u78ba\u8a8d\nhead(result)<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>SQL\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>dbGetQuery()<\/code>: SQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u7d50\u679c\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>head()<\/code>: \u30af\u30a8\u30ea\u7d50\u679c\u306e\u5148\u982d\u90e8\u5206\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d74\uff1aR\u3067\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3059\u308b<\/h2>\n\n\n\n<p>SQL\u3067\u53d6\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u3092R\u3067\u3055\u3089\u306b\u5206\u6790\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u5e73\u5747\u8a08\u7b97\nmean_value &lt;- mean(result$column_name, na.rm = TRUE)\nprint(paste(&quot;\u5e73\u5747\u5024:&quot;, mean_value))\n\n# dplyr\u306b\u3088\u308b\u30c7\u30fc\u30bf\u64cd\u4f5c\nfiltered_data %\n  filter(column_name &gt; meanan_value) %&gt;%\n  arrange(desc(column_name))\n\nprint(head(filtered_data))<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>\u5e73\u5747()<\/code>: \u7279\u5b9a\u306e\u5217\u306e\u5e73\u5747\u5024\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>%&gt;%<\/code>: dplyr \u306e\u30d1\u30a4\u30d7\u6f14\u7b97\u5b50\u3067\u3001\u8907\u6570\u306e\u30bf\u30b9\u30af\u3092\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>filter()<\/code>\u6761\u4ef6\u306b\u5408\u308f\u305b\u3066\u30c7\u30fc\u30bf\u306e\u307f\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>arrange()<\/code>.\u30c7\u30fc\u30bf\u3092\u30bd\u30fc\u30c8\u3057\u307e\u3059\uff1a\u30c7\u30fc\u30bf\u3092\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>print()<\/code>: \u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306e\u5148\u982d\u90e8\u5206\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d75: ggplot2\u3067\u30c7\u30fc\u30bf\u3092\u8996\u899a\u5316\u3059\u308b<\/h2>\n\n\n\n<p>\u3044\u3088\u3044\u3088\u79c1\u305f\u3061\u306e\u30c7\u30fc\u30bf\u3092\u7d20\u6575\u306a\u30b0\u30e9\u30d5\u306b\u5909\u8eab\u3055\u305b\u308b\u6642\u9593\u3067\u3059\uff01<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u68d2\u30b0\u30e9\u30d5\u3092\u63cf\u304f\nggplot(result, aes(x = category, y = value)) + ggplot(result, aes(x = category, y = value))\n  geom_bar(stat = \"identity\", fill = \"skyblue\") + +...\n  theme_minimal() + +...\n  labs(title = \"My Awesome Graph\", x = \"Category\", y = \"Value\")<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><code>ggplot()<\/code>: \u30b0\u30e9\u30d5\u306e\u57fa\u672c\u7684\u306a\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>geom_bar()<\/code>\u68d2\u30b0\u30e9\u30d5\u3092\u63cf\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>theme_minimal()<\/code>: \u30b0\u30e9\u30d5\u306e\u30c6\u30fc\u30de\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><code>labs()<\/code>: \u30b0\u30e9\u30d5\u306e\u30bf\u30a4\u30c8\u30eb\u3068\u8ef8\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u521d\u5fc3\u8005\u5411\u3051\u7528\u8a9e\u89e3\u8aac<\/h2>\n\n\n\n<p>\u7686\u3055\u3093\u3001\u3053\u308c\u307e\u3067\u591a\u304f\u306e\u65b0\u3057\u3044\u7528\u8a9e\u3092\u8033\u306b\u3057\u305f\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u5c11\u3057\u96e3\u3057\u304f\u611f\u3058\u307e\u305b\u3093\u3067\u3057\u305f\u304b\uff1f \u5fc3\u914d\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\uff01\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u4e3b\u8981\u306a\u7528\u8a9e\u3092\u7c21\u5358\u306b\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>R<\/strong>\u30c7\u30fc\u30bf\u5206\u6790\u306e\u305f\u3081\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u3067\u3059\uff1a\u30c7\u30fc\u30bf\u5206\u6790\u306e\u305f\u3081\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u3067\u3059\u3002 \u30c7\u30fc\u30bf\u3092\u8abf\u7406\u3059\u308b\u30ad\u30c3\u30c1\u30f3\u3060\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\uff01<\/li>\n\n\n\n<li><strong>SQLite<\/strong>:\u8efd\u91cf\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b7\u30b9\u30c6\u30e0\u3067\u3059\u3002 \u30c7\u30fc\u30bf\u3092\u4f53\u7cfb\u7684\u306b\u4fdd\u5b58\u3059\u308b\u5009\u5eab\u3068\u304a\u8003\u3048\u304f\u3060\u3055\u3044\u3002<\/li>\n\n\n\n<li><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/strong>:\u60c5\u5831\u3092\u4fdd\u5b58\u3057\u3066\u7ba1\u7406\u3059\u308b\u5927\u304d\u306a\u5009\u5eab\u3067\u3059\u3002 \u3042\u306a\u305f\u306e\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u306e\u9023\u7d61\u5148\u30ea\u30b9\u30c8\u3082\u4e00\u7a2e\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>SQL<\/strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u5bfe\u8a71\u3059\u308b\u8a00\u8a9e\u3067\u3059\uff1a\"Structure Query Language\"\u306e\u7565\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u5bfe\u8a71\u3059\u308b\u8a00\u8a9e\u3067\u3001\u30c7\u30fc\u30bf\u3092\u63a2\u3057\u3066\u6574\u7406\u3059\u308b\u547d\u4ee4\u3092\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30af\u30a8\u30ea(Query)<\/strong>.\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u9001\u308b\u8cea\u554f\u3084\u30b3\u30de\u30f3\u30c9\u3067\u3059\uff1a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u9001\u308b\u8cea\u554f\u3084\u30b3\u30de\u30f3\u30c9\u3067\u3059\u3002 \u4f8b\u3048\u3070\u3001\u300c20\u6b73\u4ee5\u4e0a\u306e\u4eba\u306e\u540d\u524d\u3092\u6559\u3048\u3066\u304f\u308c\u300d\u3068\u8a00\u3046\u3088\u3046\u306a\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30d1\u30c3\u30b1\u30fc\u30b8(Package)<\/strong>: R\u3067\u4f7f\u7528\u3067\u304d\u308b\u8ffd\u52a0\u6a5f\u80fd\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3059\u3002 \u6599\u7406\u3092\u3059\u308b\u3068\u304d\u306b\u4f7f\u3046\u30c4\u30fc\u30eb\u30bb\u30c3\u30c8\u3068\u8003\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n\n\n\n<li><strong>ggplot2<\/strong>: R\u3067\u30b0\u30e9\u30d5\u3092\u63cf\u304f\u305f\u3081\u306e\u5f37\u529b\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3067\u3059\u3002 \u30c7\u30fc\u30bf\u3092\u304d\u308c\u3044\u306b\u3059\u308b\u9b54\u6cd5\u306e\u30c4\u30fc\u30eb\u3060\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\uff01<\/li>\n\n\n\n<li><strong>dplyr<\/strong>\u3067\u3059\uff1a\u30c7\u30fc\u30bf\u3092\u6574\u7406\u30fb\u5909\u5f62\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3059\u308bR\u30d1\u30c3\u30b1\u30fc\u30b8\u3067\u3059\u3002 \u30c7\u30fc\u30bf\u3092\u6d17\u3063\u3066\u6574\u3048\u308b\u30c4\u30fc\u30eb\u3068\u8003\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n\n\n\n<li><strong>\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0(Data Frame)<\/strong>: R\u3067\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3059\u308b\u57fa\u672c\u7684\u306a\u5f62\u5f0f\u3067\u3059\u3002 \u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u306b\u4f3c\u3066\u3044\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u95a2\u6570(Function)<\/strong>:\u7279\u5b9a\u306e\u30bf\u30b9\u30af\u3092\u5b9f\u884c\u3059\u308b\u30b3\u30fc\u30c9\u306e\u675f\u3067\u3059\u3002 \u6599\u7406\u306e\u30ec\u30b7\u30d4\u306e\u3088\u3046\u306b\u3001\u6c7a\u3081\u3089\u308c\u305f\u9806\u5e8f\u3067\u30bf\u30b9\u30af\u3092\u51e6\u7406\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u7d42\u4e86<\/h2>\n\n\n\n<p>\u6700\u5f8c\u306b\u3001\u79c1\u305f\u3061\u306e\u9b54\u6cd5\u306e\u5100\u5f0f\u3092\u304d\u308c\u3044\u306b\u7de0\u3081\u304f\u304f\u308a\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u7d42\u4e86\ndbDisconnect(con)<\/code><\/pre>\n\n\n\n<p><strong>\u30b3\u30fc\u30c9\u89e3\u91c8<\/strong><\/p>\n\n\n\n<p>    <code>dbDisconnect()<\/code>: SQLite\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u63a5\u7d9a\u3092\u5b89\u5168\u306b\u7d42\u4e86\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3055\u3042\u3001\u3053\u308c\u3067\u79c1\u305f\u3061\u306eR SQLite\u306eExcel\u30c7\u30fc\u30bf\u5206\u6790\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u306f\u7d42\u308f\u308a\u307e\u3057\u305f\uff01\u3044\u304b\u304c\u3067\u3057\u305f\u304b\uff1f \u601d\u3063\u305f\u3088\u308a\u96e3\u3057\u304f\u306a\u3044\u3067\u3059\u3088\u306d\uff1f \u3053\u308c\u3067\u7686\u3055\u3093\u306fExcel\u30c7\u30fc\u30bf\u3092R SQLite\u3067\u9023\u52d5\u3057\u3066\u5206\u6790\u3057\u3066\u8996\u899a\u5316\u3059\u308b\u57fa\u672c\u304c\u8eab\u306b\u3064\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3092\u901a\u3058\u3066\u3001Excel\u30c7\u30fc\u30bf\u3092R\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3001SQLite\u306b\u4fdd\u5b58\u3057\u3001SQL\u30af\u30a8\u30ea\u3067\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u3001R\u3067\u5206\u6790\u3057\u3001\u305d\u3057\u3066\u7d20\u6575\u306a\u30b0\u30e9\u30d5\u3067\u8868\u73fe\u3059\u308b\u65b9\u6cd5\u3092\u5b66\u3073\u307e\u3057\u305f\u3002 \u3053\u306e\u3059\u3079\u3066\u306e\u30d7\u30ed\u30bb\u30b9\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u57fa\u672c\u3068\u306a\u308b\u91cd\u8981\u306a\u30b9\u30c6\u30c3\u30d7\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"># \u88dc\u8db3\u8aac\u660e - DB\u63a5\u7d9a\u7d42\u4e86\u4f5c\u696d\u306e\u7406\u7531<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>dbDisconnect(con)\u30b9\u30c6\u30c3\u30d7\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u3092\u5b89\u5168\u306b\u7d42\u4e86\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u3067\u3059\u3002\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u91cd\u8981\u306a\u7406\u7531\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30ea\u30bd\u30fc\u30b9\u7ba1\u7406: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306f\u30b7\u30b9\u30c6\u30e0\u30ea\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u63a5\u7d9a\u3092\u660e\u793a\u7684\u306b\u7d42\u4e86\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u308c\u3089\u306e\u30ea\u30bd\u30fc\u30b9\u3092\u3059\u3050\u306b\u89e3\u653e\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u6574\u5408\u6027: \u958b\u3044\u3066\u3044\u308b\u63a5\u7d9a\u3067\u9032\u884c\u4e2d\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u3042\u308b\u5834\u5408\u3001\u63a5\u7d9a\u3092\u7d42\u4e86\u3059\u308b\u3068\u3001\u3053\u308c\u3092\u5b8c\u4e86\u307e\u305f\u306f\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3: \u958b\u3044\u3066\u3044\u308b\u63a5\u7d9a\u306f\u3001\u6f5c\u5728\u7684\u306a\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30ea\u30b9\u30af\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u63a5\u7d9a\u3092\u7d42\u4e86\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u306e\u30ea\u30b9\u30af\u3092\u6e1b\u3089\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u540c\u6642\u6027\u5236\u5fa1\uff1a\u4ed6\u306e\u30d7\u30ed\u30bb\u30b9\u3084\u30e6\u30fc\u30b6\u30fc\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u30ea\u30fc\u30af\u9632\u6b62: \u63a5\u7d9a\u3092\u660e\u793a\u7684\u306b\u7d42\u4e86\u3057\u306a\u3044\u3068\u3001\u30e1\u30e2\u30ea\u30ea\u30fc\u30af\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<p>\u3057\u305f\u304c\u3063\u3066\u3001dbDisconnect(con)\u3092\u4f7f\u7528\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u3092\u7d42\u4e86\u3059\u308b\u3053\u3068\u306f\u3001\u826f\u3044\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u6163\u884c\u3067\u3042\u308a\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u5b89\u5b9a\u6027\u3068\u52b9\u7387\u3092\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002<\/p>\n<\/blockquote>\n\n\n<style>.kb-image4457_249bea-0c.kb-image-is-ratio-size, .kb-image4457_249bea-0c .kb-image-is-ratio-size{max-width:300px;width:100%;}.wp-block-kadence-column > .kt-inside-inner-col > .kb-image4457_249bea-0c.kb-image-is-ratio-size, .wp-block-kadence-column > .kt-inside-inner-col > .kb-image4457_249bea-0c .kb-image-is-ratio-size{align-self:unset;}.kb-image4457_249bea-0c figure{max-width:300px;}.kb-image4457_249bea-0c .image-is-svg, .kb-image4457_249bea-0c .image-is-svg img{width:100%;}.kb-image4457_249bea-0c .kb-image-has-overlay:after{opacity:0.3;}<\/style>\n<div class=\"wp-block-kadence-image kb-image4457_249bea-0c\"><figure class=\"aligncenter size-medium\"><img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-300x300.webp\" alt=\"\ud14c\ub9ac \uc774\ubaa8\ud2f0\ucf58\" class=\"kb-img wp-image-4456\" srcset=\"https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-300x300.webp 300w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-600x600.webp 600w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-150x150.webp 150w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-768x768.webp 768w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding-12x12.webp 12w, https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/teri-coding.webp 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><figcaption><strong>( \u697d\u3057\u304f\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3057\u307e\u3057\u3087\u3046\uff01 )<\/strong><\/figcaption><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3092\u611b\u3059\u308b\u7686\u3055\u3093\uff01\u4eca\u65e5\u306f\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u7720\u3063\u3066\u3044\u308b...<\/p>","protected":false},"author":3,"featured_media":4531,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[6],"tags":[38,747,489,164,746],"class_list":["post-3476","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-r-coding","tag-r","tag-sql-","tag-sqlite","tag-164","tag-746"],"taxonomy_info":{"category":[{"value":6,"label":"\uc54c(R)"}],"post_tag":[{"value":38,"label":"R"},{"value":747,"label":"SQL \ud29c\ud1a0\ub9ac\uc5bc"},{"value":489,"label":"SQLite"},{"value":164,"label":"\ub370\uc774\ud130 \uc2dc\uac01\ud654"},{"value":746,"label":"\uc5d1\uc140 \ub370\uc774\ud130 \ubd84\uc11d"}]},"featured_image_src_large":["https:\/\/secondlife.lol\/wp-content\/uploads\/2025\/01\/R-SQLite-DB-\ud3ec\uc2a4\ud2b8-\uc378\ub124\uc77c-600x600.jpg",600,600,true],"author_info":{"display_name":"TERE","author_link":"https:\/\/secondlife.lol\/ja\/author\/tere\/"},"comment_info":0,"category_info":[{"term_id":6,"name":"\uc54c(R)","slug":"r-coding","term_group":0,"term_taxonomy_id":6,"taxonomy":"category","description":"","parent":20,"count":61,"filter":"raw","cat_ID":6,"category_count":61,"category_description":"","cat_name":"\uc54c(R)","category_nicename":"r-coding","category_parent":20}],"tag_info":[{"term_id":38,"name":"R","slug":"r","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":747,"name":"SQL \ud29c\ud1a0\ub9ac\uc5bc","slug":"sql-%ed%8a%9c%ed%86%a0%eb%a6%ac%ec%96%bc","term_group":0,"term_taxonomy_id":747,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":489,"name":"SQLite","slug":"sqlite","term_group":0,"term_taxonomy_id":489,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":164,"name":"\ub370\uc774\ud130 \uc2dc\uac01\ud654","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%8b%9c%ea%b0%81%ed%99%94","term_group":0,"term_taxonomy_id":164,"taxonomy":"post_tag","description":"","parent":0,"count":52,"filter":"raw"},{"term_id":746,"name":"\uc5d1\uc140 \ub370\uc774\ud130 \ubd84\uc11d","slug":"%ec%97%91%ec%85%80-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b6%84%ec%84%9d","term_group":0,"term_taxonomy_id":746,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/posts\/3476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/comments?post=3476"}],"version-history":[{"count":7,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/posts\/3476\/revisions"}],"predecessor-version":[{"id":4532,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/posts\/3476\/revisions\/4532"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/media\/4531"}],"wp:attachment":[{"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/media?parent=3476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/categories?post=3476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/secondlife.lol\/ja\/wp-json\/wp\/v2\/tags?post=3476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}