Category: DataBases

Covid by region Globally -Data visualisation- Part 3

        At the end of the last post I’d found that the original NZ regional dataset had changed. I was also finding it slow working in Google Sheets as the interwongle seems to be slow with so much demand. So I decided that I’d start working locally. My current process is to get the data, manipulate

Airtable first look

        I had seen Airtable pop up a number of times. I thought it was just another team tool, like Notion & ClickUp, and it is, to an extent, but its also a DataBase , but a friendly one that you can share. It allows you to create tables and link the tables together. Also to

QGis Madeira Basic conns to Maps/.csv’s/Databases

        I thought I’d have a look at QGis again now that it has been updated. I’m always wow’d by what people can do with the GIS mapping. Unfortunately for me I’m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and

Learning UiPath RPA (Robotic Process Automation)

        Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCVย to identify and control GUI components. This is handy in cases when there is no easy access to

Regular Expressions/Regex for data cleaning

        A regular expression, regex or regexp A regular expression, regex or regexp is, in theoretical computer science and formal language theory, a sequence of characters that define a search pattern. Usually this pattern is then used by string searching algorithms for “find” or “find and replace” operations on strings, or for input validation. From Wikipedia.