List of top Computer Science Questions on Pandas

attribute name is used to display a NumPy ndarray having all the values in the DataFrame, without the axes labels.

__________ will display the total number of values for each column or row of a DataFrame.

Which of the following functions are used to split the data into groups based on some criteria?

Arrange the following steps to calculate the total number of values for each row of a DataFrame.
(A) Load the DataFrame as 'df'
(B) Use the df.count() method
(C) Print the result
(D) import pandas as pd
Choose the correct answer from the options given below:

Extracting a part of a series can be done through .

Match List-I with List-II

List-I	List-II
(A) pip install pandas	(I) one-dimensional array containing a sequence of values
(B) Numpy array	(II) can have different data types
(C) Pandas DataFrame	(III) requires homogeneous data
(D) Series	(IV) install Pandas library

Choose the correct answer from the options given below:

While appending two dataframes, if we want to raise error in case row labels are duplicate, we shall use which parameter of append() method?

Order the following steps to for creation of series from NumPy Arrays.
(A)

>>> import numpy as np

>>> array1 = np.array([1,2,3,4])

>>> import pandas as pd

>>> series3 = pd.Series(array1)

>>> print(series3)

Choose the correct answer from the options given below:

What will be the output of the command df.count(axis = 1)?

What does pivot_table( ) do in pandas that pivot( ) cannot?

In data handling, pandas support index values.

For the DataFrame (df) given below, which of the following are correct ways to access column 'Texas'?

A. df['Texas']
B. df('Texas')
C. df.Texas
D. df.['Texas']

What will be the output of the following code?
>>> seriesCapCntry = pd.Series(['NewDelhi', 'WashingtonDC', 'London', 'Paris'], index=['India', 'USA', 'UK', 'France'])
>>> seriesCapCntry[1:3]

Match the LIST-I with LIST-II

__________ gives the transpose of a DataFrame.

How do you select rows from a DataFrame 'df' where the 'Salary' column is greater than 50000?

Match the LIST-I with LIST-II

Given the following DataFrame df:

PNO	NAME
111	ROHAN
222	MEETA
333	SEEMA
444	SHALU
555	POONAM

Select the correct commands from the following to display the last five rows:

Given the following series ser1:

Index	Value
0	69
1	80
2	20
3	50
4	100
5	70

State the output of the following command:

print(ser1 >= 70)

Which of the following are the correct commands to delete a column from the DataFrame df1?

Which of the following is the correct command to display the top 2 records of Series \texttt{tail}?

While transferring the data from a DataFrame to a CSV file, if we do not want the column names to be saved to the file on disk, the parameter to be used in \texttt{to__csv()} is __________.

Consider the given DataFrame df4:

NAME	PERIODIC	ENG	MATHS	SCIENCE
MEENA	1	40	60	80
REENA	2	60	30	10
TEENA	3	80	60	40
SHEENA	2	90	20	70

We want the following output:

NAME	MEENAREENATEENASHEENA
PERIODIC	8
ENG	270
MATHS	170
SCIENCE	200

The process of changing the structure of a DataFrame using function pivot() is known as .............

The way a dataset is arranged into rows and columns is referred to as the shape of data. Following function is used to reshape and create a new DataFrame from the original one: