25:["$","title",null,{"children":"NHK Kohaku Uta Gassen 2023 Live Broadcasting X Number of Posts | tsurezure lab. こちら徒然研究室（仮称） | Observable"}] 49:T9fa,chart = addTooltips( Plot.plot({ title: "NHK紅白歌合戦2023 生放送中の X投稿数の推移", caption: "Xデータより徒然研究室（仮称）が2023年12月31日作成。", height: 1030, width: 900, marginTop: 50, marginBottom: 0, marginLeft: 185, // marginRight: -70, style: { // background: "rgb(250, 245, 240)", background: "#FBFAF5", fontSize: "12px", color: "rgb(60, 60, 60)" }, axis: null, // X軸の設定 x: { label: "検索日", axis: "top", round: true // tickFormat: "%Y-%m-%dT%H:%M:%S" // 日本時間のフォーマットを指定 }, y: { domain: [-20, d3.max(nhk_kouhaku, (d) => d.Tweet_Count) / (overlap + 1)] }, // y: { axis: null, range: [2.5 * 17 + 50, (2.5 - overlap) * 17 - 2] }, // Y軸を非表示にし、レンジを設定 color: { legend: true, label: "15分あたりの投稿数", scheme: "Turbo", //"PuRd", style: { width: 180, background: "#FBFAF5" } // レジェンドの背景色を設定 }, fy: { domain: nhk_kouhaku.map((d) => d.query) // preserve input order }, facet: { data: nhk_kouhaku, y: "query" }, marks: [ Plot.areaY(nhk_kouhaku, { x: "Minute_Timestamp", y: "Tweet_Count", z: "query", fill: "Tweet_Count", fillOpacity: 0.65, // fill: (d) => `rgba(0, 0, 255, ${calculateAlpha(d.Tweet_Count)})`, // Tweet_Countに基づいてアルファ値を計算して適用 sort: "Minute_Timestamp", curve: "catmull-rom", title: (d) => `${d.query} 時刻 ${d.Minute_Timestamp} 検索ボリューム: ${d.Tweet_Count}` }), Plot.lineY(nhk_kouhaku, { x: "Minute_Timestamp", y: "Tweet_Count", z: "query", curve: "catmull-rom", strokeWidth: 0.5, sort: "Minute_Timestamp", stroke: "black" // ストロークカラーを黒に設定 }), Plot.text( nhk_kouhaku, Plot.selectFirst({ x: d3.min(nhk_kouhaku, (d) => d.Minute_Timestamp), text: "query", dx: -5, dy: 0, frameAnchor: "right", fontFamily: "Noto Sans JP ExtraBold, sans-serif", // Noto Sans JP Bold を指定 fontWeight: "bold", fontSize: 15, // フォントサイズを設定 fill: "rgba(0, 0, 0, 0.7)" // フォントの色を黒にし、透明度を0.85に設定 }) ) ] }) )4a:[{"id":"fe9e130663eb32d92605d3a0d2b3005cc08549333e7928555cdadd6853f2fcd49131ed72e856210f14dabaa20c787503939f3a22be23fb07dfc325fe1a6ebb87","href":"https://static.observableusercontent.com/files/fe9e130663eb32d92605d3a0d2b3005cc08549333e7928555cdadd6853f2fcd49131ed72e856210f14dabaa20c787503939f3a22be23fb07dfc325fe1a6ebb87","name":"231231_1953_kouhaku_gtrends_melted_4h.csv","type":"text/csv","lastModified":1704025040157.431,"size":816203},{"id":"cf526f001f2b636e3c48bc539d4d8d99a9665dc8beedc93aea15991ea22ec19ba74de8d0a528e2492059dc27c0faebc5f20a9729915a5a9f950c0c5139a463d7","href":"https://static.observableusercontent.com/files/cf526f001f2b636e3c48bc539d4d8d99a9665dc8beedc93aea15991ea22ec19ba74de8d0a528e2492059dc27c0faebc5f20a9729915a5a9f950c0c5139a463d7","name":"231231_2354_kouhaku_24hours.csv","type":"text/csv","lastModified":1704035177071.843,"size":8507105},{"id":"367a186936aee63439bffe182af298c1b39d42f2c9abdb8f69bfefa272e77d867cf807267c2538a04d6b36fe43b110bc31356b7f11bf3b6a28f3e08610ab76a5","href":"https://static.observableusercontent.com/files/367a186936aee63439bffe182af298c1b39d42f2c9abdb8f69bfefa272e77d867cf807267c2538a04d6b36fe43b110bc31356b7f11bf3b6a28f3e08610ab76a5","name":"231231_2324_kouhaku_24hours.csv","type":"text/csv","lastModified":1704035967144.229,"size":8497619},{"id":"7a4e7cfa19f1e32d457e6716c397d1ab8015ad31539fd45e369dd355cf1bd82df46989be05ab787baeb319ec1be994cc5febe672cb4f0d04727b0e288b77c180","href":"https://static.observableusercontent.com/files/7a4e7cfa19f1e32d457e6716c397d1ab8015ad31539fd45e369dd355cf1bd82df46989be05ab787baeb319ec1be994cc5febe672cb4f0d04727b0e288b77c180","name":"240101_0019_kouhaku_24hours.csv","type":"text/csv","lastModified":1704037964384.877,"size":8510844}] 29:{"id":"1434e83d3566bb9c","slug":null,"title":"NHK Kohaku Uta Gassen 2023 Live Broadcasting X Number of Posts","thumbnail":"e3fd9e489b7895e5d4a6bbde204bb98348ef07292493bf3ff371089063604f1f","access_level":"public","create_time":"$D2023-12-31T12:17:20.157Z","update_time":"$D2023-12-31T16:09:44.655Z","view_time":null,"first_public_time":"$D2023-12-31T12:17:20.157Z","has_unpublished_edits":null,"fork":{"id":"2197276545144edf","slug":null,"title":"NHK Kohaku Uta Gassen 2023 Visualizing the number of X posts mentioning contestant singers","owner":{"id":"59dc038720f2d6ef","login":"tsurezure-lab-ws","name":"tsurezure lab. こちら徒然研究室（仮称）"}},"stars":0,"starred":false,"owner":{"type":"team","id":"59dc038720f2d6ef","login":"tsurezure-lab-ws","name":"tsurezure lab. こちら徒然研究室（仮称）","avatar_url":"https://avatars-next.observableusercontent.com/acea9591cc9d41429f95084ddae72aba731500f6a2cc2ef2c90104e712930467","tier":"starter_2024","bio":"Data x Ethnography x Visualization / Python\nデータとプログラミングと可視化で文化・社会・人間の不思議を研究しています。","followed_by_you":false,"follows_you":false},"version":1191,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5dc444280c822d70","login":"tsurezure-lab","name":"tsurezure lab. ","avatar_url":"https://avatars-next.observableusercontent.com/acea9591cc9d41429f95084ddae72aba731500f6a2cc2ef2c90104e712930467","tier":null,"bio":"Data x Ethnography x Visualization / Python\nデータとプログラミングと可視化で文化・社会・人間の不思議を研究しています。","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"5dc444280c822d70","login":"tsurezure-lab","name":"tsurezure lab. ","avatar_url":"https://avatars-next.observableusercontent.com/acea9591cc9d41429f95084ddae72aba731500f6a2cc2ef2c90104e712930467","tier":null,"role":"editor"},{"type":"team","id":"59dc038720f2d6ef","login":"tsurezure-lab-ws","name":"tsurezure lab. こちら徒然研究室（仮称）","avatar_url":"https://avatars-next.observableusercontent.com/acea9591cc9d41429f95084ddae72aba731500f6a2cc2ef2c90104e712930467","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"NHK Kohaku Uta Gassen 2023 Live Broadcasting X Number of Posts","cells":[{"id":0,"value":"# NHK Kohaku Uta Gassen 2023 Live Broadcasting X Number of Posts\nNHK紅白歌合戦2023 生放送中のX投稿数の推移","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":523,"value":"viewof overlap = Inputs.range([0, 9], {step: 0.1, label: \"Overlap\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":795,"value":"\n\n\n \n\n\n \n

\n NHK紅白歌合戦2023 生放送中のX投稿数の推移\n

\n \n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"$49","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"traffic = nhk_kouhaku","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"excludequerys = [\n // \"宇多田ヒカル\",\n // \"XG\",\n // \"島津亜矢\",\n // \"TWICE\",\n // \"NewJeans\",\n // \"日向坂46\",\n // \"松田聖子\",\n // \"和田アキ子\",\n // \"INI\",\n // \"imase\",\n // \"King Gnu\",\n // \"Da-iCE\",\n // \"Vaundy\",\n // \"back number\",\n // \"藤井風\",\n // \"ポルノグラフィティ\",\n // \"米津玄師\",\n // \"結束バンド\",\n // \"中納良恵\",\n // \"さかいゆう\",\n // \"趣里\",\n // \"サザンオールスターズ\",\n // \"ジョングク\",\n // \"スピッツ\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1088,"value":"nhk_kouhaku = await FileAttachment(\"240101_0019_kouhaku_24hours.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"nhk_kouhaku","database":"$undefined"},{"id":1130,"value":"_2106_kouhaku_24hours = await FileAttachment(\"231231_2106_kouhaku_24hours.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"_2106_kouhaku_24hours","database":"$undefined"},{"id":1177,"value":"// データセットの各日時に9時間を加算\nnhk_kouhaku.forEach((d) => {\n d.Minute_Timestamp = d3.timeHour.offset(new Date(d.Minute_Timestamp), 9);\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1020,"value":"// traffic_NG = traffic_0.filter((row) => !excludequerys.includes(row.query))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"// traffic = FileAttachment(\"230914_NHK_MUSIC_EXPO_interpolated_melt@2.csv.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"import { addTooltips } from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":772,"value":"// // Tweet_Countに基づいてアルファ値を計算する関数\n// function calculateAlpha(Tweet_Count) {\n// // Tweet_Countの値に応じてアルファ値を0から1の範囲で調整\n// const minAlpha = 0.2; // 最小のアルファ値\n// const maxAlpha = 0.9; // 最大のアルファ値\n// const normalizedTweet_Count = (Tweet_Count - 0.2) / (0.9 - 0.2);\n// return minAlpha + (maxAlpha - minAlpha) * normalizedTweet_Count;\n// }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null