Commerce (English Medium) कक्षा १२ - CBSE Question Bank Solutions

Carefully observe the following code:

import pandas as pd
Year1 = {'Q1':5000,'Q2':8000,'Q3':12000,'Q4': 18000} Year2 = {'A' :13000,'B':14000,'C':12000}
totSales = {1:Year1,2:Year2}
df = pd.DataFrame(totSales)
print(df)

Answer the following:

1. List the index of the DataFrame df
2. List the column names of DataFrame df.

Consider the given DataFrame ‘Stock’:

Write suitable Python statements for the following:

1. Add a column called Special_Price with the following data: [135,150,200,440].
2. Add a new book named ‘The Secret' with a price of 800.
3. Remove the column Special_Price.

Discuss the significance of Group by clause in detail with the help of a suitable example.

Prime Computer Services Ltd. is an international educational organization. It is planning to set up its India campus in Mumbai with its head office in Delhi. The Mumbai office campus has four main buildings-ADMIN, ACCOUNTS, EXAMINATION, and RESULT.

You as a network expert have to suggest the best network-related solutions for the problems given below, keeping in mind the distances between the buildings and other given parameters.

Shortest distances between various buildings:

The number of computers installed at various buildings is as follows:

1. Suggest the most appropriate location of the server inside the MUMBAI campus (out of the four buildings) to get the best connectivity for the maximum number of computers. Justify your answer.
2. Suggest and draw cable layouts to efficiently connect various buildings within the MUMBAI campus for wired connectivity.
3. Which networking device will you suggest to be procured by the company to interconnect all the computers of various buildings of the MUMBAI campus?
4. The company is planning to get its website designed which will allow students to see their results after registering themselves on its server. Out of the static or dynamic, which type of website will you suggest?
5. Which of the following will you suggest to establish online face-to-face communication between the people in the ADMIN office of the Mumbai campus and the Delhi head office?
   a) Cable TV
   b) Email
   c) Video conferencing
   d) Text chat

Mr. Som, a data analyst has designed the DataFrame df that contains data about Computer Olympiad with ‘CO1’, ‘CO2’, ‘CO3’, ‘CO4’, and ‘CO5’ as indexes shown below. Answer the following questions:

1. Predict the output of the following python statement:
   i. df.shape
   ii. df[2:4]
2. Write a Python statement to display the data of the Topper column of indexes CO2 to CO4.
   OR
   Write a Python statement to compute and display the difference of data of the Tot_students column and First_Runnerup column of the above given DataFrame.

'O' in FOSS stands for ______.

Legal term to describe the rights of a creator of original creative or artistic work is ______.

What do you understand by plagiarism?

Why is plagiarism a punishable offence?

Write Python code to plot a bar chart for India’s medal tally as shown below:

Also, give a suitable python statement to save this chart.

Write a python program to plot a line chart based on the given data to depict the changing weekly average temperature in Delhi for four weeks.

Week=[1,2,3,4]
Avg_week_temp=[40,42,38,44]

Which of the following is not a type of cybercrime?

1. What is this happening to Nadar?
2. What immediate action should she take to handle it?
3. Is there any law in India to handle such issues? Discuss briefly.

Which of the following is not an example of a browser?

Assertion (A): Internet cookies are text files that contain small pieces of data, like a username, password, and user preferences while surfing the internet.

Reasoning (R): To make browsing the Internet faster & easier, it is required to store certain information on the server’s computer.

What is an example of e-waste?

List any four benefits of e-waste management.

Assume that each born child is equally likely to be a boy or a girl. If a family has two children, what is the conditional probability that both are girls? Given that

1. the youngest is a girl.
2. at least one is a girl.

Find the area of the region in the first quadrant enclosed by the x-axis, the line y = x and the circle x² + y² = 32.

Assume that the chances of a patient having a heart attack is 40%. Assuming that a meditation and yoga course reduces the risk of heart attack by 30% and prescription of certain drug reduces its chance by 25%. At a time a patient can choose any one of the two options with equal probabilities. It is given that after going through one of the two options, the patient selected at random suffers a heart attack. Find the probability that the patient followed a course of meditation and yoga. Interpret the result and state which of the above stated methods is more beneficial for the patient.