FCUP-CC3047-2023/2024-2S
Bigquery mini-task (upload here yor report)
Requisitos de conclusão
Abriu: quinta-feira, 11 de abril de 2024 às 00:00
Data limite: sexta-feira, 19 de abril de 2024 às 00:00
After reading the google documentation and playing with existing datasets, use this dataset to perform the following tasks in the google cloud bigquery, using Python.
- Upload the dataset to bigquery
- Execute the following queries:
- Get a list of movies of the genre drama
- Get a list of movies of the genre drama and year 2006
- Get the titles of the 10 longest movies
Below, it follows a description of the fields for this dataset:
title.basics.tsv.gz
- tconst (string) - alphanumeric unique identifier of the title
- titleType (string) – the type/format of the title (e.g. movie, short, tvseries, tvepisode, video, etc)
- primaryTitle (string) – the more popular title / the title used by the filmmakers on promotional materials at the point of release
- originalTitle (string) - original title, in the original language
- isAdult (boolean) - 0: non-adult title; 1: adult title
- startYear (YYYY) – represents the release year of a title. In the case of TV Series, it is the series start year
- endYear (YYYY) – TV Series end year. ‘\N’ for all other title types
- runtimeMinutes – primary runtime of the title, in minutes
- genres (string array) – includes up to three genres associated with the title