• 

  Sick plane, dude.

Flight-Wrangler

Project Description

Flight Wrangler is an application we've created with the purpose of reading .csv files of flight log data, extracting it, and transforming it into easy to understand metrics. We want a user to be able to find any outliers in their data set in any of the 60 columns of the flight log data, as well as be able to visualize the entirety of a flight. This program assumes that the incoming flight logs are from Garmin and of the log version 1.00 .

Usage

When dropping a csv file in the directory, excel needs to be closed. It will not be able to read it if you have it open

Challenges Faced

Eric's Challenges

Initially, I was trying to get definitions for the different paramters we were pulling in from the .csv files. I was also having a lot of issues with different python interpreters installed and getting visual studio to sync up correctly to the venv so I could access the installed libs.

Jon's Challenges

Size increase due to dates being objects, we believe, and casting to strings didn't help. Type casting is what took up the most time in the ramp-up phase of this project. I've never dealt with receiving a CSV file like the one we have, especially with the amount of rows & the various types in them. Couldn't get AFCSON to convert to boolean, so we're going to have to drop it since it won't play nice with our mock data production implementation.

Future Plans

Come back later, we're not there yet :) Improve type casting. Minimize mock data file size (currently 7MB for 7k~ rows).

About the Devs

We're Jon Martin and Eric Webb. We're both Seniors at the Kansas State Salina Aerospace and Technology Campus in the Computer Systems Technology degree. We're also the founders of our campus's ACM club, and this is our first hackathon as a club!

Built With

• firebase
• firestore
• node.js
• pandas
• python
• react