Create a classification model, Database Management System

Assignment Help:

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can define how many minuteslate you still accept) and "delayed". Use all available data (there is weather information available). Notealso that you have data for several days which you can use for training and testing.

Then, add 4 columns for the delay. These delay are:

  • gate_departure_delays =>(actual_gate_departure-scheduled_gate_departure )
  • gate_arrival_delays =>(actual_gate_arrival-scheduled_gate_arrival)
  • runway_departure_delays =>(actual_runway_departure-scheduled_runway_departure)
  • runway_arrival_delays =>(actual_runway_arrival-scheduled_runway_arrival)

Then work on this file.

Follow the CRISP-DM framework

3. Data Preparation

  • Construct variables as needed.
  • Deal with missing data.

Depend on the model that you use, how it deals with messing data, such as replace them with the mean values or find out what values should be, or anything you comfortable with, and provide a short description for that.

  • Combine the flight history data with additional data (weather, etc.)

Add column for weather to the file history that we have. You can find weather data in the data files.

4. Modeling

  • Create at least 3 different classification models (different techniques) and discuss theadvantages of each model for this classification task.

They could be 3 different trees, and describe each model. For example, put the tree or part of it then explain everything "what does it mean? What it tell the airport? What does it mean for them? And what can they do?

  • Assess how well each model performs (use training/test data, cross validation, etc. asappropriate).

Which of these models work better?

5. Evaluation

  • How useful is your best model for the airline industry? How would you measure the model'svalue?

6. Deployment

  • How would you deploy the model?
  • Write a report covering in detail all steps of the project. The results have to be reproducibleusing this documentation.

Related Discussions:- Create a classification model

Difference between internal tables and extra datasets, What is the differen...

What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

Improved availability, Improved availability: The data in a distributed sys...

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

Define entity integrity and referential integrity, Define entity integrity ...

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut

Example of weak entity, Consider the entity type dependent related to emplo...

Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d

BI, (a) Why did SAP introduce the extended star schema?

(a) Why did SAP introduce the extended star schema?

List the types of authorization, List the types of authorization. A) R...

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

Explain the fundamental concepts of object-orientation, Explain the Fundame...

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

Entity relationship diagram, The Enhanced Entity Relationship Diagram (ERD)...

The Enhanced Entity Relationship Diagram (ERD) produced with a drawing or case tool. Your EERD must use a ''standard'' notation style such as Crows Foot or Chen. Please note that t

Define object-relational systems, Define object-relational systems? Sy...

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

Backup - restore utilities, These are designed to reduce the effects of a d...

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd