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

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

Ask Question

Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

Posted by Aman Kumar 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Consider the SchoolBus table given below: Rtno Area_covered Capacity Noofstudents Distance Transporter Charges 1 Vasantkunj 100 120 10 Shivamtravels 100000 2 HauzKhas 80 80 10 Anand travels 85000 3 Pitampura 60 55 30 Anand travels 60000 4 Rohini 100 90 35 Anand travels 100000 5 Yamuna Vihar 50 60 20 Bhalla Co. 58000 6 Krishna Nagar 70 80 30 Yadav Co. 80000 7 Vasundhara 100 110 20 Yadav Co. 100000 8 PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

Posted by Aman Kumar 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Name some web server software prominently in use .

Posted by Angela Magar 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 2 years, 11 months ago

here most popular web servers are listed such as Apache web server, Nginx Web server, Lighttpd, Jigsaw, Abyss web server, Oracle web server, Tier, Klone, X5( Xitami ) web server,and Zeus web server.

0Thank You

ANSWER

To display the total number of designation from the table EMPSALARY

Posted by Deepanshi Tripathi 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Write down the command that will give the following output. rollno name UT1 UT2 UT3 UT4 dtype: object a. print (df.max) b. print (df.max ( ) ) c. print (df.max (axis-1)) d. print (df.max, axis=1)

Posted by I G 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

What is data abstractions

Posted by S. K 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 2 years, 11 months ago

Database systems are made-up of complex data structures. To ease the user interaction with database, the developers hide internal irrelevant details from users. This process of hiding irrelevant details from user is called data abstraction.

1Thank You

ANSWER

How to hack zoom class...??

Posted by ? Royal Thakur ? 2 years, 11 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Can I get the question of networking in ip

Posted by Anuradha Patwari 3 years ago

CBSE > Class 12 > Informatics Practices

1 answers

Anuradha Patwari 2 years, 11 months ago

Please ? help

0Thank You

ANSWER

write a program in python to replace every occurence of vowel @

Posted by Rk Sahil 3 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Where I can find solution of textbook question of ip ncert book

Posted by Trixie 2205 3 years ago

CBSE > Class 12 > Informatics Practices

2 answers

Akshali Mittal 2 years, 11 months ago

Sumita arora book

0Thank You

Nik . 3 years ago

Online dekh le google ya YouTube se

0Thank You

ANSWER

Preeti Arora book solutions

Posted by Shivani Rathore 11 months, 3 weeks ago

CBSE > Class 12 > Informatics Practices

4 answers

Avika Bansal 3 weeks, 3 days ago

class 11 ch 1 computer system unsolved questions ke solutions

0Thank You

Vinila Vinod 1 year, 9 months ago

https://www.tutorialaicsip.com/?s=Preeti+Arora+

5Thank You

Nik . 3 years ago

Sumitra arora ka hai

1Thank You

Anuradha Patwari 3 years ago

Google

3Thank You

ANSWER

To get the current date ____ function is used

Posted by Tanya Sehgal 3 years ago

CBSE > Class 12 > Informatics Practices

3 answers

Priyadarshani Khowal 1 year, 9 months ago

Curdate()

0Thank You

Akshali Mittal 2 years, 11 months ago

Select now() is used

0Thank You

Anuradha Patwari 3 years ago

Now function is used

0Thank You

ANSWER

Can anyone give me the pdf of sumitra arora IP class 12 book

Posted by Nik . 3 years ago

CBSE > Class 12 > Informatics Practices

4 answers

Nik . 3 years ago

But due to corona it is difficult to buy it onl

0Thank You

Anuradha Patwari 3 years ago

So online order so u will get the book ? it self

0Thank You

Nik . 3 years ago

Google pe nhi mil rha hai

0Thank You

Anuradha Patwari 3 years ago

Kindly get it by Google

0Thank You

ANSWER

Differentiate between the features of virtual dub wax movica and moviestorm

Posted by Meenakshi Malpani 3 years ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Full form of OTF?

Posted by Tana Hina 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

2 answers

M.A.D_N.I.T.H.I.S.H_ 007 3 years ago

One time password

0Thank You

Lovnika Sihag 3 years, 1 month ago

Output Text Format (computer programming)

0Thank You

ANSWER

Write a program to create dataframe stock using the index values as 10,20,30,40and 50.

Posted by Keshav Roy 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

5 answers

Tec Om 3 years ago

if you have any query in my answer you can dm me on insta: _tec_om

0Thank You

Tec Om 3 years ago

<pre> import pandas as pp dic1={"Name":["Omkar","Jankar","Shubankar","Chitrakar","Bekar"], "salary":[200000,10000,23000,32000,1200] } data1=pp.DataFrame(dic1,index=[10,20,30,40,50]) print(data1)</pre>

0Thank You

Hey Kriti 3 years, 1 month ago

Import pandas as pd Import numpy as np dict={"name":["amit","sumit","Ronit","Aryan"],"rollno. ":[1,2,3,4]} Stock=pd.dataframe(dict, index=[10,20,30,40]) Print(stock)

0Thank You

Arpit Malik 3 years, 1 month ago

@Kaviya .... Galt hai bhai? Index me jyada values dedi??

0Thank You

Kaviya Rajasekaran 3 years, 1 month ago

Dtf={'products':['pen','pencil','crayon'],'price':[100,50,200]) Stock=pd.Dataframe(Dtf,index=[10,20,30,40,50]) Print(stock)

0Thank You

ANSWER

Write a code to display the details of cot and baby

Posted by Keshav Roy 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 1 month ago

Please ask question with complete information.

0Thank You

ANSWER

. briij kya he

Posted by Krishna Mewada 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

2 answers

Tana Hina 3 years, 1 month ago

Lund ka naam suna h kbhi wohi h briij

0Thank You

Krishna Mewada 3 years, 1 month ago

briij kya he

0Thank You

ANSWER

Consider a string good morning a)write sql command to extract the substring good b)Write sql command extract the starting position of the substring morning from the give string

Posted by Pratham Bansal 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Lol No 3 years, 1 month ago

A) substr()/mid() B) left()

0Thank You

ANSWER

What are important topics in Python for boards

Posted by Praneeth K 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 1 month ago

https://mycbseguide.com/dashboard/content/19827

0Thank You

ANSWER

Give me a imp notes

Posted by Anshika Choudhary 3 years, 1 month ago

CBSE > Class 12 > Informatics Practices

2 answers

Anuj Kumar 3 years, 1 month ago

Available in app

2Thank You

Student Of The Year 3 years, 1 month ago

How

2Thank You

ANSWER

Write a program to create a series object that stores the initial budget allocated (50000/- each) for the four quarters of the year: Qtr1,Qtr2, Qtr3, Qtr4.

Posted by Fahsin Mohamed Ali 3 years, 2 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

video conferencing

Posted by A Verma 2 years, 10 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Preeti Dabral 2 years, 10 months ago

Video conferencing is a type of online meeting where two or more people engage in a live audio-visual call. With a strong internet connection, the participants can see, hear, and talk to each other in real time, no matter where in the world they are.

0Thank You

ANSWER

Delete syllabus of ip?

Posted by Siddhant Bhargav 3 years, 2 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Indu Singh 3 years, 2 months ago

Unit-1 Data handling using Pandas – II Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance. Data Frame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting. Handling missing values – dropping and filling. Importing/Exporting Data between MySQL database and Pandas. Data Visualization , pie chart, frequency polygon, box plot and scatter plot. : color, style (dashed, dotted), width; 4. Unit Wise syllabus ; Joining, Merging and Concatenation. Unit 2: Database Query using SQL Practical  Create a data frame based on ecommerce data and generate descriptive statistics (mean, median, mode, quartile, and variance)  Create a data frame for examination result and display row labels, column labels data types of each column and the dimensions  Filter out rows based on different criteria such as duplicate rows.  Find the sum of each column, or find the column with the lowest mean.  Locate the 3 largest values in a data frame.  Subtract the mean of a row from each element of the row in a Data Frame.  Replace all negative values in a data frame with a 0.  Replace all missing values in a data frame with a 999.  Importing and exporting data between pandas and CSV file  Importing and exporting data between pandas and MySQL database  5.3 Data Management  Create a new table (order ID, customer Name, and order Date) by joining two tables (orderID, customer ID, and order Date) and (customer ID, customer Name, contact Name, country).  Create a foreign key in one of the two tables mentioned above  Create a new table (name, date of birth) by joining two tables (student id, name) and (student id, date of birth). 5.4 Introduction to Computer Networks  Download, install and configure browser.

3Thank You

ANSWER

Define bar graph and how to use it as matploylip

Posted by Taibangsatpa Singh 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

2 answers

Akshali Mittal 2 years, 11 months ago

you have to write pl. bar() For horizontal view pl. barh() this is how you can use bar graph through matplotlib Definition Basically it is the graph to present the data in the forms of bars

0Thank You

Siddhant Bhargav 3 years, 2 months ago

I don't know

0Thank You

ANSWER

Will there will be old 2020 syllabus for ip for students who are giving compartment exam in 2021.

Posted by Chaman Rana 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Siddhant Bhargav 3 years ago

Nope man you are noob so lagy

0Thank You

ANSWER

Can anyone suggest something about project?

Posted by Arsh Singh 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Akshali Mittal 2 years, 11 months ago

You can make project on ATM system

0Thank You

Siddhant Bhargav 3 years, 2 months ago

You can pass some time by watching the sky

0Thank You

Aakash Roy 3 years, 3 months ago

You can make a data analysis project on government data and with MATLAB you can visualise it for graphical representation.

2Thank You

ANSWER

Can any one give me on which topic I should make a IP project ?

Posted by Pawan Sharma 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

3 answers

Akshali Mittal 2 years, 11 months ago

Atm system

0Thank You

Lol No 3 years, 1 month ago

Make it on coronavirus

0Thank You

Indu Singh 3 years, 2 months ago

Misuse of social sites

0Thank You

ANSWER

how to convert dataframe into csv file? how to convert csv file into dataframe?

Posted by Nidhi M 3 years, 3 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Aakash Roy 3 years, 3 months ago

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, 3 months ago

CBSE > Class 12 > Informatics Practices