INDEX
[Link]. Experiment Page No.
1. Write a program using Advance Excel : 2-3
a) Create a excel sheet taking 10 inputs of employee’s
name and salary and then by using formula, calculate the
insurance (taking 3percent of the salary of the
employees having salary greater than 20,000, 0
otherwise).
b) for the same inputs from above excel sheet add a
column of Provident Fund and calculate it by using
suitable formula (12% of the salary of the employees
having salary greater than 15,000 and constant value of
1,800 for the employees having salary less than 15,000.
2. Write a Python program to demonstrate arithmetic 4-5
operators.
3. Write a Program to demonstrate for loop in Python. 6-7
4. Write a Python Program to Demonstrate Functions with 8-9
User Input.
5. Write a python program for Grade System using if-elif- 10-11
else with User Input.
6. Write a Python Program to Demonstrate Exception 12-13
Handling.
7. Write a Python Program to Demonstrate Data Types. 14-15
8. Write a program for Methods of NumPy library in 16-17
python.
9. Write a program to Demonstrate Pandas DataFrame. 18-19
10. Write a program to Demonstrate Pandas Series with 20-21
visible input data.
11. Write a program for Quartile Deviation in Data Science. 22-23
12. Write a program to Calculating standard deviation for 24-25
each dataset.
13. Write a program to explain scatter () function in 26-27
matplotlib library.
14. Write a program to explain the Matplotlib line chart. 28-29
15. Write a program to explain the Matplotlib Bar chart. 30-31
16. Write a program to explain the Matplotlib Histogram. 32-33
17. 34-35
Write a program to explain the Matplotlib pie chart.
18. Plot a line graph showing the relationship between 36-37
average pulse and calorie burn.
19. Write the Program to remove missing values from the 38-41
datasets in Data Science.
20. Write a program using Regression in scikit-learn. 42-43
21. Write a program for Clustering using K-Means in scikit- 44-45
learn.
22. Write a Python program for NAIVE BAYES 46-47
CLASSIFICATION using scikit-learn.
23. Write a Python program for SUPPORT VECTOR 48-49
MACHINES (SVM) using scikit-learn.
24. Write a Python program for PERFORMANCE ANALYSIS & 50-51
BENCHMARKING.