Original article: https://blog.petehouston.com/complete-apache-hadoop-troubleshooting/ Note: at the time of this writing, Apache Hadoop 3.2.1 is the latest version, I will use it as a standard version for troubleshooting, therefore, some solutions might not work with prior versions. Question 1: How to install Apache Hadoop version 3 and above on Mac? Try to following my complete guide to install and configure Apache Hadoop on Mac.

We will discuss about geographic calculation in this article, and that will be how to calculate distance of two locations on Earth using Python. Is it really possible? The answer is “YES“, not 100% accurate but pretty close, good enough to use for your apps. Original article: https://blog.petehouston.com/calculate-distance-of-two-locations-on-earth/ Mathematical Formula In facts…

If you know what geocoding is and want to start building your own geocoding databases, I will show you how to build geocoding databases in this article. Original article: https://blog.petehouston.com/build-geocoding-databases/ To make a geocoding database, you will need a data source. …

This article is an introduction to Geocoding, basis about geocoding and solutions related to geocoding for your business and product development. Original article: https://blog.petehouston.com/introduction-to-geocoding/ Geocoding For your information, geocoding is a process that converts addresses into geographic coordinates on this planet, Earth. Usually, the coordinate consists of two values: longitude

This is a coding tip article. I will show you how to download files with progress in Python. The sauce here is to make use of the wget module. Original article: https://blog.petehouston.com/download-files-with-progress-in-python/ First, install the module into the environment. $ pip install wget The wget module is pretty straight-forward, only…

Do you feel stuck in removing data from DataFrame in pandas? If you do, read this article, I will show you how to drop columns of DataFrame in pandas step-by-step. Original article: https://blog.petehouston.com/drop-columns-of-dataframe-in-pandas/ In order to start the tutorial, let’s use following simple dataset to manipulate. id,name,job,score 1,'Pete Houston','Software Engineer',92 2,'John Wick','Assassin',95 3,'Bruce…

In order to improve data searching, we always need to create indexes for data lookup purpose. I will show you how to set index for DataFrame in pandas. Original article: https://blog.petehouston.com/set-index-for-dataframe-in-pandas/ To get started, I will use the following data set, or you could use any dataset you have to…

In this post, we will discuss about how to read CSV file using pandas, an awesome library to deal with data written in Python. Original article: https://blog.petehouston.com/read-csv-file-using-pandas/ First, make sure you have pandas installed in your system, and use Python 3. Let say we have to deal with this CSV…

Since I’m working on a lot of CSV files, I write this article to share with you how to import CSV file into MySQL database. Original article: https://blog.petehouston.com/import-csv-file-into-mysql/ As you might not know, MySQL has supports for handling CSV files natively, which means you can export and import database tables…