Pergunta de entrevista da empresa Citi

Python: read 100s of CSV file and merge common data to a data frame. SQL: calculate distance from centroid and lat-long (from three different tables) and output city names that fall outside the radius.