List of top Computer Science Questions on Pandas

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: