A single function for all your needs. Testing is a fundamental part of any software. Without a thorough testing process, no software product is deployed into production. Data analytics products also require testing. Let’s say you’re building a forecasting engine. No one can or should rely on the output of…

How to efficiently make your data ready-to-use — Those who have worked on real-life tasks with real-life data know that the bigger slice of pie belongs to data wrangling. What I mean by data wrangling covers operations done to make the data ready for other stakeholders or downstream processes. Whether you are a data analyst, data scientist, or…

A fundamental piece in data cleaning Python and R are the two key players in the data science ecosystem. While R is not as popular as Python, it is just as efficient and capable as R doing data manipulation and analysis, and even outperforms Python in some cases. In this…

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…