Class 12th Practical paper-2 QUESTION Python Program Q 1 Write a program in python to create the following dataframe named “country” storing the following details: Considering the above dataframe...
Uncategorized
DATAFRAME PYTHON SOLUTIO….. i) Write the command to add one row: ‘May’ – 31 ii) Write the command to update Feb to 29 iii) Write the command to change index to...
MYSQL SOLUTION 1. Display the unique manufacturer from medicine Sol :- 2. Display manufacturer and total price for each manufacturer Sol :- 3. Display manufacturer and price in the...
PYTHON DATAFRAME SOLUTION ….. a) create above Data Frame “ved_medicines”b) Display medicines and its price.c) Display last 4 medicinesd) Display records of medicines whose price is more 20e) Draw...
MYSQL….. SOLUTION 1. Count and display employees post wise. Sol :- 2. Display 3 characters from 2nd place from the column ename. Sol :- 3. Display last 2 characters...
PYTHON PANDAS SOLUTION Considering the above dataframe answer the following queries by writing appropriate command in python pandas.i. Display Name, Post and Salary for all employees earning more than...
MYSQL…… SOLUTION 1. Display the name of week day when socks purchased. Sol :- 2. Display remainder after dividing price by qty Sol :- 3. Display the discount amount...
PYTHON SOLUTION ….. Considering the above dataframe answer the following question by writing appropriatecommand in python pandas: Display complete data for China and India. Display Country, Population and BirthRate...
MYSQL SOLUTION QUERY SOLUTION CREATE DATABASE CREATE TABLE STAFF and INSERT ALL THE RECORD. SOL1 :- Display the difference of maximum and minimum salary of each section. SOL2 :-...
DATAFRAME IN PANDAS SOLUTION….. Considering the above dataframe answer the following queries by writing appropriate command in python pandas. i. Add a new column named discount which is 10%...