Create Stunning Data Visualizations with AI-First Colab and Gemini

Introduction to AI-First Colab

• 💡 AI-First Colab is a Jupyter notebook hosted in Google's cloud, featuring an agentic collaborator powered by Gemini to accelerate problem-solving.
• 🚀 It runs in the browser with minimal setup, offers free access to computing resources like GPUs and TPUs, and allows notebooks to be shared via Google Drive.
• 🧠 The AI companion understands your code and data state at each step, creating an iterative and collaborative workflow.

Generating an Interactive Weather Station Table

• 🎯 The demo uses daily temperature readings from ~1500 US weather stations from a BigQuery public dataset.
• 📝 A prompt is used to create a data table showing one row per station, which Gemini processes by loading, wrangling, and displaying the data.
• 📊 The resulting table is made interactive, allowing sorting by longitude/latitude and filtering by state, revealing that many stations are airports.

Creating a Time Series Temperature Plot

• 📈 To compare temperatures, a time series plot is generated for San Francisco, JFK (New York), and Dallas Fort Worth.
• 💻 Instead of manual coding, Gemini is prompted to filter data and create the plot using the Elter plotting library.
• 🔍 The interactive chart allows zooming and hovering, clearly showing Dallas as the hottest and New York as the coldest in winter.

Building an Animated US Temperature Heat Map

• 🗺️ The geospatial nature of the data is leveraged to create an animated heat map of US temperatures.
• ✨ Gemini is prompted to use Plotly for animation, with specific preferences for color scale and point size.
• 🌟 The final visualization displays hundreds of thousands of data points, showing temperature evolution across the country day-by-day, which can be saved as an HTML file for sharing.

Benefits and Getting Started

• ✅ AI-First Colab enables users to create interactive tables, plots, and animated maps within minutes, without writing code.
• 🛠️ It caters to all experience levels, helping to uplevel visualization skills.
• ➡️ To start, open a Colab notebook, find the Gemini Spark icon, and begin prompting.