Question Bank: Data Handling using Pandas - II

What is the primary purpose of the Pandas library in Python?

Which of the following is a fundamental data structure in Pandas?

What function would you use to read a CSV file into a Pandas DataFrame?

Which Pandas function is used to sort a DataFrame?

In Pandas, what does the 'groupby()' function primarily accomplish?

What method would you use to fill missing values in a DataFrame?

In Pandas, how can you change the index of a DataFrame?

What is the purpose of descriptive statistics in data analysis?

Which keyword is used in Pandas to import the library?

What is a common way to export DataFrame data to a CSV file in Pandas?

If you have a DataFrame with NaN values, which method would you use to remove those rows?

Which of the following operations is NOT directly performed by Pandas?

In Pandas, which method would you use to combine two DataFrames along a row axis?

Which term describes the process of summarizing data points to get insights?

What do we call the labels we use to identify rows in a DataFrame?

When using the method groupby() in Pandas, which is NOT a typical aggregation function?

Which of the following is a feature of Pandas that facilitates data analysis?

What does the DataFrame.max() function do in Pandas?

Which of the following is not a measure of central tendency?

What method would you use to calculate the average (mean) of a numeric column in a DataFrame?

If you wanted to find the most frequently occurring value in a DataFrame column, which function would you use?

Which of the following would correctly calculate the range of a numeric column?

Which Pandas function would you use to obtain the variance of a column?

How does including the argument numeric_only=True in the max() method change its output?

If the mode of a dataset is 5 and the values are given as [1, 2, 3, 4, 5, 5, 6], what is the significance of that mode?

Which measure of central tendency divides a dataset into four equal parts?

Which function would you use to summarize counts of unique values in a DataFrame column?

What is the effect of handling missing values before statistical analysis?

In a dataset with grades out of 100, which of the following statistics would give the most precise overview of student performance?

What does the term 'Descriptive Statistics' refer to?

When calculating the median, what step must be taken if the number of observations is even?

Which operation is NOT typically part of descriptive statistics?

What function is used to sort values in a Pandas DataFrame?

By default, how does the sort_values() function order the DataFrame?

Given the DataFrame df, which code will sort the DataFrame by the column 'Maths' in descending order?

If two students have the same marks in 'Science', how can we sort them by 'Hindi' using sort_values()?

When sorting a DataFrame by multiple columns, what happens if the first column has duplicate values?

What is the default value of the 'axis' parameter in the sort_values() function?

What will be the output of df.sort_values(by='UT', ascending=True) if 'UT' contains values from 1 to 3 in a DataFrame?

Which of the following would correctly sort a DataFrame and ignore the original index?

What happens if you attempt to sort a DataFrame by a column that doesn’t exist?

To sort a DataFrame in descending order by multiple columns, which syntax is incorrect?

Which Pandas function returns a new sorted DataFrame without modifying the original?

When should the parameter 'ascending' be set to False in the sort_values() function?

What is the output if the DataFrame df is sorted by 'Scores' in ascending order containing just one row?

In the following statement, what does 'df.sort_values(by='Age', ascending=True)' do?

Which function would you use to find the maximum value in a Pandas DataFrame column?

What does the aggregate function in Pandas do?

Which of the following functions returns the count of entries in a Pandas DataFrame column?

What does the GROUP BY function in Pandas do?

If you want to calculate the mean and the sum of marks for each student in a DataFrame, which method would you use?

Which method would you use to obtain the size of each group in a DataFrame after a GROUP BY operation?

In which scenario would you use axis=1 with the aggregate function in Pandas?

What is the first step in the split-apply-combine strategy of GROUP BY in Pandas?

What is the result of df[['Maths', 'Science']].aggregate('sum', axis=1) for the provided DataFrame?

In Pandas, which method gets the data for a specific group after a GROUP BY operation?

What will be the output of executing df['Maths'].aggregate(['max', 'min'])?

Which of the following statements correctly demonstrates grouping by multiple columns in a DataFrame?

Which aggregation function would you use to obtain the variance of a DataFrame column?

If you want to calculate the sum of a column after grouping by another column, which statement is correct?

What is the default behavior of the axis parameter in Pandas aggregation functions?

Which of the following is a key benefit of using the GROUP BY function?

In the context of Pandas, what does it mean to aggregate data?

What does the method g1.first() return after a GROUP BY operation?

If we have a DataFrame df with NaN values, what will df['Maths'].aggregate('mean') return?

Which method would you use to visualize the distribution of data within each group?

What is a potential issue when using aggregate functions without understanding your data?

How can GROUP BY assist in analyzing student performance in different subjects?

When using multiple aggregation functions simultaneously, what is essential in their application?

What will happen if you try to group by a non-existent column?

If df.aggregate(['mean', 'max'], axis=1) is executed, which output can you expect?

When applying a function after group by, which type of function might be used?

Which of the following represents the correct syntax to apply multiple aggregate functions across the DataFrame?

Which of the following is NOT a method related to GROUP BY in Pandas?

In a situation where you want to group by a column and apply a transformation without reducing the DataFrame's size, which method would you use?

What is the default type of index created in a Pandas DataFrame?

Which function is used to change the index of a DataFrame to a specific column?

What happens to the current index when using reset_index() in a DataFrame?

When altering the index of a DataFrame, what does the parameter 'drop' do in set_index()?

Which of the following statements correctly alters the index of the DataFrame df to the 'Name' column?

If a DataFrame with a non-continuous index is sliced, what type of index is produced from the slice?

What is the output of df.reset_index(drop=True) if df has a non-numeric index?

When is it useful to use the function set_index()?

If a DataFrame has duplicate indices, how does it affect data operations?

To alter an index without losing the original data structure, which of the following parameters might you use in set_index()?

If a DataFrame df has a DateTime index, how can it be altered to a numeric index without dropping the existing information?

Which function in Pandas is used to reshape data into a new DataFrame?

When using the pivot_table() function, what parameter specifies how to aggregate the data?

What will the pivot function return if the index and column parameters specify a non-unique entry?

How can you handle multiple values in the pivot_table() aggregation without raising an error?

Which of the following is NOT a valid option for the aggfunc parameter in pivot_table()?

What type of index does the pivot() function create by default if not specified?

Which of the following statements correctly describes the use of the pivot_table() function?

In which scenario should you use pivot_table() instead of pivot()?

How do you create a new DataFrame with only relevant columns using the pivot() function?

What must be ensured when performing reshaping of data?

Which of the following will correctly return a pivoted DataFrame without errors?

What is the primary purpose of the melt() function in Pandas?

If you wanted to pivot a DataFrame and keep track of total profits per store per year, which structure should you use?

Which of the following functions is effective for handling missing data in a DataFrame?

What command is used to install the pymysql library in Python?

Which library is used to facilitate the connection between Pandas and MySQL?

To read data from a MySQL database into a Pandas DataFrame, which method is commonly used?

Which statement best describes exporting data from Pandas to MySQL?

What does the to_sql() function accomplish in Pandas?

What is required before importing or exporting data between Pandas and MySQL?

Which function can be used to connect to a MySQL database from a Python script?

When importing data into a DataFrame from MySQL, which SQL command is often used?

If you need to handle missing values in your DataFrame before exporting to MySQL, what could be a useful approach?

Which of the following is true when you export a DataFrame to MySQL?

What does establishing a connection to MySQL using pymysql require?

Which step is necessary after importing data into a DataFrame before any analysis?

Using to_sql() in Pandas to export a DataFrame requires which of the following?

What does NaN stand for in a Pandas DataFrame?

Which function can be used to remove rows with missing values in a DataFrame?

What parameter can be passed to the fillna function to fill missing values with the previous value?

What is one common reason for having missing values in a dataset?

When using fillna(method='bfill'), which value is used to fill NaN?

Which of the following statements about handling NaN values is FALSE?

In a DataFrame, if a student did not appear for an exam, what could be done with that missing value to calculate average scores?

What happens when both dropna() and fillna() are called on the same DataFrame at the same time?

Which method would you use to replace missing values based on the average of an entire column?

What would the statement df.isna().sum() return?

When handling missing values, why might someone choose to fill them with a constant value such as zero?

If missing values are handled poorly, what might be a consequence of this oversight?

When should you use dropna instead of fillna?

What is the recommended first step in handling missing values?