Section 1
[A] MULTIPLE CHOICE QUESTIONS
In pandas which method is used to calculate mean, median and other summary statistics for numerical data in columns?(A) sort_values()(B) melt 0(C) describe ()(C) pivot_table 0
Which of the following method calculates the quantile of the values in a given axis?(A) quan 0(B) quantile()(C) qu 0(D) $\mathrm{q} 0$
What is the primary function of pivot_table() function?(A) Group data(B) Sort data(C) Reshape data(D) Aggregate data
In Python the method used to fill missing values in a dataframe with specified values or filling method is:(A) melt()(B) drop_duplicates()(C) dropna()(D) fillna()
In Pandas missing data is represented by:(A) None(B) $\mathrm{NaN}$(C) Both (A) and (B)(D) Fillna
In Python the method used to calculate the mode of numerical column in a dataframe is :(A) $\operatorname{sum}(0$(B) mode()(C) median()(D) average ()[AI
What is the primary purpose of groupby method when working with categorical data in pandas?(A) Sorting data(B) Filtering data(C) Reshaping data(D) Grouping and aggregating data
The method which provides the total of numerical values in a column in a dataframe is:(A) total()(B) describe()(C) $\operatorname{sum}()$(D) None of these
Which of the following is not a function for descriptive statistics in pandas?(A) med()(B) variance()(C) std()(D) $\operatorname{agg}()$(AI)
The $\qquad$ method is used to calculate variance of values in a numerical column of a dataframe.(A) mean()(B) sum 0(C) $\operatorname{var}()$(D) median()
The $\qquad$ parameter is used to specify the column on which to sort the data of a dataframe.(A) order(B) by(C) column(D) field
Which method is used to change the labels of rows and columns in DataFrame?(A) change ()(B) rename 0(C) replace 0(D) None
Which of the following functions are used in pivoting?(A) pivot()(B) pivot_table()(C) Both (A) and (B)(D) pivot_data()
Which function in the pandas library is used to execute a SQL query and return the query's results?(A) read_sql()(B) read_table()(C) read_data()(D) None of these
$\qquad$ method can be used to store data of a dataframe to a SQL database.(A) write_sql()(B) to $s q l()$(C) store_data()(D) Both (A) and (B)
The statement to install the Python connector to connect MySQL is :(A) pip install mysql(B) pip install pymysql(C) pip install mysql-connector-python(D) Both (B) and (C)
The $\qquad$ statement is often used with aggregate functions COUNT() , MAX (),MIN() ,SUM(),AVG() to group the result-set by one or more columns.(A) groupby(B) GROUP DATA(C) DESCRIBE(D) None of these
Which of the following returns the Mode from a set of values from a pandas data structure?(A) mode()(B) $\min ()$(C) median()(D) mean()
The function used to remove an index in a pandas dataframe is :(A) drop_index()(B) reset_index()(C) change_index()(D) Both (A) and (B)
The default axis for quantile() function is:(A) row(B) column(C) heading(D) None of these