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
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
Get step-by-step solutions from verified subject matter experts
