Lecture 16 – Row Manipulation

Data 6, Summer 2021

It would be nice to have a combined score too.


Which states had the highest combined scores? The lowest?

We can sort by any column:


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


Shortcut for are.equal_to

Multiple conditions