One advice I kept hearing a lot while choosing the right bank for me was "Check if it has a good network of reliable ATMs" and as a good millennial would do, I went to Google and I asked "Which bank has the best network of ATMs in Egypt?" and to my surprise, it failed to answer my query. I searched for reports, studies anything but what I found only mentioned the total number of ATMs in Egypt.
One day I was visiting a new district, and I wanted to withdraw cash but couldn't find a nearby ATM, intuitively I pulled out my phone opened Google Maps searched "ATM near me" and it directed me to a nearby ATM. and then it hit me!
This whole time I was searching in the wrong place, it's not Google that has the answer it's Google Maps. So the very same moment I put the knowledge I gained from studying data science with Data Camp to test as I decided to do a comparison between each bank in terms of the number of ATMs they have and to do so I decided to pull out all ATM search results from Google Maps, group them by Bank & City and compare them to know which bank has a bigger network in the cities I visit frequently.
I didn't end up pulling data from Google Maps, instead, I used the (Locate Branches & ATMs) option on most banks' websites. I used Octaparse software to scrape a list of ATMs' locations from each bank's website, I then cleaned the list, grouped it by city & Banks and the results were somehow interesting.
The following is the result of my work, hope you find it interesting.
The aggregated tables and resources can be found on Kaggle here: https://www.kaggle.com/mhassan962/count-of-atms-in-egypt
Technology used:
Tableau
OctaParse
Google Sheets
Canva
