maumchaves/python_code_test_carto.md

Forked from jorgesancha/python_code_test_carto.md

Created March 28, 2020 16:52

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/maumchaves/5b0a527b8b569df1aba9fee75f8f2fcb.js"></script>
Save maumchaves/5b0a527b8b569df1aba9fee75f8f2fcb to your computer and use it in GitHub Desktop.

Python code test - CARTO

Raw

What follows is a technical test for this job offer at CARTO: https://boards.greenhouse.io/cartodb/jobs/705852#.WSvORxOGPUI

Build the following and make it run as fast as you possibly can using Python 3 (vanilla). The faster it runs, the more you will impress us!

Your code should:

Download this ~2GB file: https://s3.amazonaws.com/carto-1000x/data/yellow_tripdata_2016-01.csv
Count the lines in the file
Calculate the average value of the tip_amount field.

All of that in the most efficient way you can come up with.

That's it. Make it fly!