Relation Tutorial 6
Show the number of titles by director
read "films.csv"
project director, film count
print
| director | film_count |
|---|---|
| Godard | 3 |
| Truffaut | 2 |
| Varda | 2 |
| von Trotta | 1 |
| Kluge | 1 |
Show the average number of titles by director
read "films.csv"
project director, film coun
project film_count avg
print
| film_count_avg |
|---|
| 1.8 |