{"id":16096,"date":"2025-11-20T20:20:05","date_gmt":"2025-11-20T11:20:05","guid":{"rendered":"https:\/\/www.sambuichi.jp\/?p=16096"},"modified":"2025-11-23T07:46:31","modified_gmt":"2025-11-22T22:46:31","slug":"%e6%a7%8b%e9%80%a0%e5%8c%96csv%e3%81%8c%e5%88%87%e3%82%8a%e6%8b%93%e3%81%8f%e3%83%87%e3%83%bc%e3%82%bf%e5%a4%89%e6%8f%9b%e3%81%ae%e6%96%b0%e6%99%82%e4%bb%a3%ef%bc%9ardb%e3%81%ae%e5%88%b6%e7%b4%84","status":"publish","type":"post","link":"https:\/\/www.sambuichi.jp\/?p=16096","title":{"rendered":"\u69cb\u9020\u5316CSV\u304c\u5207\u308a\u62d3\u304f\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3\uff1aRDB\u306e\u5236\u7d04\u3092\u8d85\u3048\u305f\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d"},"content":{"rendered":"<p>Views: 42<\/p><div id=\"header\">\n<h1>\u69cb\u9020\u5316CSV\u304c\u5207\u308a\u62d3\u304f\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3\uff1aRDB\u306e\u5236\u7d04\u3092\u8d85\u3048\u305f\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d<\/h1>\n<div class=\"details\">\n<span id=\"author\" class=\"author\">Google NotebookLM\uff08\u7de8\u96c6\uff1a\u4e09\u5206\u4e00\u4fe1\u4e4b\uff09<\/span><br \/>\n<span id=\"revdate\">2025-11-20<\/span>\n<\/div>\n<\/div>\n<div id=\"content\">\n<div id=\"preamble\">\n<div class=\"sectionbody\">\n<div class=\"quoteblock abstract\">\n<blockquote><p>\n\u69cb\u9020\u5316CSV\uff08Structured CSV\uff09\u306f\u3001\u5f93\u6765\u306eRDB\uff08\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff09\u306e\u6b63\u898f\u5316\u3068\u306f\u4e00\u7dda\u3092\u753b\u3057\u3001\u6b63\u898f\u5316\u3055\u308c\u305f\u968e\u5c64\u30c7\u30fc\u30bf\u3092\u4e00\u3064\u306eCSV\u30d5\u30a1\u30a4\u30eb\u3067\u8868\u73fe\u3059\u308b\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u5f62\u5f0f\u3067\u3059\u3002\u3053\u306e\u5f62\u5f0f\u306f\u3001\u5546\u53d6\u5f15\u3001\u4f1a\u8a08\u5e33\u7c3f\u3001\u96fb\u5b50\u5e33\u7c3f\u4fdd\u5b58\u306a\u3069\u306e\u5206\u91ce\u306b\u304a\u3051\u308b\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u51e6\u7406\u306b\u3001\u6839\u672c\u7684\u306a\u9769\u65b0\u3092\u3082\u305f\u3089\u3057\u307e\u3059\u3002\n<\/p><\/blockquote>\n<\/div>\n<div class=\"videoblock\">\n<div class=\"content\">\n<h4>\u8907\u96d1\u3055\u3092\u98fc\u3044\u306a\u3089\u3059\uff1a\u968e\u5c64\u578b\u6574\u7136\u30c7\u30fc\u30bf\u306e\u529b<\/h4>\n<p><iframe loading=\"lazy\" title=\"\u8907\u96d1\u3055\u3092\u98fc\u3044\u306a\u3089\u3059\uff1a\u968e\u5c64\u578b\u6574\u7136\u30c7\u30fc\u30bf\u306e\u529b\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/2dkf_e7O-X0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\n\u6ce8\uff1a\u3053\u306e\u52d5\u753b\u306f\u3001Google\u306eNotebookLM\u306b\u53c2\u8003\u6587\u732e\u3092\u8aad\u307e\u305b\u3066\u4f5c\u6210\u3057\u305f\u89e3\u8aac\u52d5\u753b\u3067\u3059\u3002<\/p>\n<\/div>\n<div class=\"content\">\n<h4>\u69cb\u9020\u5316CSV\u304c\u5207\u308a\u62d3\u304f\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3\uff1aRDB\u306e\u5236\u7d04\u3092\u8d85\u3048\u305f\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d<\/h4>\n<p><iframe loading=\"lazy\" title=\"\u69cb\u9020\u5316CSV\u304c\u5207\u308a\u62d3\u304f\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3\uff1aRDB\u306e\u5236\u7d04\u3092\u8d85\u3048\u305f\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ZxICRqYj4QM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><br \/>\n\u6ce8\uff1a\u3053\u306e\u52d5\u753b\u306f\u3001Google\u306eNotebookLM\u306b\u53c2\u8003\u6587\u732e\u3092\u8aad\u307e\u305b\u3066\u4f5c\u6210\u3057\u305f\u89e3\u8aac\u52d5\u753b\u3067\u3059\u3002\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_1_\u5f93\u6765\u306e\u6b63\u898f\u5316\u3068\u306e\u9055\u3044\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bfhierarchical_tidy_data\">1. \u5f93\u6765\u306e\u6b63\u898f\u5316\u3068\u306e\u9055\u3044\uff1a\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\u306f\u3001Hadley Wickham\u6c0f\u304c\u63d0\u5531\u3057\u305f\u6574\u7136\u30c7\u30fc\u30bf\uff08Tidy Data\uff09\u306e\u6982\u5ff5\u3092\u62e1\u5f35\u3057\u305f\u300c<strong>\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09<\/strong>\u300d\u306b\u57fa\u3065\u3044\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u5f93\u6765\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u8ab2\u984c\">\u5f93\u6765\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u8ab2\u984c<\/h3>\n<div class=\"paragraph\">\n<p>\u5f93\u6765\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u3067\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c6\u30fc\u30d6\u30eb\u3092\u5358\u7d14\u306b\u30c0\u30f3\u30d7\u3057\u305fCSV\u304c\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30a4\u30b9\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002<br \/>\nRDB\u306e\u6b63\u898f\u5316\u3084\u6a19\u6e96\u7684\u306a\u6574\u7136\u30c7\u30fc\u30bf\u3067\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5197\u9577\u6027\u3092\u6392\u9664\u3059\u308b\u305f\u3081\u306b\u3001\u8acb\u6c42\u66f8\u30d8\u30c3\u30c0\u30fc\u3084\u660e\u7d30\u884c\u3068\u3044\u3063\u305f\u5404\u968e\u5c64\u306e\u60c5\u5831\u3092\u3001\u305d\u308c\u305e\u308c<strong>\u500b\u5225\u306e\u8868<\/strong>\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u3067\u7ba1\u7406\u3057\u307e\u3059\u3002\u3053\u306e\u305f\u3081\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u53d6\u5f97\u3059\u308b\u969b\u306b\u306f\u3001\u8acb\u6c42\u66f8ID\u306a\u3069\u306e\u30ad\u30fc\u3092\u4f7f\u3063\u305f<strong>\u95a2\u4fc2\u4ee3\u6570\u306e\u64cd\u4f5c\uff08JOIN\uff09\u304c\u5fc5\u8981<\/strong>\u3067\u3057\u305f\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u69cb\u9020\u5316csv\u306e\u7279\u9577\">\u69cb\u9020\u5316CSV\u306e\u7279\u9577<\/h3>\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\uff08\u6a19\u6e96\u5f62\u5f0fCSV\uff09\u306f\u3001\u3053\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u3001\u8907\u96d1\u306a\u968e\u5c64\u69cb\u9020\u3092\u6301\u3064\u30c7\u30fc\u30bf\u3092<strong>\u91cd\u8907\u306e\u306a\u3044\u4e00\u3064\u306e\u6d17\u7df4\u3055\u308c\u305f\u8868<\/strong>\u3067\u52b9\u7387\u7684\u306b\u8868\u73fe\u3057\u307e\u3059\u3002<br \/>\n\u3053\u308c\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u306eJOIN\u64cd\u4f5c\u304c\u4e00\u5207\u4e0d\u8981\u3068\u306a\u308a\u3001\u5fc5\u8981\u306a\u60c5\u5831\u304c\u7d20\u65e9\u304f\u3001\u624b\u9593\u306a\u304f\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u3053\u306e\u5f62\u5f0f\u306f\u3001\u5f93\u6765\u306e\u8907\u96d1\u306a\u6b63\u898f\u5316\u3055\u308c\u305f\u8868\u306e\u6df7\u6c8c\u3068\u3057\u305f\u8ff7\u8def\u3092\u53d6\u308a\u6255\u3044\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u6271\u3044\u3092\u9769\u65b0\u7684\u306b\u30b7\u30f3\u30d7\u30eb\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_2_xml\u968e\u5c64\u30c7\u30fc\u30bf\u306e\u30d5\u30e9\u30c3\u30c8\u5316\u3068\u968e\u5c64\u8868\u73fe\u306e\u4ed5\u7d44\u307f\">2. XML\u968e\u5c64\u30c7\u30fc\u30bf\u306e\u30d5\u30e9\u30c3\u30c8\u5316\u3068\u968e\u5c64\u8868\u73fe\u306e\u4ed5\u7d44\u307f<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>xBRL-CSV\u4ed5\u69d8\u306b\u57fa\u3065\u304f\u69cb\u9020\u5316CSV\u306f\u3001XML\u306a\u3069\u306e\u968e\u5c64\u7684\u306a\u30ec\u30b3\u30fc\u30c9\u3092\u30d5\u30e9\u30c3\u30c8\u306b\u5c55\u958b\u3057\u3064\u3064\u3082\u3001\u968e\u5c64\u7684\u306a\u95a2\u9023\u6027\u3092\u4fdd\u6301\u3059\u308b\u305f\u3081\u306e\u4ed5\u7d44\u307f\u3092\u5099\u3048\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u7570\u306a\u308b\u89b3\u6e2c\u5024\u306e\u6df7\u5728\">\u7570\u306a\u308b\u89b3\u6e2c\u5024\u306e\u6df7\u5728<\/h3>\n<div class=\"paragraph\">\n<p>\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u3067\u306f\u3001<strong>\u7570\u306a\u308b\u7a2e\u985e\u306e\u89b3\u6e2c<\/strong>\uff08\u8acb\u6c42\u66f8\u5168\u4f53\u306b\u95a2\u3059\u308b\u89b3\u6e2c\u3001\u660e\u7d30\u884c\u306b\u95a2\u3059\u308b\u89b3\u6e2c\u306a\u3069\uff09\u304c\u6df7\u5728\u3059\u308b\u300c\u89b3\u6e2c\u5358\u4f4d\uff08type of observational unit\uff09\u300d\u3092\u4e00\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u5185\u306b\u53ce\u5bb9\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u9023\u756a\u306b\u3088\u308b\u968e\u5c64\u8868\u73fe\">\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u9023\u756a\u306b\u3088\u308b\u968e\u5c64\u8868\u73fe<\/h3>\n<div class=\"paragraph\">\n<p>\u968e\u5c64\u7684\u306a\u95a2\u9023\u6027\u306f\u3001\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e<strong>\u9023\u756a\uff08sequence number\uff09<\/strong>\u306b\u3088\u3063\u3066\u30b0\u30eb\u30fc\u30d7\u5316\u3055\u308c\u3001\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\u8acb\u6c42\u66f8\u30c7\u30fc\u30bf\u306e\u5834\u5408\u3001\u5177\u4f53\u7684\u306b\u306f\u4ee5\u4e0b\u306e3\u968e\u5c64\u306e\u60c5\u5831\u3092\u542b\u307f\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"olist arabic\">\n<ol class=\"arabic\">\n<li>\n<p>\u8acb\u6c42\u66f8\u30d8\u30c3\u30c0\uff08<code>dInvoice<\/code>\uff09<\/p>\n<\/li>\n<li>\n<p>\u7a0e\u660e\u7d30\uff08<code>dTaxBreakdown<\/code>\uff09<\/p>\n<\/li>\n<li>\n<p>\u660e\u7d30\u884c\uff08<code>dInvoiceLine<\/code>\uff09<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph\">\n<p>\u3053\u308c\u3089\u306e\u9023\u756a\u304c\u3001\u884c\u30ec\u30d9\u30eb\u3067\u610f\u5473\u304c\u7570\u306a\u308b\u30c7\u30fc\u30bf\u306e\u968e\u5c64\u69cb\u9020\u3092\u8868\u73fe\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p>\u8acb\u6c42\u66f8\u30d8\u30c3\u30c0\u884c\u3067\u306f\u3001`dInvoice`\u306b\u6570\u5024\u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u660e\u7d30\u884c\u306e\u5217\u306f\u7a7a\u6b04\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p>\u660e\u7d30\u884c\u306e\u884c\u3067\u306f\u3001`dInvoice`\u3068`dInvoiceLine`\u306b\u6570\u5024\u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u30d8\u30c3\u30c0\u30fc\u60c5\u5831\u3084\u7a0e\u660e\u7d30\u306e\u5217\u306f\u7a7a\u6b04\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ul>\n<\/div>\n<div class=\"paragraph\">\n<p>\u3053\u306e\u624b\u6cd5\u306b\u3088\u308a\u3001\u30d8\u30c3\u30c0\u30fc\u60c5\u5831\u304c\u5197\u9577\u306b\u7e70\u308a\u8fd4\u3055\u308c\u308b\u3053\u3068\u306a\u304f\uff08\u5197\u9577\u6027\u306e\u6392\u9664\uff09\u3001\u968e\u5c64\u69cb\u9020\u3092\u6b63\u78ba\u306b\u53cd\u6620\u3057\u305f\u5358\u4e00\u306e\u8868\uff08Tidy Data\uff09\u304c\u5b9f\u73fe\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_3_\u5546\u53d6\u5f15\u4f1a\u8a08\u5206\u91ce\u3078\u306e\u9769\u65b0\u3068\u76f8\u4e92\u904b\u7528\u6027\">3. \u5546\u53d6\u5f15\u30fb\u4f1a\u8a08\u5206\u91ce\u3078\u306e\u9769\u65b0\u3068\u76f8\u4e92\u904b\u7528\u6027<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\u306e\u63a1\u7528\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3001\u96fb\u5b50\u5e33\u7c3f\u4fdd\u5b58\u3001\u76e3\u67fb\u3001\u96fb\u5b50\u7533\u544a\u3001\u898f\u5236\u5831\u544a\u306a\u3069\u3001\u73fe\u4ee3\u306e\u69cb\u9020\u5316\u30c7\u30fc\u30bf\u4ea4\u63db\u3092\u652f\u3048\u308b\u57fa\u76e4\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u6a19\u6e96\u5f62\u5f0fcsv\u3068\u3057\u3066\u306e\u6a5f\u80fd\">\u6a19\u6e96\u5f62\u5f0fCSV\u3068\u3057\u3066\u306e\u6a5f\u80fd<\/h3>\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\u306f\u3001\u968e\u5c64\u7684\u306b\u5b9a\u7fa9\u3055\u308c\u305fXML\u3001JSON\u3001Yaml\u306a\u3069\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u3092\u3001<strong>\u4e00\u8cab\u3057\u305f\u6a19\u6e96\u5f62\u5f0f<\/strong>\u3067\u6271\u3046\u3053\u3068\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u30c7\u30fc\u30bf\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u3088\u308b\u4e92\u63db\u6027\u306e\u78ba\u4fdd\">\u30c7\u30fc\u30bf\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u3088\u308b\u4e92\u63db\u6027\u306e\u78ba\u4fdd<\/h3>\n<div class=\"paragraph\">\n<p>\u3053\u306e\u6a19\u6e96\u5f62\u5f0fCSV\u3092\u4e2d\u6838\u3068\u3057\u3066\u3001\u30c7\u30fc\u30bf\u306e\u76f8\u4e92\u904b\u7528\u6027\u3092\u9ad8\u3081\u308b\u300c\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u300d\u304c\u5b9f\u73fe\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"olist arabic\">\n<ol class=\"arabic\">\n<li>\n<p><strong>\u69cb\u6587\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0<\/strong>: JP PINT\u3084\u4e2d\u5c0f\u4f01\u696d\u5171\u901aEDI\u306a\u3069\u306e\u7570\u306a\u308b\u69cb\u6587\u898f\u5247\u3067\u8868\u73fe\u3055\u308c\u305fXML\u30d5\u30a1\u30a4\u30eb\u3068\u3001\u6a19\u6e96\u5f62\u5f0fCSV\u3068\u306e\u9593\u306e\u76f8\u4e92\u5909\u63db\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002\u3053\u306e\u5909\u63db\u306f\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u5909\u66f4\u306a\u3057\u306b\u3001\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u8f9e\u66f8\uff08\u30bf\u30af\u30bd\u30ce\u30df\uff09\u306e\u5b9a\u7fa9\u5909\u66f4\u306e\u307f\u3067\u5bfe\u5fdc\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u8ad6\u7406\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0<\/strong>: \u4f1a\u8a08\u30bd\u30d5\u30c8\u304c\u63d0\u4f9b\u3059\u308b\u56fa\u6709\u5f62\u5f0fCSV\u3068\u3001\u6a19\u6e96\u5f62\u5f0fCSV\u3068\u306e\u9593\u306e\u76f8\u4e92\u5909\u63db\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph\">\n<p>\u3053\u308c\u3089\u306e\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u3088\u308a\u3001\u7570\u306a\u308b\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3084\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u9593\u3067\u306e<strong>\u30c7\u30fc\u30bf\u306e\u4e92\u63db\u6027<\/strong>\u304c\u78ba\u4fdd\u3055\u308c\u3001\u30c7\u30fc\u30bf\u4ea4\u63db\u306e\u4fe1\u983c\u6027\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_\u5fdc\u7528\u3068\u52b9\u7387\u6027\">\u5fdc\u7528\u3068\u52b9\u7387\u6027<\/h3>\n<div class=\"ulist\">\n<ul>\n<li>\n<p><strong>XBRL\u30bf\u30af\u30bd\u30ce\u30df\u3068\u306e\u9023\u643a<\/strong>: JSON\u30e1\u30bf\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u3092\u4ecb\u3057\u3066XBRL\u30bf\u30af\u30bd\u30ce\u30df\u3068\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u304c\u5b9a\u7fa9\u3055\u308c\u308b\u305f\u3081\u3001\u30b3\u30f3\u30d1\u30af\u30c8\u3067\u3042\u308a\u306a\u304c\u3089\u3001\u30c7\u30fc\u30bf\u306e\u30bb\u30de\u30f3\u30c6\u30a3\u30af\u30b9\uff08\u610f\u5473\u7684\u306b\u8c4a\u304b\u306a\u60c5\u5831\uff09\u304c\u78ba\u5b9f\u306b\u8a18\u9332\u30fb\u4ea4\u63db\u3055\u308c\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u52b9\u7387\u7684\u306a\u51e6\u7406<\/strong>: \u69cb\u9020\u5316CSV\u306f\u3001XBRL-GL\u306a\u3069\u306e\u51e6\u7406\u306b\u5fdc\u7528\u53ef\u80fd\u3067\u3042\u308a\u3001\u307e\u305f\u3001RDB\u3067\u5b9a\u7fa9\u3055\u308c\u305f\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\uff08\u4f8b\uff1aInvoice, TaxBreakdown, InvoiceLine\u306a\u3069\uff09\u304b\u3089Python\u3084SQL\u3092\u4f7f\u7528\u3057\u3066\u81ea\u52d5\u751f\u6210\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<\/li>\n<\/ul>\n<\/div>\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\u306f\u3001\u968e\u5c64\u69cb\u9020\u3092\u7d71\u5408\u3057\u3001`dInvoice`\u306a\u3069\u306e\u8b58\u5225\u5b50\u3067\u5404\u968e\u5c64\u3092\u660e\u793a\u3059\u308b\u3053\u3068\u3067\u3001<strong>\u52b9\u7387\u7684\u306a\u96c6\u8a08\u30fb\u62bd\u51fa<\/strong>\u3092\u53ef\u80fd\u306b\u3057\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3084\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u306e\u30d7\u30ed\u30bb\u30b9\u3092\u5927\u5e45\u306b\u5bb9\u6613\u306b\u3059\u308b\u5f37\u529b\u306a\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\u69cb\u9020\u5316CSV\u306f\u3001\u8907\u96d1\u306a\u968e\u5c64\u69cb\u9020\u3092\u6301\u3064\u30c7\u30fc\u30bf\u3092\u5358\u4e00\u306e\u5f62\u5f0f\u3067\u53d6\u308a\u6271\u3046\u3053\u3068\u3092\u53ef\u80fd\u306b\u3057\u3001\u7279\u306b\u5546\u53d6\u5f15\u3084\u4f1a\u8a08\u5206\u91ce\u306b\u304a\u3051\u308b\u30c7\u30b8\u30bf\u30eb\u30c7\u30fc\u30bf\u306e\u6a19\u6e96\u5316\u3068\u4ea4\u63db\u3092\u5927\u304d\u304f\u524d\u9032\u3055\u305b\u308b\u9769\u65b0\u7684\u306a\u30a2\u30d7\u30ed\u30fc\u30c1\u3067\u3059\u3002\u3053\u306e\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d\u306e\u6982\u5ff5\u306f\u3001\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u6642\u4ee3\u306e\u76e3\u67fb\u3084\u898f\u5236\u5831\u544a\u306e\u57fa\u76e4\u3068\u3057\u3066\u3001\u4eca\u5f8c\u307e\u3059\u307e\u3059\u91cd\u8981\u6027\u3092\u5897\u3059\u3067\u3057\u3087\u3046\u3002<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\u3054\u8981\u671b\u306b\u57fa\u3065\u304d\u3001\u3053\u308c\u307e\u3067\u306e\u89e3\u8aac\u306b\u4f7f\u7528\u3057\u305f\u30bd\u30fc\u30b9\u8cc7\u6599\u306e\u30bf\u30a4\u30c8\u30eb\u3068URL\u3092Asciidoc\u5f62\u5f0f\u306e\u53c2\u8003\u6587\u732e\u30ea\u30b9\u30c8\u3068\u3057\u3066\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"references\">\u53c2\u8003\u6587\u732e<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\u4ee5\u4e0b\u306e\u8868\u306f\u3001\u69cb\u9020\u5316CSV\u3001\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09\u3001\u304a\u3088\u3073\u30c7\u30fc\u30bf\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u95a2\u3059\u308b\u89e3\u8aac\u8a18\u4e8b\u306e\u53c2\u7167\u60c5\u5831\u3067\u3059\u3002<\/p>\n<\/div>\n<table class=\"tableblock frame-all grid-all stretch\">\n<colgroup>\n<col style=\"width: 80%;\">\n<col style=\"width: 20%;\">\n<\/colgroup>\n<thead>\n<tr>\n<th class=\"tableblock halign-center valign-top\">\u30bf\u30a4\u30c8\u30eb<\/th>\n<th class=\"tableblock halign-center valign-top\">\u6295\u7a3f\u65e5<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=9673\">ChatGPT\u306bTidy data\u3092\u6307\u5c0e<\/a><\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2023-08-05<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=10700\">\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3: \u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09<\/a><\/p>\n<\/td>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2023-08-05<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=10710\">\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09\u3068\u30c7\u30fc\u30bf\u5909\u63db<\/a><\/p>\n<\/th>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2023-08-06<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=14678\">\u69cb\u9020\u5316CSV\uff1aXML\u306e\u968e\u5c64\u69cb\u9020\u30921\u679a\u306e\u30b7\u30fc\u30c8\u3067\u8868\u73fe\u3059\u308b<\/a><\/p>\n<\/th>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2025-04-13<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=15086\">\u69cb\u9020\u5316CSV\u306b\u3088\u308b\u30a4\u30f3\u30dc\u30a4\u30b9\u8868\u73fe\u3068SQL\u5b9a\u7fa9<\/a><\/p>\n<\/th>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2025-05-31<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th class=\"tableblock halign-left valign-top\">\n<p class=\"tableblock\"><i class=\"fa fa-link\"><\/i> <a href=\"https:\/\/www.sambuichi.jp\/?p=15139\">Python\u3067\u69cb\u9020\u5316CSV\u3092\u81ea\u52d5\u751f\u6210\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u89e3\u8aac<\/a><\/p>\n<\/th>\n<td class=\"tableblock halign-center valign-top\">\n<p class=\"tableblock\">2025-06-02<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div id=\"footer\">\n<div id=\"footer-text\">\nLast updated 2025-11-21 07:28:07 +0900\n<\/div>\n<\/div>\n<div id=\"toc\" class=\"toc2\">\n<div id=\"toctitle\">Table of Contents<\/div>\n<ul class=\"sectlevel1\">\n<li><a href=\"#_1_\u5f93\u6765\u306e\u6b63\u898f\u5316\u3068\u306e\u9055\u3044\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bfhierarchical_tidy_data\">1. \u5f93\u6765\u306e\u6b63\u898f\u5316\u3068\u306e\u9055\u3044\uff1a\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\uff08Hierarchical Tidy Data\uff09<\/a>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_\u5f93\u6765\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u8ab2\u984c\">\u5f93\u6765\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u8ab2\u984c<\/a><\/li>\n<li><a href=\"#_\u69cb\u9020\u5316csv\u306e\u7279\u9577\">\u69cb\u9020\u5316CSV\u306e\u7279\u9577<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_2_xml\u968e\u5c64\u30c7\u30fc\u30bf\u306e\u30d5\u30e9\u30c3\u30c8\u5316\u3068\u968e\u5c64\u8868\u73fe\u306e\u4ed5\u7d44\u307f\">2. XML\u968e\u5c64\u30c7\u30fc\u30bf\u306e\u30d5\u30e9\u30c3\u30c8\u5316\u3068\u968e\u5c64\u8868\u73fe\u306e\u4ed5\u7d44\u307f<\/a>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_\u7570\u306a\u308b\u89b3\u6e2c\u5024\u306e\u6df7\u5728\">\u7570\u306a\u308b\u89b3\u6e2c\u5024\u306e\u6df7\u5728<\/a><\/li>\n<li><a href=\"#_\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u9023\u756a\u306b\u3088\u308b\u968e\u5c64\u8868\u73fe\">\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u9023\u756a\u306b\u3088\u308b\u968e\u5c64\u8868\u73fe<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_3_\u5546\u53d6\u5f15\u4f1a\u8a08\u5206\u91ce\u3078\u306e\u9769\u65b0\u3068\u76f8\u4e92\u904b\u7528\u6027\">3. \u5546\u53d6\u5f15\u30fb\u4f1a\u8a08\u5206\u91ce\u3078\u306e\u9769\u65b0\u3068\u76f8\u4e92\u904b\u7528\u6027<\/a>\n<ul class=\"sectlevel2\">\n<li><a href=\"#_\u6a19\u6e96\u5f62\u5f0fcsv\u3068\u3057\u3066\u306e\u6a5f\u80fd\">\u6a19\u6e96\u5f62\u5f0fCSV\u3068\u3057\u3066\u306e\u6a5f\u80fd<\/a><\/li>\n<li><a href=\"#_\u30c7\u30fc\u30bf\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u3088\u308b\u4e92\u63db\u6027\u306e\u78ba\u4fdd\">\u30c7\u30fc\u30bf\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0\u306b\u3088\u308b\u4e92\u63db\u6027\u306e\u78ba\u4fdd<\/a><\/li>\n<li><a href=\"#_\u5fdc\u7528\u3068\u52b9\u7387\u6027\">\u5fdc\u7528\u3068\u52b9\u7387\u6027<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#references\">\u53c2\u8003\u6587\u732e<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Views: 42 \u69cb\u9020\u5316CSV\u304c\u5207\u308a\u62d3\u304f\u30c7\u30fc\u30bf\u5909\u63db\u306e\u65b0\u6642\u4ee3\uff1aRDB\u306e\u5236\u7d04\u3092\u8d85\u3048\u305f\u300c\u968e\u5c64\u578b\u306e\u6574\u7136\u30c7\u30fc\u30bf\u300d Google NotebookLM\uff08\u7de8\u96c6\uff1a\u4e09\u5206\u4e00\u4fe1\u4e4b\uff09 2025-11-20 \u69cb\u9020\u5316CSV\uff08Structured  [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":16103,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[68,16],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/16096"}],"collection":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16096"}],"version-history":[{"count":16,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/16096\/revisions"}],"predecessor-version":[{"id":16157,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/posts\/16096\/revisions\/16157"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=\/wp\/v2\/media\/16103"}],"wp:attachment":[{"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sambuichi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}