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

To convert a dataframe into CSV file: You need to add a code df.to_csv('location') To convert a CSV file into dataframe: df = pd.read_csv('File location') print (df)

1Thank You

ANSWER

Table GYM: (i) To display the names of all the items whose name starts with “A". (ii) To display ICODEs and INAMEs of all items, whose Brand name is Reliable or Coscore. (iii) To change the Brand name to “Fit Trend India” of the item, whose (iv) Add a new row for a new item in GYM with the details: “Gl07", "Vibro exerciser”,21000,”GTCFitness" (v) SELECT COUNT (DISTINCT (BRANDNAME) ) FROM GYM; (vi) SELECT MAX (PRICE) FROM GYM, (vii) SELECT INAME FROM GYM WHERE INAME LIKE "%t’,

Posted by Ankush Anubhav 3 years, 9 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Nidhi M 3 years, 9 months ago

(i) select names from gym where name like "A%" ; (ii) select ICODEs,INAMEs from gym where bname like " Reliable" or like "Coscore" ;

4Thank You

ANSWER

Ip practical file...what to do in it ?

Posted by Avi Dahiya 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Command to insert a details of new student in the above table mysql

Posted by Disha Gupta 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

2 answers

ㄗAnkaj Singh 3 years, 10 months ago

Insert into 'table name ' VALUES (value1, value 2..........);

0Thank You

Student Of The Year 3 years, 10 months ago

INSERT INTO 'table name' VALUES (value 1,value 2.....)

0Thank You

ANSWER

Create a student table with the stud 10,name ,marks ,gender & DOB as attribute using all constraints

Posted by Disha Gupta 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Nidhi M 3 years, 9 months ago

CREATE TABLE stud 10 ( marks INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, birth_date DATE, gender VARCHAR(15) NOT NULL UNIQUE );

0Thank You

ANSWER

Practicle syllabus for I.P

Posted by Rajat Bhardwaj 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Work integrated learning IT DMA notes

Posted by Riya Kandpal 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Select sqrt(9);

Posted by Manish Sahu 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Megha Gupta 3 years, 10 months ago

1Thank You

ANSWER

Write different between CHAR and VARCHAR data type

Posted by Balaram Tamili 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Balaram Tamili 3 years, 10 months ago

I'm thankful to you

0Thank You

Gaurav Seth 3 years, 11 months ago

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>

1Thank You

ANSWER

Sir please give me sample paper of informative pratices of class12 commerce board exam 2020-2021.

Posted by Joy Bhattacharjee 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Akshali Mittal 3 years, 5 months ago

You can take it from cbse website

0Thank You

Archita Vashisht 3 years, 11 months ago

Download it from cbse sample paper 2021( which is given in this app)

3Thank You

ANSWER

Kya ip ki book change ho chuki h

Posted by Aman Malik 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Paras Kumar 3 years, 10 months ago

Yah

1Thank You

Priyanshee Sharma. 3 years, 11 months ago

0Thank You

ANSWER

Please provide me ip old code 265 deleted syllabus

Posted by Aman Malik 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Vikas Bhati 3 years, 11 months ago

Search in Google you can definitely get it

0Thank You

ANSWER

Give the output of : i) Select round(123.93);

Posted by Dileep Meena 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Kai Pocha Lofer 3 years, 11 months ago

It s 124

0Thank You

Archita Vashisht 3 years, 11 months ago

May be 124

0Thank You

ANSWER

Give the output of : i) Select round(123.93); ii) Select round(123.93,1);

Posted by Dileep Meena 3 years, 4 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Archita Vashisht 3 years, 11 months ago

1) 124 2) 123.9

0Thank You

ANSWER

Which of the following is not a downside of OSS

Posted by Arjun Murali 14 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Yogita Ingle 3 years, 11 months ago

Which of the following is not the characteristics of an open source software?
(i) Its source code is available for modification
(ii) It is owned by a company or an Individual
(iii) It can be downloaded from Internet
(iv) All of the above
Answers:
(ii) It is owned by a company or an individual.

0Thank You

ANSWER

What is the significance of pandas library

Posted by Juhi Bulchandani 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Nakul Ohlyan 3 years, 6 months ago

in computer

1Thank You

Gaurav Seth 3 years, 11 months ago

In computer programming, 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.

1Thank You

Yogita Ingle 3 years, 11 months ago

Pandas is a package of python which allows us to perform various operations on datasets such as reshaping,merging,sorting , slicing and so on.

0Thank You

ANSWER

Write program and give output ......importing and exporting data between pandas and CSV file.

Posted by Piyush Tiwari 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

A table "animals" in a database has 3 columns and 10 records.What is the degree and cardinality of this table?

Posted by Joel M 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Hardik Gehlot 3 years, 11 months ago

Nhi aata

0Thank You

Yogita Ingle 3 years, 11 months ago

(i) On 5 May 1789, Louis XVI called together an assembly of the Estates General to pass proposals for new taxes. The Estates General was a political body to which the three estates sent their representatives.
(ii) The first and second estates sent 300 representatives each, who were seated in rows facing each other on two sides, while the 600 members of the third estate had to stand at the back.
(iii) The third estate was represented by its more, prosperous and educated members. Peasants, artisans and women were denied entry to the assembly.
(iv) Louis XVI wanted voting to be conducted on the old principle-each estate having one vote. But the members of the third estate demanded that voting now be conducted by the Assembly as a whole, where each member would have one vote.
(v) The king rejected their demand as a result of which they walked out of the Assembly in protest.
(vi) The members of the third estate declared themselves a National Assembly and began to draft a constitution for France which would limit the powers of the monarch.
(vii) While the National Assembly was busy at Versailles drafting a constitution, the rest of France seethed with turmoil. They were facing acute food scarcity. Finally, the agitated common mass stormed and destroyed the Bastille, the symbol of the king's despotic and tyrannic rule on 14 July 1789.
(viii) The condition of the countryside was also not good. Peasants looted hoarded grains and burnt down documents. A large number of nobles fled from their houses.
(ix) Louis XVI finally accorded recognition to the National Assembly and accepted the principle that his powers would from now on be checked by a constitution.
(x) The feudal system of obligations and taxes was also abolished. Members of the clergy were forced to give up their privileges.

1Thank You

ANSWER

Write down three difference between series and dataframe. *

Posted by Subhash Kumar 3 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Naitik Agrawal 3 years, 11 months ago

1)Series are 1-D, whereas Dataframe are 2-D. 2)Series consists of homogeneous data, whereas dataframe consists of heterogeneous data. 3)series are value mutable whereas dataframe are not.

2Thank You

ANSWER

Write a program that reads from a csv file (markes.csv stored in desiredlocation) in a data frame then add a column Total storing total marks in three subjectaand another column for storing average marks. Print the data frame after adding these columns

Posted by Dharmarajan K 4 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Social impact chapter is missing

Posted by Sandesh Pratap Singh 4 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

To add 2 dataframes

Posted by Sampada Yadav 4 years ago

CBSE > Class 12 > Informatics Practices

1 answers

Kartick Chauhaan 3 years, 11 months ago

import pandas as pd D1=pd.DataFrame([1,2,3,4,5]) D2=pd.DataFrame([6,7,8,9,10]) print(D1+D2)

0Thank You

ANSWER

Select truncate from student1

Posted by Kiranpreet Bhatia 4 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is a communication channel? Name the basic type of communication channels available

Posted by Chirag Parjapati 4 years ago

CBSE > Class 12 > Informatics Practices

1 answers

Yogita Ingle 4 years ago

Communication channel mean the connecting cables that link various workstations.Following are three basic types of communication channels available: a Twisted-Pair Cables b Coaxial Cables c Fiber-optic Cables

0Thank You

ANSWER

Histogram example graphs in datavisualisation

Posted by Sruthy Ds 4 years ago

CBSE > Class 12 > Informatics Practices

1 answers

Meghna Thapar 4 years ago

A histogram is a chart that shows frequencies for. intervals of values of a metric variable. Such intervals as known as “bins” and they all have the same widths. The primary use of a Histogram Chart is to display the distribution (or “shape”) of the values in a data series. For example, we might know that normal human oral body temperature is approx 98.6 degrees Fahrenheit.

To make a histogram, follow these steps:

On the vertical axis, place frequencies. Label this axis "Frequency".
On the horizontal axis, place the lower value of each interval.
Draw a bar extending from the lower value of each interval to the lower value of the next interval.

0Thank You

ANSWER

Histogram example graphs in datavisualisation

Posted by Sruthy Ds 4 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

kya board may question sumita arora say aate h

Posted by Solo 2.2 4 years ago

CBSE > Class 12 > Informatics Practices

2 answers

Akshali Mittal 3 years, 5 months ago

Please aap book ke jhamele mein mat padiye kyuki isse aap confused ho sakte hai so I would suggest ki aap ek hi book per focus kijiye please don't mind it Only I want to tell you that all books have the same chapters and contents also so if you read so many books of 1 subject it will be very difficult to learn and understand the concept of the chapter ??

0Thank You

Anand Singh 4 years ago

NCERT

0Thank You

ANSWER

1. Given the school result data, plot the performance of the students(1st, 2nd and 3rd) what will be the output of this

Posted by Divyam Agarwal 4 years ago

CBSE > Class 12 > Informatics Practices