Skip to main content
moodle2324
  • More
English ‎(en)‎
Deutsch ‎(de)‎ English ‎(en)‎ Français ‎(fr)‎ Português ‎(pt)‎
You are currently using guest access
Log in
FCUP-CC3047-2023/2024-2S
  1. Home
  2. Ciência de Dados em Larga Escala
  3. Bigquery mini-task (upload here yor report)

Bigquery mini-task (upload here yor report)

Completion requirements
Opened: Thursday, 11 April 2024, 00:00
Due: Friday, 19 April 2024, 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.

  1. Upload the dataset to bigquery
  2. 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

◄ Tutorial on bigquery by Prof. Eduardo Marques
Modin ►
Portais U.Porto
  • Portal de e-learning
  • Inovação Pedagógica
    AcademiaUP
Ferramentas integradas
  • Colibri
  • Panopto
  • Turnitin
  • Wooclap
Creative Commons license logo Creative Commons
Minimum usage requirements
You are currently using guest access (Log in)
Get the mobile app
Powered by Moodle