NEW
Font size
WorksheetsPandas MCQ Quiz
Total questions: 30
Worksheet time: 15mins
What is Pandas in Python?
A data manipulation library
A machine learning library
A web development library
A game development library
Which function is used to create a DataFrame in Pandas?
DataFrame()
array()
series()
list()
Which of the following is not a data structure provided by Pandas?
DataFrame
Series
Panel
Tensor
What method is used to remove duplicate values in a DataFrame?
remove_duplicates()
drop_duplicates()
delete_duplicates()
eliminate_duplicates()
Which function reads a CSV file into a Pandas DataFrame?
read.csv()
read_txt()
read_csv()
csv_read()
What is the default axis value in the 'drop()' method in Pandas?
axis=0
axis=1
axis=2
axis=None
How can you calculate the mean of each column in a DataFrame?
mean(axis=0)
mean(axis=1)
avg(axis=0)
average(axis=1)
Which method is used to fill missing values in Pandas?
fillna()
fill()
nanfill()
replace_na()
How can you concatenate two DataFrames vertically?
concat(axis=0)
concat(axis=1)
merge(axis=0)
join()
Which of the following methods sorts a DataFrame by a column?
sort_values()
sort_by_column()
order_by()
arrange()
What method is used to get the first n rows of a DataFrame?
first(n)
head(n)
top(n)
show(n)
Which method is used to reset the index of a DataFrame?
reset_index()
restart_index()
index_reset()
index_restart()
How can you access a group of rows and columns using labels?
loc
iloc
index
row_col
Which function can merge two DataFrames?
join()
append()
merge()
concatenate()
How can you convert a DataFrame to a NumPy array?
to_numpy()
toarray()
asarray()
to_matrix()
Which method returns the shape of a DataFrame?
shape()
df_shape()
get_shape()
size()
How can you create a copy of a DataFrame?
copy()
deepcopy()
clone()
make_copy()
What method checks for any missing values in a DataFrame?
isnull()
hasnull()
find_null()
check_na()
Which Pandas data structure is one-dimensional?
Series
DataFrame
Panel
Matrix
Which method changes column names in a DataFrame?
rename()
change_column_name()
set_column_name()
update_names()
How can you apply a function to each element in a DataFrame?
applymap()
map()
apply()
transform()
What method returns the index of the maximum value?
idxmax()
max_index()
find_max()
max_idx()
Which Pandas function reads data from an Excel file?
read_excel()
load_excel()
open_excel()
excel_read()
How do you display basic statistics of a DataFrame?
describe()
summary()
stats()
details()
How can you drop rows with missing values?
dropna()
dropnull()
removena()
cleanna()
What is the default join type in Pandas merge?
Inner
Outer
Left
Right
How can you group data by one or more columns?
groupby()
group_data()
bygroup()
aggregate()
Which function is used to add a new column to a DataFrame?
assign()
append()
add_column()
insert_column()
What method converts a Series to a list?
to_list()
listify()
aslist()
series_to_list()
How can you filter rows based on a condition?
query()
filter()
select()
where()
