Published in Towards Data Science·Jul 22Member-onlyPivot and Unpivot Functions in BigQuery For Better Data ManipulationA detailed tutorial — Pivot is a very simple function in BigQuery that can be very useful when you need to rotate rows into columns. It uses an aggregate function on rows and converts the categories in rows to columns. There is unpivot function that does totally an opposite operation. If you are a…Bigquery5 min read
Published in Towards AI·Jun 23Member-onlySome Simple But Advanced Styling in Python’s Matplotlib VisualizationAdding Some Extra Flavor to Your Python Plots — Matplotlib is arguably the most popular visualization library in Python. The library is big and it is hard to really learn everything in the library. I have shared quite a lot of plots, tricks, and tips to make nicer visuals in matplotlib. In this article, I want to share some…Data Analysis5 min read
Published in Towards Data Science·Jun 16Member-onlyLearn Precision, Recall, and F1 Score of Multiclass Classification in DepthManual calculation from a confusion matrix and the syntax of sklearn library — Precision, recall, and f1-score are very popular metrics in the evaluation of a classification algorithm. It is very easy to calculate them using libraries or packages nowadays. But I believe it is also important to understand what is going on behind the scene to really understand the output well. If…Data Science8 min read
Published in Towards AI·May 26Member-onlyComplete Detailed Tutorial on Linear Regression in Python for BeginnersLinear Regression Basic, Simple, and Multiple Linear Regression Implementation in Scikit-Learn — Linear regression is the most basic type of machine learning. It is based on the simple straight-line formula we have all learned in middle school. Though there are a lot of other more complicated and efficient machine learning algorithms out there, still it is a good idea to learn the…Data Science12 min read
Published in Towards Data Science·May 18Member-onlyComplete 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·May 13Member-onlyHow 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 6Member-onlyA 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. You can…Machine Learning6 min read
Published in Towards Data Science·May 3Member-only6 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. Otherwise, it…Data Science6 min read
Published in Towards AI·Apr 21Member-onlyHow 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 6Member-onlyAn Overview of the SQL Query Clauses and FunctionsCan be used as a cheat sheet — 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
