Python vs R vs Excel for analysis in Data Analysis Python - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Comparing strengths of Python, R, and Excel for data analysis

Which tool is best suited for large-scale data manipulation and automation?

A Python, because it supports scripting and libraries like pandas

B R, because it has specialized statistical packages

C Excel, because it has built-in pivot tables and charts

D All three are equally good for large-scale automation

💡 Hint

Think about which tool allows writing code to automate tasks on big datasets.

Python is best for large-scale data manipulation and automation due to its powerful libraries and scripting ability.

❓ Predict Output

intermediate

Output of Python vs R style data summary

What is the output of this Python code snippet that summarizes a DataFrame?

Data Analysis Python

import pandas as pd

data = {'Age': [25, 30, 22, 40], 'Score': [88, 92, 85, 95]}
df = pd.DataFrame(data)
summary = df.describe()
print(summary.loc['mean', 'Score'])

A 88

B 90.0

C 92

D Error: 'mean' not found

💡 Hint

Look at the mean value of the 'Score' column calculated by describe().

The mean of the 'Score' column is (88 + 92 + 85 + 95) / 4 = 90.0.

❓ data_output

advanced

Result of filtering data in R vs Python

Given a dataset, which output matches filtering rows where 'Value' > 50 in Python pandas?

Data Analysis Python

import pandas as pd

data = {'ID': [1, 2, 3, 4], 'Value': [45, 55, 60, 40]}
df = pd.DataFrame(data)
filtered = df[df['Value'] > 50]
print(filtered)

A

   ID  Value
1   2     55
2   3     60

B

   ID  Value
0   1     45
3   4     40

C Error: invalid syntax

D

   ID  Value
1   2     55
3   4     40

💡 Hint

Filter rows where 'Value' is greater than 50.

Rows with 'Value' 55 and 60 meet the condition, so only those rows appear.

❓ visualization

advanced

Choosing the best tool for creating interactive dashboards

Which tool is most suitable for building interactive data dashboards for business users?

A None of these tools support interactive dashboards

B Excel, because it has slicers and pivot charts

C R, using Shiny package for interactive web apps

D Python, using libraries like Dash or Streamlit

💡 Hint

Consider which tool is designed specifically for interactive web applications.

R's Shiny package is designed for creating interactive web dashboards easily.

🚀 Application

expert

Selecting the best tool for a complex data science project

You have a project requiring advanced machine learning, data cleaning, and report generation. Which tool combination is best?

A R for machine learning and visualization, Excel for reports

B Python for machine learning and cleaning, R for visualization, Excel for final reports

C Excel alone, using formulas and charts

D Only Python for all tasks including report generation

💡 Hint

Think about using strengths of each tool for different parts of the project.

Combining Python, R, and Excel leverages their strengths: Python for ML and cleaning, R for visualization, Excel for reports.