2f:[{"id":"60cbe4c0801ff8a1e3ad3b2a63d18560de04661b993c405a9f233a9d6d354299caddca880da132522b3056c35bb1340ce172986a528dbf451834f50b17b78be0","href":"https://static.observableusercontent.com/files/60cbe4c0801ff8a1e3ad3b2a63d18560de04661b993c405a9f233a9d6d354299caddca880da132522b3056c35bb1340ce172986a528dbf451834f50b17b78be0","name":"one.csv","type":"text/csv","lastModified":1684953778801.785,"size":1767024}] 2d:{"title":"AP Notes","cells":[{"id":0,"value":"# AP Notes","pinned":false,"hidden":false,"mode":"md"},{"id":14,"value":"example = testData[0]","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"### Below is an example dataset.","pinned":false,"hidden":false,"mode":"md"},{"id":353,"value":"rawAP = await FileAttachment(\"one.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":358,"value":"### Manually make fields numerical:","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"testData = {\n const data = rawAP;\n const p = data.map((o) => {\n const newData = {};\n Object.keys(o).map(k => {\n if (k === \"timestamp\") {\n newData[\"date\"] = new Date(Number(o[k]) * 1000);\n } else {\n newData[k] = Number(o[k]);\n }\n });\n return newData;\n });\n\n return p;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":360,"value":"### Or import the function I wrote in CiscoWifi - 02:","pinned":false,"hidden":false,"mode":"md"},{"id":362,"value":"import { timestampsToDates } from \"14fd093abbdf9097\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":367,"value":"refinedAP = timestampsToDates(rawAP)","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"testData","pinned":false,"hidden":false,"mode":"ojs"},{"id":120,"value":"Ranges\n

states: [1, 5]
Dates: 2023-05-23T18:34:45Z to 2023-05-24T18:09:45Z
Access points: [1, 89]
Users: [1, 284]
Macs: [4, 510]

","pinned":false,"hidden":false,"mode":"html"}],"files":"$W2f","stdlib":"1","titling":"auto"}