2d:null 2e:["$","title",null,{"children":"Data Visualization - Impact of Covid on US Aviation (year 2020) | DS | Observable"}] 33:T5be,md`Commercial aviation has a direct impact on our nation’s economy, creating more than 10 million well-paying American jobs and driving 5 percent of the U.S. gross domestic product and nearly $1.7 trillion in annual economic activity. Healthy U.S. airlines stimulate the commercial aviation industry, as well as the broader economy through increased connectivity, trade and enhanced mobility of people, cultures, goods and ideas. The COVID-19 pandemic has had a significant impact on the aviation industry due to travel restrictions and a slump in demand among travellers. Significant reductions in passenger numbers have resulted in flights being cancelled or planes flying empty between airports, which in turn massively reduced revenues for airlines and forced many airlines to lay off employees. Some have attempted to avoid refunding cancelled trips in order to diminish their losses. Multiple airlines waived fees for flight booking changes and cancellations during the coronavirus outbreak. Flight fares for domestic flights also dropped. On 25 March, the United States Senate passed a bill that would allocate $58 billion in loans and guarantees to aviation-related companies, including $25 billion for passenger carriers and $4 billion for cargo carriers, plus $17 billion for companies "critical to maintaining national security", such as Boeing. Data Sources: https://data.bts.gov/
https://www.tsa.gov/
https://www.iata.org/ `34:Tae7,{ const myDiv = html`

`; const traceLine = [ { x: [...TSASumbyMonth20.keys()], y: dropPercent.map((d) => d), type: "bar", // text: (dropPercent.map(d => d)), // textposition: 'inside', // orientation: 'h', marker: { color: [ "steelblue", "steelblue", "red", "red", "red", "red", "red", "red", "red", "red", "red", "red" ] } } ]; let layout = { title: "Passengers drop in 2020 compared to 2019 (by month)", yaxis: { showline: false, showgrid: false, showticklabels: false }, xaxis: { showgrid: false, tickangle: -45 }, annotations: [ { text: dropPercent[0] + "%", showarrow: false, x: 0.02, y: 1.02, xref: "paper", yref: "paper" }, { text: dropPercent[1] + "%", showarrow: false, x: 0.1, y: 1.02, xref: "paper", yref: "paper" }, { text: dropPercent[2] + "%", showarrow: false, x: 0.17, y: 0.38, xref: "paper", yref: "paper" }, { text: dropPercent[3] + "%", showarrow: false, x: 0.25, y: -0.01, xref: "paper", yref: "paper" }, { text: dropPercent[4] + "%", showarrow: false, x: 0.37, y: 0.03, xref: "paper", yref: "paper" }, { text: dropPercent[5] + "%", showarrow: false, x: 0.455, y: 0.115, xref: "paper", yref: "paper" }, { text: dropPercent[6] + "%", showarrow: false, x: 0.54, y: 0.175, xref: "paper", yref: "paper" }, { text: dropPercent[7] + "%", showarrow: false, x: 0.625, y: 0.2, xref: "paper", yref: "paper" }, { text: dropPercent[8] + "%", showarrow: false, x: 0.745, y: 0.235, xref: "paper", yref: "paper" }, { text: dropPercent[9] + "%", showarrow: false, x: 0.825, y: 0.26, xref: "paper", yref: "paper" }, { text: dropPercent[10] + "%", showarrow: false, x: 0.91, y: 0.27, xref: "paper", yref: "paper" }, { text: dropPercent[11] + "%", showarrow: false, x: 0.995, y: 0.28, xref: "paper", yref: "paper" } ] }; Plotly.newPlot(myDiv, traceLine, layout); return myDiv; }35:T597,{ const myDiv = html`

`; const traceLine = [ { x: psgLoadFactor.map((d) => d["Year"]), y: psgLoadFactor.map((d) => d["ASM_TOTAL"]), type: "scatter", mode: "lines", name: "Available Seat Miles" }, { x: psgLoadFactor.map((d) => d["Year"]), y: psgLoadFactor.map((d) => d["RPM_TOTAL"]), type: "scatter", mode: "lines", name: "Revenue Passenger Miles" } ]; let layout = { title: "Available Seat Miles Vs Revenue Passenger Miles", width: 1000, height: 450, xaxis: { showgrid: false, tickmode: "array", tickvals: [ "Dec-05", "Dec-06", "Dec-07", "Dec-08", "Dec-09", "Dec-10", "Dec-11", "Dec-12", "Dec-13", "Dec-14", "Dec-15", "Dec-16", "Dec-17", "Dec-18", "Dec-19", "Dec-20" ], ticktext: [ "Dec 05", "Dec 06", "Dec 07", "Dec 08", "Dec 09", "Dec 10", "Dec 11", "Dec 12", "Dec 13", "Dec 14", "Dec 15", "Dec 16", "Dec 17", "Dec 18", "Dec 19", "Dec 20" ], tickangle: -45 } }; const config = { responsive: true }; Plotly.newPlot(myDiv, traceLine, layout, config); return myDiv; }36:T481,{ const myDiv = html`

`; const traceLine = [ { x: psgLoadFactor.map(d => d["Year"]), y: psgLoadFactor.map(d => d["LF_TOTAL"]), type: "scatter", mode: "lines", name: "Load Factor" } ]; let layout = { title: "Load Factor", width: 900, height: 450, xaxis: { showline: true, showgrid: false, tickmode: "array", tickvals: [ "Dec-05", "Dec-06", "Dec-07", "Dec-08", "Dec-09", "Dec-10", "Dec-11", "Dec-12", "Dec-13", "Dec-14", "Dec-15", "Dec-16", "Dec-17", "Dec-18", "Dec-19", "Dec-20" ], ticktext: [ "Dec 05", "Dec 06", "Dec 07", "Dec 08", "Dec 09", "Dec 10", "Dec 11", "Dec 12", "Dec 13", "Dec 14", "Dec 15", "Dec 16", "Dec 17", "Dec 18", "Dec 19", "Dec 20" ], tickangle: -45 } }; Plotly.newPlot(myDiv, traceLine, layout); return myDiv; }37:T525,{ const myDiv = html`

`; const trace1 = { x: TSAMon192021, y: actual, name: 'Flights operated', type: 'bar', marker: { color: 'rgba(55,128,191,0.6)' } }; const trace2 = { x: TSAMon192021, y: cancelled, type: 'bar', name: 'Flights Cancelled', marker: { color: 'red' } }; const trace3 = { x: TSAMon192021, y: planned, type: 'line', name: 'Scheduled', marker: { color: 'gray' } }; let layout = { title: "High Cancellation and lower flight operations", width: 1000, height: 450, barmode: "stack", yaxis: { showline: true, showgrid: false, title: "No of Flights" }, xaxis: { showgrid: false }, annotations: [ { text: "Cancellation rates increased in March", showarrow: true, x: 13.5, y: 649000 }, { text: "Flights decreased
with high cancellations", showarrow: true, x: 15.1, y: 313000 } ] }; var trace = [trace1, trace2, trace3]; const config = { //staticPlot: true, responsive: true, displayModeBar: false, scrollZoom: false }; Plotly.newPlot(myDiv, trace, layout, config); return myDiv; }38:T5d7,{ const myDiv = html`

`; const trace1 = { x: psgMajorAirportData.map(d => d["Passenger-Arr 2019"]), y: psgMajorAirportData.map(d => d["Airport_Dcode"]), type: 'bar', name: '2019', text: psgMajorAirportData.map(d => d["Passenger-Arr 2019"].toLocaleString() ), textposition: 'outside', orientation: 'h', transforms: [ { type: 'sort', target: 'x', order: 'ascending' } ] }; const trace2 = { x: psgMajorAirportData.map(d => d["Passenger-Arr 2020"]), y: psgMajorAirportData.map(d => d["Airport_Dcode"]), type: 'bar', name: '2020', text: psgMajorAirportData.map(d => d["Passenger-Arr 2020"].toLocaleString() ), textposition: 'outside', orientation: 'h' }; let layout = { title: "Passengers to TOP 10 destinations
(from " + dropdown + ")", width: 1000, height: 450, showlegend: true, legend: { x: 1, y: 0.5 }, yaxis: { // showline: true, showgrid: false // side: 'right' }, xaxis: { //zeroline: true, // showline: true, // autorange: 'reversed', showgrid: false, showticklabels: false } }; var traceLine = [trace1, trace2]; const config = { staticPlot: false, responsive: true, displayModeBar: false, scrollZoom: false }; Plotly.newPlot(myDiv, traceLine, layout, config); return myDiv; }39:Td67,{ var data = [ { type: 'scattermapbox', locationmode: 'USA-states', lat: a112, lon: b112, mode: 'markers', marker: { size: 15, color: 'rgb(255, 0, 0)' } }, { type: 'scattermapbox', locationmode: 'USA-states', lat: flightpathlats, lon: flightpathlons, mode: 'lines+markers+text', name: 'Airports', hovertext: airportName, hoverinfo: "text", line: { width: width, color: 'blue' }, opacity: 0.3 } ]; var layout = { title: 'Top 10 US Domestic Routes Passengers', mapbox: { center: { lat: 37.0902, lon: -95.7129 }, style: "open-street-map", zoom: 3.2 }, width: 1100, height: 700, showlegend: false, annotations: [ { text: "LAX-JFK" + "
" + w[0]["val"].toLocaleString(), showarrow: false, x: .55, y: .52, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "LAX-SFO" + "
" + w[1]["val"].toLocaleString(), showarrow: false, x: 0.1, y: 0.42, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "LAX-LAS" + "
" + w[2]["val"].toLocaleString(), showarrow: false, x: 0.2, y: 0.5, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "ORD-LGA" + "
" + w[3]["val"].toLocaleString(), showarrow: false, x: 0.72, y: 0.7, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "ATL-MCO" + "
" + w[4]["val"].toLocaleString(), showarrow: false, x: 0.74, y: 0.35, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "LAX-ORD" + "
" + w[5]["val"].toLocaleString(), showarrow: false, x: 0.47, y: 0.62, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "ATT-FLL" + "
" + w[6]["val"].toLocaleString(), showarrow: false, x: 0.68, y: 0.2, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "SEA-LAX" + "
" + w[7]["val"].toLocaleString(), showarrow: false, x: 0.15, y: 0.7, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "DFW-LAX" + "
" + w[8]["val"].toLocaleString(), showarrow: false, x: 0.33, y: 0.33, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 }, { text: "ATL-LGA" + "
" + w[9]["val"].toLocaleString(), showarrow: false, x: 0.78, y: 0.5, xref: 'paper', yref: 'paper', bgcolor: '#ff7f0e', opacity: 0.8 } ] }; const config = { staticPlot: false, responsive: true, displayModeBar: false, scrollZoom: false, showLink: false }; const myDiv = DOM.element("div"); Plotly.newPlot(myDiv, data, layout, config); return myDiv; }3a:Tdc7,{ let data = majorPsg; let date_range = Object.keys(data[0], 3).slice(4); let traces = []; let myLat = [], myLong = [], myText = [], mySize = []; for (var i = 0; i < data.length; i++) { myLat.push(data[i]['lat']); myLong.push(data[i]['lon']); myText.push( "Passengers: " + (+data[i][date_range[0]]).toLocaleString() + "
" + data[i]["airport"] + " Airport" + "
" + date_range[0] ); mySize.push(data[0][date_range[0]]); } traces.push({ type: 'scattermapbox', locationmode: 'USA-states', lat: myLat, lon: myLong, text: myText, hoverinfo: 'text', marker: { sizemode: 'area', size: mySize, sizeref: 5000, color: 'blue', opacity: 0.5 } }); function modifyTraces(i) { let myText = [], mySize = [], myTraces = JSON.parse(JSON.stringify(traces)); for (var j = 0; j < data.length; j++) { myText.push( "Passengers: " + (+data[j][date_range[i]]).toLocaleString() + "
" + data[j]["airport"] + " Airport" + "
" + date_range[i] ); mySize.push(data[j][date_range[i]]); } myTraces[0].text = myText; myTraces[0].marker.size = mySize; return myTraces; } var frames = []; for (i = 0; i < date_range.length; i++) { frames.push({ name: date_range[i], data: modifyTraces(i) }); } let sliderSteps = []; for (i = 0; i < date_range.length; i++) { sliderSteps.push({ method: 'animate', label: date_range[i], args: [ [date_range[i]], { mode: 'immediate', transition: { duration: 500 }, frame: { duration: 500, redraw: true } } ] }); } let sliders = [ { pad: { l: 130, t: 10 }, currentvalue: { visible: true, prefix: 'Mon-Year:', xanchor: 'right', font: { size: 20, color: '#666' } }, steps: sliderSteps } ]; let updatemenus = [ { x: 0, y: 0, yanchor: 'top', xanchor: 'left', showactive: true, direction: 'left', type: 'buttons', pad: { t: 30, r: 10 }, buttons: [ { method: 'animate', args: [ null, { mode: 'immediate', fromcurrent: true, transition: { duration: 500 }, frame: { duration: 500, redraw: true } } ], label: 'Play' }, { method: 'animate', args: [ [null], { mode: 'immediate', transition: { duration: 0 }, frame: { duration: 0, redraw: false } } ], label: 'Pause' } ] } ]; let layout = { margin: { t: 40, l: 10 }, title: 'Passengers total from Major Airports (Jan 2019 to Jan 2021)', mapbox: { center: { lat: 37.0902, lon: -95.7129 }, style: "open-street-map", zoom: 3.2 }, width: 1100, height: 700, updatemenus: updatemenus, sliders: sliders //annotations: annotations }; const config = { staticPlot: false, responsive: true, displayModeBar: true, scrollZoom: false }; const myDiv = DOM.element("div"); Plotly.newPlot(myDiv, { data: traces, layout: layout, config: config, frames: frames }); return myDiv; }3b:[] 31:{"id":"811f0343e5cbfc7f","slug":"covid-aviation","title":"Data Visualization - Impact of Covid on US Aviation (year 2020)","thumbnail":"1cda570c8cbc2b4b10c88e441b37e4e7a426a2e30bc871af5b45b11acc950c68","access_level":"public","create_time":"$D2021-08-14T20:55:48.465Z","update_time":"$D2022-03-28T23:30:36.378Z","view_time":null,"first_public_time":"$D2022-01-06T21:40:05.181Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"59fc6e3d2d13cb0d","login":"divyaselvaraj","name":"DS","avatar_url":"https://avatars-next.observableusercontent.com/ec9da3e5277a39551e77b0dd56381f9b70b944bfcfa03230e99bb90c8e93cbbf","tier":"starter_2024"},"version":892,"publish_version":892,"role":null,"authored":false,"authors":[{"type":"individual","id":"3e99a49417ced82a","login":"divyaselvaraj","name":"DS","avatar_url":"https://avatars-next.observableusercontent.com/ec9da3e5277a39551e77b0dd56381f9b70b944bfcfa03230e99bb90c8e93cbbf","tier":null}],"members":[{"type":"individual","id":"3e99a49417ced82a","login":"divyaselvaraj","name":"DS","avatar_url":"https://avatars-next.observableusercontent.com/ec9da3e5277a39551e77b0dd56381f9b70b944bfcfa03230e99bb90c8e93cbbf","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"f7a05b8062c4400d","slug":"industrial","title":"Industrial","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"type":"notebook","body":{"title":"Data Visualization - Impact of Covid on US Aviation (year 2020)","cells":[{"id":486,"value":"md` # Data Visualization - Impact of Covid on US Aviation (year 2020)\n## By Divya Selvaraj`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":859,"value":"md` ## 1. Flight Departures`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":858,"value":"md` Flight Departures fell down in March and April 2020 before starting to increase and stablizie in later half of 2020. `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"md ` ### 1.1 Domestic Flight Departures`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"viewof selectDom = radio({\n title: 'Select',\n options: [\n { label: 'Departures By Month', value: 'month' },\n { label: 'Departures By Day', value: 'day' }\n ],\n value: 'day'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"{\n const div = html`

`;\n const traceLine = [\n {\n x: xvalDom,\n y: yvalDom,\n type: plotTypeDom\n }\n ];\n let layout = {\n title: \"US Domestic Flight Depatures - \" + selectDom,\n yaxis: {\n showline: true,\n title: \"Domestic Flight Departures\",\n showgrid: false\n },\n xaxis: {\n zeroline: true,\n showline: true,\n tickmode: \"array\",\n tickvals: tickvalsDom,\n ticktext: ticktext,\n tickangle: -45,\n showgrid: false\n }\n };\n\n Plotly.newPlot(div, traceLine, layout);\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"md` ### 1.2 International Flight Departures`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"viewof selectIntl = radio({\n title: 'Select',\n options: [\n { label: 'Depatures By Month', value: 'month' },\n { label: 'Departures By Day', value: 'day' }\n ],\n value: 'day'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"{\n const myDiv = html`

`;\n const traceLine = [\n {\n x: xvalIntl,\n y: yvalIntl,\n type: plotTypeIntl\n }\n ];\n let layout = {\n title: \"International Flight Depatures - \" + selectIntl,\n yaxis: {\n showline: true,\n title: \"International Flight Departures\",\n showgrid: false\n },\n xaxis: {\n zeroline: true,\n showline: true,\n tickmode: \"array\",\n tickvals: tickvalsIntl,\n ticktext: ticktext,\n tickangle: -45,\n showgrid: false\n }\n };\n\n Plotly.newPlot(myDiv, traceLine, layout);\n return myDiv;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"md` ## 2. Passengers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":864,"value":"md`U.S. airlines carried fewer scheduled service passengers from March 2020 and the numbers are still less in 2021 as compared to pre-pandemic levels`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"md` ### 2.1. Passengers Screened at airports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"{\n const div = html`

`;\n\n const traceLine = [\n {\n x: TSAMon_Mon,\n y: TSAMon_Val,\n type: 'line',\n mode: 'lines+markers',\n line: { color: 'blue', width: 1 },\n marker: { symbol: 'x-thin-open' }\n }\n ];\n let layout = {\n margin: { t: 40 },\n title: \"Passengers Screened by TSA (by month)\",\n width: 1000,\n height: 450,\n xaxis: {\n tickangle: -90,\n showgrid: false,\n //showline: false,\n gridcolor: '#dcdcdc',\n tickangle: -45\n },\n yaxis: {\n //showline: true,\n showgrid: true,\n title: \"Passengers\",\n gridcolor: '#dcdcdc'\n }\n };\n\n Plotly.newPlot(div, traceLine, layout);\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md` ### 2.2 Percent drop of Passengers from last year`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":452,"value":"md` ### 2.3 Passenger Volume Comparision`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"viewof chkYear = checkbox({\n title: \"Choose Years to compare\",\n options: [\n { value: \"2019\", label: \"2019\" },\n { value: \"2020\", label: \"2020\" },\n { value: \"2021\", label: \"2021\" }\n ],\n value: [\"2020\"],\n submit: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":455,"value":"{\n const myDiv = html`

`;\n\n const dataTSA = [];\n for (let i = 0; i < chkYear.length; i++) {\n dataTSA[i] = {\n type: \"scatter\",\n mode: \"lines\",\n name: chkYear[i],\n x: TSAFormattedByMon.map(d => d.Date),\n y: TSAFormattedByMon.map(d => d['Traveller' + chkYear[i]]).filter(d => d)\n // line: { color: color[i] }\n };\n }\n\n let layout = {\n title: \"Passengers screened at US airports by TSA \",\n width: 1000,\n height: 450,\n xaxis: {\n tickmode: \"array\",\n tickvals: tickvalsTSA,\n ticktext: ticktextTSA,\n showgrid: false,\n showline: false\n },\n\n yaxis: {\n title: \"No of passengers screened\",\n gridcolor: '#dcdcdc'\n }\n };\n\n Plotly.newPlot(myDiv, dataTSA, layout);\n return myDiv;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"md `### 2.4 Passenger Load Factor`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":546,"value":"md` Available Seat-miles: the number of seats and the distance flown
\n Revenue Passenger-miles: number of passengers and the distance flown`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":561,"value":"md` Load Factor: passenger-miles as a proportion of available seat-miles in percent (%)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"md`## 3. Domestic Air fare`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":568,"value":"Data = md`The 2020 average domestic itinerary air fare of $245 was the lowest inflation-adjusted annual fare since the Bureau of Transportation Statistics began collecting such records in 1995, down 19% from the previous year of $345 in 2019.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":573,"value":"{\n const myDiv = html`

`;\n const traceLine = [\n {\n x: airFaresData.map((d) => d[\"Year\"]),\n y: airFaresData.map((d) => d[\"Unadjusted Fares (current dollars)\"]),\n type: \"line\",\n name: \"Unadjusted Fares\"\n },\n {\n x: airFaresData.map((d) => d[\"Year\"]),\n y: airFaresData.map((d) => d[\"Inflation-Adjusted (2020$)\"]),\n type: \"line\",\n name: \"Inflation-Adjusted Fares\"\n }\n ];\n let layout = {\n title: \"US Average Domestic Fares\",\n width: 1000,\n height: 450,\n yaxis: {\n showline: true,\n showgrid: false,\n title: \"Average Domestic Fares\"\n // showticklabels: false\n },\n xaxis: { showline: true, showgrid: false }\n };\n\n const config = {\n //staticPlot: true,\n responsive: true,\n displayModeBar: false,\n scrollZoom: false\n };\n\n Plotly.newPlot(myDiv, traceLine, layout, config);\n return myDiv;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"md` ## 4. Flight Operations `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"md` ### 4.1 Flight Schedule and Cancellations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":604,"value":"md`#### Flight Schedule:\nAs the coronavirus reduced air travel in March 2020, airlines anticipated more of the same in April 2020 and began un-scheduling flights accordingly. As the graph below indicates, that resulted in a steep record setting reduction in the number of April 2020 scheduled flights. In fact, the 313k flights scheduled in April 2020 is only about half of the 612K flights scheduled in April 2019 and less than half of the 648K flights scheduled in March of 2020 (for major marketing carriers)\n\n#### Cancellations:\nWhile the March percentage of flights canceled was the second lowest, outdone only by September 2001, the April 2020 cancellation rate exceeds both. The 130k canceled flights shown for April 2020 represents a 41% cancellation rate, more than double the 17% cancellation rate in March. It's also more than double the 20% of scheduled fights canceled after 9/11`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":681,"value":"md` ### 4.2 On Time arrivals\nSeptember’s 93% on-time arrival rate is up from August’s 91% and September 2019’s 84%.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":706,"value":"{\n const myDiv = html`

`;\n const trace1 = {\n x: TSAMon192021,\n y: OnTimePercent,\n type: 'line',\n name: 'Actual Flights'\n };\n\n let layout = {\n title: \"On Time Arrival Rates\",\n width: 1000,\n height: 450,\n barmode: 'stack',\n xaxis: {\n showgrid: false,\n tickangle: -45\n // showzero: true\n },\n yaxis: {\n title: \"On Time Arrival Rates\"\n },\n annotations: [\n {\n text: \"Lowest On Time rate (55%)\",\n showarrow: true,\n x: 15,\n y: 60\n },\n {\n text: \"Highest On Time rate (93%)\",\n showarrow: true,\n x: 20,\n y: 93\n }\n ]\n };\n\n var trace = [trace1];\n\n Plotly.newPlot(myDiv, trace, layout);\n return myDiv;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":726,"value":"md` ## 5. Major Airports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":727,"value":"md` ### 5.1 Top 10 US destinations from Major Airports \n(Reduction in passengers 2019 Vs 2020)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":732,"value":"viewof dropdown = Select(majorAirportList, {\n value: \"Hartsfield-Jackson Atlanta International Airport\",\n label: \"Select Airport\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":734,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":749,"value":"md` ### 5.2 Major Airports - Top 10 Domestic Routes\n(Reduction in passengers 2019 Vs 2020)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"viewof selectYear = radio({\n title: 'Select Year',\n options: [\n { label: '2019', value: '2019' },\n { label: '2020', value: '2020' }\n ],\n value: '2019'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":752,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"md` ### 5.3 Total Domestic Passengers from Major Airports\n(Reduction in total number of passengers by month 2019-2020)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":832,"value":"md`## Data and Code Section`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"md `## Plot 1.1`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"tickvalsDom = {\n if (selectDom == 'day')\n return [\n \"1/15/2020\",\n \"2/15/2020\",\n \"3/15/2020\",\n \"4/15/2020\",\n \"5/15/2020\",\n \"6/15/2020\",\n \"7/15/2020\",\n \"8/15/2020\",\n \"9/15/2020\",\n \"10/15/2020\",\n \"11/15/2020\",\n \"12/15/2020\"\n ];\n else {\n return [\n \"Jan20\",\n \"Feb20\",\n \"Mar20\",\n \"Apr20\",\n \"May20\",\n \"Jun20\",\n \"Jul20\",\n \"Aug20\",\n \"Sep20\",\n \"Oct20\",\n \"Nov20\",\n \"Dec20\"\n ];\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"ticktext = [\n \"Jan20\",\n \"Feb20\",\n \"Mar20\",\n \"Apr20\",\n \"May20\",\n \"Jun20\",\n \"Jul20\",\n \"Aug20\",\n \"Sep20\",\n \"Oct20\",\n \"Nov20\",\n \"Dec20\"\n ]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"xvalDom = {\n if (selectDom == 'month') {\n return domDeptSum_month;\n } else {\n return domesticDept.map(d => d.Date);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"yvalDom = {\n if (selectDom == 'month') {\n return domDeptSum_value;\n } else {\n return domesticDept.map(d => d.Current);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"//Data Source: https://data.bts.gov/Aviation/Commercial-Aviation-Departures/bpqk-hyst\ncommercialData = d3.csv(\n 'https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/Commercial_Aviation_Departures_TSA.csv'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"commercialDatabyMonth = commercialData.map(function(obj) {\n return {\n Mode: obj.Mode,\n Indicator: obj.Indicator,\n Date: obj.Date.slice(0, 10),\n MonYr: timeformat(parseTimemdy(obj.Date.slice(0, 10))),\n Current: +obj['Current'].replaceAll(\",\", \"\"),\n Year: obj['Year']\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"domesticDept = commercialDatabyMonth.filter(\n d =>\n d.Indicator == 'U.S. Domestic Commercial Flights (Departures)' &&\n d.Year == \"2020\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"domDeptSumbyMonth = d3.rollup(domesticDept, v => d3.sum(v, d => d.Current), d => d.MonYr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"domDeptSum_month = [...domDeptSumbyMonth.keys()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"domDeptSum_value = [...domDeptSumbyMonth.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"plotTypeDom = {\n if (selectDom == 'month') {\n return \"bar\";\n } else {\n return \"line\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"md ` ## Plot 1.2`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"xvalIntl = {\n if (selectIntl == 'month') {\n return intlDeptSum_month;\n } else {\n return internlDept.map(d => d.Date);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"yvalIntl = {\n if (selectIntl == 'month') {\n return intlDeptSum_value;\n } else {\n return internlDept.map(d => d.Current);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"plotTypeIntl = {\n if (selectIntl == 'month') {\n return \"bar\";\n } else {\n return \"line\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"tickvalsIntl = {\n if (selectIntl == 'day')\n return [\n \"1/15/2020\",\n \"2/15/2020\",\n \"3/15/2020\",\n \"4/15/2020\",\n \"5/15/2020\",\n \"6/15/2020\",\n \"7/15/2020\",\n \"8/15/2020\",\n \"9/15/2020\",\n \"10/15/2020\",\n \"11/15/2020\",\n \"12/15/2020\"\n ];\n else {\n return [\n \"Jan20\",\n \"Feb20\",\n \"Mar20\",\n \"Apr20\",\n \"May20\",\n \"Jun20\",\n \"Jul20\",\n \"Aug20\",\n \"Sep20\",\n \"Oct20\",\n \"Nov20\",\n \"Dec20\"\n ];\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"internlDept = commercialDatabyMonth.filter(\n d =>\n d.Indicator == 'U.S. International Commercial Flights (Departures)' &&\n d.Year == \"2020\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"intlDeptSumbyMonth = d3.rollup(internlDept, v => d3.sum(v, d => d.Current), d => d.MonYr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"intlDeptSum_month = [...intlDeptSumbyMonth.keys()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"intlDeptSum_value = [...intlDeptSumbyMonth.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"md ` ## Plot 2.1`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"TSAData = commercialDatabyMonth.filter(\n d =>\n d.Indicator == 'People Screened at All Airports' //&&\n //d.Year == \"2020\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"TSADataMon = d3.rollup(\n TSAData,\n v => d3.sum(v, d => d.Current),\n d => d.MonYr\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"TSAMon_Mon = [...TSADataMon.keys()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"TSAMon_Val = [...TSADataMon.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":360,"value":"md ` ## Plot 2.2`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"TSA2019 = TSAData.map(function(obj) {\n return {\n MonYr: obj.MonYr,\n Passenger_2019: obj.Current,\n Year: obj['Year']\n };\n}).filter(d => d.Year == \"2019\" && d.MonYr.slice(3,5) ==\"19\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"TSA2020 = TSAData.map(function(obj) {\n return {\n MonYr: obj.MonYr,\n Passenger_2020: obj.Current,\n Year: obj['Year']\n };\n}).filter(d => d.Year == \"2020\" && d.MonYr.slice(3,5) ==\"20\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"TSASumbyMonth19 = d3.rollup(TSA2019, v => d3.sum(v, d => d.Passenger_2019), d => d.MonYr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"TSASumbyMonth20 = d3.rollup(\n TSA2020,\n v => d3.sum(v, d => d.Passenger_2020),\n d => d.MonYr\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"dropPercent = {\n const res = [];\n const a = [...TSASumbyMonth19.values()];\n const b = [...TSASumbyMonth20.values()];\n for (let i = 0; i < a.length; i++) {\n const temp = Math.round((((b[i] || 0) - (a[i] || 0)) / (a[i] || 0)) * 100);\n res[i] = temp;\n }\n return res;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":881,"value":"dropPercentage = dropPercent","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":887,"value":"(dropPercentage[0] = 6)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"md` ## Plot 2.3`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":512,"value":"TSAFormattedByMon = TSA_reordered.map(function(obj) {\n return {\n Date: timeformatDayMon(obj.Date),\n DateMon: timeformatMonName(obj.Date),\n Traveller2019: +obj['Traveller2019'].replaceAll(\",\", \"\"),\n Traveller2020: +obj['Traveller2020'].replaceAll(\",\", \"\"),\n Traveller2021: +obj['Traveller2021'].replaceAll(\",\", \"\")\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"TSA_reordered = [...TSA_1,...TSA_2]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"TSA_1 = sortData(TSAFormatted.filter(d => d.Date >= new Date(\"01/01/2021\")))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":517,"value":"TSA_2 = sortData(TSAFormatted.filter(d => d.Date < new Date(\"01/01/2021\")))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"TSAFormatted = TSAscreenData.map(function(obj) {\n return {\n Date: new Date(obj.Date.trim()),\n Traveller2019: obj['2019'].trim(),\n Traveller2020: obj['2020'].trim(),\n Traveller2021: obj['2021'].trim()\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"//Data source: https://www.tsa.gov/coronavirus/passenger-throughput\nTSAscreenData = d3.csv(\n 'https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/TSA-passengers.csv'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"tickvalsTSA = [\n \"31/01\",\n \"28/02\",\n \"31/03\",\n \"30/04\",\n \"31/05\",\n \"30/06\",\n \"31/07\",\n \"31/08\",\n \"30/09\",\n \"31/10\",\n \"30/11\",\n \"31/12\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":531,"value":"ticktextTSA = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"md ` ## Plot 2.4`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"psgLoadFactor = d3.csv(\n 'https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/Load%20Factor.csv'\n //'https://raw.githubusercontent.com/FlightData/USFlightData/main/LoadFactor.csv'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":575,"value":"md ` ## Plot 3`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"//Data Source - https://www.bts.gov/newsroom/third-quarter-2020-air-fare-drops-new-low-passenger-numbers-decline\n//airFares = scrapeTableData('https://www.bts.gov/newsroom/third-quarter-2020-air-fare-drops-new-low-passenger-numbers-decline')\nairFaresData = d3.csv(\n \"https://raw.githubusercontent.com/divya-dataanalytics/Aviation-Covid-Impact-DataViz-JavaScript/main/Domestic%20Air%20Fares.csv\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"md` ## Plot 4.1`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"TSAMon192021 = [...TSASumbyMonth19.keys(), ...TSASumbyMonth20.keys(), ...TSASumbyMonth21.keys() ]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"TSASumbyMonth21 = d3\n .rollup(\n TSASumMonth21,\n v => d3.sum(v, d => d.Traveller2021),\n d => d.DateMon + \" \" + 21\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":622,"value":"TSASumMonth21 = TSAFormattedByMon.filter(d => d.Traveller2021 != 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"actual = onTimefn(planned,0,cancelled,diverted)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":628,"value":"planned = [...plannedMon.values()];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"plannedMon = d3.rollup(\n arrivalsMonYr,\n v => d3.sum(v, d => d['scheduled_arr']),\n d => d['MonYr']\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"arrivalsMonYr = arrivals20192020.map(function(obj) {\n return {\n MonYr: obj[\"month\"].concat(\"/\", obj.year),\n scheduled_arr: +obj.arr_flights,\n cancelled: +obj.arr_cancelled,\n diverted: +obj.arr_diverted,\n delays: +obj.arr_del15,\n actual: obj.arr_flights - obj.arr_cancelled - obj.arr_diverted,\n onTime: (obj.arr_flights - obj.arr_cancelled - obj.arr_diverted - obj.arr_del15) \n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"arrivals20192020 = d3.csv(\n 'https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/Arrivals_20192020.csv'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"cancelled = [...cancelledMon.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"cancelledMon = d3.rollup(\n arrivalsMonYr,\n v => d3.sum(v, d => d['cancelled']),\n d => d['MonYr']\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"diverted = [...divertedMon.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"divertedMon = d3.rollup(\n arrivalsMonYr,\n v => d3.sum(v, d => d['diverted']),\n d => d['MonYr']\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"md ` ## Plot 4.2`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":708,"value":"OnTimePercent = perct(onTime , planned)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"onTime = [...OnTime.values()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"OnTime = d3.rollup(\n arrivalsMonYr,\n v => d3.sum(v, d => d['onTime']),\n d => d['MonYr']\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"md ` ## Plot 5.1`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":736,"value":"majorAirportList = [...MajorairportsDestGroup.keys()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":737,"value":"MajorairportsDestGroup = d3.group(MajorairportsDest, d => d.Source)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":740,"value":"MajorairportsDest = Majorairports.filter(d => d.Type == \"Destination Airports\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"Majorairports = d3.csv(\n \"https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/MajorAirports.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":745,"value":"psgMajorAirportData = MajorairportsDestGroup.get(dropdown)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":690,"value":"md ` ## Plot 5.2`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"w = top10.map(function(obj) {\n return {\n \n val: obj[\"Passenger-Arr \" + selectYear]\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":758,"value":"top10 = top15.filter(d => d.Airport_Dest != 'MCO' && d.Airport_Source != 'LAS' && d.Airport_Dest != 'SEA' && d.Airport_Dest != 'ORD' )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":760,"value":"top15 = MajorairportsDest.sort(function(a, b) {\n return a['Passenger-Arr 2019'] < b['Passenger-Arr 2019'] ? 1 : -1;\n}).slice(0, 14)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":878,"value":"airports_dat = d3.csv(\n \"https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":762,"value":"a112 = [...new Set(a11.concat(a12))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"a11 = [...new Set(latitude.map(d => d[0][0]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":773,"value":"a12 = [...new Set(latitude.map(d => d[1][0]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"latitude = top10.map(a => {\n const latitude1 = airports\n .filter(b => b.airportID === a[\"Airport Scode\"])\n .map(b => b.latitude);\n const latitude2 = airports\n .filter(b => b.airportID === a.Airport_Dcode)\n .map(b => b.latitude);\n return Object.assign({}, [latitude1, latitude2]);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":769,"value":"airports = airports_dat.map(function(obj) {\n return {\n airportID: obj['GKA'],\n airportName: obj['Goroka Airport'],\n latitude: +obj['-6.081689834590001'],\n longitude: +obj['145.391998291']\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":775,"value":"b11 = [...new Set(longitude.map(d => d[0][0]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"b112 = [...new Set(b11.concat(b12))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":778,"value":"b12 = [...new Set(longitude.map(d => d[1][0]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":781,"value":"longitude = top10.map(a => {\n const longitude1 = airports\n .filter(b => b.airportID === a[\"Airport Scode\"])\n .map(b => b.longitude);\n const longitude2 = airports\n .filter(b => b.airportID === a.Airport_Dcode)\n .map(b => b.longitude);\n return Object.assign({}, [longitude1, longitude2]);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"flightpathlats={\n const lats = [];\n latitude.forEach(d=>{\n lats.push(d[0][0]);\n lats.push(d[1][0]);\n lats.push(null);\n })\n return lats;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":802,"value":"flightpathlons={\n const lons = [];\n longitude.forEach(d=>{\n lons.push(d[0][0]);\n lons.push(d[1][0]);\n lons.push(null);\n })\n return lons;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"airportName = {\n const air = [];\n top10.forEach(d => {\n air.push(d[\"Source\"]);\n air.push(d[\"Dest\"]);\n air.push(null);\n });\n return air;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":808,"value":"width = {\n if (selectYear == 2019) {\n return 5;\n } else {\n return 1;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":692,"value":"md ` ## Plot 5.3`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":826,"value":"majorPsg = d3.csv(\n 'https://raw.githubusercontent.com/divya-dataanalytics/Data-Visualization-JavaScript/main/MajorAirports_passengers.csv'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"md` ## Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"parseTimemdy = d3.timeParse(\"%m/%d/%Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"timeformatMonDayYr = d3.timeFormat(\"%m/%d/%y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"timeformat = d3.timeFormat(\"%b%y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"timeformatDayMon = d3.timeFormat(\"%d/%m\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"timeformatMonName = d3.timeFormat(\"%b\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"function sortData(a) {\n var b = a.slice().sort((a, b) => a.Date - b.Date);\n return b;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":582,"value":"async function scrapeTableData(url) {\n const response = await soFetch(url);\n const text = await response.text();\n //const domparser = new DOMParser();\n //const dom = domparser.parseFromString(text, \"text/html\");\n const dom = html`${text}`;\n const tables = await dom.querySelectorAll('table');\n if (tables.length <= 0) {\n throw new Error('Could not find any tables.');\n }\n const tablesLen = tables.length;\n\n const tablesData = [];\n for (let i = 0; i < tablesLen; i++) {\n let tableEl = tables[i];\n\n tablesData.push(tableEl);\n }\n return tablesData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"getTableData = (data, start = 1) => {\n const d = tableToJson(data, start);\n const t = d.slice(1);\n const columns = d[0];\n return t.map(d =>\n columns.reduce((acc, e, i) => {\n acc[e] = d[i];\n return acc;\n }, {})\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"function tableToJson(table,start=1) {\n //Code from : https://stackoverflow.com/questions/9927126/how-to-convert-the-following-table-to-json-with-javascript\n var data = [];\n for (var i = start; i < table.rows.length; i++) {\n var tableRow = table.rows[i];\n var rowData = [];\n for (var j = 0; j < tableRow.cells.length; j++) {\n rowData.push(tableRow.cells[j].innerHTML);\n }\n data.push(rowData);\n }\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"onTimefn = (arr1, arr2, arr3, arr4 ) => {\n const res = [];\n for(let i = 0; i < arr1.length; i++){\n const temp = Math.abs((arr1[i] || 0) - (arr2[i] || 0) - (arr3[i] || 0) - (arr4[i] || 0));\n res[i] = temp;\n };\n return res}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":715,"value":"perct = (arr1, arr2) => {\n const res = [];\n for (let i = 0; i < arr1.length; i++) {\n const temp = ((arr1[i] || 0) / (arr2[i] || 0)) * 100;\n const temp_perc = temp.toFixed(2);\n res[i] = temp_perc;\n }\n return res;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"md `## Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"Plotly = require(\"plotly.js-dist\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"import { soFetch } from '@alecglassford/so-fetch'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"import { checkbox, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"import { Select } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"import { select } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"import { Table } from \"@observablehq/table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"import { vl } from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3b","stdlib":"1","titling":"auto"}} 32:"$31:body"