Practice Test GeeksDA - Data Analyst Practice Test
← All DA Flashcard Decks

Data Analysis Tools and Programming Flashcards

6 cards from real DA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Data Analysis Tools and Programming flashcards as text

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

    Answer: Pandas

    Pandas provides the DataFrame structure and a rich set of functions for data cleaning, transformation, and analysis in Python.

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

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

    df.describe() generates descriptive statistics including count, mean, standard deviation, and quartile values for numeric columns.

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

    Answer: VLOOKUP

    VLOOKUP searches the first column of a range for a value and returns a result from a specified column in the same row.

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

    Answer: Summarizing, aggregating, and reorganizing data interactively

    Pivot tables let analysts quickly summarize large datasets by grouping and aggregating values across rows and columns.

  5. What is R primarily used for in data analysis?

    Answer: Statistical computing and data visualization

    R is a programming language designed for statistical analysis, data manipulation, and producing high-quality visualizations.

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

    Answer: Number of rows

    len(df) returns the number of rows in a pandas DataFrame, equivalent to df.shape[0].