Skip to content

Latest commit

 

History

History
16 lines (12 loc) · 1.02 KB

09.md

File metadata and controls

16 lines (12 loc) · 1.02 KB

Search Examples III

Time: 30 minutes

Instructions

It's time to keep practicing. This time, it's your turn to be creative. The idea is that you create searches by using the most common commands. Feel free to add more queries if you finish early.

Upload data

Let's use some data from FIFA. Upload the file for soccer rankings.

Using Search Commands

  • 9.1 - What's the average rank number for Spain in 2018?
  • 9.2 - What are the average rank number for Germany or Italy in 2000? Average both team ranks together
  • 9.3 - What are the top five countries by average rank for 2014?
  • 9.4 - List the countries with a new diff_points field that includes the difference between total_points and previous_points. (diff_points = total_points - previous_points) - You will need to use eval to create the new field.
  • 9.5 - What is the min, avg, and max rank numbers for Italy for all time?