Skip to content

Python related tutorials

Python

How to determine if a coordinate locates within any distance from a reference point such as center of city – Python

Simple code project in Python GIS tutorial Use-Case:  I wanted to create consistency and customization in how geographical units such as city is defined in my data. I have a set of observation with their address coordinates within different cities… Read More »How to determine if a coordinate locates within any distance from a reference point such as center of city – Python

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

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