Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    DA2

    Uploaded by

    Sanchit Anand
    The document imports necessary libraries and reads flight data from a CSV file. It selects columns from the data and defines lists of airline data and indices. It then plots the airline data in a table with the indices as row labels and data columns as column labels, styled with colors. The table is plotted to check for peak hours, compare flight durations and stops, and analyze profits from flights. Bar graphs and scatter plots are proposed to visualize this data for comparisons by the target airline company.

    Copyright:

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

    DA2

    Uploaded by

    Sanchit Anand
    28 views3 pages
    The document imports necessary libraries and reads flight data from a CSV file. It selects columns from the data and defines lists of airline data and indices. It then plots the airline data in a table with the indices as row labels and data columns as column labels, styled with colors. The table is plotted to check for peak hours, compare flight durations and stops, and analyze profits from flights. Bar graphs and scatter plots are proposed to visualize this data for comparisons by the target airline company.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document imports necessary libraries and reads flight data from a CSV file. It selects columns from the data and defines lists of airline data and indices. It then plots the airline data in a table with the indices as row labels and data columns as column labels, styled with colors. The table is plotted to check for peak hours, compare flight durations and stops, and analyze profits from flights. Bar graphs and scatter plots are proposed to visualize this data for comparisons by the target airline company.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    28 views3 pages

    DA2

    Uploaded by

    Sanchit Anand
    The document imports necessary libraries and reads flight data from a CSV file. It selects columns from the data and defines lists of airline data and indices. It then plots the airline data in a table with the indices as row labels and data columns as column labels, styled with colors. The table is plotted to check for peak hours, compare flight durations and stops, and analyze profits from flights. Bar graphs and scatter plots are proposed to visualize this data for comparisons by the target airline company.

    Copyright:

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

    import pandas as pd

    import matplotlib.pyplot as plt


    import colorama
    from colorama import Fore
    import numpy as np
    print(Fore.RED + 'QUANTITATIVE')
    print(Fore.BLUE+ 'ORDINAL')
    print(Fore.YELLOW + 'CATEGORICAL')
    flights=pd.read_csv("D:\\aryan\\Vit_temp\\flights_data.csv")
    dictionary_state=flights.loc[:,
    ['Airline','Date_of_Journey','Duration_minutes','Price']]
    x=['Airline','Date_of_Journey','Duration_minutes','Price']
    y=[ i for i in range(20)]
    z=[[i for i in dictionary_state.loc[j]]for j in y]

    fig, ax=plt.subplots()
    ax.set_axis_off()
    rcol=plt.cm.BuPu(np.full(len(y),0.1))
    ccolor=[["y","b","r","b"]for j in y]
    plt.table(
    cellText=z,
    rowLabels=y,
    colLabels=x,
    colWidths=[0.2]*4,
    cellColours=ccolor,
    rowColours=rcol,
    cellLoc="center",
    loc="upper left")
    plt.show()
    Week 5 task Visual Idiom

    Database: flight data set

    Target user: Airline company

    Requirement for visualization


    1. To check the peak hours of the airlines and to hire pilots accordingly
    2. To compare the flight durations with halts and stops and to improve them so that customers
    rely on the airline and get comfort
    3. To check the profits gained from flights based on peak hours

    Task Abstraction

    For all the above requirements, they can be mapped using queries

    Dataset: table

    Data type: Items, Attributes

    Visual Idiom encoding techniques: the data can be arranged and expressed in graph for comparison

    1. To check peak hours, the bar graph can be plot where the height represents the total flights at
    the time and the x-axis represents the time slots
    2. Other method could be scatter plots where the number of stops and flight durations are
    mapped with different colors.

    You might also like