DA Data Analysis Tools and Programming

Question 1

Which Python library is primarily used for data manipulation and analysis?

Accepted Answer

Pandas

Answer

NumPy

Answer

Matplotlib

Answer

SciPy

Question 2

What does the pandas function df.describe() return?

Accepted Answer

Summary statistics (count, mean, std, min, max, percentiles) for numeric columns

Answer

The column data types

Answer

The first five rows of the DataFrame

Answer

The number of missing values per column

Question 3

In Excel, which function is used to look up a value in a table and return a corresponding value from another column?

Accepted Answer

VLOOKUP

Answer

SUMIF

Answer

COUNTIF

Answer

INDEX

Question 4

What is a pivot table used for in Excel or data analysis?

Accepted Answer

Summarizing, aggregating, and reorganizing data interactively

Answer

Generating random sample data

Answer

Writing macros for automation

Answer

Formatting cells conditionally

Question 5

What is R primarily used for in data analysis?

Accepted Answer

Statistical computing and data visualization

Answer

Web development

Answer

Database administration

Answer

Network monitoring

Question 6

What does the Python function len() return when applied to a pandas DataFrame?

Accepted Answer

Number of rows

Answer

Number of columns

Answer

Number of non-null values

Answer

Memory usage in bytes