Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Assigment 5

    Uploaded by

    Tania Fernanda Moreno Fuentes

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Assigment 5

    Uploaded by

    Tania Fernanda Moreno Fuentes
    3 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3 views2 pages

    Assigment 5

    Uploaded by

    Tania Fernanda Moreno Fuentes

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Assigment 5

    Intro to Big Data & Data Mining


    Student: Tania Moreno
    Date: July 26th, 2024.

    Task 1: How many flights are in this dataset from Houston to city of "Los Angels"? Print the
    number.

    Flights from Houston to Los Angeles: 5283 flights.

    Task 2: Which top-10 destination cities have the most number of flights?

    City Flights
    1 Dallas 13496
    2 Atlanta 8584
    3 New Orleans 7974
    4 Dallas-Fort Worth 7964
    5 Chicago 7705
    6 San Antonio 6332
    7 Austin 6014
    8 Phoenix 5898
    9 Denver 5647
    10 New York 5312

    Task 3: Which states have no flights?


    States with no flights
    1 ND
    2 DC
    3 ME
    4 VT
    5 SD
    6 MT
    7 ID
    8 NH
    9 DE
    10 WY
    11 RI
    12 <NA>
    13 AS
    14 CQ
    15 GU
    16 VI
    Task 4: Which top 10 destination cities have the most cancelations of flights?

    City Cancellation flights


    1 Dallas 611
    2 Dallas-Fort Worth 245
    3 Chicago 215
    4 New Orleans 210
    15 Atlanta 200
    6 Harlingen 166
    7 New York 131
    8 San Antonio 110
    9 Phoenix 109
    10 Lafayette 98

    Task 5: Is there any Cities without a Flight from Houston?

    City Origin
    1 St Louis IAH
    2 Albuquerque IAH
    3 Lubbock IAH
    4 Nashville IAH
    5 Jacksonville IAH
    6 Salt Lake City IAH
    7 Savannah IAH
    8 Fayetteville/Springdale/Rogers IAH
    9 Richmond IAH
    10 El Paso IAH

    Task 6: What is the ratio of flights canceled for each state?

    State Total flights Cancelled flights Cancel Ratio


    1 LA 15625 485 3.10
    2 TX 51442 1549 3.01
    3 IL 7705 215 2.79
    4 NY 5312 131 2.47
    5 KS 1594 39 2.45
    6 MS 4969 117 2.35
    7 GA 9533 219 2.30
    8 WI 1673 38 2.27
    9 AR 2911 62 2.13
    10 KY 3087 64 2.07

    You might also like