Page 30 - IPP-12-2024

29. Meenakshi, a 55-year-old lady, started using a social-media-based messaging application on her smartphone.
Meanwhile, she unknowingly clicked on a link floating on that application, after which she received a text from
her bank account asking for OTP. Based on the given information, answer the following questions:
(i) What suggestions would you give regarding such incidents?
(ii) What actions should Meenakshi take immediately?
(iii) Identify the type of cybercrime that she is a victim of. (3)
30. Consider the given DataFrame ‘Species’:
Name Height(m)
0 Kiara 2-3
1 Bidara 1-1.5
2 Balsa 2-3
3 Lame 3-4
(i) Rename the column ‘Name’ to ‘Local_Name’.
(ii) Add a column called ‘Numbers’ with data: [10, 100, 100, 30].
(iii) Delete the column ‘Height (m)’. (3)
SECTION D
31. Assume that you are a database administrator in a company and have been asked to give the output from
a database to make decisions based on it. Write the following SQL queries:
Table: Equipments

Equipment_Code Equipment_Name Department Installation_Date Total_Cost
ANAU11 Anaesthesia Anaesthesiology 2023-03-03 41000
Machine
ANAU13 Anaesthesia Anaesthesiology 2023-03-13 41000
Machine
BCCO12 Haematology Haematology Lab 2010-02-01 80000
Analyzer
CLAN04 Chemistry Analyzer Operating Room Nursing 2023-03-13 130000
COAG06 Coagulation Operating Room Nursing 2020-08-02 30000
Analyzer
(i) To display the year of the oldest installed equipment.
(ii) To display the name and cost of equipments department-wise.
(iii) To display the most expensive equipment.
(iv) To count the total number of equipments installed in the year 2023. (4)
32. A data researcher in a stock market analyzes the increment or decrement in percentage of stocks in 4 weeks
based on the DataFrame (df) given below:
Stocks Week1 Week2 Week3 Week4
0 Stock_1 24 3 10 -13
1 Stock_2 28 4 -8 4
2 Stock_3 16 12 -10 2
3 Stock_4 52 -25 15 10
Answer the following questions:
(i) Predict the output of the following Python statements:
(a) print(df.tail(2))
(b) print(df.iloc[1:2])
(ii) Write the Python statement to check for NaN values in DataFrame (df)
(iii) Replace the week4 percentage of Stock_2 with 8. (1+1+2)
OR
Display the column ‘Stocks’ as the index of the given DataFrame (df).

Practice Paper A.5