Published inPython in Plain EnglishHandling Date Time with Time Zones in Python and pandasWhat is the time zone?Aug 2, 2023Aug 2, 2023
Create a weather map using OpenWeather API in PythonCurrent weather data provided by Open Weather API allows you to get weather information for free for any location on our planet. All you…Jun 28, 2023Jun 28, 2023
Download all your Google Photos and extract EXIF metadata with GPS into a CSV file using Python…Using Google Takeout dataMay 26, 2023May 26, 2023
Google Photos: Get and upload photos with APIAs an Android phone owner, I am making now more photos with my phone camera than with my 10-year-old DSLR camera. Massive amounts of my…May 15, 20231May 15, 20231
Exporting pandas dataframe from Google Colab notebook to Google Spreadsheet using gspreadQuite often I need to export data from pandas dataframe into Google Spreadsheet to share with people who are not software developers. They…Apr 30, 20232Apr 30, 20232
Published inTowards DevExtracting person details from Wikidata JSON Dump file into CSV fileWikidata is a graph database containing almost 100 million entities. Each entity has multiple properties defined. This database is…Sep 2, 2022Sep 2, 2022
Published inDev GeniusAustralian Census 2021. Loading data and showing it on a mapLast year we had an Australian Census survey and now a new dataset is available for download from ABS website.Jul 21, 2022Jul 21, 2022
Published inBetter ProgrammingLoading Location History Places From Google Timeline Into Pandas and CSVKnow how often you were visiting the supermarket when you go for coffee and what’s your usual travel times to and from work, and how long…Jun 16, 20222Jun 16, 20222
Published inDev GeniusLoading POI data from OpenStreetMap using Overpass APIOpenStreetMap is a valuable source of geospatial data. It’s like Wikipedia for maps. Everyone can edit it by adding streets, houses, lakes…May 19, 20221May 19, 20221
Getting administrative boundaries from Open Street Map (OSM) using PyOsmiumCountry administrative boundaries play an important role for geospatial data analysis and visualisation. Lots of countries, like Australia…Apr 26, 20221Apr 26, 20221