Google Colab as alternative in Data Analysis Python - Step-by-Step Execution

Concept Flow - Google Colab as alternative

Open Browser

↓

Go to colab.research.google.com

↓

Create New Notebook

↓

Write Python Code

↓

Run Code in Cloud

↓

View Output & Save to Drive

This flow shows how you open Google Colab, create a notebook, write and run Python code in the cloud, then view and save your results.

Execution Sample

Data Analysis Python

import pandas as pd

data = {'Name': ['Anna', 'Ben'], 'Age': [28, 34]}
df = pd.DataFrame(data)
df.head()

This code creates a small table with names and ages, then shows the first rows.

Execution Table

Step	Action	Code Line	Result/Output
1	Import pandas library	import pandas as pd	pandas module loaded
2	Create data dictionary	data = {'Name': ['Anna', 'Ben'], 'Age': [28, 34]}	{'Name': ['Anna', 'Ben'], 'Age': [28, 34]}
3	Create DataFrame from data	df = pd.DataFrame(data)	DataFrame with 2 rows and 2 columns created
4	Display first rows	df.head()	Name Age 0 Anna 28 1 Ben 34

💡 Code execution ends after displaying the DataFrame head.

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4
data	undefined	{'Name': ['Anna', 'Ben'], 'Age': [28, 34]}	{'Name': ['Anna', 'Ben'], 'Age': [28, 34]}	{'Name': ['Anna', 'Ben'], 'Age': [28, 34]}
df	undefined	undefined	DataFrame with 2 rows and 2 columns	Same DataFrame displayed

Key Moments - 2 Insights

Why do we not see any output after importing pandas?

Importing a library loads it but does not produce visible output, as shown in step 1 of the execution_table.

What does df.head() show and why?

df.head() shows the first few rows of the DataFrame to give a quick look at the data, as seen in step 4.

Visual Quiz - 3 Questions

Look at the execution_table at step 3, what is the value of variable df?

A A dictionary with names and ages

B A DataFrame with 2 rows and 2 columns

C Undefined

D A list of names

💡 Hint

Check the 'Result/Output' column at step 3 in execution_table.

At which step does the code display the data table output?

A Step 4

B Step 1

C Step 3

D Step 2

💡 Hint

Look for the step where df.head() is called in execution_table.

If we remove the line 'import pandas as pd', what will happen at step 3?

A DataFrame will be created successfully

B Data dictionary will be printed

C Error because pandas is not defined

D Nothing will happen

💡 Hint

Without importing pandas, pd.DataFrame cannot be used as shown in variable_tracker.

Concept Snapshot

Google Colab lets you write and run Python code in your browser.
You create notebooks online without installing anything.
Code runs on Google's cloud servers.
You can save and share notebooks easily.
Great for data analysis and learning Python.

Full Transcript

Google Colab is an online tool where you can write and run Python code without installing software. You open your browser, go to colab.research.google.com, and create a new notebook. Then you write Python code, like importing pandas and creating a table. When you run the code, it executes on Google's servers and shows the output below the code. This way, you can do data analysis easily and save your work to Google Drive.

Practice

1.

What is the main advantage of using Google Colab for data analysis?

easy

A. It requires expensive software licenses.

B. It only works with JavaScript code.

C. It allows running Python code without installing anything on your computer.

D. It can only be used offline.

Solution

1. Step 1: Understand what Google Colab offers

   Google Colab is a cloud-based tool that lets you write and run Python code online.

2. Step 2: Identify the key benefit for beginners

   Since it runs in the cloud, you don't need to install Python or any software on your computer.

3. Final Answer:

   It allows running Python code without installing anything on your computer. -> Option C

4. Quick Check:

   Cloud-based Python execution = It allows running Python code without installing anything on your computer. [OK]

Hint: Remember: Colab runs code online, no install needed [OK]

Common Mistakes:

• Thinking Colab only runs JavaScript
• Assuming Colab requires paid licenses
• Believing Colab works offline only

2.

Which of the following is the correct way to start a new Python notebook in Google Colab?

1. Open colab.research.google.com
2. Click on 'File' menu
3. Select which option?

easy

A. Open Notebook

B. New Python 3 Notebook

C. Download Notebook

D. Upload Notebook

Solution

1. Step 1: Navigate to Google Colab website

   Open the URL colab.research.google.com in your browser.

2. Step 2: Use the File menu to create a new notebook

   Under the 'File' menu, the option to start a new Python notebook is 'New Python 3 Notebook'.

3. Final Answer:

   New Python 3 Notebook -> Option B

4. Quick Check:

   New notebook creation = New Python 3 Notebook [OK]

Hint: Look for 'New Python 3 Notebook' under File menu [OK]

Common Mistakes:

• Choosing 'Open Notebook' which opens existing files
• Selecting 'Download Notebook' which saves locally
• Picking 'Upload Notebook' which uploads files

3.

What will be the output of the following code run in Google Colab?

import pandas as pd

data = {'Name': ['Anna', 'Bob'], 'Age': [28, 34]}
df = pd.DataFrame(data)
df.head()

medium

A. A list of names only.

B. An error because pandas is not installed in Colab.

C. An empty DataFrame with no rows.

D. A table showing the first two rows with columns 'Name' and 'Age'.

Solution

1. Step 1: Understand pandas DataFrame creation

   The code creates a DataFrame with two columns: 'Name' and 'Age', and two rows with data.

2. Step 2: Use df.head() to display the first rows

   Calling df.head() shows the first 5 rows, but since there are only 2 rows, it shows both.

3. Final Answer:

   A table showing the first two rows with columns 'Name' and 'Age'. -> Option D

4. Quick Check:

   DataFrame head shows data rows = A table showing the first two rows with columns 'Name' and 'Age'. [OK]

Hint: df.head() shows first rows of your DataFrame [OK]

Common Mistakes:

• Thinking pandas is not pre-installed in Colab
• Expecting an error from this simple code
• Assuming df.head() returns empty or partial data

4.

Identify the error in this Google Colab code snippet:

import matplotlib.pyplot as plt

plt.plot([1, 2, 3], [4, 5])
plt.show()

medium

A. The lists have different lengths causing a ValueError.

B. matplotlib is not supported in Google Colab.

C. plt.show() is missing parentheses.

D. No error; the plot will display correctly.

Solution

1. Step 1: Check the input lists to plt.plot()

   The x-values list has 3 elements, but the y-values list has only 2 elements.

2. Step 2: Understand matplotlib's requirement

   Both lists must be the same length to plot points; otherwise, a ValueError occurs.

3. Final Answer:

   The lists have different lengths causing a ValueError. -> Option A

4. Quick Check:

   List length mismatch = ValueError = The lists have different lengths causing a ValueError. [OK]

Hint: Check if x and y lists have same length before plotting [OK]

Common Mistakes:

• Assuming matplotlib is unsupported in Colab
• Forgetting plt.show() needs parentheses
• Thinking plot works with unequal list lengths

5.

You want to share your data analysis project with a friend who does not have Python installed. How can Google Colab help you?

hard

A. By letting you save your notebook in Google Drive and share the link.

B. By requiring your friend to install Python first.

C. By exporting the notebook only as a PDF without code.

D. By sending the raw Python files via email.

Solution

1. Step 1: Understand sharing options in Google Colab

   Colab notebooks are saved in Google Drive and can be shared via links easily.

2. Step 2: Compare with other sharing methods

   Sharing a link allows your friend to open and run the notebook online without installing Python.

3. Final Answer:

   By letting you save your notebook in Google Drive and share the link. -> Option A

4. Quick Check:

   Sharing via Drive link = By letting you save your notebook in Google Drive and share the link. [OK]

Hint: Share your notebook link from Google Drive for easy access [OK]

Common Mistakes:

• Thinking friend must install Python to run notebook
• Believing PDF export shares runnable code
• Assuming raw files emailed are easiest way