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

No products in the cart.

Ask questions which are clear, concise and easy to understand.

Ask Question

"""Write SQL queries for the following – i) Change the colour of GARMENT with code as 116 to “Orange” ii) Display count of garments available in store size wise. iii) Display all the garments available in store where name has ‘s’ in it and price more than 1200. iv) Modify structure of table to make Gcode as primary key """ i) update garment set colour='orange' where gcode=116; select * from garment; ii) select size,count(*) from garment group by size; iii)select * from garment where gname like '%s%' and price>1200; iv) alter table garment add primary key (gcode);

Posted by Megha Singh 2 years, 7 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Akshat Krishna 2 years, 7 months ago

i) update garment set colour='orange' where gcode=116; select * from garment; ii) select size,count(*) from garment group by size; iii)select * from garment where gname like '%s%' and price>1200; iv) alter table garment add primary key (gcode); this is the answer right??

ANSWER

Data Visualization on Covid analysis with csv file

Posted by Bibhu Raj 2 years, 8 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Vinila Vinod 2 years, 3 months ago

https://pythonworld.in/practical-project/project-list/

ANSWER

What is DBMS

Posted by Akash Akash 2 years, 9 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Diya Vijay 2 years, 7 months ago

DBMS stands for database management system and is defined as the a computerized data-keeping system.The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs

Tec Om 2 years, 9 months ago

Structured way of data in the form of rows and columns

ANSWER

predict the output of the queries select power (5,3);

Posted by Chayanika Medhi 2 years, 9 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Diya Vijay 2 years, 7 months ago

Power(5,3) means 5^3 So 5×5×5 = 125

Dev Pancholi 2 years, 8 months ago

125

ANSWER

Create a pandas series from a dictionary of values and an ndarray

Posted by Vansh Gadhiya 3 years ago

CBSE > Class 12 > Informatics Practices

3 answers

Dev Pancholi 2 years, 8 months ago

import pandas as pd import numpy as np

Sunil Pandey 2 years, 10 months ago

import pandas as pd

Bla Re 3 years ago

import pandas as pd import numpy as np S=[1,2,3,4] ss=pd.Series(s)

ANSWER

I want a project synopsis based on python and csv

Posted by Anjana Bhatt 3 years ago

CBSE > Class 12 > Informatics Practices

1 answers

Abhijeet Singh Vagle 3 years ago

in which topic you get ??

ANSWER

.Series is a _______________ dimensional, while Pandas is _______dimensional. * 0/1 a. One , One b. Two , one c. One, Two d. Two, Two

Posted by Prabhat Jaiswal 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

5 answers

Shreya Mahajan 2 years, 11 months ago

C

Aman Yadav Nagla Gange 3 years, 1 month ago

C

Nisha N 3 years, 1 month ago

A.one,one

Nisha N 3 years, 1 month ago

C. One, two

Prabhat Jaiswal 3 years, 1 month ago

C. One,two

ANSWER

Create a series named employee storing employee name as index value and salaries of the employees as data print the names and salaries of all employees whose salary is above 25000

Posted by Anjali Jha 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Create a series named Employees

Posted by Anjali Jha 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Fill in the blanks: In a DataFrame, Axis = 1 represents the ________elements .

Posted by Vedant Sharma 3 years, 2 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Muskan Sharma 3 years, 2 months ago

Columns

ANSWER

To print the details of pen using iloc or loc

Posted by Ashra Shabeer 3 years, 2 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Himanshi Asnani 1 year, 10 months ago

Loc

ANSWER

what is the code for updating table in dbms ?

Posted by Vikky Jakhar 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 3 months ago

<pre> UPDATE table_name SET column1 = value1, column2 = value2,... WHERE condition; table_name: name of the table column1: name of first , second, third column.... value1: new value for first, second, third column.... condition: condition to select the rows for which the values of columns needs to be updated.</pre>

ANSWER

how np.tile() works

Posted by Tec Om 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Diya Vijay 3 years, 1 month ago

np.tile is used for repetition For example, s=pd.Series(np.tile([1,2,3],2)) Output : 0 1 1 2 2 3 3 1 4 2 5 3 I hope you understand...

ANSWER

Write a code to create dataframe from CSV and TXT file. With example

Posted by Rajeshwari K S 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Tec Om 3 years, 3 months ago

<a href="https://www.instagram.com/_tec_om/">tec_om</a>

Tec Om 3 years, 3 months ago

if you want a detailed example then write it here or dm me on instagram <link href="https://www.instagram.com/_tec_om/">tec_om</link>

Tec Om 3 years, 3 months ago

to create a dataframe from form a csv file you must follow the following code lines
import pandas as pd
var=pd.read_csv("file name or address") #if it(your csv file) is in the same folder then you can give the name of the file with extension
print(var)
to create a dataframe from txt file you can use this code:
import pandas as pd
var=pd.read_table("file name or address")
print(var)

ANSWER

# known as

Posted by Pynshai Lyngdoh 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Tec Om 3 years, 3 months ago

comments are the additional information which is given by user to identify which portion of code is for what purpose, this helps a programmer to check code in future

Tec Om 3 years, 3 months ago

# this is known as pound symbol which is use to write comments in python

Sia ? 3 years, 3 months ago

Please ask question with complete information.

ANSWER

Python is also known as

Posted by Pynshai Lyngdoh 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 3 months ago

When he began implementing Python, Guido van Rossum was also reading the published scripts from “Monty Python's Flying Circus”, a BBC comedy series from the 1970s. Van Rossum thought he needed a name that was short, unique, and slightly mysterious, so he decided to call the language Python.

ANSWER

write python code to create following dataframe

Posted by Nikita Kumari 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Tec Om 3 years, 3 months ago

import pandas as pd
a={"name":["nikita","om","jatin"],"class":[12,12,12,]}
df=pd.DataFrame(a)
print (df)

Tec Om 3 years, 3 months ago

<pref>you can create data frame by following lines: import pandas as pd a={ "names":["hari","nikita"] } #here you can give any type of dictionary df=pd.DataFrame(a) print(df) #your program will be printed here</pref>

Jatin Batra 3 years, 3 months ago

Where is '' following dataframe " , kindly mention so that I can answer u....

ANSWER

Anyone can help me with my ip project on book shop management system

Posted by Krishna Prajapati 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Krishna Prajapati 3 years, 3 months ago

In python

ANSWER

How to make a ppt on writing skills

Posted by Raj Kaur 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Tec Om 3 years, 3 months ago

you can use powerpoint and google slides for ppt

ANSWER

How to make a ppt on self mangement skills

Posted by Raj Kaur 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Why there is no syllabus for IT 402 in cbse new syllabus release?

Posted by Herajit Sharma 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Explain what the following statements are using ? df is the name of a Dataframe. (i) df.iloc[:5,] (ii) df.iloc[1:5,] (iii) df.iloc[5,0] (iv) df.iloc[1:5,0] (v) df.iloc[1:5,:5] (vi) df.iloc[2:7,1:3

Posted by Sana Singh 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

State difference between where and check keyword

Posted by Priyanshi Sharma 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is default value? How do you define it? What is default value for a column for which no value is defined?

Posted by S. K 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 3 months ago

For date and time types other than TIMESTAMP, the default is the appropriate “zero” value for the type. For the first TIMESTAMP column in a table, the default value is the current date and time. For string types other than ENUM, the default value is the empty string.

ANSWER

Roshi wants to add another column 'Hobbies' with datatype and size as varchar (50) in the already existing table 'student' .She has written the following statement .However it has errors .Rewrite the correcr statement MODIFY TABLE Student Hobbies VARCHAR;

Posted by Phaneithem Khongsai 3 years, 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Information about pratical

Posted by Jayanta Kumar Gorai 3 years, 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

If a database “Productinfo” exists, which MYSQL command helps you to start working in that database?

Posted by Tushar Jain 3 years, 4 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Preeti Dabral 3 years, 4 months ago

To access a specific database, type the following command at the mysql> prompt, replacing dbname with the name of the database that you want to access: use dbname; Make sure you do not forget the semicolon at the end of the statement. After you access a database, you can run SQL queries, list tables, and so on.

Vedant Sharma 3 years, 2 months ago

Use Productinfo; The above command is used to start working on any existing database .

ANSWER

Name functions using which you can perform arithmetic operations on ndarrays.

Posted by Ankita Hazra 3 years, 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

I want to know that in which app I can practice the pandas

Posted by Bharath Singh 3 years, 5 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Jatin Batra 3 years, 3 months ago

Pydroid 3

Tec Om 3 years, 5 months ago

pydroid

ANSWER

Given a Data Frame mdf as shown below: A 7 41 B 8 45 C 9 48 Q7 1 but ate but rial 34 Q8 0 1 What will be the output produced by the following code? print(":", mdf.loc[0][*C']) print("II:", mdf.iloc[1][2])

Posted by Mahek Shah 3 years, 5 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Page 3 of 40

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Google Play

Download myCBSEguide App