Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help with two things inside of juypter note book and please in you're answer explain in great detail thank you here is a

i need help with two things inside of juypter note book and please in you're answer explain in great detail thank you

image text in transcribed

here is a snapshot from the data i cant link the actual file

image text in transcribed

2. Using the matplotlib function barh, create a bar plot showing the data from 5 above, i.e. the percentage of delayed flights for each airline. a. Figure out the two arguments needed for barh and correctly call the function. b. Label your X axis. Make sure the values are actually percentages, not decimals. This should generate a plot that looks like this: 3. Create a boxplot for the delays due to weather at the airports BOS, LGA and ATL. a. Use your code from 6 three times to get the data for the three airports, be sure to get the correct column. b. Call the correct plotting function on them in a list. c. Change the x ticks to contain the airport codes and label the Y-axis. Your plot should look like this: \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline year & month & carrier & carrier_name & airport & airport_name & arr_flights & arr_del15 & arr_cancelled & arr_diverted & arr_delay & carrier_delay & weather_delay & nas_delay & security_delay & late_aircraft_delay \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & ABE & Allentown/Bethlehem/Easton, PA: Lehigh Valley International & 89 & 13 & 2 & 1 & 1375 & 71 & 761 & 118 & 0 & 425 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & ABY & Albany, GA: Southwest Georgia Regional & 62 & 10 & 0 & 1 & 799 & 218 & 1 & 62 & 0 & 518 \\ \hline 2023 & 8 & & Endeavor Air Inc. & AEX & Alexandria, LA: Alexandria International & 62 & 10 & 1 & 0 & 766 & 56 & 188 & 78 & 0 & 444 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & AGS & Augusta, GA: Augusta Regional at Bush Field & 66 & 12 & 1 & 1 & 1397 & 471 & 320 & 388 & 0 & 218 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & ALB & Albany, NY: Albany International & 92 & 22 & 2 & 0 & 1530 & 628 & 0 & 134 & 0 & 768 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & ATL & Atlanta, GA: Hartsfield-Jackson Atlanta International & 1636 & 256 & 32 & 11 & 29768 & 9339 & 4557 & 4676 & 0 & 11196 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & AUS & Austin, TX: Austin - Bergstrom International & 75 & 12 & 0 & 0 & 843 & 535 & 170 & 111 & 0 & 27 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & AVL & Asheville, NC: Asheville Regional & 59 & 7 & 2 & 0 & 324 & 117 & 0 & 25 & 0 & 182 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & AZO & Kalamazoo, MI: Kalamazoo/Battle Creek International & 62 & 13 & 0 & 0 & 707 & 470 & 77 & 87 & 0 & 73 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BDL & Hartford, CT: Bradley International & 30 & 4 & 1 & 0 & 1421 & 0 & 532 & 0 & 0 & 889 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BGM & Binghamton, NY: Greater Binghamton/Edwin A. Link Field & 58 & 10 & 1 & 0 & 1604 & 207 & 0 & 1049 & 0 & 348 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BGR & Bangor, ME: Bangor International & 124 & 13 & 3 & 0 & 1207 & 282 & 650 & 18 & 0 & 257 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BHM & Birmingham, AL: Birmingham-Shuttlesworth International & 84 & 17 & 2 & 2 & 1124 & 208 & 0 & 164 & 0 & 752 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BNA & Nashville, TN: Nashville International & 166 & 25 & 2 & 0 & 1465 & 362 & 308 & 523 & 0 & 272 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BQK & Brunswick, GA: Brunswick Golden Isles & 62 & 14 & 2 & 2 & 2641 & 1238 & 184 & 771 & 0 & 448 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & BTV & Burlington, VT: Burlington International & 147 & 30 & 3 & 0 & 1628 & 714 & 0 & 324 & 0 & 590 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BUF & Buffalo, NY: Buffalo Niagara International & 154 & 25 & 2 & 0 & 1065 & 289 & 0 & 448 & 0 & 328 \\ \hline 2023 & 8 & & Endeavor Air Inc. & BWI & Baltimore, MD: Baltimore/Washington International Thurgood Marshall & 62 & 13 & 2 & 0 & 900 & 89 & 0 & 203 & 28 & 580 \\ \hline 2023 & 8 & & Endeavor Air Inc. & CAE & Columbia, SC: Columbia Metropolitan & 92 & 20 & 1 & 0 & 1375 & 398 & 0 & 448 & 0 & 529 \\ \hline 2023 & 8 & & Endeavor Air Inc. & CHA & Chattanooga, TN: Lovell Field & 119 & 17 & 1 & 0 & 1108 & 341 & 174 & 82 & 0 & 511 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CHO & Charlottesville, VA: Charlottesville Albemarle & 139 & 17 & 2 & 1 & 891 & 226 & 118 & 348 & 0 & 199 \\ \hline 2023 & 8 & & Endeavor Air Inc. & CHS & Charleston, SC: Charleston AFB/International & 137 & 16 & 4 & 0 & 935 & 322 & 12 & 330 & 0 & 271 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CLE & Cleveland, OH: Cleveland-Hopkins International & 323 & 62 & 6 & 3 & 4601 & 1792 & 851 & 304 & 0 & 1654 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CLT & Charlotte, NC: Charlotte Douglas International & 232 & 38 & 9 & 1 & 2617 & 752 & 49 & 753 & 0 & 1063 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CMH & Columbus, OH: John Glenn Columbus International & 99 & 15 & 2 & 0 & 971 & 275 & 23 & 109 & 0 & 564 \\ \hline 2023 & 8 & & Endeavor Air Inc. & CRW & Charleston/Dunbar, WV: West Virginia International Yeager & 5 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CSG & Columbus, GA: Columbus Airport & 79 & 10 & 2 & 0 & 1280 & 828 & 59 & 4 & 0 & 376 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CVG & Cincinnati, OH: Cincinnati/Northern Kentucky International & 637 & 109 & 8 & 0 & 8481 & 2548 & 122 & 1248 & 0 & 4563 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & CWA & Mosinee, WI: Central Wisconsin & 62 & 12 & 0 & 0 & 878 & 460 & 0 & 5 & 0 & 413 \\ \hline 2023 & 8 & 9g & Endeavor Air Inc. & DAY & Dayton, OH: James M Cox/Dayton International & 27 & 5 & 0 & 0 & 418 & 92 & 0 & 118 & 0 & 208 \\ \hline 2023 & 8 & & Endeavor Air Inc. & DCA & Washington, DC: Ronald Reagan Washington National & 205 & 29 & 3 & 0 & 2886 & 749 & 46 & 1240 & 0 & 851 \\ \hline 2023 & 8 & & Endeavor Air Inc. & DHN & Dothan, AL: Dothan Regional & 62 & 11 & 0 & 0 & 456 & 43 & 0 & 316 & 0 & 97 \\ \hline 2023 & 8 & & Endeavor Air Inc. & DLH & Duluth, MN: Duluth International & 55 & 2 & 0 & 0 & 153 & 8 & 0 & 3 & 0 & 142 \\ \hline 2023 & 8 & 9g & Endeavor Air Inc. & DSM & Des Moines, IA: Des Moines International & 218 & 52 & 1 & 0 & 3728 & 1539 & 0 & 646 & 0 & 1543 \\ \hline 2023 & 8 & & Endeavor Air Inc. & DTW & Detroit, Ml: Detroit Metro Wayne County & 1607 & 262 & 19 & 5 & 24485 & 6954 & 1146 & 4936 & 0 & 11449 \\ \hline 2023 & 8 & & Endeavor Air Inc. & EW & Evansville, IN: Evansville Regional & 79 & 14 & 1 & 0 & 1105 & 762 & 64 & 111 & 0 & 168 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & EWR & Newark, NJ: Newark Liberty International & 150 & 21 & 2 & 0 & 1264 & 620 & 0 & 237 & 0 & 407 \\ \hline 2023 & 8 & & Endeavor Air Inc. & FAR & Fargo, ND: Hector International & 58 & 6 & 1 & 0 & 309 & 180 & 0 & 3 & 0 & 126 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & FAY & Fayetteville, NC: Fayetteville Regional/Grannis Field & 31 & 7 & 0 & 1 & 718 & 204 & 61 & 78 & 0 & 375 \\ \hline 2023 & 8 & & Endeavor Air Inc. & FSD & Sioux Falls, SD: Joe Foss Field & 53 & 20 & 0 & 0 & 1382 & 653 & 32 & 54 & 0 & 643 \\ \hline 2023 & 8 & 9E & Endeavor Air Inc. & GFK & Grand Forks, ND: Grand Forks International & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline 2023 & 8 & & Endeavor Air Inc. & GRR & Grand Rapids, MI: Gerald R. Ford International & 149 & 18 & 1 & 0 & 1427 & 525 & 28 & 147 & 0 & 727 \\ \hline 2023 & 8 & 9g & Endeavor Air Inc. & Gso & Greensboro/High Point, NC: Piedmont Triad International & 166 & 14 & 1 & 1 & 1282 & 912 & 0 & 178 & 0 & 192 \\ \hline 2023 & 8 & & Endeavor Air Inc. & GSP & Greer, SC: Greenville-Spartanburg International & 104 & 19 & 2 & 0 & 1141 & 582 & 37 & 126 & 0 & 396 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven NoSQL Databases In A Week Get Up And Running With The Fundamentals And Functionalities Of Seven Of The Most Popular NoSQL Databases

Authors: Aaron Ploetz ,Devram Kandhare ,Sudarshan Kadambi ,Xun Wu

1st Edition

1787288862, 978-1787288867

More Books

Students also viewed these Databases questions