Published in Towards Data Science·17 hours agoComplete Explanation on SQL Joins and Unions With Examples in PostgreSQLAll the Commonly Used Types of Joins and Some Interesting Ones — This article will be a comprehensive guide for SQL unions and joins. A lot of time databases are designed in a way that joins and unions are essential. For convenience, data can be stored in several separate tables instead of having a big table. …Data Science12 min read
Published in Towards Data Science·5 days agoHow to Make Animated and Racing Bar Plots in PythonComplete Working Code — Bar plot is pretty basic and very common. All the plotting libraries have bar plot options for sure. This article will focus on the animated bar plot. I will share the code for some animated bar plots. If you haven’t seen them before, you may enjoy them. I tried to…Data Visualization8 min read
Published in Towards Data Science·May 6A Complete Guide for Detecting and Dealing with Outliers6 Methods to Detect the Outliers and 4 different methods to Deal with Them — Outliers can be a big problem in data analysis or machine learning. Only a few outliers can totally alter a machine learning algorithm's performance or totally ruin a visualization. So, it is important to detect outliers and deal with them carefully. Detecting Outliers Detecting outliers is not challenging at all. …Machine Learning6 min read
Published in Towards Data Science·May 36 Tips for Dealing With Null ValuesIncludes Iterative Method, Mean and Median Fill with Groupby, Mean and Median Fill — Null values are a big problem in machine learning and deep learning. If you are using sklearn, TensorFlow, or any other machine learning or deep learning packages, it is required to clean up null values before you pass your data to the machine learning or deep learning framework. …Data Science6 min read
Published in Towards AI·Apr 21How to Create and Use Multi-Index DataFrame to Scale Up Your Data AnalysisDetails of Multi-Index DataFrame: Create, Slice and Index, and Analyze — In most of the DataFrames, we see one index that works as a row identifier. But what if there is more than one index in a DataFrame. Is multi-index DataFrames a good thing for data analysis or confusing? Actually, it can be a very good data analysis, if you know…Data Science8 min read
Published in Towards AI·Apr 6An Overview of the SQL Query Clauses and FunctionsCan be used as a cheat sheet for SQL — SQL is probably the most widely used tool in the world of Data Science, Analysis, or Engineering. In most job postings SQL is one of the common requirements. There are a lot of tutorials and articles available as well. I decided to make a collection of SQL select queries, clauses…Data Science14 min read
Published in Towards Data Science·Mar 1720 Very Commonly Used Functions of PySpark RDDEach Function is Demonstrated with Clear Example — Apache Spark is very popular in Big Data Analytics. It uses a distributed processing system. PySpark is the interface for Apache Spark in Python. When you have a huge dataset of terabytes size, regular python code will be really slow. But a PySpark algorithm will be much faster. …Big Data11 min read
Published in Towards Data Science·Mar 5Regression in TensorFlow Using Both Sequential and Function APIsDemonstration of a Few Different Types of Model Structure — Tensorflow is arguably the most popular package in deep learning and the neural network domain. I wrote a few different tutorials before on Regular Dense Neural Networks, CNN structure, and RNNs. But all my tutorials on Tensorflow were on classification problems. Sometimes image classification and sometimes natural language classification.Data Science10 min read
Published in Towards Data Science·Feb 22Simple Explanation on How Decision Tree Algorithm Makes DecisionsIntuition Behind the Decision Tree Algorithm — The decision tree is a very popular machine learning algorithm. It works for both linear and non-linear data. Also, it can be used for both classification and regression. With great libraries and packages available in Python and R, anyone can easily use decision tree and other machine learning algorithms without…Machine Learning8 min read
Published in Towards Data Science·Feb 15Details of Violinplot and Relplot in SeabornUsing Violinplots and Relplots in Seaborn with Full Potential — Python’s Seaborn library is a very popular visualization library. It is built on Matplotlib and includes a lot of advanced plots with built-in styles. I have an article on Seaborn that covers the most popular plots (a link is provided at the end of this article). …Data Science8 min read
