Below are the 50 most important Python Pandas mcqs for online exams and the company interviews. These Pandas multiple choice questions can be asked for various programming test taken by the various companies like Infosys, TCS, Accenture, Capgemini, etc. and lot of others. Pandas mcq are also useful for class 12 pandas. These questions include pandas dataframe mcq, pandas series mcq and pandas fundamental mcq questions. We are also planning to provide you pandas mcq pdf for download.
Q.1. Which of the following are modules/libraries in Python?
a. NumPy
b. Pandas
c. Matplotlib
d. All of the above
Show Answer
Q.2. NumPy stands for ____
a. Number Python
b. Numerical Python
c. Numbers in Python
d. None of the above
Show Answer
Q.3. Which of the following libraries allows to manipulate, transform and visualize data easily and efficiently.
a. Pandas
b. NumPy
c. Matplotlib
d. All of the above
Show Answer
Q.4. PANDAS stands for _____________
a. Panel Data Analysis
b. Panel Data analyst
c. Panel Data
d. Panel Dashboard
Show Answer
Q.5. __________ is an important library used for analyzing data.
a. Math
b. Random
c. Pandas
d. None of the above
Show Answer
Q.6. Important data structure of pandas is/are ___________
a. Series
b. DataFrame
c. Both of the above
d. None of the above
Show Answer
Q.7. Which of the following library in Python is used for plotting graphs and visualization.
a. Pandas
b. NumPy
c. Matplotlib
d. None of the above
Show Answer
Q.8. Pandas Series can have _________________ data types
a. float
b. integer
c. String
d. All of the above
Show Answer
Q.9. _________ is used when data is in Tabular Format.
a. NumPy
b. Pandas
c. Matplotlib
d. All of the above
Show Answer
Q.10. Which of the following command is used to install pandas?
a. pip install pandas
b. install pandas
c. pip pandas
d. None of the above
Show Answer
Q.10. Which of the following command is used to import pandas?
a. import pandas as pd
b. import pandas
c. from pandas import *
d. All of above
Show Answer
Q.12. A _______________ is a one-dimensional array.
a. Data Frame
b. Series
c. Both of the above
d. None of the above
Show Answer
Q.13. Which of the following statement is wrong?
a. We can create Series from Dictionary in Python.
b. Keys of dictionary become index of the series.
c. Order of indexes created from Keys may not be in the same order as typed in dictionary.
d. All are correct
Show Answer
Q.14. A Series by default have numeric data labels starting from ______________.
a. 3
b. 2
c. 1
d. 0
Answer
Show Answer
Q.15. The data label associated with a particular value of Series is called its ______________
a. Data value
b. Index
c. Value
d. None of the above
Show Answer
Q.16. Which of the following module is to be imported to create Series?
a. NumPy
b. Pandas
c. Matplotlib
d. None of the above
Show Answer
Q.17. Which of the following function/method help to create Series?
a. series( )
b. Series( )
c. createSeries( )
d. None of the above
Show Answer
Q.18. Write the output of the following :
>>> import pandas as pd
>>> series1 = pd.Series([10,20,30])
>>> print(series1)
a.
Output:
0 10
1 20
2 30
dtype: int64
b.
Output:
10
20
30
dtype: int64
c.
Output:
0
1
2
dtype: int64
d. None of the above
Show Answer
a.
0 10
1 20
2 30
dtype: int64
Q.19. When you print/display any series then the left most column is showing _________ value.
a. Index
b. Data
c. Value
d. None of the above
Show Answer
Q.20. How many values will be there in array1, if given code is not returning any error?
>>> series4 = pd.Series(array1, index = [“Jan”, “Feb”, “Mar”, “Apr”])
a. 1
b. 2
c. 3
d. 4
Answer
Show Answer
Pandas Series mcq questions and answers
Q.21. Which of the following statement will create an empty series named “S1”?
a. S1 = pd.Series(None)
b. S1 = pd.Series( )
c. Both of the above
d. None of the above
Show Answer
Q.22. How many elements will be there in the series named “S1”?
>>> S1 = pd.Series(range(5))
>>> print(S1)
a. 5
b. 4
c. 6
d. None of the above
Show Answer
Q.23. When we create a series from dictionary then the keys of dictionary become ________________
a. Index of the series
b. Value of the series
c. Caption of the series
d. None of the series
Show Answer
Q.24. Write the output of the following :
>>> S1=pd.Series(14, index = [‘a’, ‘b’, ‘c’])
>>> print(S1)
a.
a 14
b 14
c 14
dtype: int64
b.
a 14
dtype: int64
c. Error
d. None of the above
Show Answer
a.
a 14
b 14
c 14
dtype: int64
Q.25. Write the output of the following:
>>> S1=pd.Series(14, 7, index = [‘a’, ‘b’, ‘c’])
>>> print(S1)
a.
a 14
b 7
c 7
dtype: int64
b.
a 14
b 7
dtype: int64
c. Error
d. None of the above
Show Answer
Q.26. Write the output of the following :
>>> S1=pd.Series([14, 7, 9] ,index = range(1, 8, 3))
>>> print(S1)
a.
14 1
7 4
9 7
dtype: int64
b.
1 14
4 7
7 9
dtype: int64
c. Error
d. None of the above
Show Answer
b.
1 14
4 7
7 9
dtype: int64
Q.27. Which of the following code will generate the following output?
Jan 31
Feb 28
Mar 31
dtype: int64
a.
import pandas as pd
S1 = pd.Series(data = [31,28,31], index=[“Jan”,”Feb”,”Mar”])
print(S1)
b.
import pandas as pd
S1 = pd.Series([31,28,31], index=[“Jan”,”Feb”,”Mar”])
print(S1)
c. Both of the above
d. None of the above
Show Answer
Q.28. Write the output of the following:
import pandas as pd
S1 = pd.Series(data = range(31, 2, -6), index = [x for x in “aeiou” ])
print(S1)
a.
a 31
e 25
i 19
o 13
u 7
dtype: int64
b.
a 31
e 25
i 19
o 13
dtype: int64
c. Error
d. None of the above
Show Answer
a.
a 31
e 25
i 19
o 13
u 7
dtype: int64
Q.29. What type of error is returned by following code?
import pandas as pd
S1 = pd.Series(data = (31, 2, -6), index = [7, 9, 3, 2])
print(S1)
a. SyntaxError
b. IndexError
c. ValueError
d. None of the above
Show Answer
Q.30. Write the output of the following :
import pandas as pd
S1 = pd.Series(data = 2*(31, 2, -6))
print(S1)
a.
0 31
1 2
2 -6
dtype: int64
b.
0 31
1 2
2 -6
3 31
4 2
dtype: int64
c.
0 31
1 2
2 -6
3 31
dtype: int64
d.
0 31
1 2
2 -6
3 31
4 2
5 -6
dtype: int64
Show Answer
Show Answer
d.
0 31
1 2
2 -6
3 31
4 2
5 -6
dtype: int64
Q.31. Pandas is an open-source _______ Library?
A. Ruby
B. Javascript
C. Java
D. Python
Show Answer
Q.32. Pandas key data structure is called?
A. Keyframe
B. DataFrame
C. Statistics
D. Econometrics
Show Answer
Q.33. In pandas, Index values must be?
A. unique
B. hashable
C. Both A and B
D. None of the above
Show Answer
Q.34. Which of the following is correct Features of DataFrame?
A. Potentially columns are of different types
B. Can Perform Arithmetic operations on rows and columns
C. Labeled axes (rows and columns)
D. All of the above
Show Answer
Q.35. A panel is a ___ container of data
A. 1D
B. 2D
C. 3D
D. Infinite
Show Answer
Q.36. Which of the following is true?
A. If data is an ndarray, index must be the same length as data.
B. Series is a one-dimensional labeled array capable of holding any data type.
C. Both A and B
D. None of the above
Show Answer
Q.37. Which of the following takes a dict of dicts or a dict of array-like sequences and returns a DataFrame?
A. DataFrame.from_items
B. DataFrame.from_records
C. DataFrame.from_dict
D. All of the above
Show Answer
Q.38. Which of the following makes use of pandas and returns data in a series or dataFrame?
A. pandaSDMX
B. freedapi
C. OutPy
D. Inpy
swer
Show Answer
Q.39. What will be output for the following code?
import pandas as pd
import numpy as np
s = pd.Series(np.random.randn(4))
print(s.ndim)
A. 0
B. 1
C. 2
D. 3
Answer
Show Answer
Q.40. Which of the following indexing capabilities is used as a concise means of selecting data from a pandas object?
A. In
B. ix
C. ipy
D. iy
Answer
Show Answer
Q.41. Python pandas was developed by?
A. Guido van Rossum
B. Travis Oliphant
C. Wes McKinney
D. Brendan Eich
Show Answer
Q.42. What will be output for the following code?
import pandas as pd
s = pd.Series([1,2,3,4,5],index = [‘a’,’b’,’c’,’d’,’e’])
print(s[‘a’])
A. 1
B. 2
C. 3
D. 4
Answer
Show Answer
Q.43. What will be correct syntax for pandas series?
A. pandas_Series( data, index, dtype, copy)
B. pandas.Series( data, index, dtype)
C. pandas.Series( data, index, dtype, copy)
D. pandas_Series( data, index, dtype)
Show Answer
pandas.Series( data, index, dtype, copy)
Q.44. What will be syntax for pandas dataframe?
A. pandas.DataFrame( data, index, dtype, copy)
B. pandas.DataFrame( data, index, rows, dtype, copy)
C. pandas_DataFrame( data, index, columns, dtype, copy)
D. pandas.DataFrame( data, index, columns, dtype, copy)
Show Answer
pandas.DataFrame( data, index, columns, dtype, copy)
Q.45. Axis 1, in panel represent?
A. minor_axis
B. major_axis
C. items
D. None of the above
Show Answer
Q.46. Which of the following thing can be data in Pandas?
A. a python dict
B. an ndarray
C. a scalar value
D. All of the above
Show Answer
Q.47. The ________ project builds on top of pandas and matplotlib to provide easy plotting of data.
A. yhat
B. Seaborn
C. Vincent
D. Pychart
Show Answer
Q.48. Why ndim is used?
A. Returns the number of elements in the underlying data.
B. Returns the Series as ndarray.
C. Returns the number of dimensions of the underlying data, by definition 1.
D. Returns a list of the axis labels
Show Answer
Returns the number of dimensions of the underlying data, by definition 1.
Q.49. What will be output for the following code?
import pandas as pd
import numpy as np
s = pd.Series(np.random.randn(2))
print(s.size)
A. 0
B. 1
C. 2
D. 3
Show Answer
Q.50. Which of the following is false?
A. The integer format tracks only the locations and sizes of blocks of data.
B. Pandas follow the NumPy convention of raising an error when you try to convert something to a bool.
C. Two kinds of SparseIndex are implemented
D. The integer format keeps an arrays of all of the locations where the data are not equal to the fill value
Show Answer
The integer format tracks only the locations and sizes of blocks of data.