Author: Max Drake

I have been interested in displaying tabulated data on a web page from a Database, exploring what is out there to use. WordPress has a couple of Free Table add-in’s but they are usually only available for uploading static data to your website (or from Excel/CSV). There is one WordPress Add-in that read from a

I was viewing the free statistics-101 course from Cognitive Class.ai and they recommend using the SPSS statistical tool by IBM which you can use on a free trial base for 14 days. I came across a free tool PSPP  which is based on the SPSS tool but is freeware when looking at this video on

After writing the previous post on web scraping and the example given of using Google Spreadsheet to obtain a web table I started wondering about Excel. I was aware that it had a web connection so decided to explore those. This first video shows how to automate the data scraping  from websites into Excel: Then

I have been looking at some of the free Data Science and Cognitive Computing Courses and was following the Data Journalism: First Steps, Skills and Tools course. The Google Searching video was on improving your searches in Google using the following: quotes to get specific key words eg “data science on construction” using – sign

I had an excel sheet with some property data. I isolated it to one property for this exercise. The property has A Site, A block, A Unit and 8 rooms and 3 cupboards (denoted by room name they were in with a letter ‘a’ at the end) In the first part of the process I

The community edition download on the Neo4j  website is here.  After downloading the particular version you want in ZIP format it takes you to a page that offers a free book and the instructions for installing. For basic overview and setting up Neo4j community edition ( older version from an EXE ) I watched the

I have been interested in NoSQL databases and so I decided to try MongoDB. I always thought it stood for NO SQL but apparently its NOT ONLY SQL. I used this video to get an overview of setup and uses: Installing on VPS. Not a problem. Directly as the video. Installing on my PC, real

I clicked on this video and decided to try to set up the process that is demonstrated from about 30 minutes in on the video, connecting Wufoo Contact page on my website to a Trello shareable list Dashboard via a Zapier integration. Summary After signing up to free accounts in Wufoo, Trello & Zapier, I

OpenRefine (formerly Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data. You can download it from here. In the Cognitive Class tutorial on OpenRefine it talks about 60-85% of time of data scientists spending on

There is an interactive tutorial here running Python. This instance is running from another website so could be slow. I found this video extremely good for setting up (I used the pip install method not anaconda) and how to use it. The Jupyter Notebook The Jupyter Notebook is an open-source web application that allows you