Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

completed as per the instructions given and attached the excel sheet..

files attached...   samples of outputs also attached..                        

file submitted..

ENGILISH DICTIONARY APP: import json from difflib import get_close_matches import sys # i have created add function to add new words to the extisting file def Add(): f = open('words.txt','r+') # it opens the file in read and write mode words = json.load(f) # it converts the text file to python dictioanry format word =…

  EDA on VEHICLE INSURANCE DATA   A company has customer data that contains 8 columns of customer details and another table having name customer_policy data contains the policy details of the customer. The company intends to offer some discount in premium for certain customers. To do that they ask their Data…

Aim: Writing code in MATLAB to optimize the stalagmite function and to find the global maxima of the function             OBJECTIVE: Explanation of the concept of the genetic algorithm Explanation of the syntax of the genetic algorithm Plotting graphs for 3 cases and…

  AIM:  1). To write the MATLAB program that solves ordinary diferential equation of motion of a simple pendulum with damping. `(d^2 theta)/dt^2+(b/m)(d theta)/dt+(g/l)sintheta=0`          2). To write the MATLAB program that stimulates the pendulum motions. THEORY:  The motion of…

  % animating the kinematic manipulator % inputs l1=1; l2= 0.5; theta1= linspace(0,90,25); theta2= linspace(0,90,25); ct=1; for i= 1:length(theta1) A1= theta1(i); for j= 1:length(theta2) A2 = theta2(j); % defining cordinates x0=0; y0=0; x1= l1*cosd(A1); y1= l1*sind(A1); x2=x1+l2*cosd(A2); y2= y1+l2*sind(A2); % plotting…