Published in Towards AI·Jun 23Some 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. …Data Analysis5 min read
Published in Towards Data Science·Jun 16Learn 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 26Complete 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 18Complete 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 13How 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. Otherwise, it…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 — 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
