List of top Computer Science Questions on Data Handling using Pandas

With reference to the parameter header of pd.read_csv(), which of the parameter values allow the column names to be inferred from the first line of csv file?
A. header = 1
B. header = 0
C. header = True
D. header = False

Which function is used to sort a Pandas DataFrame in descending order based on a column?

Arrange the steps required to read data from a MySQL database to a DataFrame:
A. pip install pymysql
B. pip install sqlalchemy
C. pandas.read_sql_query(query, sql_conn)
D. engine=create_engine('driver://username:password@host/name_of_database', index=false)

__________ method can also be used to change the data values of a row to a particular value.

Arrange the following statements to create a series from a dictionary.
(A) Print the series
(B) Import the pandas library
(C) Create the series
(D) Create a dictionary

The plot function of pandas matplotlib uses 'kind' argument which can accept a string indicating the type of graph to be plotted. Which of the following are valid plots?

Given the following code for histogram:

df.plot(kind='hist', edgecolor="Green", linewidth=2, linestyle='-', fill=False, hatch='o')

What is the role of fill=False?

Match List I with List II

LIST I	LIST II
A. DataFrame.std()	IV. Standard Deviation
B. DataFrame.describe()	III. Descriptive statistical values
C. DataFrame.var()	I. Variance
D. DataFrame.mode()	II. Value that appears most