SQL With SQUID GAME Concept

-

Hey,

I hope you'll know the squid game, lets apply the same concept on SQL for data manipulation.'










Comments

Post a Comment

Popular posts from this blog

Employees Salary Prediction Using Linear Regression - KNIME ANALYTICS PLATFORM

-
Image
Here I will be using the KNIME to forecast the employee's salaries with respect to their year of experience by training and testing data in ML using Linear Regression. Step 1 : Reading the data set with KNINE - File Reader Node 1                                         Step 2: Adding the data filter node to remove the Null Values Setting up the pattern match to N/A Step 3: Adding Node 2.1 Partitioning for Data sorting to Train & Test for Machine learning Algo. Here we set 70% of total data to Train & 30% to Test Step 4:  Training data for linear regression Note: After training the data, we have concluded that our model shows ~95% Accuracy , as we have selected the Random samples from the training data to maintain the efficiency of the model. Step 5: Adding the Linear Regression Node run Trained & Test Data Step 6: Once we have trained and tested data, we have got the ...
Read more

Docker

-
Image
  What is Docker ? Docker is a containerization platform that provides easy way to containerize your applications, which means, using Docker you can build container images, run the images to create containers and also push these containers to container registries such as Docker Hub, Quay.io and so on. In simple words, you can understand as  containerization is a concept or technology  and  Docker Implements Containerization . Docker Architecture ? The above picture, clearly indicates that Docker Deamon is brain of Docker. If Docker Deamon is killed, stops working for some reasons, Docker is brain dead :p (sarcasm intended). Docker LifeCycle We can use the above Image as reference to understand the lifecycle of Docker. There are three important things, docker build -> builds docker images from Dockerfile docker run -> runs container from docker images docker push -> push the container image to public/private regestries to share the docker images. Understandin...
Read more

Facebook Ad-Campaigns Analysis /Sales-Prediction - Project B - python

-
Image
In this project, I did Sales Conversion Optimization by analyzing  Facebook  ad campaigns Prediction using Random Forest Regressor Aim: To optimize Sales conversion and predict future sales. Approach:  Exploratory Data Analysis using matplotlib and seaborn and model training using  Random Forest Regressor. Importing Libraries import numpy as np import pandas as pd import os df=pd.read_csv("File/path.csv") df.head() df.info()   #Checking for null values  # Doing Exploratory Data Analysis df.shape (1143, 11) df . describe () import matplotlib.pyplot as plt import seaborn as sns Correlation Matrix : import matplotlib.pyplot as plt import seaborn as sns g=sns.heatmap(df[["Impressions","Clicks","Spent","Total_Conversion", "Approved_Conversion"]].corr(),annot=True ,fmt=".2f", cmap="coolwarm") # Here above it's clear, "Impressions" and "Total_Conversion" are more correlated...
Read more