There are numerous threads on the Alteryx Community where people are asking how to covert xls files to xlsx. The solutions generally suggest one of two approaches, either Read the file in with an Input Data tool then output again in the new format Use the Run Command tool to use an an Excel component …
Author archives: Bob Peers
Jupyter Notebook Shortcut on MacOS using Anaconda
It’s not immediately clear on Mac OS how to start a Jupyter Notebook if you’re using Anaconda. The actual executable is located at /Users/*YOURUSER*/opt/anaconda3/bin/jupyter-notebook but it can be a pain to either type the full link or even worse start the Anaconda application first just to open a notebook. The easiest way I found is to …
Continue reading “Jupyter Notebook Shortcut on MacOS using Anaconda”
Brew Permissions Error
I recently installed Homebrew on my MacBook and immediately hit permissions issues (I’m running Catalina v 10.15.2 (19C57) and it seems permissions are an issue for many apps). Trying to install wget gave this error. If you look at the permissions on the .config folder you immediately see the problem. By default it’s owned by …
The Knowledge Curve
Having recently changed jobs to become a Consultant after working 15 years in the Retail Industry I think about this chart a lot. I’m personally at a stage where I think I know quite a bit but I’m mostly overwhelmed by how much more there is to know 🤯 I also need to become more …
IoT Sensors – Saving Collected Data
Now that my sensors are successfully collecting data and the data is being processed by a Node-RED flow on my Raspberry Pi the final step is to add some persistence to the data. As it stands the data is constantly streaming and being displayed on a dashboard but after that it’s discarded so there’s no …
Logic Gates Explained with Water
IoT Sensors – Data Collection
In the first part I talked mostly about the sensors and the gateway so in this article I’ll show you how to collect, filter and store that data from the sensors. My setup is running locally on my LAN and uses a Raspberry Pi 3B+ to process the data. I’ll be using Node-RED to process …
How to use Amazon S3 from KNIME
This post follows on from my S3 post usng Node-RED so you can read that for a brief into to S3. Using S3 with KNIME is extremely easy as there is already an S3 node available to install. Amazon S3 Connection The only node that needs installing is the Amazon S3 Connection. All the other …
Format and Mount External Hard Drives in Linux
Assuming you’ve just bought a new external hard drive or you have one that’s already in use these are the steps you need to take to make it usable with Linux. ⚠️ Be aware that following these steps will reformat the drive causing all data to be permanently erased. You’ve been warned. First connect the …
Continue reading “Format and Mount External Hard Drives in Linux”
IoT Sensors – Getting Started
Introduction I’ve been interested in setting up some home monitoring/automation since getting my first Raspberry Pi a couple of years ago. After using the device for various development projects I finally decided on my first project, try to make a basic home temperature/humidity monitor that cold measure both indoor and outdoors. The idea is to …