Discover and read the best of Twitter Threads about #DataCleaningchallenge
Most recents (5)
" SQL Interview problem "
🧵
🧵
This is a REAL SQL Interview question that might seem impossible to solve just by using SQL at first. But during the video the problem by breaking it into multiple parts
#SQL #DataScience #DataCleaningchallenge #DataAnalytics #dataviz #MachineLearning #deeplearning
#SQL #DataScience #DataCleaningchallenge #DataAnalytics #dataviz #MachineLearning #deeplearning
Youtube Video Link -
" SQL Puzzle Interview Question "
🧵
🧵
Table script:
create table input (
id int,
formula varchar(10),
value int
)
insert into input values (1,'1+4',10),(2,'2+1',5),(3,'3-2',40),(4,'4-1',20);
create table input (
id int,
formula varchar(10),
value int
)
insert into input values (1,'1+4',10),(2,'2+1',5),(3,'3-2',40),(4,'4-1',20);
" Exploratory Data Analysis on Terrorism "
🧵
🧵
We are performed Exploratory Data Analysis on terrorism #dataset to find out the hot zone of #terrorism. #EDA nothing but #analyzing the given data & finding the #trends, patterns & making some assumptions. #DataVisualization #DataScience #MachineLearning
In this #dataset, there are many features including countries, states, regions, gang names, weapon types, target types, years, months, days, and many more features.
The model will not perform well if training data is small, or noisy with errors outlier or if #data is not representative consist of irrelevant feature(garbage in garbage out) lastly neither too simple(result in #underfitting) nor too complex(results in #overfitting
#DataScience
#DataScience
Not enough training data.
Poor Quality of data.
Irrelevant features.
Nonrepresentative training data.
Overfitting and Underfitting.
#DataCleaningchallenge #MachineLearning #Deeplearning #DataAnalytics #DataVisualization #Python #Powerbi #SQL #MYSQL
analyticsvidhya.com/blog/2021/06/5…
Poor Quality of data.
Irrelevant features.
Nonrepresentative training data.
Overfitting and Underfitting.
#DataCleaningchallenge #MachineLearning #Deeplearning #DataAnalytics #DataVisualization #Python #Powerbi #SQL #MYSQL
analyticsvidhya.com/blog/2021/06/5…
Top 25 SQL Interview Questions and Answers
🧵
🧵
There are certain SQL concepts which you should be familiar with if you plan to attend an #SQL interview. No matter which RDBMS you use wether it is MySQL, Oracle, Microsoft SQL Server, #PostgreSQL or any other, these SQL concepts are common for all of the popular RDBMS.
