Spreadsheet related tutorials
Particular useful for non-technical professionals or beginners. What are different types of marges for data tables and how we can apply them on any data tables or sheets, for example on excel or google sheets files Use-case: A tutorial for… Read More »Step-by-step Data Table Merging or Cross Referencing Tutorial for Beginners – covering all types of merges
– simple code win in Python GIS tutorial Use-case: Sort a tabular data based on one or multiple columns using a simple and accessible python method. Specially useful for less technical background who may deal with a spreadsheet in excel… Read More »Sorting spreadsheets based on one or multiple columns – quick solution for slow loading sheets in excel or google sheets
– 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
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
How to load Google Sheets in Python / Google Colab and save data into Google Sheet spreadsheets using Python in Colab environment. Providing a downloadable template solution and step by step tutorial for beginners regardless of previous knowledge on programming.… Read More »How to load & save data to Google Sheets in Python using Google Colab
How to load Google Drive in Python / Google Colab and save data into Google Drive using Python in Colab environment. Providing a downloadable template solution and step by step tutorial for beginners regardless of previous knowledge on programming. In… Read More »How to load & save data to Google Drive in Python / Google Colab