Sunday, March 29, 2020

10 most frequently used "Command Line" commands

›
Here below are my 10 most frequently used "Command Line" commands. There are hundreds of commands to use depending on your oper...
Friday, March 27, 2020

Pandas dataFrame - Compare two rows and keep one if condition is met

›
Here I have two columns 'A' and 'B', I want to keep the row where the cell value in column 'A' is less than the corr...
Monday, March 16, 2020

Understanding Spatial Database From Scratch In Open Source Software (QGIS)

›
Understanding Spatial Database From Scratch In Open Source Software (QGIS) Location enabled applications are very common nowadays and ma...
Saturday, March 14, 2020

ArcMap - Create a curve as part of polygon with straight sides

›
It is very common to create polygons with all sides perfectly joined by straight lines. And chances are you are already familiar with digi...
Sunday, March 8, 2020

Python Pandas - Group by common values in a column and save to excel

›
I was working with a big dataframe containing states and their LGAs and wards as seen below;- Now, my client want to have data for ea...
Saturday, March 7, 2020

ArcMap - Streaming and Freehand Digitizing

›
ArcGIS has an excellent digitizing feature where you can digitize or create lines and polygons without clicking at every vertex. This is ...
Wednesday, February 26, 2020

Check if email contains double "@" character

›
An email that is correctly written should contain just a single '@' string. Here I have a scenario where am working on over 18,000 e...
Monday, February 10, 2020

Javascript program - Split array of numbers into two (numbers less than 12 and numbers greater than 12)

›
Javascript -  Split array of numbers into two... This JS code will return (lessThan_12) for numbers less than 12 from the given array of n...
Sunday, February 9, 2020

JavaScript Program - what year will age be 100 years old?

›
This will be a simple javascript program that uses HTML form to ask users to enter their name and their age. Then it will evaluate the age a...
Tuesday, February 4, 2020

Working with GeoJSON and GeoPandas

›
GeoJSON is an extension of regular JSON data structure that supports geographic/geometry types, such as: Point, LineString, Polygon, Mult...