{"id":83751,"date":"2026-06-04T17:43:44","date_gmt":"2026-06-04T08:43:44","guid":{"rendered":"https:\/\/www.creationline.com\/tech-blog\/?p=83751"},"modified":"2026-06-04T17:43:45","modified_gmt":"2026-06-04T08:43:45","slug":"%e3%83%a1%e3%83%80%e3%83%aa%e3%82%aa%e3%83%b3%e3%82%a2%e3%83%bc%e3%82%ad%e3%83%86%e3%82%af%e3%83%81%e3%83%a3%e3%81%a3%e3%81%a6%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751","title":{"rendered":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>Databricks\u304c\u63d0\u5531\u3057\u3001\u30c7\u30fc\u30bf\u30ec\u30a4\u30af\u30cf\u30a6\u30b9\u306e\u6a19\u6e96\u7684\u306a\u69cb\u6210\u3068\u306a\u3063\u3066\u3044\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3\u5c64\u306e\u5f79\u5272<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Bronze \u300c\u307e\u305a\u5168\u3066\u53d7\u3051\u53d6\u308b\u300d<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u751f\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u4fdd\u5b58\u3002\u5909\u63db\u30fb\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u306f\u884c\u308f\u306a\u3044<\/li>\n\n\n\n<li>\u76ee\u7684\u3068\u3057\u3066\u5143\u30c7\u30fc\u30bf\u3092\u5931\u308f\u306a\u3044\u3001\u4f55\u304b\u3042\u308c\u3070\u518d\u51e6\u7406\u3067\u304d\u308b<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Silver \u300c\u4f7f\u3048\u308b\u72b6\u614b\u306b\u3059\u308b\u300d<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u578b\u5909\u63db\u30fbNULL\u9664\u53bb\u30fb\u91cd\u8907\u6392\u9664\u30fb\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u7d71\u4e00<\/li>\n\n\n\n<li>\u76ee\u7684\u3068\u3057\u3066\u3069\u306e\u30c1\u30fc\u30e0\u304c\u4f7f\u3063\u3066\u3082\u5b89\u5168\u306a\u30af\u30ea\u30fc\u30f3\u306a\u30c7\u30fc\u30bf\u306b\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Gold \u300c\u7b54\u3048\u3092\u51fa\u3059\u300d<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u3092\u9069\u7528\u3057\u305f\u96c6\u8a08\u30fb\u52a0\u5de5\u6e08\u307f\u30c6\u30fc\u30d6\u30eb<\/li>\n\n\n\n<li>\u76ee\u7684\u3068\u3057\u3066BI\u30c4\u30fc\u30eb\u3084\u30ec\u30dd\u30fc\u30c8\u306b\u305d\u306e\u307e\u307e\u4f7f\u3048\u308b\u5f62\u306b\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u306a\u305c\u5c64\u3092\u5206\u3051\u308b\u306e\u304b<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5c64\u3092\u5206\u3051\u305a\u306b\u751f\u30c7\u30fc\u30bf\u304b\u3089\u76f4\u63a5\u96c6\u8a08\u3059\u308b\u3068<\/li>\n\n\n\n<li>\u6c5a\u308c\u30c7\u30fc\u30bf\u304c\u6df7\u5165\u3057\u305f\u8a08\u7b97\u7d50\u679c\u306b\u6c17\u3065\u3051\u306a\u3044<\/li>\n\n\n\n<li>\u518d\u51e6\u7406\u3059\u308b\u6642\u300c\u3069\u3053\u307e\u3067\u623b\u308c\u3070\u3044\u3044\u304b\u300d\u304c\u308f\u304b\u3089\u306a\u3044<\/li>\n\n\n\n<li>\u30c1\u30fc\u30e0\u306b\u3088\u3063\u3066\u7570\u306a\u308b\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u30ed\u30b8\u30c3\u30af\u304c\u4e71\u7acb\u3059\u308b<\/li>\n\n\n\n<li><strong>\u5c64\u3054\u3068\u306b\u8cac\u52d9\u3092\u5206\u3051\u308b\u3053\u3068\u3067\u3001\u554f\u984c\u304c\u8d77\u304d\u305f\u3068\u304d\u306b\u3069\u306e\u5c64\u306b\u539f\u56e0\u304c\u3042\u308b\u304b\u304c\u5373\u5ea7\u306b\u308f\u304b\u308b\u306e\u304c\u6700\u5927\u306e\u30e1\u30ea\u30c3\u30c8<\/strong><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u5b9f\u52d9\u3067\u306e\u4f4d\u7f6e\u4ed8\u3051<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30c4\u30fc\u30eb<\/th><th>\u5f79\u5272<\/th><\/tr><\/thead><tbody><tr><td>Delta Lake \/ Apache Iceberg<\/td><td>\u30b9\u30c8\u30ec\u30fc\u30b8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff08\u5c64\u3054\u3068\u306b\u7ba1\u7406\uff09<\/td><\/tr><tr><td>Databricks \/ Apache Spark<\/td><td>\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u306e\u51e6\u7406\u30a8\u30f3\u30b8\u30f3<\/td><\/tr><tr><td>dbt<\/td><td>Silver\/Gold\u5c64\u306e\u5909\u63db\u30ed\u30b8\u30c3\u30af\u7ba1\u7406<\/td><\/tr><tr><td>Apache Airflow<\/td><td>\u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u306e\u30b9\u30b1\u30b8\u30e5\u30fc\u30ea\u30f3\u30b0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8         \u5b9f\u52d9\u898f\u6a21\n  \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\n  CSV\uff08\u751f\u30c7\u30fc\u30bf\uff09      \u2192  S3 \/ ADLS\n  pandas               \u2192  Spark \/ Polars\n  \u624b\u52d5\u5b9f\u884c             \u2192  Airflow \/ Dagster\n  \u30d5\u30a1\u30a4\u30eb\u4fdd\u5b58         \u2192  Delta Lake \/ Parquet<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">ClaudeCode\u306b\u4f5c\u6210\u3055\u305b\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u69cb\u6210<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">.\n\u251c\u2500\u2500 data\n\u2502&amp;nbsp;&amp;nbsp; \u251c\u2500\u2500 bronze\n\u2502&amp;nbsp;&amp;nbsp; \u2502&amp;nbsp;&amp;nbsp; \u2514\u2500\u2500 orders.csv\n\u2502&amp;nbsp;&amp;nbsp; \u251c\u2500\u2500 gold\n\u2502&amp;nbsp;&amp;nbsp; \u2502&amp;nbsp;&amp;nbsp; \u251c\u2500\u2500 customer_summary.csv\n\u2502&amp;nbsp;&amp;nbsp; \u2502&amp;nbsp;&amp;nbsp; \u251c\u2500\u2500 monthly_sales.csv\n\u2502&amp;nbsp;&amp;nbsp; \u2502&amp;nbsp;&amp;nbsp; \u2514\u2500\u2500 product_ranking.csv\n\u2502&amp;nbsp;&amp;nbsp; \u251c\u2500\u2500 raw\n\u2502&amp;nbsp;&amp;nbsp; \u2502&amp;nbsp;&amp;nbsp; \u2514\u2500\u2500 orders.csv\n\u2502&amp;nbsp;&amp;nbsp; \u2514\u2500\u2500 silver\n\u2502&amp;nbsp;&amp;nbsp;     \u2514\u2500\u2500 orders.csv\n\u251c\u2500\u2500 docs\n\u2502&amp;nbsp;&amp;nbsp; \u2514\u2500\u2500 scripts.md\n\u251c\u2500\u2500 main.py\n\u2514\u2500\u2500 pyproject.toml<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><code>main.py<\/code><\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import csv\nimport random\nfrom datetime import datetime, timedelta\nfrom pathlib import Path\n\nimport pandas as pd\n\nrandom.seed(42)\n\n# \u5546\u54c1\u30de\u30b9\u30bf\nPRODUCTS = [\n    {\"id\": \"P001\", \"name\": \"\u30ce\u30fc\u30c8PC\",    \"price\": 120000},\n    {\"id\": \"P002\", \"name\": \"\u30de\u30a6\u30b9\",      \"price\":   3000},\n    {\"id\": \"P003\", \"name\": \"\u30ad\u30fc\u30dc\u30fc\u30c9\",  \"price\":   8000},\n    {\"id\": \"P004\", \"name\": \"\u30e2\u30cb\u30bf\u30fc\",    \"price\":  45000},\n    {\"id\": \"P005\", \"name\": \"\u30d8\u30c3\u30c9\u30bb\u30c3\u30c8\",\"price\":  15000},\n]\n\n\n# ----------------------------------------\n# Step 0: \u751f\u30c7\u30fc\u30bf\u751f\u6210\n# ----------------------------------------\n\ndef generate_raw(n: int = 100):\n    \"\"\"\u6c5a\u308c\u3092\u542b\u3080\u6ce8\u6587\u30c7\u30fc\u30bf\u3092 n \u4ef6\u751f\u6210\u3057\u3066 CSV \u306b\u4fdd\u5b58\u3059\u308b\"\"\"\n\n    orders = []\n    start = datetime(2024, 1, 1)\n    end   = datetime(2024, 12, 31)\n\n    for i in range(1, n + 1):\n        product  = random.choice(PRODUCTS)\n        quantity = random.randint(1, 5)\n\n        # \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092 20% \u306e\u78ba\u7387\u3067 DD\/MM\/YYYY \u306b\u5909\u3048\u308b\uff08\u6c5a\u308c\u2460\uff09\n        delta       = end - start\n        dt          = start + timedelta(days=random.randint(0, delta.days))\n        order_date  = dt.strftime(\"%d\/%m\/%Y\") if random.random() &lt; 0.2 else dt.strftime(\"%Y-%m-%d\")\n\n        row = {\n            \"order_id\":    f\"ORD-{i:04d}\",\n            \"customer_id\": f\"C{random.randint(1, 20):03d}\",\n            \"product_id\":  product[\"id\"],\n            \"product_name\":product[\"name\"],\n            \"quantity\":    quantity if random.random() > 0.05 else \"\",   # \u6c5a\u308c\u2461: 5% \u3067\u7a7a\u6b04\n            \"unit_price\":  product[\"price\"] if random.random() > 0.05 else \"\",  # \u6c5a\u308c\u2461: \u540c\u4e0a\n            \"order_date\":  order_date,\n            \"status\":      random.choice([\"completed\", \"completed\", \"cancelled\", \"pending\"]),\n        }\n\n        # 5% \u306e\u78ba\u7387\u3067\u65e2\u5b58\u306e order_id \u3068\u91cd\u8907\u3055\u305b\u308b\uff08\u6c5a\u308c\u2462\uff09\n        if random.random() &lt; 0.05:\n            row[\"order_id\"] = f\"ORD-{random.randint(1, i):04d}\"\n\n        orders.append(row)\n\n    out_path = Path(\"data\/raw\/orders.csv\")\n    out_path.parent.mkdir(parents=True, exist_ok=True)\n    with open(out_path, \"w\", newline=\"\", encoding=\"utf-8\") as f:\n        writer = csv.DictWriter(f, fieldnames=orders[0].keys())\n        writer.writeheader()\n        writer.writerows(orders)\n\n    print(f\"  \u751f\u30c7\u30fc\u30bf\u3092\u751f\u6210\u3057\u307e\u3057\u305f: {out_path} ({len(orders)} \u4ef6)\")\n\n\n# ----------------------------------------\n# Step 1: Bronze \u5c64 \u2014 \u751f\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u53d6\u308a\u8fbc\u3080\n# ----------------------------------------\n\ndef load_to_bronze(raw_path: str, bronze_path: str) -> pd.DataFrame:\n    \"\"\"\u751f\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u8aad\u307f\u8fbc\u307f\u3001\u53d6\u308a\u8fbc\u307f\u65e5\u6642\u3060\u3051\u4ed8\u4e0e\u3057\u3066\u4fdd\u5b58\u3059\u308b\"\"\"\n\n    # \u5168\u30ab\u30e9\u30e0\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u8aad\u3080\uff08\u578b\u5909\u63db\u306f\u3057\u306a\u3044\uff09\n    df = pd.read_csv(raw_path, dtype=str)\n\n    df[\"ingested_at\"] = datetime.now().isoformat()\n    df[\"source_file\"] = Path(raw_path).name\n\n    Path(bronze_path).parent.mkdir(parents=True, exist_ok=True)\n    df.to_csv(bronze_path, index=False)\n\n    return df\n\n\n# ----------------------------------------\n# Step 2: Silver \u5c64 \u2014 \u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u30fb\u6a19\u6e96\u5316\n# ----------------------------------------\n\ndef standardize_date(date_str: str) -> str | None:\n    \"\"\"YYYY-MM-DD \u3068 DD\/MM\/YYYY \u306e\u4e21\u65b9\u3092 YYYY-MM-DD \u306b\u7d71\u4e00\u3059\u308b\"\"\"\n    for fmt in (\"%Y-%m-%d\", \"%d\/%m\/%Y\"):\n        try:\n            return pd.to_datetime(date_str, format=fmt).strftime(\"%Y-%m-%d\")\n        except (ValueError, TypeError):\n            continue\n    return None\n\n\ndef transform_to_silver(bronze_path: str, silver_path: str) -> pd.DataFrame:\n    \"\"\"Bronze \u30c7\u30fc\u30bf\u3092\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u3057\u3066 Silver \u306b\u4fdd\u5b58\u3059\u308b\"\"\"\n\n    df = pd.read_csv(bronze_path, dtype=str)\n    before = len(df)\n\n    # \u6570\u5024\u306b\u5909\u63db\u3067\u304d\u306a\u3044\u884c\u306f NaN \u306b\u306a\u308b\n    df[\"quantity\"]   = pd.to_numeric(df[\"quantity\"],   errors=\"coerce\")\n    df[\"unit_price\"] = pd.to_numeric(df[\"unit_price\"], errors=\"coerce\")\n\n    # NaN \u3092\u542b\u3080\u884c\u3092\u9664\u5916\uff08\u6b20\u640d\u5024\u306e\u6392\u9664\uff09\n    df = df.dropna(subset=[\"quantity\", \"unit_price\"])\n\n    # \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u7d71\u4e00\u3057\u3001\u5909\u63db\u3067\u304d\u306a\u3044\u884c\u3092\u9664\u5916\n    df[\"order_date\"] = df[\"order_date\"].apply(standardize_date)\n    df = df.dropna(subset=[\"order_date\"])\n\n    # order_id \u304c\u91cd\u8907\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u6700\u521d\u306e1\u4ef6\u3060\u3051\u6b8b\u3059\n    df = df.drop_duplicates(subset=[\"order_id\"], keep=\"first\")\n\n    # \u5408\u8a08\u91d1\u984d\u3092\u8a08\u7b97\u3057\u3066\u8ffd\u52a0\n    df[\"total_amount\"] = (df[\"quantity\"] * df[\"unit_price\"]).astype(int)\n    df[\"quantity\"]     = df[\"quantity\"].astype(int)\n    df[\"unit_price\"]   = df[\"unit_price\"].astype(int)\n\n    Path(silver_path).parent.mkdir(parents=True, exist_ok=True)\n    df.to_csv(silver_path, index=False)\n\n    print(f\"  \u9664\u5916\u4ef6\u6570: {before - len(df)} \u4ef6 (NULL\u30fb\u91cd\u8907)\")\n    return df\n\n\n# ----------------------------------------\n# Step 3: Gold \u5c64 \u2014 \u30d3\u30b8\u30cd\u30b9\u96c6\u8a08\n# ----------------------------------------\n\ndef build_gold(silver_path: str, gold_dir: str) -> dict[str, pd.DataFrame]:\n    \"\"\"Silver \u30c7\u30fc\u30bf\u304b\u30893\u7a2e\u985e\u306e\u96c6\u8a08\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u4fdd\u5b58\u3059\u308b\"\"\"\n\n    df = pd.read_csv(silver_path)\n    df[\"order_date\"] = pd.to_datetime(df[\"order_date\"])\n\n    # \u5b8c\u4e86\u6e08\u307f\u6ce8\u6587\u3060\u3051\u3092\u96c6\u8a08\u5bfe\u8c61\u306b\u3059\u308b\n    completed = df[df[\"status\"] == \"completed\"].copy()\n    completed[\"year_month\"] = completed[\"order_date\"].dt.to_period(\"M\").astype(str)\n\n    # \u6708\u5225\u58f2\u4e0a\n    monthly_sales = (\n        completed\n        .groupby(\"year_month\")\n        .agg(order_count=(\"order_id\", \"count\"), total_sales=(\"total_amount\", \"sum\"))\n        .reset_index()\n        .sort_values(\"year_month\")\n    )\n\n    # \u5546\u54c1\u5225\u30e9\u30f3\u30ad\u30f3\u30b0\n    product_ranking = (\n        completed\n        .groupby([\"product_id\", \"product_name\"])\n        .agg(\n            order_count=(\"order_id\", \"count\"),\n            total_quantity=(\"quantity\", \"sum\"),\n            total_sales=(\"total_amount\", \"sum\"),\n        )\n        .reset_index()\n        .sort_values(\"total_sales\", ascending=False)\n        .reset_index(drop=True)\n    )\n    product_ranking.index     += 1\n    product_ranking.index.name = \"rank\"\n\n    # \u9867\u5ba2\u5225\u30b5\u30de\u30ea\u30fc\n    customer_summary = (\n        completed\n        .groupby(\"customer_id\")\n        .agg(\n            order_count=(\"order_id\", \"count\"),\n            total_spent=(\"total_amount\", \"sum\"),\n            avg_order_value=(\"total_amount\", \"mean\"),\n        )\n        .reset_index()\n        .sort_values(\"total_spent\", ascending=False)\n    )\n    customer_summary[\"avg_order_value\"] = customer_summary[\"avg_order_value\"].round(0).astype(int)\n\n    gold_path = Path(gold_dir)\n    gold_path.mkdir(parents=True, exist_ok=True)\n    monthly_sales.to_csv(gold_path \/ \"monthly_sales.csv\",     index=False)\n    product_ranking.to_csv(gold_path \/ \"product_ranking.csv\")\n    customer_summary.to_csv(gold_path \/ \"customer_summary.csv\", index=False)\n\n    return {\n        \"monthly_sales\":    monthly_sales,\n        \"product_ranking\":  product_ranking,\n        \"customer_summary\": customer_summary,\n    }\n\n\n# ----------------------------------------\n# \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u5b9f\u884c\n# ----------------------------------------\n\ndef main():\n    print(\"\\n\" + \"=\" * 50)\n    print(\"  \u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3 \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u958b\u59cb\")\n    print(\"=\" * 50)\n\n    print(\"\\n[Step 0] \u751f\u30c7\u30fc\u30bf\u751f\u6210\")\n    generate_raw()\n\n    print(\"\\n[Step 1] Bronze\u5c64 - \u751f\u30c7\u30fc\u30bf\u53d6\u308a\u8fbc\u307f\")\n    bronze_df = load_to_bronze(\"data\/raw\/orders.csv\", \"data\/bronze\/orders.csv\")\n    print(f\"  \u53d6\u308a\u8fbc\u307f\u4ef6\u6570: {len(bronze_df)} \u4ef6\")\n\n    print(\"\\n[Step 2] Silver\u5c64 - \u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u30fb\u6a19\u6e96\u5316\")\n    silver_df = transform_to_silver(\"data\/bronze\/orders.csv\", \"data\/silver\/orders.csv\")\n    print(f\"  \u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u5f8c\u4ef6\u6570: {len(silver_df)} \u4ef6\")\n\n    print(\"\\n[Step 3] Gold\u5c64 - \u30d3\u30b8\u30cd\u30b9\u96c6\u8a08\")\n    gold = build_gold(\"data\/silver\/orders.csv\", \"data\/gold\")\n    print(f\"  \u6708\u5225\u30b5\u30de\u30ea\u30fc: {len(gold['monthly_sales'])} \u30f6\u6708\u5206\")\n    print(f\"  \u5546\u54c1\u30e9\u30f3\u30ad\u30f3\u30b0: {len(gold['product_ranking'])} \u5546\u54c1\")\n    print(f\"  \u9867\u5ba2\u30b5\u30de\u30ea\u30fc: {len(gold['customer_summary'])} \u9867\u5ba2\")\n\n    print(\"\\n\" + \"=\" * 50)\n    print(\"  \u30d1\u30a4\u30d7\u30e9\u30a4\u30f3\u5b8c\u4e86!\")\n    print(\"=\" * 50)\n\n    print(\"\\n\u3010\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\u3011\")\n    print(f\"  data\/raw\/orders.csv     ({len(bronze_df)} \u4ef6, \u751f\u30c7\u30fc\u30bf)\")\n    print(f\"    \u2193 Bronze: \u30e1\u30bf\u30c7\u30fc\u30bf\u4ed8\u4e0e\u306e\u307f\")\n    print(f\"  data\/bronze\/orders.csv  ({len(bronze_df)} \u4ef6)\")\n    print(f\"    \u2193 Silver: NULL\u9664\u53bb\u30fb\u91cd\u8907\u6392\u9664\u30fb\u578b\u5909\u63db\u30fb\u65e5\u4ed8\u7d71\u4e00\")\n    print(f\"  data\/silver\/orders.csv  ({len(silver_df)} \u4ef6)\")\n    print(f\"    \u2193 Gold: \u5b8c\u4e86\u6ce8\u6587\u306e\u307f\u96c6\u8a08\")\n    print(f\"  data\/gold\/monthly_sales.csv\")\n    print(f\"  data\/gold\/product_ranking.csv\")\n    print(f\"  data\/gold\/customer_summary.csv\")\n\n\nif __name__ == \"__main__\":\n    main()<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><code>main.py<\/code>\u3088\u308a\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3092\u7406\u89e3\u3059\u308b<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step0 <code>generate_raw()<\/code>\u751f\u30c7\u30fc\u30bf\u751f\u6210<\/h3>\n\n\n\n<p>100\u4ef6\u306e\u6ce8\u6587\u30c7\u30fc\u30bf\u3092\u751f\u6210\u3002\u5b9f\u52d9\u3067\u8d77\u3053\u308a\u3046\u308b\u4ee5\u4e0b\u306e\u300c\u6c5a\u308c\u300d\u3092\u610f\u56f3\u7684\u306b\u6df7\u5165\u3055\u305b\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u6c5a\u308c\u306e\u7a2e\u985e<\/th><th>\u5185\u5bb9<\/th><th>\u767a\u751f\u78ba\u7387<\/th><\/tr><\/thead><tbody><tr><td>\u6b20\u640d\u5024<\/td><td><code>quantity<\/code> \u307e\u305f\u306f <code>unit_price<\/code> \u304c\u7a7a\u6b04<\/td><td>\u54045%<\/td><\/tr><tr><td>\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u6df7\u5728<\/td><td><code>YYYY-MM-DD<\/code> \u3068 <code>DD\/MM\/YYYY<\/code> \u304c\u6df7\u5728<\/td><td>20%<\/td><\/tr><tr><td>\u91cd\u8907\u30ec\u30b3\u30fc\u30c9<\/td><td>\u540c\u3058 <code>order_id<\/code> \u3092\u6301\u3064\u6ce8\u6587\u304c\u8907\u6570\u5b58\u5728<\/td><td>5%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u6df7\u5728<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092 20% \u306e\u78ba\u7387\u3067 DD\/MM\/YYYY \u306b\u5909\u3048\u308b\uff08\u6c5a\u308c\u2460\uff09\ndelta       = end - start\ndt          = start + timedelta(days=random.randint(0, delta.days))\norder_date  = dt.strftime(\"%d\/%m\/%Y\") if random.random() &lt; 0.2 else dt.strftime(\"%Y-%m-%d\")<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u6b20\u640d\u5024<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\"quantity\":    quantity if random.random() > 0.05 else \"\",   # \u6c5a\u308c\u2461: 5% \u3067\u7a7a\u6b04<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u91cd\u8907\u30ec\u30b3\u30fc\u30c9<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> if random.random() &lt; 0.05:\n            row[\"order_id\"] = f\"ORD-{random.randint(1, i):04d}\"<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step1 <code>load_to_bronze()<\/code>Bronze\u5c64<\/h3>\n\n\n\n<p>\u751f\u30c7\u30fc\u30bf\u3092<strong>\u305d\u306e\u307e\u307e<\/strong>\u53d6\u308a\u8fbc\u3080\u3002\u5909\u63db\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u306f\u4e00\u5207\u884c\u308f\u306a\u3044\u3002<br>\u751f\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u5f8c\u304b\u3089\u518d\u51e6\u7406\u304c\u697d\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<p>&lt;\u4e3b\u306a\u51e6\u7406&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5168\u30ab\u30e9\u30e0\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u8aad\u307f\u8fbc\u3080<\/li>\n\n\n\n<li>\u8aad\u307f\u8fbc\u307f\u65e5\u6642\u3068\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u4ed8\u4e0e\u3057\u3066\u4fdd\u5b58<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step2\u3000<code>standardize_date()\/transform_to_silver()<\/code>Silver\u5c64<\/h3>\n\n\n\n<p>Bronze\u5c64\u306e\u30c7\u30fc\u30bf\u3092\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u30fb\u6a19\u6e96\u5316\u3057\u307e\u3059<br><code>standardize_date()<\/code>\u3067\u65e5\u6642\u5f62\u5f0f\u3092\u7d71\u4e00<\/p>\n\n\n\n<p>&lt;\u4e3b\u306a\u51e6\u7406&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>quantity<\/code>,<code>price<\/code>\u3092\u6570\u5024\u578b\u306b\u5909\u63db(\u3067\u304d\u306a\u3044\u3082\u306e\u306f\u9664\u5916)<\/li>\n\n\n\n<li><code>order_date<\/code>\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u7d71\u4e00(\u3067\u304d\u306a\u3044\u3082\u306e\u306f\u9664\u5916)<\/li>\n\n\n\n<li><code>order_id<\/code>\u304c\u91cd\u8907\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u4e00\u4ef6\u3060\u3051\u6b8b\u3059<\/li>\n\n\n\n<li>\u5408\u8a08\u91d1\u984d\u8a08\u7b97<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step3 <code>build_gold()<\/code> Gold\u5c64<\/h3>\n\n\n\n<p>Silver \u30c7\u30fc\u30bf\u304b\u30893\u7a2e\u985e\u306e\u96c6\u8a08\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u4fdd\u5b58\u3059\u308b<\/p>\n\n\n\n<p>&lt;\u4e3b\u306a\u51e6\u7406&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6708\u5225\u58f2\u4e0a\u30b5\u30de\u30ea\u30fc\uff08\u6ce8\u6587\u6570\u30fb\u58f2\u4e0a\u5408\u8a08\uff09<\/li>\n\n\n\n<li>\u5546\u54c1\u5225\u58f2\u4e0a\u30e9\u30f3\u30ad\u30f3\u30b0\uff08\u58f2\u4e0a\u91d1\u984d\u9806\uff09<\/li>\n\n\n\n<li>\u9867\u5ba2\u5225\u8cfc\u5165\u30b5\u30de\u30ea\u30fc\uff08\u8cfc\u5165\u56de\u6570\u30fb\u5408\u8a08\u91d1\u984d\u30fb\u5e73\u5747\u5358\u4fa1\uff09<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3092\u5b66\u3093\u3067<\/h2>\n\n\n\n<p>\u30d1\u30c3\u3068\u5b66\u3093\u3060\u30a4\u30e1\u30fc\u30b8\u306f<strong>\u30d6\u30ed\u30f3\u30ba\u306f\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304b\u3089\u53d6\u308a\u51fa\u3059\u3060\u3051<\/strong>\u3001<strong>\u30b7\u30eb\u30d0\u30fc\u306b\u3066\u30c7\u30fc\u30bf\u304c\u6271\u3048\u308b\u72b6\u614b\u306b<\/strong>\u3059\u308b\u3002<strong>\u30b4\u30fc\u30eb\u30c9\u3067\u306f\u6271\u3048\u308b\u72b6\u614b\u306b\u3057\u305f\u304b\u3089\u30d3\u30e5\u30fc\u3067\u30e6\u30fc\u30b6\u30fc\u304c\u6271\u3048\u308b\u72b6\u614b\u307e\u3067\u6301\u3063\u3066\u3044\u304f<\/strong>\u3068\u3044\u3063\u305f\u3068\u3053\u308d\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p>\u79c1\u304c\u4ee5\u524d\u57f7\u7b46\u3057\u305f\u300c<a href=\"https:\/\/zenn.dev\/hrk_sgyumm23\/articles\/7d8765639b3d31#6.%E3%83%87%E3%83%BC%E3%82%BF%E3%83%9E%E3%83%8D%E3%82%B8%E3%83%A1%E3%83%B3%E3%83%88%E5%AE%9F%E8%A1%8C%E5%B1%A4\">\u300cDX\u6642\u4ee3\u306e\u30c7\u30fc\u30bf\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\u5927\u5168\u300d\u3092\u8aad\u3093\u3067\u5927\u4e8b\u3068\u601d\u3063\u305f\u7b87\u6240\u307e\u3068\u3081<\/a>\u300d\u306e\u300c\u30c7\u30fc\u30bf\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\u5b9f\u884c\u5c64\u300d\u306e\u7ae0\u306b\u8fd1\u3044\u5185\u5bb9\u306b\u3082\u601d\u3044\u307e\u3059\u3002<br><\/p>\n\n\n\n<p>\u73fe\u5728\u3001\u79c1\u304c\u53d6\u308a\u7d44\u3093\u3067\u3044\u308b\u696d\u52d9\u3067\u3082\u4e0a\u6d41\u304b\u3089\u6765\u305fRaw\u30c7\u30fc\u30bf\u306a\u3069\u3092\u6574\u5f62\u3057\u30e6\u30fc\u30b6\u30fc\u306b\u53ef\u8996\u5316\u3057\u3066\u5c4a\u3051\u308b\u696d\u52d9\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3067\u5f97\u305fTips\u3092\u6d3b\u304b\u3059\u3053\u3068\u3067\u3088\u308a\u30c7\u30fc\u30bf\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\u306e\u30ea\u30c6\u30e9\u30b7\u30fc\u306e\u3042\u308b\u30d7\u30ed\u30c0\u30af\u30c8\u306b\u8fd1\u3065\u3051\u3089\u308c\u305d\u3046\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f 3\u5c64\u306e\u5f79\u5272 Bronze \u300c\u307e\u305a\u5168\u3066\u53d7\u3051\u53d6\u308b\u300d Silver \u300c\u4f7f\u3048\u308b\u72b6\u614b\u306b\u3059\u308b\u300d Gold \u300c\u7b54\u3048\u3092\u51fa\u3059\u300d \u306a\u305c\u5c64\u3092\u5206\u3051\u308b\u306e\u304b \u5b9f\u52d9\u3067\u306e\u4f4d\u7f6e\u4ed8\u3051 \u30c4\u30fc\u30eb \u5f79\u5272 Delta Lake \/ A [&#8230;]<\/p>\n","protected":false},"author":211,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[1051,323],"tags":[1195],"class_list":["post-83751","post","type-post","status-publish","format-standard","hentry","category-h-sugiyama","category-python","tag-1195"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3<\/title>\n<meta name=\"description\" content=\"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"og:description\" content=\"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751\" \/>\n<meta property=\"og:site_name\" content=\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/creationline\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-04T08:43:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-04T08:43:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2026\/01\/screenshot.png\" \/>\n\t<meta property=\"og:image:width\" content=\"470\" \/>\n\t<meta property=\"og:image:height\" content=\"394\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SugiyamaHaruki\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@creationline\" \/>\n<meta name=\"twitter:site\" content=\"@creationline\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"SugiyamaHaruki\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751\"},\"author\":{\"name\":\"SugiyamaHaruki\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/ad78b1a0e266d91d08fa55058698d915\"},\"headline\":\"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f\",\"datePublished\":\"2026-06-04T08:43:44+00:00\",\"dateModified\":\"2026-06-04T08:43:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751\"},\"wordCount\":37,\"keywords\":[\"\u30c7\u30fc\u30bf\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\"],\"articleSection\":[\"h-sugiyama\",\"Python\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751\",\"name\":\"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#website\"},\"datePublished\":\"2026-06-04T08:43:44+00:00\",\"dateModified\":\"2026-06-04T08:43:45+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/ad78b1a0e266d91d08fa55058698d915\"},\"description\":\"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/others\\\/python\\\/83751#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"HOME\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u8457\u8005\uff08Author\uff09\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/author\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"h-sugiyama\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/author\\\/h-sugiyama\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/\",\"name\":\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"description\":\"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/ad78b1a0e266d91d08fa55058698d915\",\"name\":\"SugiyamaHaruki\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/IMG_8618-230x230.jpg\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/IMG_8618-230x230.jpg\",\"contentUrl\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/IMG_8618-230x230.jpg\",\"caption\":\"SugiyamaHaruki\"},\"description\":\"\u30af\u30e9\u30a6\u30c9\u306b\u8208\u5473\u304c\u3042\u308a\u307e\u3059\u3002 \u97f3\u697d\u3068\u8d70\u308b\u3053\u3068\u304c\u597d\u304d\u3067\u3059\u3002\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/author\\\/h-sugiyama\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3","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:\/\/www.creationline.com\/tech-blog\/others\/python\/83751","og_locale":"ja_JP","og_type":"article","og_title":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","og_description":"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3","og_url":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751","og_site_name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","article_publisher":"https:\/\/www.facebook.com\/creationline","article_published_time":"2026-06-04T08:43:44+00:00","article_modified_time":"2026-06-04T08:43:45+00:00","og_image":[{"width":470,"height":394,"url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2026\/01\/screenshot.png","type":"image\/png"}],"author":"SugiyamaHaruki","twitter_card":"summary_large_image","twitter_creator":"@creationline","twitter_site":"@creationline","twitter_misc":{"\u57f7\u7b46\u8005":"SugiyamaHaruki","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"5\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751#article","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751"},"author":{"name":"SugiyamaHaruki","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/ad78b1a0e266d91d08fa55058698d915"},"headline":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f","datePublished":"2026-06-04T08:43:44+00:00","dateModified":"2026-06-04T08:43:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751"},"wordCount":37,"keywords":["\u30c7\u30fc\u30bf\u30de\u30cd\u30b8\u30e1\u30f3\u30c8"],"articleSection":["h-sugiyama","Python"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751","url":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751","name":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#website"},"datePublished":"2026-06-04T08:43:44+00:00","dateModified":"2026-06-04T08:43:45+00:00","author":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/ad78b1a0e266d91d08fa55058698d915"},"description":"h-sugiyama, Python |\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3068\u306f \u30c7\u30fc\u30bf\u3092\u300c\u6bb5\u968e\u7684\u306b\u54c1\u8cea\u3042\u3052\u306a\u304c\u3089\u4fdd\u5b58\u3059\u308b\u300d\u8a2d\u8a08\u30d1\u30bf\u30fc\u30f3","breadcrumb":{"@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.creationline.com\/tech-blog\/others\/python\/83751#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"HOME","item":"https:\/\/www.creationline.com\/tech-blog"},{"@type":"ListItem","position":2,"name":"\u8457\u8005\uff08Author\uff09","item":"https:\/\/www.creationline.com\/tech-blog\/author"},{"@type":"ListItem","position":3,"name":"h-sugiyama","item":"https:\/\/www.creationline.com\/tech-blog\/author\/h-sugiyama"},{"@type":"ListItem","position":4,"name":"\u30e1\u30c0\u30ea\u30aa\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3063\u3066\uff1f"}]},{"@type":"WebSite","@id":"https:\/\/www.creationline.com\/tech-blog\/#website","url":"https:\/\/www.creationline.com\/tech-blog\/","name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.creationline.com\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/ad78b1a0e266d91d08fa55058698d915","name":"SugiyamaHaruki","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2025\/09\/IMG_8618-230x230.jpg","url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2025\/09\/IMG_8618-230x230.jpg","contentUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2025\/09\/IMG_8618-230x230.jpg","caption":"SugiyamaHaruki"},"description":"\u30af\u30e9\u30a6\u30c9\u306b\u8208\u5473\u304c\u3042\u308a\u307e\u3059\u3002 \u97f3\u697d\u3068\u8d70\u308b\u3053\u3068\u304c\u597d\u304d\u3067\u3059\u3002","url":"https:\/\/www.creationline.com\/tech-blog\/author\/h-sugiyama"}]}},"_links":{"self":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/83751","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/users\/211"}],"replies":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/comments?post=83751"}],"version-history":[{"count":4,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/83751\/revisions"}],"predecessor-version":[{"id":84132,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/83751\/revisions\/84132"}],"wp:attachment":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/media?parent=83751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/categories?post=83751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/tags?post=83751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}