Hello friends...

Do you know..!!! SQL has some powerful commands that changes the way of what we actually think of SQL.

These commands are known Windows Functions.

"Windows Functions in SQL" https://quickdatascienceds.blogspot.com/2021/10/windows-functions-in-sql.html?m=1

Please like share and subscribe to our channel for being updated on Data Science and related technologies.

Thanks Team QDS.

Hello friends...

We are often mislead in our analysis by introduction of few outliers, their presence can change the entire analysis... One easy to deal with them is..

"Trimming the Outliers" https://quickdatascienceds.blogspot.com/2021/09/trimming-outliers.html?m=1

Please read, like, share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hiiiii.....

We may use more and more powerful hard drives, RAMs, GPU, CPU.. etc etc. But we might still not get a fast performance when we start working with Big Data... This is due to the improper db and table structure.

To achieve a better performance we need to properly index our tables.

So let's learn about "Indexes in SQL" https://quickdatascienceds.blogspot.com/2021/10/indexes-in-sql.html?m=1


Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hello friends...

We are pleased to announce that we are launching a new series "Quick Reads" covering some of very important topics in very compact and easy-to-remember manner.

So bringing the first topic in this QUICK READS:-

"Encoding" -- way to convert non numerical variables into numerical variables.
https://quickdatascienceds.blogspot.com/2021/10/encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Feel free to post your queries and we will answer them ASAP.

Thanks Team QDS

Hello DS enthusiasts...

Bringing to you another important Quick Read -- Count Frequency Encoding.

A technique used in categorical variable encoding...

"Count Frequency Encoding" https://quickdatascienceds.blogspot.com/2021/10/count-frequency-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies. https://t.me/quickdatascience

Feel free to post your queries and we will answer them ASAP.

Thanks Team QDS

Hello friends....

Another technique that is most commonly used in categorical variables encoding is...

"Mean Encoding or Target Encoding" https://quickdatascienceds.blogspot.com/2021/10/mean-encoding-or-target-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.
https://t.me/quickdatascience

Feel free to post your queries and we will answer them ASAP.

Thanks Team QDS

Hello...

One hot encoding... We all have heard this name many times...

Let's have a look at what it is.. and how to work with it.

"One Hot Encoding" https://quickdatascienceds.blogspot.com/2021/10/one-hot-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Feel free to connect with us..

Thanks Team QDS

Hello friends...

Another topic in our series of Quick Reads - Encoding.

"Ordinal Encoding" https://quickdatascienceds.blogspot.com/2021/10/ordinal-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Feel free to connect with us...

Thanks Team QDS

Hello...

What to do in case you have too many values in a variable..!!!

Let's see a technique we can use to encode such variables..

"Rare Label Encoding" https://quickdatascienceds.blogspot.com/2021/10/rare-label-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Feel free to connect with us...

Thanks Team QDS

Hello friends...

Still not clear to how to encode your variables..!!!

Let system decide...

"Decision Tree Encoding" https://quickdatascienceds.blogspot.com/2021/10/decision-tree-encoding.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Feel free to connect with us

Thanks Team QDS

Wishing you all a very happy dhanteras... 😊

Wishing you all a very Happy Diwali😊

Hello friends...

Time to get back on track...

Bringing you our first full practical article...

Studying and analysing the Netflix Data.

"Data Visualization — Netflix Data Set" https://quickdatascienceds.blogspot.com/2021/11/data-visualization-netflix-data-set.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hello...

Hope you liked our Netflix Data Analysis..

We bring to you our next most loved topic IPL - Indian Premier League Analysis and see what we can get more insights we can get.

"Data Visualization — IPL Data Set (Part 1)" https://quickdatascienceds.blogspot.com/2021/11/data-visualization-ipl-data-set-part-1.html?m=1

It would be pleasure to hear from you all... Do share your views in our comment section and let's interact.

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hello...

Hope you enjoyed IPL data Analysis.... But we have more of it waiting for you in Part 2...

"Data Visualization — IPL Data Set (Part 2)" https://quickdatascienceds.blogspot.com/2021/11/data-visualization-ipl-data-set-part-2.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hello friends...

Another topic that we would like to present in our QUICK READS is another important technique that is used in data pre processing...

"Discretisation" https://quickdatascienceds.blogspot.com/2021/11/discretisation.html?m=1

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thank Team QDS

Hello friends.

We studied about Discretisation or binning.. but we haven't seen any method how to perform this binning...

Presenting first technique used for binning...

"Discretisation -- Equal Widths" https://quickdatascienceds.blogspot.com/2021/11/discretisation-equal-widths.html

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thank Team QDS

Hello friends...

Another technique used for Discretisation or binning is...

"Discretisation -- Equal Frequency" https://quickdatascienceds.blogspot.com/2021/11/discretisation-equal-frequency.html

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Thanks Team QDS

Hello friends...

We know about decision trees... But have you ever thought we could it for binning proces...!!!

No...!!!

Let's learn about it here in more detail...

"Discretisation -- Decision Tree" https://quickdatascienceds.blogspot.com/2021/11/discretisation-decision-tree.html

Please like share and subscribe our channel for being updated on Data Science and related technologies.

Team QDS

Hello friends...

Sorry for being away from a long time... Was busy with some personal engagements...

Nevertheless... We are back on track...

To start afresh we are here to bring you a new topic Feature Scaling.

"Feature Scaling" https://quickdatascienceds.blogspot.com/2022/02/feature-scaling.html

Please like share and subscribe our channel for being updated on Data science and related technologies.