On the class web site is:
	
	https://www.jre-training.com/Pandas/Data/airport-codes.csv
	
	Please create a list of "large-airports"
	
	I want to see the following columns:
	
	ident
	name
	iso_country
	municipality
	iata_code
	
	I would like to see a new column w/ "city, county"
	
	I would like the data sorted by iata_code
	
	---------------------------------------------------------

import pandas as pd

# I want only a few selected columns
selected_columns =  ['ident','type','name','iso_country','municipality','iata_code']

url = 'https://www.jre-training.com/Pandas/Data/airport-codes.csv'
orgin_df = pd.read_csv(url, usecols=selected_columns)

filter = orgin_df['type'] == 'large_airport'

filtered_df = orgin_df.loc[filter, selected_columns]
filtered_df = filtered_df.assign(full_name=lambda record: record.municipality + ", " + record.iso_country)
filtered_df.sort_values(by=['iata_code'], inplace=True)
filtered_df.reset_index(inplace=True)

print(filtered_df)