Part – 1 Python with IP
1. WAP in Python to plot a quadratic equation using dashed Line Chart.
2. WAP in Python to plot frequency of marks using Line Chart
Marks=[50,40,50,65,65,75,75,80,80,90,90,90]
3. WAP in Python to compare the sugar levels among men and women in a city using histogram.
Men:[113,85,90,150,149,88,93,115,135,80,77,82,129]
Women:[67,98,120,133,150,84,69,89,79,120,112,100]
5. WAPin Python to create a bar chart by using multiple x values on the same chartfor men and women.
men: (22,30,35,35,26)
women: (25,32,30,35,29)
6. First 10 terms of Fibonacci series are stored in a list namely fib:
fib = [0, 1, 1, 2, 3, 5, 8, 13, 21, 34]
Write a program to plot Fibonacci terms and their square-roots with two separate lines on the same plot.
(a) Series should be plotted as a cyan line with ‘o’ markers having size as 5 and edge-color as red.
(b) The square-root series should be plotted as a black line with ‘+’ markers having size as 7 and edge-color as red.
[0, -1, -1, -2, -3, -5, -8, -13, -21, -34, 0, 1, 1, 2, 3, 5, 8, 13, 21, 34]
Write a program to plot nfib with following specifications:
(a) The line color should be magenta
(b) The marker edge color should be black with size 5
(c) Grid should be displayed
8. Write a program to plot a bar chart from the medals won by the four countries. Make sure that bars are separately visible.
Country | Gold | Silver | Bronze | Total |
India | 26 | 20 | 20 | 66 |
Australia | 80 | 59 | 59 | 198 |
England | 45 | 45 | 46 | 136 |
Canada | 10 | 12 | 14 | 36 |
9. Create a Series using dictionary.
10. Create a data frame using dictionary.
11. WAP in Python to sort the pandas DataFrame on the basis of a single column in ascending order.
12. Create a Series and access the top 2 and last 2 elements using head() and tail() methods.
13. WAP to perform mathematical operation addition, subtraction and multiplication on two series.
14. WAP to show indexes and axes of a DataFrame.
15. WAP to represent size and shape of the DataFrame.
16. WAP to transpose the values of index and columns in a DataFrame.
18. Consider the saleDf shown below.
| Target | Sales |
ZoneA | 56000 | 58000 |
ZoneB | 70000 | 68000 |
ZoneC | 75000 | 78000 |
ZoneD | 60000 | 61000 |
SQL Practical
1. Shiva, a student of class XII, created a table “CLASS”. Grade is one of the columns of this table. Write the SQL query to find the details of students whose grade have not been entered.
2. Shiva is using a table with the following details:
Students(Name, Class, Stream_id, Stream_Name)
Write the SQL query to display the names of students who have not been assigned any stream or have been assigned Stream_Name that end with “computers”
3. Write the difference between drop, delete and truncate command with example.
4. Write the sort notes on group by, having and where clause with example.
5. Write the SQL query to find out the square root of 26.
6. Shiva is using a table employee. It hasfollowing details: Employee(Code, Name, Salary, DeptCode). Write the SQL queryto display maximum salary department wise.
7. Write the SQL Query to display the difference of highest and lowest salary of each department having maximum salary greater than 4000.
8. Write the SQL Query to increase 20% salary ofthe employee whose experience is more than 5 year of the table Emp(id, name, salary,exp)
9. Write the SQL Query for inner join of two tables Emp(eid, ename,salary,dept_id) and Dept(dept_id, dname)
10. Write the SQL Query for full outer join of two tables Emp(eid, ename,salary,dept_id) and Dept(dept_id, dname)
11. Write a SQL to Enter 5 Employee data in a single query in the table Emp (eid, ename, salary, city, dob).
12. Display 4 characters extracted from 5th right character onwards from string ‘ABCDEFG’.
13. Write a query to create a string from the ASCII values 65, 67.3, ‘68.3’
14. Display names ‘MR. MODI’ and ‘MR. Sharma’ into lowercase.
15. How many characters are there in string ‘CANDIDE’.
No comments:
Post a Comment