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.
Aggregation and data grouping of Dataframes is accomplished in Python Pandas using “groupby()” and “agg()” functions. In this post, we’ll look at every aspect of grouping by single or multiple columns, applying aggregation functions such as max, min, count, and naming the resulting Dataframes and Pandas Series.