Python vs R vs Excel for analysis in Data Analysis Python - Hands-On Comparison

Python vs R vs Excel for analysis

📖 Scenario: You work in a small business that tracks sales data. You want to understand how to use Python, R, and Excel to analyze this data and find the best tool for your needs.

🎯 Goal: Build simple data analysis examples in Python, R, and Excel to compare how each tool handles data setup, filtering, and summarizing.

📋 What You'll Learn

Create a sales data dictionary in Python

Set a sales threshold variable

Filter sales above the threshold using a dictionary comprehension

Print the filtered sales dictionary

💡 Why This Matters

🌍 Real World

Businesses often need to analyze sales data to find top-performing months or products. Knowing how to filter data quickly helps make better decisions.

💼 Career

Data analysts and business users use Python, R, or Excel to clean and analyze data. Understanding these tools helps pick the right one for the task.

1

DATA SETUP: Create sales data dictionary

Create a dictionary called sales with these exact entries: 'January': 1500, 'February': 1800, 'March': 1200, 'April': 2200, 'May': 1700

Data Analysis Python

# Create the sales dictionary with exact month and sales values
# Your code here

Hint

Use curly braces to create a dictionary with month names as keys and sales numbers as values.

2

CONFIGURATION: Set sales threshold

Create a variable called threshold and set it to 1600

Data Analysis Python

sales = {'January': 1500, 'February': 1800, 'March': 1200, 'April': 2200, 'May': 1700}
# Set the sales threshold to 1600
# Your code here

Hint

Just assign the number 1600 to the variable named threshold.

3

CORE LOGIC: Filter sales above threshold

Use a dictionary comprehension to create a new dictionary called high_sales that contains only the months and sales from sales where the sales value is greater than threshold

Data Analysis Python

sales = {'January': 1500, 'February': 1800, 'March': 1200, 'April': 2200, 'May': 1700}
threshold = 1600
# Create high_sales dictionary with months having sales > threshold
# Your code here

Hint

Use dictionary comprehension syntax: {key: value for key, value in dict.items() if condition}

4

OUTPUT: Print filtered sales

Print the high_sales dictionary

Data Analysis Python

sales = {'January': 1500, 'February': 1800, 'March': 1200, 'April': 2200, 'May': 1700}
threshold = 1600
high_sales = {month: amount for month, amount in sales.items() if amount > threshold}
# Print the high_sales dictionary
# Your code here

Hint

Use print(high_sales) to show the filtered dictionary.

Practice

1. Which tool is best suited for quick, visual data analysis without coding?

easy

A. Python

B. Excel

C. R

D. SQL

Solution

1. Step 1: Understand tool strengths

   Excel is designed for easy, visual data work with minimal coding.

2. Step 2: Compare with other tools

   Python and R require coding and are better for complex or large data tasks.

3. Final Answer:

   Excel -> Option B

4. Quick Check:

   Visual, no-code analysis = Excel [OK]

Hint: Visual and simple? Choose Excel [OK]

Common Mistakes:

• Confusing Python's power with ease of use
• Thinking R is for simple visuals
• Assuming SQL is for visual analysis

2. Which of the following is the correct way to import a CSV file in Python using pandas?

easy

A. import pandas as pd\ndf = pd.read_csv('file.csv')

B. read.csv('file.csv')

C. import csv.read('file.csv')

D. load('file.csv')

Solution

1. Step 1: Recall pandas import syntax

   Python uses 'import pandas as pd' to import pandas library.

2. Step 2: Use correct function to read CSV

   'pd.read_csv()' is the correct function to load CSV files into a DataFrame.

3. Final Answer:

   import pandas as pd\ndf = pd.read_csv('file.csv') -> Option A

4. Quick Check:

   pandas CSV import = pd.read_csv() [OK]

Hint: Use pd.read_csv() to load CSV in Python [OK]

Common Mistakes:

• Using 'import csv.read()' which is invalid
• Confusing R syntax 'read.csv()' with Python
• Using 'load()' which is not a pandas function

3. What will be the output of this Python code snippet?

import pandas as pd\ndata = {'A': [1, 2], 'B': [3, 4]}\ndf = pd.DataFrame(data)\nprint(df.describe())

medium

A. Prints the original DataFrame without statistics

B. Error because describe() is not a pandas function

C. Summary statistics including count, mean, std, min, max for columns A and B

D. Only prints the column names

Solution

1. Step 1: Understand pandas describe()

   The describe() method returns summary statistics for numeric columns.

2. Step 2: Check DataFrame content

   DataFrame has columns A and B with numeric values, so describe() will show count, mean, std, min, max, etc.

3. Final Answer:

   Summary statistics including count, mean, std, min, max for columns A and B -> Option C

4. Quick Check:

   df.describe() = summary stats [OK]

Hint: df.describe() shows stats summary [OK]

Common Mistakes:

• Thinking describe() prints raw data
• Assuming describe() causes error
• Expecting only column names output

4. Identify the error in this R code snippet for reading a CSV file:

data <- read.csv('data.csv')

medium

A. The code is correct and will run without error.

B. The function name should be 'read_csv' instead of 'read.csv'.

C. The file path must be absolute, not relative.

D. The assignment operator should be '=' not '<-'.

Solution

1. Step 1: Check R assignment syntax

   In R, '<-' is the standard assignment operator and is correct here.

2. Step 2: Verify function name and file path

   'read.csv' is the correct function to read CSV files in R, and relative paths are allowed.

3. Final Answer:

   The code is correct and will run without error. -> Option A

4. Quick Check:

   R read.csv with <- is valid [OK]

Hint: R uses '<-' for assignment and read.csv() for CSV [OK]

Common Mistakes:

• Confusing R assignment with '='
• Thinking read_csv is R base function
• Assuming relative paths cause error

5. You have a large dataset with millions of rows and want to perform complex statistical modeling. Which tool is best and why?

hard

A. SQL, because it can store data but not perform modeling

B. Excel, because it is easy to use for large datasets

C. R, because it specializes in deep statistical analysis

D. Python, because it handles big data and has many libraries for modeling

Solution

1. Step 1: Consider dataset size and tool capability

   Excel struggles with millions of rows; SQL stores data but lacks modeling tools.

2. Step 2: Compare Python and R for modeling and big data

   Python is powerful for big data and has extensive libraries for complex modeling; R is strong in statistics but less scalable for very large data.

3. Final Answer:

   Python, because it handles big data and has many libraries for modeling -> Option D

4. Quick Check:

   Big data + modeling = Python [OK]

Hint: Big data and modeling? Pick Python [OK]

Common Mistakes:

• Choosing Excel for big data
• Picking R without considering data size
• Confusing SQL as modeling tool