GCP Courses/Videos Analysis#

import pandas as pd

Load Data#

cols = ['format', 'name', 'credits', 'link']
catalog_data = pd.read_json('../data/gcp_resources_chkp_230620.json', orient='split')[cols]

Preprocessing#

catalog_data['link'] = catalog_data['link'].apply(
    lambda x: f'<a href="{x}" target="_blank">link</a>')

Most expensive resources#

limit = 10

catalog_data.sort_values(
    by=['format', 'credits','name'], 
    ascending=[True, False, True], inplace=True)

catalog_data[:limit].style.format()
  format name credits link
148 Course Serverless Data Processing with Dataflow: Develop Pipelines 70 link
26 Course Building Scalable Java Microservices with Spring Boot and Spring Cloud 55 link
55 Course Enterprise Database Migration 55 link
13 Course Architecting with Google Kubernetes Engine: Workloads 45 link
20 Course Building Batch Data Pipelines on Google Cloud 45 link
111 Course Logging, Monitoring and Observability in Google Cloud 45 link
8 Course Application Development with Cloud Run 40 link
30 Course Computer Vision Fundamentals with Google Cloud 40 link
142 Course Production Machine Learning Systems 40 link
1 Course API Development on Google Cloud's Apigee API Platform 35 link

Search resources#

def contains(sentence):
    return catalog_data['name'].str.lower().str.contains(sentence)

def check_sentences(sentences):
    check = contains(sentences[0])

    for sentence in sentences[1:]:
        check |= contains(sentence)

    return check
valid_sentences = [
    'machine learning',
    'ml',
    'vertex',
    'data science',
    'tensorflow',
    'feature engineering',
    'computer vision',
    'natural language',
    'recommendation system',
    'forecast'
]

invalid_sentences = [
    'lookml',
    'bigquery'
]

valid_filter = check_sentences(valid_sentences)
invalid_filter = check_sentences(invalid_sentences)
filter = valid_filter & ~invalid_filter

print(f'{len(catalog_data[filter])} resources')

catalog_data[filter].style.format()
69 resources
  format name credits link
30 Course Computer Vision Fundamentals with Google Cloud 40 link
142 Course Production Machine Learning Systems 40 link
112 Course ML Pipelines on Google Cloud 30 link
114 Course Machine Learning in the Enterprise 26 link
143 Course Recommendation Systems on Google Cloud 25 link
154 Course Smart Analytics, Machine Learning, and AI on Google Cloud 25 link
155 Course TensorFlow on Google Cloud 25 link
127 Course Natural Language Processing on Google Cloud 21 link
9 Course Applying Machine Learning to your Data with Google Cloud 20 link
59 Course Feature Engineering 20 link
68 Course Google Cloud Big Data and Machine Learning Fundamentals 20 link
109 Course Launching into Machine Learning 20 link
110 Course Launching into Machine Learning 20 link
117 Course Managing Machine Learning Projects with Google Cloud 20 link
92 Course How Google Does Machine Learning 10 link
161 Course Vertex Forecasting and Time Series in Practice 10 link
72 Course Google Cloud Computing Foundations: Data, ML, and AI in Google Cloud 9 link
113 Course Machine Learning Operations (MLOps): Getting Started 5 link
67 Course Google Cloud AI and ML Solutions for the Public Sector 2 link
574 Lab MLOps with Vertex AI 9 link
547 Lab Integrate with Machine Learning APIs: Challenge Lab 7 link
577 Lab Machine Learning with TensorFlow in Vertex AI 7 link
642 Lab Predict Baby Weight with TensorFlow on AI Platform 7 link
213 Lab Autoscaling TensorFlow Model Deployments with TF Serving and Kubernetes 5 link
251 Lab Building a Fraud Detection Model with Vertex AI AutoML 5 link
253 Lab Building an Application with MongoDB Atlas and Natural Language API hosted on Cloud Run 5 link
264 Lab Classify Images of Clouds in the Cloud with AutoML Images 5 link
266 Lab Classify Text into Categories with the Natural Language API 5 link
430 Lab Distributed Multi-worker TensorFlow Training on Kubernetes 5 link
452 Lab Extract, Analyze, and Translate Text from Images with the Cloud ML APIs 5 link
461 Lab Fraud Detection on Financial Transactions with Machine Learning on Google Cloud 5 link
530 Lab Identify Damaged Car Parts with Vertex AutoML Vision 5 link
534 Lab Implementing Canary Releases of TensorFlow Model Deployments with Kubernetes and Anthos Service Mesh 5 link
576 Lab Machine Learning with Spark on Google Cloud Dataproc 5 link
638 Lab Perform Foundational Data, ML, and AI Tasks in Google Cloud: Challenge Lab 5 link
668 Lab Real Time Machine Learning with Cloud Dataflow and Vertex AI 5 link
678 Lab Running Distributed TensorFlow using Vertex AI 5 link
699 Lab Self Service ML Pipelines Using Dataprep and AutoML Tables 5 link
728 Lab TFX on Google Cloud Vertex Pipelines 5 link
764 Lab Using the Natural Language API from Google Docs 5 link
773 Lab Vertex AI Tabular Data: Qwik Start 5 link
776 Lab Vertex Pipelines: Qwik Start 5 link
265 Lab Classify Images with TensorFlow Convolutional Neural Networks 1 link
287 Lab Cloud Natural Language API: Qwik Start 1 link
438 Lab Entity and Sentiment Analysis with the Natural Language API 1 link
466 Lab Generative AI with Vertex AI: Getting Started 1 link
467 Lab Generative AI with Vertex AI: Prompt Design 1 link
474 Lab Get Started with TensorFlow on Google Cloud: Challenge Lab 1 link
531 Lab Identify Horses or Humans with TensorFlow and Vertex AI 1 link
556 Lab Introduction to Computer Vision with TensorFlow 1 link
557 Lab Introduction to Convolutions with TensorFlow 1 link
732 Lab TensorFlow: Qwik Start 1 link
774 Lab Vertex AI Workbench Notebook: Qwik Start 1 link
775 Lab Vertex AI: Qwik Start 1 link
231 Lab Bracketology with Google Machine Learning 0 link
840 Quest Data Science on Google Cloud: Machine Learning 44 link
878 Quest Integrate with Machine Learning APIs 29 link
839 Quest Data Science on Google Cloud 22 link
884 Quest Machine Learning APIs 22 link
812 Quest Build and Deploy Machine Learning Solutions on Vertex AI 21 link
880 Quest Intro to ML: Image Processing 17 link
786 Quest Advanced ML: ML Infrastructure 16 link
903 Quest Perform Foundational Data, ML, and AI Tasks in Google Cloud 14 link
870 Quest Google Cloud Solutions II: Data and Machine Learning 11 link
798 Quest Baseline: Data, ML, AI 10 link
879 Quest Intermediate ML: TensorFlow on Google Cloud 8 link
862 Quest Get Started with TensorFlow on Google Cloud 6 link
881 Quest Intro to ML: Language Processing 5 link
855 Quest Generative AI Explorer - Vertex AI 3 link