Question: using python help me solve this flights.csv Airport code Country City Path ID Path Order Flow Amount (t) Latitude Longitude 0 PRG Czech Republic Prague

using python help me solve this

flights.csv

Airport code Country City Path ID Path Order Flow Amount (t) Latitude Longitude
0 PRG Czech Republic Prague PRG-VIE 1 NaN 50.075538 14.4378
1 VIE Austria Vienna PRG-VIE 2 250 48.208174 16.373819
2 PRG Czech Republic Prague PRG-MSQ 1 NaN 50.075538 14.4378
3 MSQ Belarus Minsk PRG-MSQ 2 1200 53.90454 27.561524
4 PRG Czech Republic Prague PRG-TMP 1 NaN 50.075538 14.4378
5 TMP Finland Tampere PRG-TMP 2 800 61.497752 23.760954
6 PRG Czech Republic Prague PRG-HAM 1 NaN 50.075538 14.4378
7 HAM Germany Hamburg PRG-HAM 2 400 53.551085 9.993682
8 PRG Czech Republic Prague PRG-ATH 1 NaN 50.075538 14.4378
9 ATH Greece Athens PRG-ATH 2 150 37.98381 23.727539

I need your help to solve the following exercise using python

using python help me solve this flights.csv Airport code Country City Path

memory usage: 2.0+ KB 1 # Question 3: What is the average flow amount? # HINT: Here is one very good example of why the iloc function is useful -- the column name "Flow Amount (t)" would be # inconvenient to type, so you might want to use the position of the column instead... If you prefer column name, that # is fine, too. Out[12]: 616.0 2 # Question 4: What is the highest flow amount? Out[14]: 1300.0 3 # Question 5: Which city has the flow amount of 550? # Hint: Recall back to our discussion on the relational algebra of SELECTION and the Python bracket notation Out[16]: 17 Warsaw Name: City, dtype: object

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!