CBSE > Class 12 > Informatics Practices | CBSE Board | Homework Help

Primary memory is also called internal memory whereas Secondary memory is also known as a Backup memory or Auxiliary memory.
Primary memory can be accessed by the data bus whereas Secondary memory is accessed by I/O channels.
Primary memory data is directly accessed by the processing unit whereas Secondary memory data cannot be accessed directly by the processor.
Primary memory is costlier than secondary memory whereas Secondary memory is cheaper compared to primary memory.
Primary memory is both volatile & nonvolatile whereas Secondary memory is always a non-volatile memory.

0Thank You

ANSWER

Write Code to add, delete, and rename a column in given DataFrame. Df=pd.DataFrame({“A”:[1,2,3],”B”:[4,5,6]})

Posted by Ashish Sharma 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

2 answers

Nidhi M 3 years, 9 months ago

print ("Deleting another column using POP function:") df.pop('two') print df

0Thank You

Nidhi M 3 years, 9 months ago

print ("Adding a new column by passing as Series:") df['three']=pd.Series([10,20,30],index=['a','b','c']) print df

0Thank You

ANSWER

Write a program in Python Pandas to create the following DataFrame batsman from a Dictionary: B_NO Name Score1 Score2 1 Sunil Pillai 90 80 2 Gaurav Sharma 65 45 3 Piyush Goel 70 90 4 Kartik Thakur 80 76 Perform the following operations on the DataFrame : 1)Add both the scores of a batsman and assign to column “Total” 2)Display the highest score in both Score1 and Score2 of the DataFrame.

Posted by Neha Kumari 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Which person make the python programming language.

Posted by Avilash Sharma 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

2 answers

Naitik Agrawal 3 years, 11 months ago

Sorry it's "Guido Van Rossum"

1Thank You

Naitik Agrawal 3 years, 11 months ago

Guido Can Rossum

0Thank You

ANSWER

How can I get pdf of Sumitra Arora Text book of IP Class 12?

Posted by Satish Kumar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Naitik Agrawal 3 years, 11 months ago

Go to sultan Chand website!

0Thank You

ANSWER

There is a column HOBBY in a table CONTACTS. The following two 1 statements are giving different outputs. What may be the possible reason? SELECT COUNT(*) FROM CONTACTS; SELECT COUNT(HOBBY) FROM CONTACTS;

Posted by Dhruv Dahiya 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Kartick Chauhaan 3 years, 11 months ago

SELECT COUNT(*) FROM CONTACTS; ☝️ This statement gives one type of output. This is because the function Count(*) counts total number of records in the table. It also includes the NaN values as records. BUT THE STATEMENT SELECT COUNT(HOBBY) FROM CONTACTS; Gives another output. This is because this statement is applied over a column and so it does not includes the NaN values.

0Thank You

ANSWER

27. Insert the following information: Students Adno Name Average *** Scode 501 R.Jain 98 M 111 545 Kavita 73 F 333 705 K.Rashika 85 F 111 754 Rahul Goel 60 M 444 892 Sahil Jain 78 M 333 935 Rohan Saini 85 M 222 955 Anjali 64 F 444 983 Sneha Aggarwal 80 F 222 28. Write queries based upon item table given in q. no 27. (i) Display all students' information. (ii) Display Rohan Saini's information. (iii) Display number of students in the table. (iv) Display number of students in each ***. (v) Display students' information in ascending order using name. (vi) Display students' information in descending order using average marks. (vii) Display students' name starting with letter "K". (viii) Display students' information, whose name ends with "l". (ix) Display a report with adno,name,average*5 as total marks from student table. (x) Display students' information, whose average marks are in between 80 to 90. (xi) Display students' info., who are getting average marks of more than 80 and scode 333. (xii) Display students' name and average marks, whose scode is 222 and 333. (xiii) Display sum of average marks. (xiv) Display maximum average marks (xv) Display minimum average marks. 200

Posted by Ishika Dua 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is a random module

Posted by Sree Lakshmi 3 years, 6 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

You can generate random numbers in Python by using random module. Python offers random module that can generate random numbers. These are pseudo-random number as the sequence of number generated depends on the seed. If the seeding value is same, the sequence will be the same.

0Thank You

ANSWER

Entre in the database student

Posted by Gunjan Verma 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

MS ravana a leading marketing professional working in a multinational company is most of the time on move to get her profession demands although she carries a laptop with her all the time but many times she required to take some data from her office PC she has to make several requesting phone calls to her colleagues Barbara to send the required documents from a office PC suggest her anyone pop popular protocol name so that she can herself remotely access her office PC anytime from anywhere

Posted by Adi Gaming 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is the difference between sum and cumulative sum? how do you perform the two on data frame?

Posted by Aman Badhwar 3 years, 5 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 5 months ago

With sum, you take a certain number of values and perform a sum to get the total. Cumsum is the cumulative sum of differences between the values. So for each row, you'll get the cumulative total up until that point.

0Thank You

ANSWER

What is quarter? how is it different from quantile?

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

The first quartile (Q₁) is defined as the middle number between the smallest number (minimum) and the median of the data set. It is also known as the lower or 25th empirical quartile, as 25% of the data is below this point.

0Thank You

ANSWER

What is pivoting? how is it useful?

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Naitik Agrawal 3 years, 11 months ago

It's deleted from the syllabus bro

0Thank You

ANSWER

How is a series object different from and similar to nd arrays? Support your answer with examples.

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Write a program to create a series object that stores the table of number 5.

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

5 marks questions Write python code to create a series object temp1 that stores temperatures of 7 days in it. Take any random 7 temperatures.

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is pandas library of python? What is its significance?

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

pandas is a software library written for the Python programming language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series. It is free software released under the three-clause BSD license.

0Thank You

ANSWER

Write a query to display the number of employees with the same job

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is the difference between a where clause and a having clause of SQL select statement

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

The main difference between WHERE and HAVING clause comes when used together with GROUP BY clause, In that case WHERE is used to filter rows before grouping and HAVING is used to exclude records after grouping. This is the most important difference and if you remember this, it will help you write better SQL queries.

0Thank You

ANSWER

What is the function

Posted by Aman Badhwar 3 years, 6 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 6 months ago

A function is a binary relation between two sets that associates to each element of the first set exactly one element of the second set. Typical examples are functions from integers to integers, or from the real numbers to real numbers.

0Thank You

ANSWER

4 marks questions How does dataframe object specify indexes to its data rows

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

2. which one of the following is not a numeric function options are mod, sign,mid,pow

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Avilash Sharma 4 years, 1 month ago

First of all write the correct word. Ok... Not mid it is a mod. Come to your question.. Sign is not a numeric python

0Thank You

ANSWER

multiple choice question: question number 1 which one of the following is not a text function .options are: trim, truncate, left, mid

Posted by Aman Badhwar 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Diffrentiate between package and library

Posted by Sree Lakshmi 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Meghna Thapar 4 years, 1 month ago

A library is a set of modules which makes sense to be together and that can be used in a program or another library. A package is a unit of distribution that can contain a library or an executable or both. It's a way to share your code with the community. Module is a file which contains python functions , global variables etc. It is nothing but .py file which has python executable code / statement. Package is namespace which contains multiple package/modules. Library It is collection of various packages.

1Thank You

ANSWER

working with numpy

Posted by Indiadigital Solutions 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Write SQL queries for the following: (i) To count how many addresses are not having NULL values in the address column of students table. (2) (ii) To display Name, Class from STUDENT table and the corresponding Grade from SPORTS table. (2) (iii) To display Name of the student and their corresponding Coach names from STUDENTS and SPORTS tables. (2)

Posted by Aastha Jaiswal 4 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Differentiate with print CHAR and VARCHAR.

Posted by Account Deleted 4 years, 2 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Yogita Ingle 4 years, 2 months ago

CHAR and VARCHAR are both ASCII character data types and almost same but they are different at the stage of storing and retrieving the data from the database. Following are some important differences between CHAR and VARCHAR in MySQL −

CHAR Data Type	VARCHAR Data Type
Its full name is CHARACTER	Its full name is VARIABLE CHARACTER
It stores values in fixed lengths and are padded with space characters to match the specified length	VARCHAR stores values in variable length along with 1-byte or 2-byte length prefix and are not padded with any characters
It can hold a maximum of 255 characters.	It can hold a maximum of 65,535 characters.
It uses static memory allocation. <pre> mysql>create table emp(name CHAR(20)); Query OK, 0 rows affected (0.25</pre>	It uses dynamic memory allocation. <pre> mysql>create table emp1(name VARCHAR(20)); Query OK, 0 rows affected (0.21</pre>