{ "cells": [ { "cell_type": "markdown", "id": "84130e7d", "metadata": {}, "source": [ "# Interpreting Used DJI Drone Listed Price Ranges\n", "\n", "## tl;dr\n", "\n", "This reproducible companion validates **43 aircraft-model aggregates**\n", "summarizing **251 published catalog configurations** in the\n", "Reboot Hub Q3 2026 dataset. The values are **listed prices, not completed-sale prices**.\n", "Configuration counts describe **configuration coverage, not sales volume or market demand**.\n", "\n", "The notebook shows how to read low, median and high listed-price points without\n", "treating a one-date catalog snapshot as a transaction index or a time series.\n", "\n", "- Maintained source: [https://reboot-hub.com/pages/reboot-hub-data](https://reboot-hub.com/pages/reboot-hub-data)\n", "- Exact version DOI: [https://doi.org/10.5281/zenodo.21387578](https://doi.org/10.5281/zenodo.21387578)\n", "- GitHub release: [https://github.com/Reboot-Hub/dji-drone-specs-used-price-index/releases/tag/v0.2.0](https://github.com/Reboot-Hub/dji-drone-specs-used-price-index/releases/tag/v0.2.0)\n" ] }, { "cell_type": "markdown", "id": "ffe49c9d", "metadata": {}, "source": [ "## Context & Methods\n", "\n", "### Key assumptions and boundaries\n", "\n", "- Snapshot date: **2026-07-07**; release: **2026-Q3**.\n", "- Grain: one aircraft model-level aggregate, not one sale or one customer order.\n", "- Price ranges can reflect condition, controller, battery, accessory and bundle\n", " differences. A wide range is not proof of price volatility.\n", "- The underlying configuration rows are not included in this public release.\n", "- A single snapshot cannot establish a price trend. Trend comparisons require a\n", " later quarterly release generated with the same method.\n", "- Reboot Hub is **not affiliated with, endorsed by, or officially authorized by DJI**.\n", "\n", "The analysis uses only the public CC BY 4.0 release. It does not contain customer,\n", "supplier, repair-order, cost or credential data.\n" ] }, { "cell_type": "markdown", "id": "9fa8d79a", "metadata": {}, "source": [ "## Data\n", "\n", "### 1. Load the versioned public CSV\n" ] }, { "cell_type": "code", "execution_count": 1, "id": "c45479f3", "metadata": { "execution": { "iopub.execute_input": "2026-07-16T13:37:42.446280Z", "iopub.status.busy": "2026-07-16T13:37:42.446280Z", "iopub.status.idle": "2026-07-16T13:37:43.007012Z", "shell.execute_reply": "2026-07-16T13:37:43.006509Z" } }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Loaded 43 rows from ..\\model_price_summary_2026_q3.csv\n" ] } ], "source": [ "import base64\n", "from html import escape\n", "from io import BytesIO\n", "from pathlib import Path\n", "\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "from IPython.display import HTML, display\n", "\n", "DATA_FILENAME = 'model_price_summary_2026_q3.csv'\n", "RAW_RELEASE_URL = 'https://raw.githubusercontent.com/Reboot-Hub/dji-drone-specs-used-price-index/v0.2.0/model_price_summary_2026_q3.csv'\n", "EXPECTED_MODEL_ROWS = 43\n", "EXPECTED_CONFIGURATION_COUNT = 251\n", "\n", "\n", "def display_figure(fig, alt_text):\n", " buffer = BytesIO()\n", " fig.savefig(buffer, format=\"png\", dpi=144, bbox_inches=\"tight\")\n", " encoded = base64.b64encode(buffer.getvalue()).decode(\"ascii\")\n", " safe_alt = escape(alt_text, quote=True)\n", " display(\n", " HTML(\n", " f'\"{safe_alt}\"'\n", " )\n", " )\n", " plt.close(fig)\n", "\n", "local_candidates = [\n", " Path(DATA_FILENAME),\n", " Path(\"..\") / DATA_FILENAME,\n", " Path(\"/kaggle/input/dji-drone-specs-used-price-index\") / DATA_FILENAME,\n", "]\n", "local_source = next((path for path in local_candidates if path.exists()), None)\n", "data_source = local_source if local_source is not None else RAW_RELEASE_URL\n", "data = pd.read_csv(data_source)\n", "\n", "print(f\"Loaded {len(data)} rows from {data_source}\")\n" ] }, { "cell_type": "markdown", "id": "7ece0a43", "metadata": {}, "source": [ "### 2. Re-run the publication gates\n" ] }, { "cell_type": "code", "execution_count": 2, "id": "ddeec64f", "metadata": { "execution": { "iopub.execute_input": "2026-07-16T13:37:43.008016Z", "iopub.status.busy": "2026-07-16T13:37:43.008016Z", "iopub.status.idle": "2026-07-16T13:37:43.016387Z", "shell.execute_reply": "2026-07-16T13:37:43.016387Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
checkresult
0aircraft-model rows43
1published configurations summarized251
2duplicate model names0
3invalid low/median/high ranges0
4snapshot dates2026-07-07
\n", "
" ], "text/plain": [ " check result\n", "0 aircraft-model rows 43\n", "1 published configurations summarized 251\n", "2 duplicate model names 0\n", "3 invalid low/median/high ranges 0\n", "4 snapshot dates 2026-07-07" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "required_columns = {\n", " \"model\",\n", " \"configurations_tracked\",\n", " \"listed_price_low_usd\",\n", " \"listed_price_high_usd\",\n", " \"median_listed_price_usd\",\n", " \"snapshot_date\",\n", " \"release_quarter\",\n", " \"observation_unit\",\n", " \"quality_status\",\n", " \"source_url\",\n", " \"methodology_note\",\n", " \"non_affiliation_note\",\n", "}\n", "\n", "assert required_columns.issubset(data.columns)\n", "assert len(data) == EXPECTED_MODEL_ROWS\n", "assert int(data[\"configurations_tracked\"].sum()) == EXPECTED_CONFIGURATION_COUNT\n", "assert data[\"model\"].str.casefold().is_unique\n", "assert (data[\"configurations_tracked\"] > 0).all()\n", "assert (data[\"listed_price_low_usd\"] <= data[\"median_listed_price_usd\"]).all()\n", "assert (data[\"median_listed_price_usd\"] <= data[\"listed_price_high_usd\"]).all()\n", "assert data[\"snapshot_date\"].nunique() == 1\n", "assert data[\"release_quarter\"].nunique() == 1\n", "assert (data[\"quality_status\"] == \"passed_publication_gate\").all()\n", "\n", "validation_summary = pd.DataFrame(\n", " {\n", " \"check\": [\n", " \"aircraft-model rows\",\n", " \"published configurations summarized\",\n", " \"duplicate model names\",\n", " \"invalid low/median/high ranges\",\n", " \"snapshot dates\",\n", " ],\n", " \"result\": [\n", " len(data),\n", " int(data[\"configurations_tracked\"].sum()),\n", " int(data[\"model\"].str.casefold().duplicated().sum()),\n", " int(\n", " (\n", " (data[\"listed_price_low_usd\"] > data[\"median_listed_price_usd\"])\n", " | (data[\"median_listed_price_usd\"] > data[\"listed_price_high_usd\"])\n", " ).sum()\n", " ),\n", " \", \".join(sorted(data[\"snapshot_date\"].astype(str).unique())),\n", " ],\n", " }\n", ")\n", "display(validation_summary)\n" ] }, { "cell_type": "markdown", "id": "48ca2bcf", "metadata": {}, "source": [ "## Results\n", "\n", "### 3. Inspect configuration coverage\n", "\n", "`configurations_tracked` counts the catalog configurations summarized for a\n", "model. It is useful for judging how much listed-price variation was observed,\n", "but it is **not** a proxy for sales, searches, installed base or popularity.\n" ] }, { "cell_type": "code", "execution_count": 3, "id": "eca6e80d", "metadata": { "execution": { "iopub.execute_input": "2026-07-16T13:37:43.017391Z", "iopub.status.busy": "2026-07-16T13:37:43.017391Z", "iopub.status.idle": "2026-07-16T13:37:43.141334Z", "shell.execute_reply": "2026-07-16T13:37:43.141334Z" } }, "outputs": [ { "data": { "text/html": [ "\"Bar" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "coverage = (\n", " data[[\"model\", \"configurations_tracked\"]]\n", " .sort_values([\"configurations_tracked\", \"model\"], ascending=[False, True])\n", " .head(12)\n", " .sort_values(\"configurations_tracked\")\n", ")\n", "\n", "fig, ax = plt.subplots(figsize=(9, 5.5))\n", "ax.barh(coverage[\"model\"], coverage[\"configurations_tracked\"], color=\"#d71920\")\n", "ax.set_title(\"Highest configuration coverage in the Q3 2026 snapshot\")\n", "ax.set_xlabel(\"Published catalog configurations summarized\")\n", "ax.set_ylabel(\"\")\n", "ax.set_xlim(left=0)\n", "ax.grid(axis=\"x\", alpha=0.2)\n", "plt.tight_layout()\n", "display_figure(\n", " fig,\n", " \"Bar chart of configuration coverage by DJI model in the Q3 2026 listed-price snapshot.\",\n", ")\n" ] }, { "cell_type": "markdown", "id": "14e3f346", "metadata": {}, "source": [ "### 4. Read listed-price ranges with their median points\n", "\n", "The next view is limited to the same twelve models with the greatest configuration\n", "coverage. Horizontal lines show observed low-to-high listed prices, while dots\n", "show the model-level median. The chart compares catalog ranges only; it does not\n", "measure transaction value, depreciation or market volatility.\n" ] }, { "cell_type": "code", "execution_count": 4, "id": "b299f995", "metadata": { "execution": { "iopub.execute_input": "2026-07-16T13:37:43.142886Z", "iopub.status.busy": "2026-07-16T13:37:43.142369Z", "iopub.status.idle": "2026-07-16T13:37:43.244269Z", "shell.execute_reply": "2026-07-16T13:37:43.244269Z" } }, "outputs": [ { "data": { "text/html": [ "\"Range" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
ModelConfigsListed range (USD)Median
DJI Mini 310$280 to $530$405
DJI Mavic 2 Pro10$276 to $700$455
DJI Mavic 210$247 to $700$465
DJI Mavic Air 210$241 to $750$470
DJI Mini 3 Pro10$380 to $740$516
DJI Air 2S10$391 to $776$543
DJI Mini 4 Pro10$461 to $850$672
DJI Air 310$591 to $1,129$828
DJI Air 3S10$790 to $1,320$1,066
DJI Mavic 310$1,481 to $2,601$1,953
DJI Mavic 3 Classic10$2,140 to $2,721$2,450
DJI Mavic 3 Pro10$1,712 to $3,354$2,486
" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "range_view = (\n", " data.merge(coverage[[\"model\"]], on=\"model\", how=\"inner\")\n", " .sort_values(\"median_listed_price_usd\")\n", " .reset_index(drop=True)\n", ")\n", "range_view[\"listed_price_spread_usd\"] = (\n", " range_view[\"listed_price_high_usd\"] - range_view[\"listed_price_low_usd\"]\n", ")\n", "\n", "fig, ax = plt.subplots(figsize=(10, 6.5))\n", "positions = range(len(range_view))\n", "ax.hlines(\n", " positions,\n", " range_view[\"listed_price_low_usd\"],\n", " range_view[\"listed_price_high_usd\"],\n", " color=\"#59636e\",\n", " linewidth=3,\n", ")\n", "ax.scatter(\n", " range_view[\"median_listed_price_usd\"],\n", " list(positions),\n", " color=\"#d71920\",\n", " s=45,\n", " zorder=3,\n", " label=\"Median listed price\",\n", ")\n", "ax.set_yticks(list(positions), range_view[\"model\"])\n", "ax.set_title(\"Observed listed-price ranges for the most-covered models\")\n", "ax.set_xlabel(\"Listed price (USD)\")\n", "ax.set_ylabel(\"\")\n", "ax.set_xlim(left=0)\n", "ax.grid(axis=\"x\", alpha=0.2)\n", "ax.legend(loc=\"lower right\")\n", "plt.tight_layout()\n", "display_figure(\n", " fig,\n", " \"Range chart of low, median and high listed prices for the twelve models with the highest configuration coverage.\",\n", ")\n", "\n", "cell_style = (\n", " \"border:1px solid #dfe3e8;padding:5px;text-align:left;vertical-align:top;\"\n", " \"white-space:normal;overflow-wrap:anywhere;\"\n", ")\n", "header_style = cell_style + \"background:#111827;color:#fff;font-weight:700;\"\n", "table_rows = []\n", "for _, row in range_view.iterrows():\n", " listed_range = (\n", " f\"${row['listed_price_low_usd']:,.0f} to \"\n", " f\"${row['listed_price_high_usd']:,.0f}\"\n", " )\n", " median = f\"${row['median_listed_price_usd']:,.0f}\"\n", " table_rows.append(\n", " \"\"\n", " f'{escape(str(row[\"model\"]))}'\n", " f'{int(row[\"configurations_tracked\"])}'\n", " f'{escape(listed_range)}'\n", " f'{escape(median)}'\n", " \"\"\n", " )\n", "\n", "table_html = (\n", " ''\n", " \"\"\n", " f''\n", " f''\n", " f''\n", " f''\n", " \"\"\n", " + \"\".join(table_rows)\n", " + \"
ModelConfigsListed range (USD)Median
\"\n", ")\n", "display(HTML(table_html))\n" ] }, { "cell_type": "markdown", "id": "7cf7966a", "metadata": {}, "source": [ "## Takeaways\n", "\n", "1. The public release contains **43 aircraft-model aggregates** covering\n", " **251 published catalog configurations** after documented\n", " exclusion and normalization gates.\n", "2. A model name alone does not explain its observed listed-price range. Bundle,\n", " controller, battery, accessories and condition can all move the endpoints.\n", "3. Configuration coverage is a data-coverage measure, not sales volume or market\n", " demand. Listed prices are not completed-sale prices.\n", "4. The Q3 2026 release is a baseline snapshot. No depreciation or trend claim is\n", " supportable until a later, methodologically comparable quarter exists.\n", "5. For formal reuse, cite **Reboot Hub DJI Drone Specs and Used Price Index v0.2.0**\n", " using DOI [10.5281/zenodo.21387578](https://doi.org/10.5281/zenodo.21387578) and retain the methodology\n", " boundary from the [maintained source](https://reboot-hub.com/pages/reboot-hub-data).\n", "\n", "License: CC BY 4.0. Reboot Hub is not affiliated with, endorsed by, or officially\n", "authorized by DJI.\n" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.12.10" }, "reboot_hub_asset": { "canonical": "https://reboot-hub.com/pages/reboot-hub-data", "doi": "10.5281/zenodo.21387578", "release": "v0.2.0" } }, "nbformat": 4, "nbformat_minor": 5 }