Using OneDrive API to sync OneDrive files directly to your Python projects

We may already have this phrase “Data is the new oil”. And, we as data scientists work on the data science process — refining this new oil to be valuable and ready to use. The most fundamental step of the data science process is Data Storage. In this article, I am going to show an example of how to use Cloud technology as Data Storage.

OneDrive is one of the most efficient available cloud storage in terms of pricing and capacity. And, it is also very easy to get one. With the free version, you can use it You get…

Local 3D Model Streaming Service — Without Using ArcGIS Enterprise

3D Building Model of Stuttgart — Loading I3S Scene Layers Service in Unity3D (by Author)

In the recent Geo Data Science projects, the 3D geovisualization tool plays an important role in several application domains such as urban planning, indoor/outdoor pedestrian navigation, environmental simulations, cultural heritage, or facility management [1] In recent years, ESRI has developed I3S or indexed 3D scene layer which is the delivery format specification for scene layers. It aims to be used to represent different types of 3D data such as 3D building models, integrated mesh, point clouds, and much more. The advantage of I3S is its ability to stream large 3D datasets through the web with high performance and scalability. [2]…

No Ads | Flexible | Scalable — Using Google Cloud Free Tier & One-Click Installer.

Most websites on the internet are built using WordPress. It is one of the best CMS. As a beginner, you may try learning with to create a website and host with WordPress. However, the free site from always comes with annoying advertisements somewhere on your web. Of course, you won’t earn money from that. If you want to remove ads, then you have to subscribe to the service.

This article introduces how you can host WordPress for free. No ads. Allows plugins. Using Google Cloud Free Tier!

Step 1: Get Google Cloud Account


This step is pretty simple. Just register to Google…

A powerful hidden feature in macOS | No need for extra plugins.

Photo by Wesson Wang on Unsplash

Rename multiple files would cause a lot of pain to many people. Lucky for macOS users, that the batch renaming capabilities are integrated into Mac’s Finder. This article shows a short tutorial on how to do it which you can follow instantly.

Step 1: Select All Target Files to Rename.

Just open the Finder and browse to the location of your files. Select all files you want to rename and right-click and click on Rename…

Get Your Own Textured Building Model Anywhere In the World.

Why 3D Building Models? 🏨

Nowadays, the 3D texture building model plays a big role in a variety of application domains such as game development, urban planning, Smart Cities, indoor/outdoor pedestrian navigation, environmental simulations, real estate, cultural heritage, facility management, and much more. One of the main advantages of 3D models over 2D is that it gives a better impression and understanding of the area to the users, especially when the model comes with textures.

But it is expensive… 💰

However, generate building models with textures is always pricey. You need to get high-resolution images from drones/UAV/Satellites and do long post-processing. …


A Comprehensive Guide

Photo by Caspar Camille Rubin on Unsplash

This article is a very short tutorial for installing PostgreSQL 12/ PostGIS on the Ubuntu system. It is a production note which I initially wrote for myself to install PostgreSQL on several machines. The explanation is kept very short and straight to the result.

Step 1: Add and Install the PostgreSQL 12 via your terminal.

$ sudo apt update
$ sudo apt install postgresql-12 postgresql-client-12

Step 2: Test PostgreSQL + Assign password to postgres

$ systemctl status postgresql.service

CesiumJS Tutorial

Let’s add your favorite basemap to the 3D virtual globe

CesiumJS is an open-source JavaScript library for creating world-class 3D globes and maps with the best possible performance, precision, visual quality, and ease of use. If you are new to Cesium, please check the basic tutorial of Cesium from

This short article shows step-by-step on how to add Mapbox based-map to the CesiumJS web application. Let’s begin!

Step 1. Prepare Mapbox API Key

You can get the Mapbox API key by registering an account and get your access token from

Update Python Environments in 1 min with Conda.

Photo by Mathias Nevière on Unsplash

As some of you might face an issue cannot updating Sypder and other python modules to the latest. Sometimes, your anaconda navigator shows the outdated environment. In this article, I will show you an easy way to update your Spyder to the latest version.

Prerequisite: Conda or Miniconda or Anaconda installed. 🐍

1.) Open Terminal or Anaconda Prompt with the administrator right.

2.) Update your conda/anaconda to the latest version with the following commands:

// update conda
$ conda update conda
// Optionally, also update anaconda
$ conda update anaconda

3.) Update Spyder (or other Python environments)

// Update Spyder…

Using PyCountry Library. With An Example Use in CSSE COVID-19 Dataframe.

Photo by Juliana Kozoski on Unsplash

In data science projects, you may have a data table that contains country data like country name, country code, etc. But, different data sets usually provide data in different country data formats or attributes; for example, “Germany” can be recorded as “GER”, “Germany”, “DE”, “Federal Republic of Germany”, country code — 276, etc.). This would cause you some difficulties to join tables, data aggregation, data analysis, or data visualization.

This article introduces PyCountry, a Python library for completing the country data from the country database to ready your dataset to be matched or aggregated to others.

Let’s get started~



An Example Use of Python for Beginner.

Photo by Amanda Jones on Unsplash

This short article will guide you how you can convert the .docx word document to the simple web page document (.html) or Markdown document (.md) in an easy way with some help of Python-based CLI — Mammoth.

According to the statistic from Statista survey (Jan 6, 2020), the Microsoft Office Suite is the most popular office software. You can easily take a quick note, short report, tutorial document, etc. with the Microsoft Word. And, you might want to share the document content with some of your friends, colleagues, clients as a web document (.html)) or Markdown document (.md). In the…

Joe T. Santhanavanich

Ph.D. Candidate in GeoSciences TU Dresden. LinkedIn:

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store