2f:T625,plotByDayOfTheWeek = Plot.plot({ width: 900, x: { tickValues: d3.range(0, 1440, 60), tickFormat: (minute) => { const hours = Math.floor(minute / 60) .toString() .padStart(2, "0"); const minutes = (minute % 60).toString().padStart(2, "0"); return `${hours}:${minutes}`; } }, color: { type: "categorical", domain: d3.range(7), // Assuming your days are coded as 0-6 scheme: "Observable10" }, marks: [ Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 0), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 1), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 2), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 3), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 4), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 5), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ), Plot.lineY( averageAndUserFilteredData.filter((d) => d.dayOfWeek === 6), { x: "minuteOfDay", y: "avgOccupancy", stroke: "dayOfWeek" } ) ] })30:T52a,function findLeastBusyPeriods(data, windowSize) { let leastBusyPeriods = []; for (const dayOfWeek of daysOfWeekSettings) { let dayOfWeekData = data.filter( (d) => d.dayOfWeek === dayOfWeek.weekDayNumber && d.minuteOfDay >= dayOfWeek.openingTime && d.minuteOfDay <= dayOfWeek.closingTime ); let minAvg = Infinity; let leastBusyStart = null; let leastBusyStartTime = null; let leastBusyEnd = null; let leastBusyEndTime = null; for (let i = 0; i <= dayOfWeekData.length - windowSize; i++) { let sum = 0; for (let j = i; j < i + windowSize; j++) { sum += dayOfWeekData[j].avgOccupancy; } const avg = sum / windowSize; if (avg < minAvg) { minAvg = avg; leastBusyStart = dayOfWeekData[i].minuteOfDay; leastBusyStartTime = dayOfWeekData[i].time; leastBusyEnd = dayOfWeekData[i + windowSize - 1].minuteOfDay; leastBusyEndTime = dayOfWeekData[i + windowSize - 1].time; } } leastBusyPeriods.push({ dayOfWeek: dayOfWeek.weekDayName, leastBusyStart: leastBusyStart, leastBusyStartTime: leastBusyStartTime, leastBusyEnd: leastBusyEnd, leastBusyEndTime: leastBusyEndTime, averageOccupancy: minAvg }); } return leastBusyPeriods; }31:[] 2d:{"title":"🏋️ Gym Occupancy","cells":[{"id":0,"value":"# 🏋️ Gym Occupancy\n\nWhen should I go to the gym if I want to avoid the crowd?","pinned":false,"hidden":false,"mode":"md"},{"id":186,"value":"## Occupancy by date and time\n(from 06:00 to 23:59)","pinned":false,"hidden":false,"mode":"md"},{"id":84,"value":"Plot.plot({\n width: 900,\n marks: [Plot.lineY(processedData, { x: \"Timestamp\", y: \"Occupancy\" })]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":188,"value":"## Average occupancy by day of the week\n(from 06:00 to 23:59)","pinned":false,"hidden":false,"mode":"md"},{"id":541,"value":"viewof userSelectedDaysOfWeek = Inputs.checkbox(\n daysOfWeekSettings.map((day) => day),\n {\n value: [0, 1, 2, 3, 4, 5, 6],\n valueof: (day) => day.weekDayNumber,\n keyof: (day) => day.weekDayName\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":238,"value":"html`

${plotByDayOfTheWeek}

${legend}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"legend = Plot.legend({\n color: {\n type: \"categorical\",\n domain: d3.range(7), // Assuming your days are coded as 0-6\n scheme: \"Observable10\",\n label: \"Day of the Week\", // Label for the legend\n tickFormat: (i) => daysOfWeekSettings[i].weekDayName // Map the index to the day of the week\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":343,"value":"## Least busy periods by day of week","pinned":false,"hidden":false,"mode":"md"},{"id":395,"value":"### 60-minute periods","pinned":false,"hidden":false,"mode":"md"},{"id":363,"value":"leastBusySixtyMinutePeriods","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"### 30-minute periods","pinned":false,"hidden":false,"mode":"md"},{"id":399,"value":"leastBusyThirtyMinutePeriods","pinned":false,"hidden":false,"mode":"ojs"},{"id":128,"value":"## Processed Data","pinned":false,"hidden":false,"mode":"md"},{"id":130,"value":"processedData = preprocessData(data)","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"value":"### Grouped and averaged data by day of week","pinned":false,"hidden":false,"mode":"md"},{"id":141,"value":"averagedData = groupAndAverage(processedData).sort((a, b) =>\n d3.ascending(a.minuteOfDay, b.minuteOfDay)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":594,"value":"averageAndUserFilteredData = averagedData.filter((d) =>\n userSelectedDaysOfWeek.includes(d.dayOfWeek)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":422,"value":"averageOccupancyByStartMinuteByDayOfWeek = getAverageOccupancyByStartMinuteByDayOfTheWeek(\n averagedData,\n 60\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":296,"value":"leastBusySixtyMinutePeriods = findLeastBusyPeriods(averagedData, 60)","pinned":false,"hidden":false,"mode":"ojs"},{"id":386,"value":"leastBusyThirtyMinutePeriods = findLeastBusyPeriods(averagedData, 30)","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"## Functions and utilities","pinned":false,"hidden":false,"mode":"md"},{"id":121,"value":"timestampParser = d3.utcParse(\"%m/%d/%Y %H:%M:%S\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":495,"value":"convertMinute = function (minute) {\n const hours = Math.floor(minute / 60)\n .toString()\n .padStart(2, \"0\");\n const minutes = (minute % 60).toString().padStart(2, \"0\");\n return `${hours}:${minutes}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"function getDayOfWeek(date) {\n let day = date.getUTCDay() - 1; // Subtract 1 so Monday becomes 0, Sunday becomes -1\n if (day === -1) day = 6; // Change -1 (Sunday) to 6\n return day;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"preprocessData = (data) => {\n return data\n .map((d) => {\n const date = timestampParser(d.Timestamp);\n const minuteOfDay = date.getUTCHours() * 60 + date.getUTCMinutes();\n if (minuteOfDay >= 360) {\n // This will exclude times between 00:00 and 06:00\n return {\n Occupancy: d.Capacity,\n Timestamp: date,\n dayOfWeek: getDayOfWeek(date),\n minuteOfDay: minuteOfDay\n };\n }\n })\n .filter((d) => d); // This will remove undefined entries resulting from the exclusion\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":125,"value":"groupAndAverage = (data) => {\n const grouped = d3.groups(\n data,\n (d) => d.dayOfWeek,\n (d) => d.minuteOfDay\n );\n const averages = [];\n\n grouped.forEach(([dayOfWeek, days]) => {\n days.forEach(([minuteOfDay, values]) => {\n const avg = d3.mean(values, (d) => d.Occupancy);\n const hours = Math.floor(minuteOfDay / 60)\n .toString()\n .padStart(2, \"0\");\n const minutes = (minuteOfDay % 60).toString().padStart(2, \"0\");\n const time = `${hours}:${minutes}`;\n averages.push({ dayOfWeek, minuteOfDay, avgOccupancy: avg, time });\n });\n });\n\n return averages;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":416,"value":"getAverageOccupancyByStartMinuteByDayOfTheWeek = function (data, windowSize) {\n let averageOccupancyPerStartMinuteByDay = structuredClone(daysOfWeekSettings);\n\n for (const dayOfWeek of averageOccupancyPerStartMinuteByDay) {\n let averageOccupancy = Infinity;\n let averageOccupancyPerStartMinute = [];\n\n for (\n let i = dayOfWeek.openingTime;\n i <= dayOfWeek.closingTime - windowSize;\n i++\n ) {\n let sum = 0;\n for (let j = i; j < i + windowSize; j++) {\n sum += data[j].avgOccupancy;\n }\n const averageOccupancy = sum / windowSize;\n averageOccupancyPerStartMinute.push({\n startMinute: i,\n averageOccupancy: averageOccupancy\n });\n }\n\n averageOccupancyPerStartMinuteByDay[\n dayOfWeek.weekDayNumber\n ].averageOccupancyPerStartMinute = averageOccupancyPerStartMinute;\n }\n\n return averageOccupancyPerStartMinuteByDay;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":463,"value":"selectedDay","pinned":false,"hidden":false,"mode":"ojs"},{"id":449,"value":"viewof selectedDay = Inputs.select(averageOccupancyByStartMinuteByDayOfWeek, {\n label: \"Select the day of the week\",\n keyof: (day) => day.weekDayName\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"viewof selectedTime = Inputs.range(\n [selectedDay.openingTime, selectedDay.closingTime - 60],\n\n {\n value: selectedDay.openingTime,\n step: 1,\n label: \"Select the opening time\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"openingTimeInHourMinute = convertMinute(selectedTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":511,"value":"averageOccupancyForDayAndTime = selectedDay.averageOccupancyPerStartMinute.find(\n (d) => (d.startMinute = selectedTime)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":289,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":115,"value":"## Data","pinned":false,"hidden":false,"mode":"md"},{"id":99,"value":"data = {\n return d3.dsv(\n \",\",\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQ_1WaheUGe8cD64bydQY8g7Z4v1buxkqxK2eoKnMGrooQEgprTJnjy7WzB4N23M3wrLGXG8_drGvb8/pub?gid=0&single=true&output=csv\",\n (d) => {\n return {\n Timestamp: d.Timestamp,\n Capacity: +d.Capacity\n };\n }\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":326,"value":"daysOfWeekSettings = [\n {\n weekDayNumber: 0,\n weekDayName: \"Monday\",\n openingTime: 405,\n closingTime: 1320\n },\n {\n weekDayNumber: 1,\n weekDayName: \"Tuesday\",\n openingTime: 405,\n closingTime: 1320\n },\n {\n weekDayNumber: 2,\n weekDayName: \"Wednesday\",\n openingTime: 405,\n closingTime: 1320\n },\n {\n weekDayNumber: 3,\n weekDayName: \"Thursday\",\n openingTime: 405,\n closingTime: 1320\n },\n {\n weekDayNumber: 4,\n weekDayName: \"Friday\",\n openingTime: 405,\n closingTime: 1260\n },\n {\n weekDayNumber: 5,\n weekDayName: \"Saturday\",\n openingTime: 540,\n closingTime: 1200\n },\n {\n weekDayNumber: 6,\n weekDayName: \"Sunday\",\n openingTime: 540,\n closingTime: 1200\n }\n]","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}