31:T150a,chargeChart = { const margin = { top: 50, right: 30, bottom: 150, left: 30 }; const height = 20 * chargeData.length + margin.top + margin.bottom; const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const xScale = d3 .scaleLinear() .domain([0, 10000]) .range([margin.left * 8, width - margin.right]); const yScale = d3 .scaleBand() .domain(chargeData.map((d) => d[0])) .range([margin.top, height - margin.bottom]) .padding(0.1); const xAxis = d3 .axisTop() .scale(xScale) .ticks(10000 / 500); const yAxis = d3.axisLeft().scale(yScale); // 方眼線の描画 const gridLines = svg.append("g").attr("class", "grid-lines"); // 横方向の方眼線 yScale.domain().forEach((d) => { gridLines .append("line") .attr("class", "horizontal") .attr("x1", margin.left) .attr("x2", width - margin.right) .attr("y1", yScale(d) + yScale.bandwidth()) .attr("y2", yScale(d) + yScale.bandwidth()) .attr("stroke", "lightgray") .attr("stroke-width", 1); }); xScale.ticks(10000 / 500).forEach((tick) => { gridLines .append("line") .attr("class", "vertical") .attr("x1", xScale(tick)) .attr("x2", xScale(tick)) .attr("y1", margin.top) .attr("y2", height - margin.bottom) .attr("stroke", "lightgray") .attr("stroke-dasharray", 4); }); svg .selectAll("path") .data(chargeData) .join("path") .attr("d", (d) => { const x1 = d[1] === 0 ? margin.left * 8 : xScale(d[1]); const x2 = d[1] === 0 ? x1 : Math.max(xScale(d[2]) - xScale(d[1]), 2) + x1; const y1 = yScale(d[0]) + yScale.bandwidth() / 2; // 中心位置 return `M${x1},${y1} L${x2},${y1}`; }) .attr("stroke", (d) => colorScale(d[4])) .attr("stroke-width", 2) .attr("fill", "none") .on("mouseover", function (e, d, i) { tooltip .html( `

${d[0]}
価格:${d[1]}円~${d[2]}円
開催地:${d[3]}
オケ区分:${d[4]}
交響曲:${d[5]}第${d[6]}番
協奏曲:${d[7]}

${d.data[0]}
価格:${d.data[1]}円~${d.data[2]}円
開催地:${d.data[3]}
オケ区分:${d.data[4]}
交響曲:${d.data[5]}第${d.data[6]}番
協奏曲:${d.data[7]}

` ) .style("visibility", "visible"); d3.select(this).attr("opacity", 0.5); }) .on("mousemove", function (e) { // ツールチップの横幅を取得 var tooltipWidth = tooltip.node().offsetWidth; var tooltipHeight = tooltip.node().offsetHeight; // マウスのX座標によって条件分岐 var tooltipX = e.pageX < window.innerWidth / 2 ? e.pageX + 10 : e.pageX - tooltipWidth - 10; // マウスのY座標によって条件分岐 var tooltipY = e.pageY < height / 2 ? e.pageY - tooltipHeight - 10 : e.pageY + 10; // ツールチップをマウスの位置に移動 tooltip .style("top", tooltipY + "px") .style("left", tooltipX + "px") .style("width", "300px"); }) .on("mouseout", function () { tooltip.html(``).style("visibility", "hidden"); d3.select(this).transition().attr("opacity", 1); }); svg .append("g") .attr("transform", `translate(0, ${margin.top})`) .call(xAxis) .selectAll("text") .style("font-size", "10px") .attr("transform", "rotate(30)") .style("text-anchor", "end"); svg .append("g") .attr("transform", `translate(${margin.left * 8}, 0)`) .call(yAxis) .selectAll("text") .style("font-size", "12px") .style("text-anchor", "end"); return svg.node(); } 32:Ta53,areaChart = { const height = 700; const margin = { top: 30, right: 30, bottom: 30, left: 30 }; const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const xScale = d3 .scaleLinear() .domain([0, d3.max(stackedData, (d) => d3.max(d, (e) => e[1]))]) .range([margin.left * 4, width - margin.right]); const sortedPrefectures = areaTotal .slice() .sort((a, b) => d3.descending(a[1], b[1])) // 値の降順にソート .map((d) => d[0]); const yScale = d3 .scaleBand() //.domain(prefectures) .domain(sortedPrefectures) .range([margin.top, height - margin.bottom]) .padding(0.1); const xAxis = d3.axisTop().scale(xScale); const yAxis = d3.axisLeft().scale(yScale); // 軸の文字サイズをデータ数に応じて調整 const fontSize = 8; svg .append("g") .selectAll("g") .data(stackedData) // 各カテゴリ .join("g") .attr("fill", (d) => colorScale(d.key)) // カテゴリごとの色(d) => colorScale(d.key) .selectAll("rect") .data((d) => d) // 各データポイント .join("rect") .attr("x", (d) => xScale(d[0])) // 開始位置 .attr("y", (d) => yScale(d.data.area)) // 地域名に基づく位置 .attr("width", (d) => xScale(d[1]) - xScale(d[0])) // 幅 .attr("height", yScale.bandwidth()) .on("mouseover", function (event, d) { // ホバー時のイベント const genre = d3.select(this.parentNode).datum().key; const value = d[1] - d[0]; // ツールチップを表示 tooltip.html(` ${genre}
${value}`).style("visibility", "visible"); }) .on("mousemove", function (event) { // マウスの位置にツールチップを追従 tooltip .style("top", event.pageY - 10 + "px") .style("left", event.pageX + 10 + "px"); }) .on("mouseout", function () { // ホバーが外れた時のイベント // ツールチップを非表示にする tooltip.style("visibility", "hidden"); }); svg .append("g") .selectAll("text") .data(areaTotal) .join("text") .attr("text-anchor", "middle") .attr("x", (d) => xScale(d[1]) + 5) // .attr("y", (d) => yScale(d[0]) + yScale.bandwidth() / 2) // .attr("font-family", "sans-serif") .attr("font-size", 8) .attr("fill", "black") .text((d) => d[1]); svg.append("g").attr("transform", `translate(0, ${margin.top})`).call(xAxis); svg .append("g") .attr("transform", `translate(${margin.left * 4}, 0)`) .call(yAxis) .selectAll("text") .style("font-size", `${fontSize}px`); return svg.node(); }33:T173e,viewof chart = { const height = width / 2, margin = { top: 70, right: 20, bottom: 100, left: 150 }; const svg = d3.create("svg").attr("width", width).attr("height", height); const yScale = d3 .scaleBand() .domain(proChargeData4.map((d) => d[0])) .range([margin.top, height - margin.bottom]); const xScale = d3 .scaleLinear() .domain([0, d3.max(proChargeData4, (d) => d[4])]) .range([margin.left, width - margin.right]); // 方眼線の描画 const gridLines = svg.append("g").attr("class", "grid-lines"); // 横方向の方眼線 yScale.domain().forEach((d) => { gridLines .append("line") .attr("class", "horizontal") .attr("x1", margin.left) .attr("x2", width - margin.right) .attr("y1", yScale(d) + yScale.bandwidth()) .attr("y2", yScale(d) + yScale.bandwidth()) .attr("stroke", "lightgray") .attr("stroke-width", 1); }); xScale.ticks(10000 / 500).forEach((tick) => { gridLines .append("line") .attr("class", "vertical") .attr("x1", xScale(tick)) .attr("x2", xScale(tick)) .attr("y1", margin.top) .attr("y2", height - margin.bottom) .attr("stroke", "lightgray") .attr("stroke-dasharray", 4); }); // 軸 svg .append("g") .attr("transform", `translate(0,${margin.top})`) .call(d3.axisTop(xScale)); svg .append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(yScale)); // 座席種類 const seats = [3, 12, 13, 14, 15, 16, 4]; const discounts = [1, 7, 8, 9, 10, 11, 2]; // 一般料金の線と点（横向き） proChargeData4.map((d) => { const generalPoints = seats.map((seat) => ({ x: xScale(d[seat]), y: yScale(d[0]) + yScale.bandwidth() / 2 })); svg .append("path") .datum(generalPoints) .attr("fill", "none") .attr("stroke", "#90CAF9") .attr("stroke-width", 2) .attr( "d", d3 .line() .x((d) => d.x) .y((d) => d.y) ); svg .selectAll(`.general-${d.name}`) .data(generalPoints.map((p) => ({ ...p, meta: d }))) .enter() .append("circle") .attr("cx", (d) => d.x) .attr("cy", (d) => d.y) .attr("r", 5) .attr("fill", "#90CAF9") //マウスホバー//12, 13, 14, 15, 16 .on("mouseover", function (e, d) { const concert = d.meta; tooltip .html( `

${concert[0]}
S席: ${concert[12]}円
A席: ${concert[13]}円
B席: ${concert[14]}円
C席: ${concert[15]}円
D席: ${concert[16]}円
開催地: ${concert[5]}
協奏曲: ${concert[6]}

${concert[0]}
割引S席: ${concert[7]}円
割引A席: ${concert[8]}円
割引B席: ${concert[9]}円
割引C席: ${concert[10]}円
割引D席: ${concert[11]}円
開催地: ${concert[5]}
協奏曲: ${concert[6]}

` ) .style("visibility", "visible"); d3.select(this).attr("opacity", 0.5); }) .on("mousemove", function (e) { // ツールチップの横幅を取得 var tooltipWidth = tooltip.node().offsetWidth; var tooltipHeight = tooltip.node().offsetHeight; // マウスのX座標によって条件分岐 var tooltipX = e.pageX < window.innerWidth / 2 ? e.pageX + 10 : e.pageX - tooltipWidth - 10; // マウスのY座標によって条件分岐 var tooltipY = e.pageY < height / 2 ? e.pageY - tooltipHeight - 10 : e.pageY + 10; // ツールチップをマウスの位置に移動 tooltip .style("top", tooltipY + "px") .style("left", tooltipX + "px") .style("width", "300px"); }) .on("mouseout", function () { tooltip.html(``).style("visibility", "hidden"); d3.select(this).transition().attr("opacity", 1); }); }); return svg.node(); }34:T73a,chargeAmatyuaHistogram = { const margin = { top: 50, right: 30, bottom: 30, left: 30 }; const height = width / 2; const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const xScale = d3 .scaleBand() .domain(histogramAnxis) .range([margin.left, width - margin.right]) .padding(0.1); const yScale = d3 .scaleLinear() .domain([0, d3.max(histogramData, (d) => d.value)]) .range([height - margin.bottom, margin.top]); const xAxis = d3.axisBottom().scale(xScale); const yAxis = d3.axisLeft().scale(yScale); svg .append("g") .selectAll("rect") .data(histogramData) .join("rect") .attr("x", (d) => xScale(d.key)) .attr("y", yScale(0)) .attr("width", xScale.bandwidth()) .attr("height", 0) .attr("fill", "#8cc") .transition() // ここからトランジション .duration(1000) // トランジションにかかる時間（3000ms） .delay((d, i) => i * 50) // 遅延時間（データ番号順に100ms） .attr("y", (d) => yScale(d.value)) // 最終位置 .attr("height", (d) => yScale(0) - yScale(d.value)); svg .append("g") .selectAll("text") .data(histogramData) .join("text") .attr("text-anchor", "middle") .attr("x", (d) => xScale(d.key) + xScale.bandwidth() / 2) // .attr("y", (d) => yScale(d.value) - 5) // .attr("font-family", "sans-serif") .attr("font-size", 12) .attr("fill", "black") .text((d) => d.value); svg .append("g") .attr("transform", `translate(0, ${height - margin.bottom})`) .call(xAxis) .selectAll("text") .style("font-size", "10px"); svg .append("g") .attr("transform", `translate(${margin.left}, 0)`) .call(yAxis) .selectAll("text") .style("font-size", "12px") .style("text-anchor", "end"); return svg.node(); }35:T77b,chargeProHistogram = { const margin = { top: 50, right: 30, bottom: 50, left: 30 }; const height = width / 2; const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const xScale = d3 .scaleBand() .domain(histogramAnxis2) .range([margin.left, width - margin.right]) .padding(0.1); const yScale = d3 .scaleLinear() .domain([0, d3.max(kirikae, (d) => d.value)]) .range([height - margin.bottom, margin.top]); const xAxis = d3.axisBottom().scale(xScale); const yAxis = d3.axisLeft().scale(yScale).ticks(3); svg .append("g") .selectAll("rect") .data(kirikae) .join("rect") .attr("x", (d) => xScale(d.key)) .attr("y", yScale(0)) .attr("width", xScale.bandwidth()) .attr("height", 0) .attr("fill", "#f78") .transition() // ここからトランジション .duration(1000) // トランジションにかかる時間（3000ms） .delay((d, i) => i * 100) // 遅延時間（データ番号順に100ms） .attr("y", (d) => yScale(d.value)) // 最終位置 .attr("height", (d) => yScale(0) - yScale(d.value)); svg .append("g") .selectAll("text") .data(kirikae) .join("text") .attr("text-anchor", "middle") .attr("x", (d) => xScale(d.key) + xScale.bandwidth() / 2) // .attr("y", (d) => yScale(d.value) - 5) // .attr("font-family", "sans-serif") .attr("font-size", 12) .attr("fill", "black") .text((d) => d.value); svg .append("g") .attr("transform", `translate(0, ${height - margin.bottom})`) .call(xAxis) .selectAll("text") //.attr("transform", "rotate(-20)") // .style("text-anchor", "end") .style("font-size", "10px"); svg .append("g") .attr("transform", `translate(${margin.left}, 0)`) .call(yAxis) .selectAll("text") .style("font-size", "12px") .style("text-anchor", "end"); return svg.node(); }36:T830,// Copyright 2021, Observable Inc. // Released under the ISC license. // https://observablehq.com/@d3/color-legend function Swatches(color, { columns = null, format, unknown: formatUnknown, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 } = {}) { const id = `-swatches-${Math.random().toString(16).slice(2)}`; const unknown = formatUnknown == null ? undefined : color.unknown(); const unknowns = unknown == null || unknown === d3.scaleImplicit ? [] : [unknown]; const domain = color.domain().concat(unknowns); if (format === undefined) format = x => x === unknown ? formatUnknown : x; function entity(character) { return `&#${character.charCodeAt(0).toString()};`; } if (columns !== null) return htl.html`

${domain.map(value => { const label = `${format(value)}`; return htl.html`

${label}

`; })}

`; return htl.html`

${domain.map(value => htl.html`${format(value)}`)}

`; }37:T606,Plot.plot({ width: width, height: width * 0.75, projection: { type: "azimuthal-equidistant", rotate: [-136, 0], domain: land, insetLeft: 400 * 0.1 }, style: { background: "white" // 背景色を白に設定 }, marks: [ Plot.geo({ type: "Sphere" }, { fill: "#add8f7", stroke: "none" }), Plot.graticule(), Plot.geo(land, { fill: "white" }), // Plot.geo(topojson.feature(japan, japan.objects.municipalities).features, { // strokeWidth: 0.5, // stroke: "orange", // fill: "none" // }), Plot.geo(topojson.feature(japan, japan.objects.prefs).features, { stroke: "black", fill: "none" }), Plot.geo(areamap, { stroke: "white", r: (d) => { const radius = AreaRadiusMap.get(d.properties.name); // `newAreaMap`が`Map`の場合 return radius !== undefined ? radius : 0; // 見つからない場合はデフォルトの半径を使用 }, fill: "red", opacity: 0.5 }) /* Plot.text( areamap, // データ { text: (d) => { const text = areaCount1.get(d.properties.name); // areaCount1 から取得 return text !== undefined ? `${text}` : ""; // 値がない場合は 0 }, x: (d) => d.geometry.coordinates[0], // x 座標 (経度) y: (d) => d.geometry.coordinates[1], // y 座標 (緯度) fill: "white", fontSize: 8, // フォントサイズ textAnchor: "middle" // テキストの中央揃え } )*/ ] })38:T805,{ const container = yield htl.html`

`; const map = L.map(container); // タイルレイヤーを追加 L.tileLayer("https://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}.png", { attribution: '© CartoDB' }).addTo(map); // GeoJSONデータを追加し、マーカーをcircleMarkerでカスタマイズ const layer = L.geoJSON(areamap, { pointToLayer: function (feature, latlng) { const radiusValue = AreaRadiusMap.get(feature.properties.name); // 半径の値を計算 let radius; if (radiusValue <= 20) { radius = radiusValue * 3; // 半径が20以下なら2倍 } else if (radiusValue >= 30) { radius = radiusValue; // 半径が20以上なら50 } else { radius = 0; // それ以外の場合、半径は0 } // 半径が0の場合はcircleMarkerを作成しない if (radius > 0) { return L.circleMarker(latlng, { radius: radius, fillColor: "red", color: "none", fillOpacity: 0.5 }); } return null; // 半径が0の場合、マーカーを返さない }, onEachFeature: function (feature, layer) { const coordinates = feature.geometry.coordinates; const latlng = L.latLng(coordinates[1], coordinates[0]); // テキストラベルを追加 const text = areaCount1.get(feature.properties.name) || ""; const areaText = feature.properties.name || ""; if (text) { const icon = L.divIcon({ className: "text-label", // CSSクラスを設定 html: `${text}`, // テキストのスタイル iconSize: [0, 0], iconAnchor: [1, 4] }); L.marker(latlng, { icon: icon }).addTo(map); // マップにラベルを追加 } } }).addTo(map); // 地図のズームと位置をデータに合わせる map.fitBounds(layer.getBounds(), { maxZoom: 9 }); }39:[{"id":"a482ee1fe7b88161bd0f8108c176f97ac83f0bb861193745001e14125a0072d05c2e385c45b5a28246f3824835154a1816f722a2fa60ceb8a804953e863bf1a7","href":"https://static.observableusercontent.com/files/a482ee1fe7b88161bd0f8108c176f97ac83f0bb861193745001e14125a0072d05c2e385c45b5a28246f3824835154a1816f722a2fa60ceb8a804953e863bf1a7","name":"areaMap@1.json","type":"application/json","lastModified":1738539513263.522,"size":12590},{"id":"0e24d33ad9d11daf47aa40d8472044395e538b2abed19e33f7425e649616afc5af3140fe4c7973ff12eaba1dc42a7d115eff8011521c8b15f166944750945252","href":"https://static.observableusercontent.com/files/0e24d33ad9d11daf47aa40d8472044395e538b2abed19e33f7425e649616afc5af3140fe4c7973ff12eaba1dc42a7d115eff8011521c8b15f166944750945252","name":"オーケストラのチケット価格にはどのような傾向があるか？.png","type":"image/png","lastModified":1738548302221.713,"size":91925}] 2f:{"title":"オーケストラのチケット価格にはどのような傾向があるか？","cells":[{"id":0,"value":"# オーケストラのチケット価格にはどのような傾向があるか？","pinned":false,"hidden":false,"mode":"md"},{"id":3483,"value":"K.M","pinned":false,"hidden":false,"mode":"md"},{"id":3512,"value":"untitled = FileAttachment(\"オーケストラのチケット価格にはどのような傾向があるか？.png\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":222,"value":"## はじめに","pinned":false,"hidden":false,"mode":"md"},{"id":10,"value":"オーケストラを聴きに行ったことはありますか？\n私は大学オーケストラに所属しており、それをきっかけに演奏会へ足を運ぶようになりました。多くのオーケストラ団体が学生割引を設けており、私も積極的に活用しています。しかし、実際に会場を見渡してみると、若者の観客は決して多いとは言えません。\nなぜ若者の観客が少ないのか。その要因の一つとして、チケット価格が挙げられるかもしれません。学生割引があるとはいえ、一般的にオーケストラの公演は高価なイメージがあり、敷居が高いと感じる人も多いでしょう。そこで本記事では、日本全国のオーケストラのチケット価格の傾向を調査し、学生や若年層にとってどれほどアクセスしやすいものなのかを検証します。\nオーケストラを聴いたことがない方にも、実際のチケット価格を知ってもらうことで、演奏会へ足を運ぶきっかけになれば幸いです。","pinned":false,"hidden":false,"mode":"md"},{"id":1693,"value":"# オーケストラのチケット価格傾向","pinned":false,"hidden":false,"mode":"md"},{"id":482,"value":"### アマオケチケット価格閲覧ツール","pinned":false,"hidden":false,"mode":"md"},{"id":1729,"value":"チケットサイトticketから2024年11月~12月に行われたアマチュアオーケストラの定期演奏会のデータを集めました。
\n※最小価格は最も安い割引のものを表示
\n※手作業でデータを集めたため、抜けや誤りがあることご了承ください","pinned":false,"hidden":false,"mode":"md"},{"id":485,"value":"viewof groupRange = Inputs.range([1, 135], {\n step: 1,\n value: 100,\n label: \"表示する公演数\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":611,"value":"viewof selectedArea = Inputs.checkbox(Array.from(areatype.keys()), {\n step: 1,\n value: Array.from(areatype.keys()),\n label: \"地域\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":818,"value":"viewof selectedconcerto = Inputs.radio([\"すべて表示\", \"あり\", \"なし\"], {\n label: \"協奏曲\",\n value: \"すべて表示\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":864,"value":"viewof selectedMinOption = Inputs.radio(chargeMinRadio, {\n label: \"最低価格\", \n value: 0 \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":671,"value":"viewof selectedMaxOption = Inputs.radio(chargeMaxRadio, {\n label: \"最高価格\", \n value: 99999999\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":490,"value":"viewof narabikae = Inputs.select(chargeDataSort, { label: \"並び替え\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":524,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":3631,"value":"

おまけ

\n","pinned":false,"hidden":false,"mode":"html"},{"id":1539,"value":"viewof selectedComposer = Inputs.checkbox(composer, {\n step: 1,\n value: composer,\n label: \"作曲家\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3534,"value":"2ヶ月だけでも100以上もの公演があります。大学オケ、市民オケ、会社のオケなど様々なオーケストラ団体があります。東京周辺は公演数も多く、各地で1年にたくさん公演の機会があります。
\nまた、アマチュアオケにもプロとして活躍されている演奏家をお呼びした協奏曲が実施があります。プロオーケストラの協奏曲に比べて良い席で安価で楽しむことができるのが魅力です。
\n
\n都道府県ごとに分類したグラフ化してみます。","pinned":false,"hidden":false,"mode":"md"},{"id":3618,"value":"{\n const height = 60;\n const maxRowWidth = 300; // Set your desired maximum width\n const data = [\"アマチュア\", \"プロ\"];\n\n //const data = [...d3.group(dataset, (d) => d.Genre).keys()];\n\n const svg = d3.create(\"svg\").attr(\"viewBox\", [0, 0, width, height]);\n\n const g = svg\n .append(\"g\")\n .selectAll(\"g\")\n .data(data)\n .join(\"g\")\n .attr(\"transform\", (d, i) => {\n const col = Math.floor((i * 150) / maxRowWidth);\n const row = i - col * Math.floor(maxRowWidth / 150);\n return `translate(${20 + col * 150},${10 + row * 30})`;\n });\n\n g.append(\"circle\").attr(\"r\", 10).attr(\"fill\", colorScale);\n\n g.append(\"text\")\n .attr(\"x\", 10)\n .attr(\"dy\", 6)\n .text((d) => d);\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":250,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":3538,"value":"東京にはオーケストラ団体が圧倒的に多いです。先ほどのツールのチェックボックスを東京のみにすると、それだけ無料オーケストラの数も多いことがわかります。また、無料オーケストラは発足したばかりのオーケストラ団体であったり音大の学生オケであったりという傾向があります。","pinned":false,"hidden":false,"mode":"md"},{"id":1723,"value":"### プロオケチケット価格閲覧ツール","pinned":false,"hidden":false,"mode":"md"},{"id":1727,"value":"プロオケはほとんどの団体が1ヶ月に1回、2ヶ月に1回の公演を行なっています。ここでは日本オーケストラ連盟正会員20団体の2025年2月(開催がない場合は3月)に行われた定期演奏会(他一部演奏会)のデータを集めました。
\n席のランクを点で表記しています。
\n※1回券のみ
\n※値下げ表示は最も安い値下げ条件のみ
\n※手作業でデータを集めため、抜けや誤りがあることご了承ください","pinned":false,"hidden":false,"mode":"md"},{"id":3503,"value":"{\n const height = 60;\n const maxRowWidth = 300; // Set your desired maximum width\n const data = [\"一般料金\", \"割引料金\"];\n\n //const data = [...d3.group(dataset, (d) => d.Genre).keys()];\n\n const svg = d3.create(\"svg\").attr(\"viewBox\", [0, 0, width, height]);\n\n const g = svg\n .append(\"g\")\n .selectAll(\"g\")\n .data(data)\n .join(\"g\")\n .attr(\"transform\", (d, i) => {\n const col = Math.floor((i * 150) / maxRowWidth);\n const row = i - col * Math.floor(maxRowWidth / 150);\n return `translate(${20 + col * 150},${10 + row * 30})`;\n });\n\n g.append(\"circle\").attr(\"r\", 10).attr(\"fill\", GenreColor);\n\n g.append(\"text\")\n .attr(\"x\", 10)\n .attr(\"dy\", 6)\n .text((d) => d);\n\n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3699,"value":"viewof groupRange2 = Inputs.range([1, 26], {\n step: 1,\n value: 26,\n label: \"表示する公演数\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3651,"value":"viewof selectedArea2 = Inputs.checkbox(Array.from(areatype.keys()), {\n step: 1,\n value: Array.from(areatype.keys()),\n label: \"地域\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3654,"value":"viewof selectedconcerto2 = Inputs.radio([\"すべて表示\", \"あり\", \"なし\"], {\n label: \"協奏曲\",\n value: \"すべて表示\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3662,"value":"viewof narabikae2 = Inputs.select(chargeDataSort2, { label: \"並び替え\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":2074,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":3540,"value":"プロオケでは若年層を取り込むために積極的な値引きが行われていることがわかります。NHK交響楽団ではなんと学生料金は一般価格から半額にもなります。席のランクは低くとも国内トップレベルのオケを1000円で聞くことができるのです。読売交響楽団では学生のみ当日の残席をランク関係なく買うことができるシステムを行なっています。
\nまた、先ほど東京に公演が集中しているというデータを提示しましたが、プロオケも同じ傾向があるもののチケット最高価格は東京よりも低い値段になるようです。札幌では7000円、仙台では5000円、中部フィルでは6000円と上のランクの席が10000円を超える東京のオーケストラと比べるとかなり低い値段ということがわかりました。地方の人々も公演数は少なくとも東京より安い値段でオーケストラを楽しむことはできるようです。
\n\n

\n次にチケット価格の最安値をヒストグラム化してみます。","pinned":false,"hidden":false,"mode":"md"},{"id":1669,"value":"#### <アマオケ>チケット価格最安値比較ヒストグラム","pinned":false,"hidden":false,"mode":"md"},{"id":1565,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":1673,"value":"#### <プロオケ>チケット価格最安値比較ヒストグラム","pinned":false,"hidden":false,"mode":"md"},{"id":1911,"value":"viewof kirikae = Inputs.select(chargeDataSortPro, { label: \"料金\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1646,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":1000,"value":"アマチュアオーケストラはほとんどの公演を1000円以下で楽しむことができ、無料公演もあります。一方で、プロオケは一般料金は3000円前後が最低価格として多いです。しかし、学生割引を利用すると、プロオケでもランクの低い席のチケットあれば1000円前後で楽しむことができるものや3000円以下の席がほとんどになります。プロオケは学生のときにたくさん行っておくと非常に有益ですね。

\nアイドルやアーティストのライブとなると最安値でも6000円程度になるはずです。生演奏が3000円もしないで享受できるというのはとてもリーズナブルです。","pinned":false,"hidden":false,"mode":"md"},{"id":1079,"value":"# まとめ","pinned":false,"hidden":false,"mode":"md"},{"id":1081,"value":"本調査を通じて、多くのオーケストラ公演が手の届きやすい価格から提供されていることがわかりました。特に学生割引やユースチケットなどを活用すれば、映画やコンサートと変わらない、あるいはそれ以下の価格でハイレベルな演奏を楽しむこともできます。
\n50人以上の大人数が2時間前後演奏する姿は圧巻ですので一度体験してみて欲しいです。気軽にオーケストラの公演に足を運び、生演奏のオーケストラの魅力をぜひ体験してみてください。","pinned":false,"hidden":false,"mode":"md"},{"id":3555,"value":"## データを集めたサイト","pinned":false,"hidden":false,"mode":"md"},{"id":3566,"value":"・ticket\nhttps://teket.jp/events?word=交響曲&category=®ion=&event_date_from=2024-07-01&event_date_to=2024-09-30
\n・日本オーケストラ連盟\nhttps://www.orchestra.or.jp/accession/","pinned":false,"hidden":false,"mode":"md"},{"id":960,"value":"populationData = [\n {\n \"東京\": 14047594,\n \"神奈川\": 9237337,\n \"大阪府\": 8837685,\n }\n]\n\n//https://www.homemate.co.jp/research/population/all/","pinned":false,"hidden":false,"mode":"ojs"},{"id":3668,"value":"プロチケット価格データ整形","pinned":false,"hidden":false,"mode":"md"},{"id":978,"value":"soukanData1 = Array.from(areaData1)\n .map(([area, counts]) => {\n const total = counts.アマチュア + counts.プロ + counts.来日; // トータルの計算\n return [area, total]; // 合計を追加\n })\n .sort((a, b) => b[2] - a[2]) //[2]total","pinned":false,"hidden":false,"mode":"ojs"},{"id":1312,"value":"areaTotalMap = d3.rollup(\n filteredMonth,\n (v) => {\n // d.area が \"なし\" の場合は 0、それ以外はカウント\n const count = v.filter((d) => d.name !== \"データ無し\").length;\n return count;\n },\n (d) => d.area\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1325,"value":"areaTotal = Array.from(areaTotalMap)","pinned":false,"hidden":false,"mode":"ojs"},{"id":942,"value":"soukanData = sortedAreaData.map((d) => [d[0], d[2]])","pinned":false,"hidden":false,"mode":"ojs"},{"id":521,"value":"selectedType","pinned":false,"hidden":false,"mode":"ojs"},{"id":2032,"value":"#### データ","pinned":false,"hidden":false,"mode":"md"},{"id":3644,"value":"viewof selectedconcertoPro = Inputs.radio([\"すべて表示\", \"あり\", \"なし\"], {\n label: \"協奏曲\",\n value: \"すべて表示\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":766,"value":"selectedPrefectures = selectedArea\n .map((area) => areatype.get(area)) // area ごとに対応する都道府県リストを取得\n .flat(Infinity)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1762,"value":"dataset2","pinned":true,"hidden":false,"mode":"ojs"},{"id":3665,"value":"sortedMinBandCharge2 = dataset2\n .map((d) => [\n d.name,\n d.discountmin,\n d.discountmax,\n d.generalmin,\n d.generalmax,\n d.area,\n d.soliste,\n d.discountS,\n d.discountA,\n d.discountB,\n d.discountC,\n d.discountD,\n d.generalS,\n d.genaralA,\n d.generalB,\n d.generalC,\n d.generalD\n ])\n .sort((a, b) => a[1] - b[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":3673,"value":"sortedMaxBandCharge2 = dataset2\n .map((d) => [\n d.name,\n d.discountmin,\n d.discountmax,\n d.generalmin,\n d.generalmax,\n d.area,\n d.soliste,\n d.discountS,\n d.discountA,\n d.discountB,\n d.discountC,\n d.discountD,\n d.generalS,\n d.genaralA,\n d.generalB,\n d.generalC,\n d.generalD\n ])\n .sort((a, b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":3685,"value":"sortedMinBandCharge21 = dataset2\n .map((d) => [\n d.name,\n d.discountmin,\n d.discountmax,\n d.generalmin,\n d.generalmax,\n d.area,\n d.soliste,\n d.discountS,\n d.discountA,\n d.discountB,\n d.discountC,\n d.discountD,\n d.generalS,\n d.genaralA,\n d.generalB,\n d.generalC,\n d.generalD\n ])\n .sort((a, b) => a[3] - b[3])","pinned":false,"hidden":false,"mode":"ojs"},{"id":3687,"value":"sortedMaxBandCharge22 = dataset2\n .map((d) => [\n d.name,\n d.discountmin,\n d.discountmax,\n d.generalmin,\n d.generalmax,\n d.area,\n d.soliste,\n d.discountS,\n d.discountA,\n d.discountB,\n d.discountC,\n d.discountD,\n d.generalS,\n d.genaralA,\n d.generalB,\n d.generalC,\n d.generalD\n ])\n .sort((a, b) => b[3] - a[3])","pinned":false,"hidden":false,"mode":"ojs"},{"id":3678,"value":"chargeDataSort2 = new Map([\n [\"値引きされたチケット価格最低価格が低い順\", sortedMinBandCharge2],\n [\"値引きされたチケット価格最低価格が高い順\", sortedMaxBandCharge2],\n [\"一般料金のチケット価格最低価格が低い順\", sortedMinBandCharge21],\n [\"一般料金のチケット価格最低価格が高い順\", sortedMaxBandCharge22]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":3696,"value":"selectedPrefectures2 = selectedArea2\n .map((area) => areatype.get(area)) // area ごとに対応する都道府県リストを取得\n .flat(Infinity)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3692,"value":"proChargeData1 = narabikae2.slice(0, groupRange2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3690,"value":"proChargeData2 = proChargeData1.filter((d) =>\n selectedPrefectures2.includes(d[5])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3714,"value":"proChargeData4 = selectedconcerto2 === \"なし\"\n ? proChargeData2.filter((d) => d[6] === \"なし\")\n : selectedconcerto2 === \"あり\"\n ? proChargeData2.filter((d) => d[6] !== \"なし\")\n : proChargeData2","pinned":false,"hidden":false,"mode":"ojs"},{"id":1800,"value":"アマオケチケット価格データ整形","pinned":false,"hidden":false,"mode":"md"},{"id":587,"value":"sortedMinBandCharge = dataset\n .map((d) => [\n d.name,\n d.min,\n d.max,\n d.area,\n d.type,\n d.composer,\n d.number,\n d.concerto\n ])\n .sort((a, b) => a[1] - b[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":590,"value":"sortedMaxBandCharge = dataset\n .map((d) => [\n d.name,\n d.min,\n d.max,\n d.area,\n d.type,\n d.composer,\n d.number,\n d.concerto\n ])\n .sort((a, b) => b[1] - a[1])","pinned":false,"hidden":false,"mode":"ojs"},{"id":492,"value":"chargeDataSort = new Map([\n [\"チケット価格最低価格が低い順\", sortedMinBandCharge],\n [\"チケット価格最低価格が高い順\", sortedMaxBandCharge]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":516,"value":"chargeData1 = narabikae.slice(0, groupRange)","pinned":false,"hidden":false,"mode":"ojs"},{"id":761,"value":"chargeData2 = chargeData1.filter((d) => selectedPrefectures.includes(d[3]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":779,"value":"chargeData3 = chargeData2.filter((d) => selectedType.includes(d[4]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":831,"value":"chargeData4 = selectedconcerto === \"なし\"\n ? chargeData3.filter((d) => d[7] === \"なし\")\n : selectedconcerto === \"あり\"\n ? chargeData3.filter((d) => d[7] !== \"なし\")\n : chargeData3","pinned":false,"hidden":false,"mode":"ojs"},{"id":858,"value":"chargeData5 = chargeData4.filter(\n (d) => d[2] <= selectedMaxOption && d[1] >= selectedMinOption\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1206,"value":"chargeData = chargeData5.filter((d) => selectedComposer.includes(d[5]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1804,"value":"プロオケチケット価格データ整形","pinned":false,"hidden":false,"mode":"md"},{"id":2024,"value":"chargeDataSortPro = new Map([\n [\"一般料金\", histogramData3],\n [\"割引料金\", histogramData2]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":324,"value":"filteredMonth2 = dataset.filter((data) => selectedMonth.includes(data.month))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1345,"value":"// filteredMonth2 に含まれている都道府県を取得\nexistingAreas = [...new Set(filteredMonth2.map((d) => d.area))]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1347,"value":"missingAreas = prefectures.filter((area) => !existingAreas.includes(area))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1351,"value":"//使用するデータになしを組み込む\nmissingData = missingAreas.map(area => ({\n name: \"データ無し\",\n year: 2024,\n month: 12,\n day: 1,\n area: area,\n max: 0,\n min: 0,\n discount: \"なし\",\n composer: \"なし\",\n number: 0,\n concerto: \"なし\",\n type: \"なし\",\n url: \"なし\",\n site: \"なし\"\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1358,"value":"filteredMonth = filteredMonth2.concat(missingData)","pinned":false,"hidden":false,"mode":"ojs"},{"id":322,"value":"areaData1 = d3.rollup(\n filteredMonth, // 集計対象のデータ\n (v) => ({\n アマチュア: v.filter((d) => d.type === \"アマチュア\").length,\n プロ: v.filter((d) => d.type === \"プロ\").length,\n 来日: v.filter((d) => d.concert === \"来日\").length\n }),\n (d) => d.area // エリアでグループ化\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":327,"value":"areaArray = Array.from(areaData1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1330,"value":"// Map を Array に変換\ndataArray = Array.from(areaData1, ([area, values]) => ({\n area,\n ...values // アマチュア, プロ, 来日を展開\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":345,"value":"sortedAreaData2 = Array.from(areaData1)\n .map(([area, counts]) => {\n const total = counts.アマチュア + counts.プロ + counts.来日; // トータルの計算\n return [area, counts, total]; // 合計を追加\n })\n .sort((a, b) => b[2] - a[2]) //[2]total","pinned":false,"hidden":false,"mode":"ojs"},{"id":1385,"value":"sortedAreaData = Array.from(areaData1).map(([area, counts]) => {\n const total = counts.アマチュア + counts.プロ + counts.来日; // トータルの計算\n return [area, counts, total]; // 合計を追加\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":441,"value":"//filteredSortedAreaData = sortedAreaData.slice(0, arearange)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2036,"value":"積み上げ棒グラフデータ","pinned":false,"hidden":false,"mode":"md"},{"id":333,"value":"stack = d3.stack().keys([\"アマチュア\", \"プロ\", \"来日\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":336,"value":"stackedData = stack(dataArray)","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"stackedDatadata = stackedData.flat(2).map((d) => d[2]) ","pinned":false,"hidden":false,"mode":"ojs"},{"id":235,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"type = [\"アマチュア\",\"プロ\",\"来日\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1755,"value":"使用データ","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"dataset = d3.tsv(url, d3.autoType)","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"data = dataset","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSmZOOaugUJ0ppubSZwtgRdoVSmZiIS2Obz128rt0oX0H0m25-M-zTVSUKWpcr0-VVzJ0T3PKQ1-d7U/pub?gid=0&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1757,"value":"url2 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQxNV8Bm8uz3wu-7end6m2i5wiU0PR-1Nm72irykx8xyGNYrqvpkxlbpj56bIhgPJv1fBK86Ic7hqGq/pub?gid=0&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1759,"value":"dataset2 = d3.tsv(url2, d3.autoType)","pinned":true,"hidden":false,"mode":"ojs"},{"id":289,"value":"ソートなど","pinned":false,"hidden":false,"mode":"md"},{"id":354,"value":"areaCount1 = d3.rollup(\n dataset,\n (v) => v.length, // 出現回数をカウント\n (d) => d.area // エリアごとに集計\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":356,"value":"sortedArea = Array.from(areaCount1)\n .sort((a, b) => b[1] - a[1]) // 出現回数で降順に並べ替え\n .map((d) => d[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":812,"value":"composerCount = d3.rollup(\n dataset,\n (v) => v.length, // 出現回数をカウント\n (d) => d.composer // エリアごとに集計\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":814,"value":"composer = Array.from(composerCount)\n .sort((a, b) => b[1] - a[1]) // 出現回数で降順に並べ替え\n .map((d) => d[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":279,"value":"areas = Array.from(new Set(dataset.map((d) => d.area)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"sortedMinCharge = Array.from(new Set(dataset.map((d) => d.min))).sort(\n (a, b) => a - b\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"sortedMaxCharge = Array.from(new Set(dataset.map((d) => d.max))).sort(\n (a, b) => b - a\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":545,"value":"sortedMinNames = dataset\n .sort((a, b) => a.min - b.min) // minで昇順にソート\n .map((d) => d.name)","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"sortedMaxNames = dataset\n .sort((a, b) => b.max - a.max) // minで昇順にソート\n .map((d) => d.name)","pinned":false,"hidden":false,"mode":"ojs"},{"id":287,"value":"types = Array.from(new Set(dataset.map((d) => d.type)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":143,"value":"months = new Map(\n [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dec\"\n ].map((month, i) => [month, i + 1])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":613,"value":"areatype = new Map([\n [\"北海道\", [\"北海道\"]],\n [\"東北\", [\"青森\", \"岩手\", \"宮城\", \"秋田\", \"山形\", \"福島\"]],\n [\"東京\", [\"東京\"]],\n [\"神奈川\", [\"神奈川\"]],\n [\"関東\", [\"茨城\", \"栃木\", \"群馬\", \"埼玉\", \"千葉\"]],\n [\n \"中部\",\n [\"新潟\", \"富山\", \"石川\", \"福井\", \"山梨\", \"長野\", \"岐阜\", \"静岡\", \"愛知\"]\n ],\n [\"近畿\", [\"三重\", \"滋賀\", \"京都\", \"大阪\", \"兵庫\", \"奈良\", \"和歌山\"]],\n [\"中国\", [\"鳥取\", \"島根\", \"岡山\", \"広島\", \"山口\"]],\n [\"四国\", [\"徳島\", \"香川\", \"愛媛\", \"高知\"]],\n [\"九州\", [\"福岡\", \"佐賀\", \"長崎\", \"熊本\", \"大分\", \"宮崎\", \"鹿児島\", \"沖縄\"]]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":895,"value":"prefectures = [\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 \"香川\",\n \"愛媛\",\n \"高知\",\n \"福岡\",\n \"佐賀\",\n \"長崎\",\n \"熊本\",\n \"大分\",\n \"宮崎\",\n \"鹿児島\",\n \"沖縄\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":681,"value":"chargeMaxRadio = new Map([\n [\"すべて表示\", 99999999],\n [\"0円\", 0],\n [\"500円以下\", 500],\n [\"1000円以下\", 1000],\n [\"2000円以下\", 2000],\n [\"5000円以下\", 5000],\n [\"8000円以下\", 8000],\n [\"10000円以下\", 10000]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":870,"value":"chargeMinRadio = new Map([\n [\"0円\", 0],\n [\"500円以上\", 500],\n [\"1000円以上\", 1000],\n [\"2000円以上\", 2000],\n [\"5000円以上\", 5000],\n [\"8000円以上\", 8000],\n [\"10000円以上\", 10000]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":429,"value":"tooltip = d3\n .select(\"body\")\n .append(\"div\")\n .style(\"position\", \"absolute\")\n .style(\"background\", \"white\")\n .style(\"border\", \"1px solid #ccc\")\n .style(\"padding\", \"5px\")\n .style(\"border-radius\", \"3px\")\n .style(\"box-shadow\", \"0px 2px 5px rgba(0,0,0,0.3)\")\n .style(\"visibility\", \"hidden\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":655,"value":"colorScale = d3\n .scaleOrdinal()\n .domain([\"アマチュア\", \"プロ\"])\n .range([\"#8cc\", \"#f78\"])\n .unknown(\"#ccc\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":174,"value":"mapurl = \"https://raw.githubusercontent.com/smartnews-smri/japan-topography/main/data/municipality/topojson/s0010/N03-21_210101.json\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":176,"value":"japan = {\n const japan = await d3.json(mapurl);\n\n const municipalities = { ...japan.objects[\"N03-21_210101\"] };\n\n municipalities.geometries = municipalities.geometries.map((d) => ({\n ...d,\n properties: {\n ...d.properties,\n prefCode: +d.properties.N03_007?.substring(0, 2) || null\n }\n }));\n\n japan.objects.municipalities = municipalities;\n\n const prefs = {\n type: \"GeometryCollection\",\n geometries: d3.range(1, 48).map((i) => ({\n ...topojson.mergeArcs(\n japan,\n japan.objects.municipalities.geometries.filter(\n (d) => d.properties.prefCode === i\n )\n ),\n properties: { prefCode: i }\n }))\n };\n japan.objects.prefs = prefs;\n\n return japan;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":178,"value":"land = topojson.merge(japan, japan.objects.prefs.geometries)","pinned":false,"hidden":false,"mode":"ojs"},{"id":183,"value":"prefPointsUrl = \"file:///Users/kuroiwamikaze/Desktop/network/areaMap.json\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1782,"value":"areamap = FileAttachment(\"areaMap@1.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":185,"value":"//prefPoints = d3.json(prefPointsUrl)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1104,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":1433,"value":"//areamap = FileAttachment(\"areaMap.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":187,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":1434,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":726,"value":"AreaRadiusMap = new Map(\n Array.from(areaCount1.entries()).map(([key, value]) => {\n let newValue; // 変数を初期化\n /*\n if (value < 1) {\n newValue = 0; // 1以下なら4\n } else if (value >= 1 && value <= 2) {\n newValue = 2; // 5以下なら6\n } else if (value >= 1 && value <= 3) {\n newValue = 3;\n } else if (value > 5 && value < 20) {\n newValue = 10; // 10以上20未満なら20\n } else if (value >= 10) {\n newValue = 20; // 20以上なら30\n } else if (value >= 20) {\n newValue = 30; // 20以上なら30\n } else if (value >= 40) {\n newValue = 50; // 20以上なら30\n }\n */\n newValue = value;\n return [key, newValue]; // 新しい配列として返す\n })\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1542,"value":"ヒストグラムデータ","pinned":false,"hidden":false,"mode":"md"},{"id":1544,"value":"filteredAmatyuaHistogram = dataset.filter((d) => d.type === \"アマチュア\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1552,"value":"histogramCount1 = d3.rollup(\n filteredAmatyuaHistogram,\n (v) => v.length,\n (d) =>\n `${Math.floor(d.min / 500) * 500}-${Math.floor(d.min / 500) * 500 + 499}`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1634,"value":"histogramData = Array.from(histogramCount1, ([key, value]) => ({ key, value }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1639,"value":"filteredProHistogram = dataset.filter((d) => d.type === \"プロ\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1641,"value":"histogramProCount = d3.rollup(\n dataset2,\n (v) => v.length,\n (d) =>\n `${Math.floor(d.discountmin / 1000) * 1000}-${\n Math.floor(d.discountmin / 1000) * 1000 + 999\n }`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1915,"value":"histogramProCount3 = d3.rollup(\n dataset2,\n (v) => v.length,\n (d) =>\n `${Math.floor(d.generalmin / 1000) * 1000}-${\n Math.floor(d.generalmin / 1000) * 1000 + 999\n }`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1653,"value":"histogramData2 = Array.from(histogramProCount, ([key, value]) => ({\n key,\n value\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1913,"value":"histogramData3 = Array.from(histogramProCount3, ([key, value]) => ({\n key,\n value\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1561,"value":"histogramAnxis = [\n \"0-499\",\n \"500-999\",\n \"1000-1499\",\n \"1500-1999\",\n \"2000-2499\",\n \"3000-3499\",\n \"3500-3999\",\n \"4000-4499\",\n \"4500-5999\",\n \"5000-5499\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1623,"value":"histogramAnxis2 = [\n \"0-999\",\n \"1000-1999\",\n \"2000-2999\",\n \"3000-3999\",\n \"4000-4999\",\n \"5000-5999\",\n \"6000-6999\",\n \"7000-7999\",\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2065,"value":"viewof selectedType = Inputs.checkbox(type, {\n step: 1,\n value: [\"アマチュア\", \"プロ\"],\n label: \"種類\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":141,"value":"viewof selectedMonth = Inputs.checkbox(months, {\n step: 1,\n value: Array.from(months.values()), // すべての値をデフォルトで選択\n label: \"開催月\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":958,"value":"viewof selectedTypeOption = Inputs.radio(\n [\"すべて\", \"アマチュア\", \"プロ\", \"来日\"],\n {\n label: \"団の種類\",\n value: \"すべて\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1017,"value":"narabikae","pinned":false,"hidden":false,"mode":"ojs"},{"id":1021,"value":"proDataset1 = dataset.filter((data) => \"プロ\".includes(data.type))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1108,"value":"discountColor = d3\n .scaleOrdinal()\n .domain([\"一般料金\", \"会員価格\", \"U29\"])\n .range([\"#e28082\", \"#a174a1\", \"#be808c\"])\n .unknown(\"#pink\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1091,"value":"discountData = Array.from(\n dataset2.map((d) => ({ name: d.name, min: d.min, max: d.max }))\n)\n/*こういうデータを作る\n[\n { name: \"N響\", general:10000, discount1: 8000, discount2: 6000 },\n { name: \"読響\", general:10000, discount1: 80, discount2: 70 }\n];\n*/","pinned":false,"hidden":false,"mode":"ojs"},{"id":1053,"value":"proDataset = Array.from(\n proDataset1.map((d) => ({ name: d.name, min: d.min, max: d.max }))\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3505,"value":"GenreColor = d3\n .scaleOrdinal()\n .domain([\"一般料金\", \"割引料金\"])\n .range([\"#90CAF9\", \"#F48FB1\"])\n .unknown(\"#pink\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":3620,"value":"GenreColor2 = d3\n .scaleOrdinal()\n .domain([\"一般料金\", \"割引料金\"])\n .range([\"#90CAF9\", \"#F48FB1\"])\n .unknown(\"#pink\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":3518,"value":"","pinned":false,"hidden":false,"mode":"html"}],"files":"$W39","stdlib":"1","titling":"auto"}