Skip to content

September 2022

Remove Duplicates from a spreadsheet based on all or subset of columns | Google sheets/Excel | Python/Colab | Data Solution for beginners

– efficient & ready-to-execute for slow loading sheets in Pyhton / Google Colab Goal of this tutorial: efficient and simple removal of duplicates from spreadsheet data! In this tutorial and video, I show you how to remove duplicates such as in this data. Fast and actionable. Specially for bigger data where loading… Read More »Remove Duplicates from a spreadsheet based on all or subset of columns | Google sheets/Excel | Python/Colab | Data Solution for beginners

How to start r coding: packages installation in R, and an interactive chart example

Code available to download. A tutorial for beginners on how to start r coding scripts, installing R packages, and interactive chart visualization examples, Code available to download. Begin all your R scripts with this snippet! Automatically installing and load library… Read More »How to start r coding: packages installation in R, and an interactive chart example

A fast and simple way to slice spreadsheets data from Google Sheets or Excel – good solution for large data & non-technical professionals

Slide or filter an extract or subset of spreadsheet data using a simple and quick way for non-technical professionals – Using Excel or Google Sheets and python in google colab environment. No deep knowledge on coding or python required. No… Read More »A fast and simple way to slice spreadsheets data from Google Sheets or Excel – good solution for large data & non-technical professionals