26. What will be the output of the given code?
import pandas as pd
s = pd.Series([1, 2, 3, 4, 5],
index=['akram', 'brijesh', 'charu', 'deepika', 'era'])
print(s['charu'])
a) 1
b) 2
c) 3
d) 4
27. Assuming the given series, named stud, which command will be used to print 5 as output?
| Amit |
90 |
| Ramesh |
100 |
| Mahesh |
50 |
| john |
67 |
| Abdul |
89 |
Name: Student, dtype: int64
a) stud.index
b) stud.length
c) stud.values
d) stud.size
28. A social science teacher wants to use a pandas series to teach about Indian historical monuments and its states. The series should have the monument names as values and state names as indexes which are stored in the given lists, as shown in the code. Choose the statement which will create the series:
import pandas as pd
Monument = ['Qutub Minar', 'Gateway of India', 'Red Fort', 'Taj Mahal']
State = ['Delhi', 'Maharashtra', 'Delhi', 'Uttar Pradesh']
a) S=df.Series(Monument,index=State)
b) S=pd.Series(State,Monument)
c) S=pd.Series(Monument,index=State)
d) S=pd.series(Monument,index=State)
29. ________ is a cybercrime in which a target or targets are contacted by email, telephone or text message by someone posing as a legitimate institution to lure individuals into providing sensitive data such as personally identifiable information, banking and credit card details, and passwords.
a) Plagiarism
b) Phishing
c) Cyberstalking
d) Hacking
30. Observe the following figure. Identify the coding for obtaining this as output.
a) import matplotlib.pyplot as plt
plt.plot([1,2],[4,5])
plt.show()
b) import matplotlib.pyplot as plt
plt.plot([1,2,3],[4,5,1])
plt.show()
c) import matplotlib.pyplot as plt
plt.plot([2,3],[5,1])
plt.show()
d) import matplotlib.pyplot as plt
plt.plot([1,3],[4,1])
plt.show()
31. Read the statements given below and identify the right option to draw a histogram.
Statement A: To make a Histogram with Matplotlib, we can use the plt.hist() function.
Statement B: The bin parameter is compulsory to create histogram.
a) Statement A is correct
b) Statement B is correct
c) Statement A is correct, but Statement B is incorrect
d) Statement A is incorrect, but Statement B is correct
32. Which graph should be used where each column represents a range of values, and the height of a column corresponds to how many values are in that range?
a) plot
b) line
c) bar
d) histogram
33. Suhhani is confused about the free operating system available in the market. Few of her friends suggested a few operating systems. Help her in choosing free operating system for her device:
a) Ubuntu
b) Windows
c) Mozilla Firefox
d) Blender
34. Consider the following statements with reference to the use of email:
Statement 1: Sending threatening messages to a classmate.
Statement 2: Inviting friends to participate in a school club or sports activity.
Statement 3: Asking your teacher for help on homework.
Statement 4: Responding to or forwarding spam emails.
Which of the above statements refer to appropriate use of email?
a) Statements 1 and 2
b) Statements 2 and 3
c) Statements 3 and 4
d) Statements 2 and 4
35. Consider the following series named animal:
| L |
Lion |
| B |
Bear |
| E |
Elephant |
| T |
Tiger |
| W |
Wolf |
dtype: object
Write the output of the command:
print(animal[::-3])
a)
b)
c)
d)
36. Saharsh is a student of class -9 and he is a very frequent user of internet applications. One day he got an unpleasant message on his instant messenger. What do you think he should do?
a) ignore it and start chatting to someone else
b) reply back to them and find out what their problem is
c) shut down the computer and hope they'll leave him alone in future
d) go to his parents, teacher, or other trusted adult and let them know that he feels uncomfortable
37. What is a correct syntax to return the values of first row of a Pandas DataFrame? Assuming the name of the DataFrame is dfRent.
a) dfRent[0]
b) dfRent.loc[1]
c) dfRent.loc[0]
d) dfRent.iloc[1]
38. Feasible method(s) to manage e-waste:
a) Reduce
b) Reuse
c) Recycle
d) All of the above
39. Difference between loc() and iloc():
a) Both are Label indexed based functions
b) Both are Integer position-based functions
c) loc() is label based function and iloc() integer position based function
d) loc() is integer position based function and iloc() index position based function
40. Write the output of the given program:
import pandas as pd
S1 = pd.Series([5, 6, 7, 8, 10], index=['v', 'w', 'x', 'y', 'z'])
l = [2, 6, 1, 4, 6]
S2 = pd.Series(l, index=['z', 'y', 'a', 'w', 'v'])
print(S1 - S2)
a)
| a |
0 |
| v |
-1.0 |
| w |
2.0 |
| x |
NaN |
| y |
2.0 |
| z |
8.0 |
dtype: float64
b)
| a |
NaN |
| v |
-1.0 |
| w |
2.0 |
| x |
NaN |
| y |
2.0 |
| z |
8.0 |
dtype: float64
c)
d)
| a |
NaN |
| v |
-1.0 |
| w |
2.0 |
| x |
3.0 |
| y |
2.0 |
| z |
8.0 |
dtype: float64
41. We should exhibit proper manners and etiquettes while being online.
Choose the right net etiquette(s) from the following:
a) Avoid Cyber Bullying
b) Respect Other’s Privacy
c) No Copyright violation
d) All of the above
42. Which command will be used to delete 3 and 5 rows of the data frame. Assuming the data frame name as DF.
a) DF.drop([2,4],axis=0)
b) DF.drop([2,4],axis=1)
c) DF.drop([3,5],axis=1)
d) DF.drop([3,5])
43. Write the output of the given command:
import pandas as pd
s = pd.Series([1, 2, 3, 4, 5, 6],
index=['A', 'B', 'C', 'D', 'E', 'F'])
print(s[s % 2 == 0])
a)
b)
c)
d)
44. Ritika is a new learner for the python pandas, and she is aware of some concepts of python. She has created some lists, but is unable to create the data frame from the same. Help her by identifying the statement which will create the data frame.
import pandas as pd
Name = ['Manpreet', 'Kavil', 'Manu', 'Ria']
Phy = [70, 60, 76, 89]
Chem = [30, 70, 50, 65]
a) df=pd.DataFrame({"Name":Name,"Phy":Phy,"Chem":Chem})
b) d=("Name":Name,"Phy":Phy,"Chem":Chem) df=pd.DataFrame(d)
c) df=pd.DataFrame([Name,Phy,Chem],columns=['Name',"Phy","Chem","Total"])
d) df=pd.DataFrame({Name:"Name", Phy :"Phy",Chem: "Chem"})
45. Linux, MySQL and Mozilla Firefox software come under _______ category.
a) Proprietary
b) FOSS
c) Freeware
d) Shareware
46. Assuming the given structure, which command will give us the given output:
| |
Flight No |
Airline |
Passenger |
| 0 |
1 |
Indigo |
230000 |
| 1 |
2 |
SpiceJet |
12000 |
| 2 |
3 |
Indian Airlines |
240000 |
| 3 |
4 |
Lufthansa |
245000 |
| 4 |
5 |
Air Asia |
210000 |
Output Required: (3,5)
a) print(df.shape())
b) print(df.shape)
c) print(df.size)
d) print(df.size())
47. Write the output of the given command:
df1.loc[:0,'Sal']
Consider the given dataframe.
| |
EName |
Sal |
Bonus |
| 0 |
Kavita |
50000 |
3000 |
| 1 |
Sudha |
60000 |
4000 |
| 2 |
Garima |
55000 |
5000 |
a) 0 Kavita 50000 3000
b) 50000
c) 3000
d) 50000
48. Consider the following data frame name df
| |
Name |
Age |
Marks |
| 0 |
Amit |
15 |
90.0 |
| 1 |
Bhavdeep |
16 |
NaN |
| 2 |
Reema |
17 |
87.0 |
Write the output of the given command:
print(df.marks/2)
a)
Name: Marks, dtype: float64
b)
Name: Marks, dtype: float64
c)
Name: Marks, dtype: float64
d)
Name: Marks, dtype: float64
49. Read the statements given below. Identify the right option from the following for Attribute and method/function.
Statement A: Attribute always ends without parenthesis.
Statement B: Function/Method cannot work without arguments.
a) Both statements are correct.
b) Both statements are incorrect.
c) Statement A is correct, but Statement B is incorrect
d) Statement A is incorrect, but Statement B is correct