Lecture 16 – Row Manipulation

Data 6, Summer 2021

It would be nice to have a combined score too.

sort

Which states had the highest combined scores? The lowest?

We can sort by any column:

take

When we combine sort and take, we can get some pretty powerful answers.

What are the top 5 states according to math scores?

What are the top 8 states in terms of participation?

Note: .take works on arrays too, not just tables!

Quick Check 1

where

Shortcut for are.equal_to

Multiple conditions

Quick Check 2