Merging and Joining data sets are key activities of any data scientist or analyst. In this tutorial, we explore the process of combining datasets based on common columns quickly and easily with the Python Pandas library and it’s fast merge() functionality. Finally conquer merging and become a master with this 2-part tutorial.
Geocode your addresses for free with Python and Google For a recent project, I ported the “batch geocoding in R” script over to Python. The script allows geocoding of large numbers of string addresses to latitude and longitude values using the Google Maps Geocoding API. The Google Geocoding API is one of the most accurate geocoding …
Batch CSV Geocoding in Python with Google Maps API Read More »
Pandas Data Selection There are multiple ways to select and index rows and columns from Pandas DataFrames. I find tutorials online focusing on advanced selections of row and column choices a little complex for my requirements, but mastering the Pandas iloc, loc, and ix selectors can actually be made quite simple. Selection Options There’s three main options to …
Pandas iloc and loc – quickly select rows and columns in DataFrames Read More »
Do you get wet on your cycle to work? How rainy is Ireland? In this post we work out what percentage of cycles you get rained on in Ireland and around the world!
The most recent post on this site was an analysis of how often people cycling to work actually get rained on in different cities around the world. You can check it out here. The analysis was completed using data from the Wunderground weather website, Python, specifically the Pandas and Seaborn libraries. In this post, I will …
Analysis of Weather data using Pandas, Python, and Seaborn Read More »
[Short version] The S3 ingestion script for Amazon applications provided by Logentries will not work for the gzip compressed log files produced by the Elastic Beanstalk log rotation system. A slightly edited script will work instead and can be found on Github here.[/Short Version] Logentries is a brilliant startup originating here in Dublin for collecting and …
AWS Elastic Beanstalk – Logging to Logentries & InsightOps from Python Read More »