Performance matters more as the data size increases. I admire Pandas. It’s one of the first tools I learned in my data science journey and I have been using it frequently ever since. Pandas was the only tool I needed to do data cleaning, manipulation, and analysis until I had…

And when to use which — Pandas is a highly efficient data analysis and manipulation analysis library for Python. Considering the dominance of Python in data science and the amount of data cleaning, manipulation, and analysis work, Pandas is one of the most widely-used tools in the field of data science. I have been using Pandas…

Without having to install anything. — If you work in the field of data science, regardless of the job title or position, SQL is one of the most important skills you need to have. I would put it in the top 3 along with Python. When I first started learning data science, I found it a…

Tips for increasing the efficiency — Pandas is one of the most frequently used tools in the data science ecosystem. It makes it quite easy to manipulate and analyze tabular data by providing numerous functions with an easy-to-understand syntax. While Pandas is on top of the competition in data analysis and manipulation, its performance starts to…

A step-by-step tutorial with gspread and pandas-datareader — Google Sheets is a cloud-based spreadsheet program included in the Google Docs Editors suite. It’s free and all you need to use Google Sheets is a Google account. I have been using it for a few years and never felt the need to use Microsoft Excel in this period. In…

A great helper for debugging — We rarely get a script running without any errors on the first try, which is absolutely normal when writing code. The important and sometimes challenging part is to fix these errors. The process of fixing the errors and making the script work as expected can take many iterations depending on…

Help the algorithm by making the data proper — Data preprocessing is a fundamental step in a machine learning pipeline. It depends on the algorithm being used but, in general, we cannot or should not expect algorithms to perform well with the raw data. Even well-structured models might fail to produce acceptable results if the raw data is not…

List is a core data structure for Python — Data structures are of great importance for any programming language because how you store, access, and manage data is one of the key factors in designing efficient programs. Python has 4 built-in data structures: List Set Tuple Dictionary List is represented as a collection of data points in square brackets…