Ir para o conteúdo principal
moodle2324
  • Mais
Português ‎(pt)‎
Deutsch ‎(de)‎ English ‎(en)‎ Français ‎(fr)‎ Português ‎(pt)‎
A aceder como visitante
Entrar
FCUP-CC3047-2023/2024-2S
  1. Página principal
  2. Ciência de Dados em Larga Escala
  3. Bigquery mini-task (upload here yor report)

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.

  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
Logo da licença Creative Commons Creative Commons
Requisitos mínimos de utilização
A aceder como visitante (Entrar)
Obter a Aplicação móvel
Fornecido por Moodle