Project 2 - EDA on Vehicle Insurance Customer Data

Project Documentation: Optimizing Team Hiring Insights through Data Cleaning and TransformationIntroductionIn today's data-driven environment, businesses thrive on informed decision-making. At ABC Private Limited, a manufacturer and seller of diverse products ranging from Classic Cars to Trucks and Buses, understanding…

Project Documentation: Alumni Career Choices AnalysisAimThe aim of this project is to analyze the career choices of alumni from two universities with respect to their passing year and the courses they completed. This analysis helps in understanding the career growth of alumni, which plays a crucial role in the institute's…

From the series of queries and actions conducted on the `ecommerce` database, several insights can be derived regarding the user demographics and their activities on the platform. Firstly, the database contains information about users' demographics, such as their gender, country, language, and usage of applications like…

EDA on Vehicle Insurance Customer Data Aim: The aim of this project is to perform exploratory data analysis (EDA) and data cleaning on two datasets containing customer details and policy details. The objective is to prepare the data for future analysis and modeling, identify patterns, and derive insights to aid business…

English Dictionary Project   Overview:   The English Dictionary project is a simple command-line application that allows users to add words, find their meanings, and update their meanings. The words and their meanings are stored in a dictionary.   Library Book Management System : The Library Book Management System is a simple application developed using Python's Tkinter library and SQLite database. It provides basic functionalities to manage a library's book inventory, including adding new books, searching for books, issuing books, deleting books, and updating book information.

2D meshing and pre-processing for Car hood Metal Sheet   OBJECTIVE:- Starting with the given Component (in 3D) of Automobile Car Hood, Performing Geometry clean-up and after Generating the Mid-Surface of the Model, then proceeding with Meshing of the Components under the Quality Criteria to meet the requirement of…

AIM: To create a 3D model of a flow bench and run flow analysis. OBJECTIVES : To obtain a plot of valve lift versus mass flow rate. Find the effect of valve lift on the mass flow rate. To run a parametric study for various valve lift. INTRODUCTION :  An airflow bench is a device used for testing…

AIM : To find out the critical frequencies of a rotating shaft in Solidworks. OBJECTIVES : To create 3D model of a rotating shaft. To perform frequency analysis on the rotating shaft and find out the critical frequencies. INTRODUCTION : For a rotating shaft there is a speed at which, for any…

AIM:  To simulate the transient behavior of a simple pendulum and to create an animation of it's motion. OBJECTIVE :  To write a program in Python that solves the second-order ODE corresponding to the motion of a simple pendulum and to plot its angular displacement and angular velocity wrt time. To…

AIM :  To model the flow over an airfoil for various angle of attacks. OBJECTIVES : To model the flow over an airfoil which can be obtained from here - airfoil data To compare the lift and drag forces for the angle of attacks 0,2,4,6,8,10 degrees. INTRODUCTION : An airfoil is…

AIM:  To write a program in Python to solve an Otto cycle and make plots for it. OBJECTIVE : To solve and find out different state variables in the Otto cycle and plot its a p-V diagram. To calculate the thermal efficiency of the given Otto cycle. THEORY: The Otto cycle is the perfect cycle for sparkle…

AIM: To design and analyze a Centrifugal Pump. OBJECTIVES : To create a 3D model of a centrifugal pump. To obtain the relationship between Pressure ratio and mass flow rate using a Performance diagram. THEORY: Centrifugal Pumps are the most popular and commonly used type of pump for the transfer of…

AIM: To write a script that does data analysis on python. OBJECTIVE : Visualizing the data, i.e., to plot a graph between any two quantities according to the user's input. Compatibility Check, i.e., code should exit gracefully, if a non-compatible file is provided as an input. To calculate basic engine performance…

AIM : To write codes in Python to perform curve fitting. OBJECTIVE :  To wite codes to fit a linear and cubic polynomial for the Cp data. To plot the linear and cubic fit curves along with the raw data points. To measure the fitness characteristics for both the curves. THEORY : Curve fitting…

AIM : To simulate the transient state flow over a cylinder. OBJECTIVES : To run a baseline simulation and then calculate the Reynolds number.  To increase the Reynolds number by a factor of 20%, 40%, and 100% then run the transient flow simulation. INTRODUCTION :  Steady State Transient…

    Aim  :- To compute the Performance parameter of Heat Exchanger using Epsilon-NTU method.   OBJECTIVE : ·       To calculate Effectiveness, based upon NTU(No. of transfer unit), and Capacity rate ratio(Crr). ·       To…

Robot’s Manipulator Kinematic Study and Workspace Visualization. AIM: To visualize the simulation to analyze. To have understanding of workspace with the help of kinematics study of Manipulator (2d). GOVERNING EQUATIONS IF ANY: - The transformation matrix T for the end-effector with respect to the coordinate frame…

AIM : -To write a program in MATLAB for parsing NASA thermodynamics data. OBJECTIVE : 1.      Making of a MATLAB code to extracts 14 coefficients by reading NASA Polynomial format as a .dat file. 2.      From the given DATA file calculating Molecular weight of each species…

AIM : To create a Rankine Cycle Simulator using MATLAB. OBJECTIVE : To calculate the state points of the Rankine Cycle based on user inputs.  To plot the corresponding T-s and h-s plots for the given set of inputs. THEORY :-               …

AIM : To model the Valve Train components for IC Engine and assemble than to get the simulations in Solidworks According to the Following cases. OBJECTIVES : To get results while performing Motion study simulations for different cam heights. S.No. CAM lift (mm) Speed (RPM) Material 1. 3.5 1500 Cast Carbon…

Multi-Body Analysis On Piston Assembly   AIM :-  To Model Piston-Assembly  and then assemble them in SolidWorks. The motion analysis Of the Piston-Assembly is carried out in three different Offset cases.. OBJECTIVE :- To create 3D model of different components of piston assembly, To run motion study analysis…

  AIM :- To design and run the simulation of Planetary Gear train using SolidWorks. Obejective : - ·        To create internal ring gear with following properties - Module = 2.5 (ANSI METRIC must be used while selecting Gear train). Number of teeth = 46 ·       …

AIM : - Simulate Multibody Dynamics of Internal Geneva Mechanism using SOLIDWORKS.   OBJECTIVE : -   Create cad models of Internal Geneva Mechanism in SOLIDWORKS Create an assembly of Internal Geneva Mechanism in SOLIDWORKS Simulate Multibody Dynamics of Internal Geneva Mechanism using SOLIDWORKS at…

AIM Write a program to suit a linear and cubic polynomial for the Cp data and measure the fitness characteristics for both the curves. OBJECTIVES ·       A MATLAB code to suit a Linear and Cubic Polynomial for the given DATA, ·       Plot the comparison…

SIMPLE PENDULUM A pendulum is a weight suspended from a pivot so that it can swing freely. When a pendulum is displaced sideways from its resting, equilibrium position, it is subject to a restoring force due to gravity that will accelerate it back toward the equilibrium position. The second order ODE use the following…

AIM: Derivation of PV diagram using MATLAB Code and also calculating the Thermal Efficiency of the cycle GOVERNING EQUATIONS IF ANY:  Ideal Gas Equation PV =mRT where : - P –Absolute Pressure (in Pa)                       …