Essential libraries overview (Pandas, NumPy, Matplotlib) in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Pandas used for in data science?

Pandas is a library that helps you work with tables of data. It makes it easy to read, write, and change data in rows and columns, like a spreadsheet.

beginner

What does NumPy provide for data analysis?

NumPy gives you fast tools to work with numbers in big lists or grids. It helps with math and calculations on arrays of numbers.

beginner

What is Matplotlib used for?

Matplotlib helps you make pictures from data, like charts and graphs. It shows your data so you can understand it better.

intermediate

How do Pandas and NumPy work together?

Pandas uses NumPy behind the scenes to handle numbers quickly. Pandas adds easy ways to work with labeled data on top of NumPy's fast number tools.

beginner

Why is Matplotlib important for data science?

Matplotlib lets you turn numbers into pictures. Pictures help you see patterns and stories in data that are hard to find by just looking at numbers.

Which library is best for handling tables of data with rows and columns?

A Pandas

B NumPy

C Matplotlib

D Seaborn

Pandas is designed for working with tabular data, making it easy to manipulate rows and columns.

What does NumPy mainly provide?

A Fast numerical arrays and math functions

B Web scraping utilities

C Text processing tools

D Charts and graphs

NumPy offers fast arrays and math functions to handle numerical data efficiently.

Which library would you use to create a line chart?

A NumPy

B Pandas

C Matplotlib

D SciPy

Matplotlib is used to create visual charts like line charts.

Pandas is built on top of which library for fast number handling?

A Matplotlib

B NumPy

C SciPy

D TensorFlow

Pandas uses NumPy arrays internally for fast numerical operations.

Which library helps you understand data by turning it into pictures?

A Requests

B Pandas

C NumPy

D Matplotlib

Matplotlib creates visualizations that help interpret data.

Explain the main purpose of Pandas, NumPy, and Matplotlib in data science.

Think about what each library helps you do with data.

Describe how Pandas and NumPy work together when analyzing data.

Consider the relationship between data structure and speed.

Practice

1. Which library is mainly used to organize data in tables for easy analysis?

easy

A. Seaborn

B. NumPy

C. Matplotlib

D. Pandas

Solution

1. Step 1: Understand library purposes

   Pandas is designed to organize data in tables called DataFrames.

2. Step 2: Match library to task

   Since the question asks about organizing data in tables, Pandas fits best.

3. Final Answer:

   Pandas -> Option D

4. Quick Check:

   Tables = Pandas [OK]

Hint: Tables mean Pandas, numbers mean NumPy, charts mean Matplotlib [OK]

Common Mistakes:

• Confusing NumPy with Pandas for table data
• Thinking Matplotlib organizes data
• Choosing Seaborn which is for visualization, not tables

2. Which of the following is the correct way to import NumPy in Python?

easy

A. import matplotlib.pyplot as plt

B. import pandas as pd

C. import numpy as np

D. import numpy as pd

Solution

1. Step 1: Recall standard import conventions

   NumPy is commonly imported as 'np' to shorten code.

2. Step 2: Check each option

   import numpy as np uses 'import numpy as np' which is correct; others are for different libraries or wrong aliases.

3. Final Answer:

   import numpy as np -> Option C

4. Quick Check:

   NumPy alias = np [OK]

Hint: NumPy is always imported as np [OK]

Common Mistakes:

• Using wrong alias like pd for NumPy
• Mixing import statements of different libraries
• Forgetting 'as' keyword

3. What will be the output of this code?

import numpy as np
arr = np.array([1, 2, 3])
print(arr * 2)

medium

A. [2 4 6]

B. [1 2 3 1 2 3]

C. [3 4 5]

D. Error

Solution

1. Step 1: Understand NumPy array multiplication

   Multiplying a NumPy array by a number multiplies each element by that number.

2. Step 2: Calculate element-wise multiplication

   Each element in [1, 2, 3] multiplied by 2 gives [2, 4, 6].

3. Final Answer:

   [2 4 6] -> Option A

4. Quick Check:

   Array * 2 doubles each element [OK]

Hint: NumPy * number multiplies each element [OK]

Common Mistakes:

• Thinking * duplicates the array
• Expecting element-wise addition instead of multiplication
• Assuming syntax error

4. Find the error in this code snippet:

import matplotlib.pyplot as plt
plt.plot([1, 2, 3], [4, 5])
plt.show()

medium

A. plt.show() is missing

B. The lists have different lengths causing an error

C. Wrong import statement for matplotlib

D. No error, code runs fine

Solution

1. Step 1: Check input lists length

   Plotting requires x and y lists to have the same length.

2. Step 2: Identify mismatch

   Here, x has 3 elements, y has 2, causing a ValueError.

3. Final Answer:

   The lists have different lengths causing an error -> Option B

4. Quick Check:

   Plot lists length must match [OK]

Hint: x and y lists must be same length for plot [OK]

Common Mistakes:

• Ignoring length mismatch
• Thinking plt.show() is missing
• Assuming import is wrong

5. You have a Pandas DataFrame with a column 'Age'. Which library and method would you use to quickly calculate the average age?

hard

A. Pandas' mean() method on the 'Age' column

B. Matplotlib's plot() on the 'Age' column

C. NumPy's np.mean() on the 'Age' column

D. NumPy's array() to convert 'Age' column

Solution

1. Step 1: Identify the data structure

   The 'Age' column is part of a Pandas DataFrame.

2. Step 2: Choose the best method for average

   Pandas columns have a built-in mean() method to calculate average quickly.

3. Step 3: Compare options

   NumPy's np.mean() works but requires extra step; Matplotlib is for plotting, not calculation.

4. Final Answer:

   Pandas' mean() method on the 'Age' column -> Option A

5. Quick Check:

   DataFrame column average = mean() [OK]

Hint: Use Pandas mean() directly on DataFrame columns [OK]

Common Mistakes:

• Using Matplotlib for calculations
• Converting column unnecessarily with NumPy
• Not using built-in Pandas methods