Hi guys, I'm new at awk and I'm learning but I'm really lost at the below. I have the following dataset: "DAY_OF_MONTH","DAY_OF_WEEK","ORIGIN","DEST","DEP_TIME","DEP_DEL15","CANCELLED","DIVERTED","DISTANCE" 1,Tuesday,ORD,GRB,1003,0.00,0.00,0.00,279.966 1,Tuesday,TUL,ORD,1027,0.00,0.00,0.00,941.265…

I can't see how you get to your Expected Output from your given dataset. Where do you get the total_flights from? Please show what code you've got so far, mayhap partly pseudo code to reveal your thoughts.

If a flight is either Cancelled or Diverted, does that also render it Delayed? I'm not clear why your fields DEP_DEL15, CANCELLED and DIVERTED are formatted as real numbers with two decimal digits, if they can only take values 0 and 1. Seems to me (from your Expected Output totals), that your file…

echo ""DAY_OF_MONTH","DAY_OF_WEEK","ORIGIN","DEST","DEP_TIME","DEP_DEL15","CANCELLED","DIVERTED","DISTANCE" 1,Tuesday,ORD,GRB,1003,0.00,0.00,0.00,279.966 1,Tuesday,TUL,ORD,1027,0.00,0.00,0.00,941.265 7,Monday,AUS,MSY,0838,0.00,0.00,0.00,714.396 17,Thursday,AUS,SFO,0.00,0.00,0.00,2419.94" | awk -F , …

total_flights is obtained from summing up all flights belonging to a day. In the dataset given, for Tuesday it should be 2. For Monday 1 and for Thursday 1.

[image] Paul_Pedant: at also render it Delayed? No, cancelled or diverted flights do not influence at delayed flights.

This sounds very much homework/classwork, furthermore asking help using specific commands are typical students request, and so you are to post inadequate category and show or effort in resolving please read again the new rules Closing thread till you give us an answer on what to do with this one ( …

I thought I could post this since no documentation is given to solve this. I wrote I'm new at awk, therefore, I was hoping to get some help here. Thanks.

Unix Linux Community

Performing operations with AWK

Shell Programming and Scripting

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled