Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Use data wrangling commands to find out what were the top 6 destinations for flights And to find which 5 airports had the highest average

Use data wrangling commands to find out what were the top 6 destinations for flights
And to find which 5 airports had the highest average arrival delay time
image text in transcribed
2 Filter dep,tim sched dep,tima dep, delay arr time sched ar tim arr delay carler tallum day fighi origia dest air simd distanc -8 827 -4 803 -5 931 -5 709 -2 716 -9 722 3 704 -3805 -7 912 4948 -5 1055 -3 728 -1 | 921 -6 80s 6 81S -33 DL N905DE 717 MSP ATL 521 815 -12 XE N18101 2305 MSP AH 139 1034 129 1008 -1lXE N17146|2997 MSP EWR 720-11 UAN441UA 520 MSP ORD 51 334 53 334 726F9 N923FR275 MSP DEN93680 721-17 UA N462UA 243 MSP DES 94 680 83 700 139 1034 4 MQ N504MQ 3842 MSP ORD 1606 615 610 -22 DL N363NW 1981 MSP MEM -10 CO N59630 1517 MSP AH 827 626 630 637 639 630 1005 -17 N3SW 2513 MSP ATL 112 90 -15 AA NAYAA 788 MSP MIA 185 1501 800-32 WN N903WN 1327 MSP DEN 680 79 528 52 334 8341.-19 DL N760NC 2897MSP STL- 63 449 4 DL N3756 1490 MSP DTW 815 Showing 1 to 15 of 125,802 entries Console 1 340 341 342 343 345 346.5 347 349.5 350.5 357 357.5 358.5 361.5 362 363.5 364.5 365.5 366.5 368 373.5 377 381 383 391.5 392 398.5 401.5 404.5 407 410 410.5 426.5 427.5 432 436.5 437 44 446.5 448 454.5 471 479 481.5 495 583.5 521 559.5 567.5 591 644.5 671 716 755 762 793 818 838 1283 1343.5 res5Sav_delay-Cres5sdep delay res5Sarr.delay)/2 > ViewCnexres5) MacBook Air

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions