cs660-listing#2.py

list_of_traded_corps = symbols.loc[:, ['NASDAQ Symbol', 'Security Name', 'Listing Exchange']]

listing_exchange = {
    'A': 'NYSE MKT',
    'N': 'New York Stock Exchange (NYSE)',
    'P': 'NYSE ARCA',
    'Q': 'Q - NASDAQ?', # not sure about this one
    'V': 'Investors\' Exchange, LLC (IEXG)',
    'Z': 'BATS Global Markets (BATS)'
}

list_of_traded_corps['Listing Exchange'] = list_of_traded_corps['Listing Exchange'].apply(lambda c: listing_exchange[c])
list_of_traded_corps.head()