''' 1A: English Dictionary App This project uses the skills learnt from week 1 to week 6. The aim of this project is to create an English Dictionary app that returns definitions of English words. This project uses the skills learnt from week 1 to week 6.  The aim of this project is to create…

''' 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 scientist team to get some information.…

/* Business model Customer to Customer (C2C) allows customers to do business with each other. This model is growing fast with e-commerce platforms where sellers may be required to pay some amount and buyer can buy it without paying anything. E-Commerce website brings the seller and buyer to the same platform. Analyzing…

######################################## Q-1 ###################################/* Q1. Create new schema as alumni*/ create database if not exists alumni;   use alumni;   ##################################### Q - 2 #################################### /* Import all .csv files into MySQL */ # Answer --> In…

  Answer :::      Project - Click Here   https://public.tableau.com/views/Project-1_16609858542460/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link    

    Click Here - Literacy Rate in TamilNadu by Abhishek Kumar   

Answer in .ipynb file

answers in .ipynb                            

ALL ANSWERS IN .xlsx FILE + SCREENSHOTS                      

            https://1drv.ms/x/s!AqO_gHz8bg-pogQ9iLuqiQn1T6j3?e=ZJZaLN Click me for Project 2 .xlsx               Q. Features of Dashboard Ans: Please Scroll down to the data file...     Q. Separate Worksheet Required for Ans: In Separate Worksheets   Q.  Create a Macro for Data Formatting (Conditional Formatting, Freezing…

Click for the dashboard    https://app.powerbi.com/groups/me/dashboards/19da2fd0-4513-46c8-9c56-ec03f65ffa64?ctid=e5aae375-9070-43ba-b47f-b4ea3b346865&pbi_source=linkShare      Project  On    COVID-19 Vaccinations Trend Analysis         By      …

 datasets -  Datasets       https://www.kaggle.com/datasets/arashnic/taxi-pricing-with-mobility-analytics   https://app.powerbi.com/groups/ffa537f1-19a7-4f39-9799-86638fba9762/dashboards/2c8e3e89-43ef-4121-934d-003bab6ed85c?ctid=e5aae375-9070-43ba-b47f-b4ea3b346865&pbi_source=linkShare                                 By…

Question-  Why there is a difference in the formula of variance for population and sample Answer- When we use N instead of N-1, we have an error called statistical bias, which means that the sample variance is systematically different from the true population parameter.   If we repeat this process many times…

Question 1-  Perform Gradient Descent in Python with any loss function Answer- Answer in .ipynb file and in screenshots   Question 2- Difference between L1 & L2 Gradient descent method Answer-    ->L1 Regularization, also called a lasso regression, adds the “absolute value of magnitude” of the coefficient as a penalty…

Question1. Pros and cons of SVM Answer: Pros and Cons associated with SVM Pros: It works really well with a clear margin of separation It is effective in high dimensional spaces. It is effective in cases where the number of dimensions is greater than the number of samples. It uses a subset of training points in the decision…

Q1. Apply knn to the “Surface defects in stainless steel plates” and identify the differences Ans: In .ipynb file 2) What are the pros and cons of knn Pros : No training period required hence also called as lazy learning algorithm Easy to implement Many new data can be added without any changes to the…

Question1. What is a Neural Network? A neural network is a method in artificial intelligence that teaches computers to process data in a way that is inspired by the human brain. It is a type of machine learning process, called deep learning, that uses interconnected nodes or neurons in a layered structure that resembles…

Question1. How does similarity is calculated if data is categorical in nature similarity in categorical data is not as direct when itcomes to numerical data. the categorical data is first tranformed to numerical values and both are standardised to make sense of the similarity and dissimilarity between/among those features.…

In .ipynb file

 The steps we are going to follow in this case are: Selecting the right attributes. Finding the optimum value of K using Elbow method. Implementing K-Means algorithm. 1. Selecting the right Attribute: Importing the necessary libraries. import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn…

Q.1:- Please find the attached images for the answer Q.2:- Expected value is used when we want to calculate the mean of a probability distribution. This represents the average value we expect to occur before collecting any data. Mean is typically used when we want to calculate the average value of a given sample. This…