Google Colab as alternative in Data Analysis Python - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import pandas in Google Colab.

Data Analysis Python

import [1] as pd

Drag options to blanks, or click blank then click option'

Amatplotlib

Bpandas

Cnumpy

Dseaborn

Attempts:

3 left

💡 Hint

Common Mistakes

Importing numpy instead of pandas.

Using wrong alias like 'pn' instead of 'pd'.

We use import pandas as pd to work with data tables in Python.

2fill in blank

medium

Complete the code to read a CSV file in Google Colab.

Data Analysis Python

df = pd.read_csv('[1]')

Drag options to blanks, or click blank then click option'

A/mnt/data/data.csv

Bdata.csv

Chttps://drive.google.com/file/d/FILE_ID/view?usp=sharing

D/content/sample_data/data.csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using only filename without path.

Using Google Drive share URL directly.

In Colab, files in the sample_data folder can be accessed with /content/sample_data/filename.

3fill in blank

hard

Fix the error in the code to mount Google Drive in Colab.

Data Analysis Python

from google.colab import [1]
[1].mount('/content/drive')

Drag options to blanks, or click blank then click option'

Astorage

Bfiles

Cdrive

Dauth

Attempts:

3 left

💡 Hint

Common Mistakes

Importing wrong module like files or auth.

Forgetting to mount after import.

The drive module from google.colab is used to mount Google Drive.

4fill in blank

hard

Fill both blanks to list files in the mounted Google Drive folder.

Data Analysis Python

import os
files = os.[1]('[2]')
print(files)

Drag options to blanks, or click blank then click option'

Alistdir

Bwalk

C/content/drive/MyDrive

D/content/sample_data

Attempts:

3 left

💡 Hint

Common Mistakes

Using os.walk which returns a generator, not a list.

Using wrong path like sample_data instead of MyDrive.

os.listdir lists files in a directory. The path to Google Drive is /content/drive/MyDrive.

5fill in blank

hard

Fill all three blanks to save a DataFrame to Google Drive in CSV format.

Data Analysis Python

df.[1]('[2]/[3].csv', index=False)

Drag options to blanks, or click blank then click option'

Ato_csv

B/content/drive/MyDrive

Cmy_data

Dread_csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using read_csv instead of to_csv.

Saving to wrong folder path.

Use to_csv to save DataFrame. The path is Google Drive folder plus filename.

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