Tip #58: Automated data analysis in Colab?


Hi Reader,

Last week, I invited you to help me test Google's Data Science Agent in Colab, which promises to automate your data analysis.

Does it live up to that promise? Let's find out! 👇


Sponsored by: Morning Brew

Business news you’ll actually enjoy

Join 4M+ professionals who start their day with Morning Brew—a free daily newsletter that makes business, tech, and finance news genuinely enjoyable to read and hard to forget. Each morning, it breaks down complex stories in plain English—cutting through the noise with sharp insights and just enough wit to keep you engaged. In under 5 minutes, you’ll be up to speed on what matters most to your career and the world around you—all before you’ve finished your morning coffee.


🔢 How to use Data Science Agent in Colab:

Before we get to the results, here's a recap of how it works:

  1. You open a blank Colab notebook.
  2. You upload a data file.
  3. You describe what analysis you want done.
  4. Gemini does the analysis for you.

The interface is a bit confusing, so I recorded a short video (no audio) to help you get started.


🎯 Does it do a good job with the analysis?

Here's what tester #1 said:

I tested it with a non-trivial statistical analysis and I should say... the results are really impressive. Implementing the same code from scratch, without an existing pipeline, it would have taken to me more than one hour (to be optimistic!!)

Tester #2:

This Data Science Agent in Colab is so powerful! I created a mock dataset for testing and asked it to calculate the cluster coherence. Then it came out with a plan and executed it. Most amazing part is that it installed the missing packages by itself when running into an error. Finally, it did answer my question (Which cluster has the smallest coherence value?) which is amazing.

Tester #3:

It was good at simple analysis but might not work great when given complex problems.

👉 Here are my takeaways:

After reviewing the Colab notebooks shared by testers and testing it myself, here's my overall conclusion:

Data Science Agent is only useful if you are able to evaluate whether the steps it takes are correct. It will come up with a plan and write the code to execute that plan, but you still need to know enough to assess:

  • Is it including all of the steps that are necessary to solve this problem?
  • Is it making reasonable assumptions?
  • Is it ignoring any relevant factors?
  • Is the code it writes in alignment with the stated goal?

As such, Data Science Agent is most useful for those who could already complete the analysis on their own, but just want help in order to execute the analysis faster.

Thus if you use Data Science Agent without sufficient expertise, you run the risk of performing a misleading (or incorrect) analysis!


See you Friday! 👋

If you enjoyed this week's tip, please considering sharing it with a friend!

I'll be back in your inbox on Friday to share the top AI news of the week.

- Kevin

P.S. My favorite AI-generated video so far 😂

Learn Artificial Intelligence from Data School 🤖

Join 25,000+ intelligent readers and receive AI tips every Tuesday!

Read more from Learn Artificial Intelligence from Data School 🤖

Hi Reader, Today I'm trying something brand new! I wrote short summaries of the 5 most important AI stories this week, and also turned it into a video: Watch the video I'd love to know what you think! 💬 AI-generated TV ad airs during NBA finals Prediction market Kalshi just aired this AI-generated ad on network TV during the NBA finals. It was created in just two days by one person using Google's new Veo 3 video model, plus scripting help from Google's Gemini chatbot. Expect to see many more...

Hi Reader, Thanks for sticking with me through last week’s course launch! 🙏 As you may have noticed, Tuesday Tips has been on pause for a few months. I was focused on launching the course, plus I’ve been working on a book 🤫 I can’t promise a new tip every Tuesday, but I’ll do my best to provide you with valuable content as time permits. As for today’s tip, I’m trying out something new… 👇 Sponsored by: Superhuman AI Find out why 1M+ professionals read Superhuman AI daily. AI won't take over...

Hi Reader, This week, I've got a short tip about AI agents, followed by some Data School news... 👉 Tip #56: What are AI agents? Google is calling 2025 "the agentic era," DeepLearning.AI says "the agentic era is upon us," and NVIDIA's founder says "one of the most important things happening in the world of enterprise is agentic AI." Clearly AI agents are a big deal, but what exactly are they? Simply put, an AI agent is an application that uses a Large Language Model (LLM) to control its...