Lecture 10

Groups

DATA 8

Fall 2023

Announcements

• Lab 4 due tonight at 11pm.
• HW 5 due Wednesday 9/20 at 11pm
• Project 1 due Friday 9/29
• Checkpoint due Friday 9/22
• World population through data
• Sahai OH: Mondays, 5-7pm @ FSM Cafe

​

How to Get to FSM

Functions

(Demo)

Apply

Apply

apply

1. Calls a function on every element in the input column(s)
2. Produces an array containing the output of the function on each input column element.
1. First argument: Function to apply
2. Other arguments: Specified input column(s)

table_name.apply(function_name, 'column_label(s)')

​

(Demo)

Prediction

(Demo)

Prediction Accuracy

(Demo)

Discussion Questions

1. How could we take sex into account when making predictions?
2. Do we make smaller errors on average when we do this?

(Demo)

Grouping

Grouping by One Column

The group method aggregates all rows with the same value for a column into a single row in the resulting table.

• First argument: Which column to group by
• Second argument: (Optional) How to combine values
• len — number of grouped values (default)
• list — list of all grouped values
• sum — total of all grouped values

(Demo)

Lists

Lists are Generic Sequences

A list is a sequence of values (just like an array), � but the values can have different types

[2+3, 'four', Table().with_column('K', [3, 4])]

• Lists can be used to create table rows.
• If you create a table column from a list, it will be converted to an array automatically

​

(Demo)

Cross-Classification

(Demo)