The Pandas DataFrame – this blog post covers the basics of loading, editing, and viewing data in Python, and getting to grips with the all-important data structure in Python – the Pandas Dataframe. Learn by example to load CSV files, rename columns, extract statistics, and select rows and columns.
In this post, geocoded data for all property price sales in Ireland from 2012-2017 is available. Data is sourced on the Irish Property Price Register and geocoded using the Google geocoding script in Python. All of the GPS latitude/longitude coordinates are further tied to census small area and electoral division boundaries.
Many precious hours have been lost to Character encoding errors and EOF character errors in CSV files being read by the Pandas read_csv file. This is an incredibly frustrating start to any analysis! Hopefully this post will save some people from the same fate!
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 »