Recent Comments
Category Archives: Howto
Plotting video locations from my Sony camera in Python
Two years ago I bought a Sony FDR-X3000 actioncam to record video on my bike rides. And I’m really happy about it. It’s just great reliving my rides in 4K, going downhill for kilometers from some col I climbed. I … Continue reading
Posted in Data engineering, Howto, Python
Tagged geodata, matplotlib, pandas, Sidecar, Sony FDR-X3000, XML, xmldom
Leave a comment
Gaining insights on my workout data with Apache Superset
For a few years I’ve been gathering data on my workouts. In Excel. It’s not exactly state of the art data architecture, but it was fine for a while. But data alone doesn’t do much. I wanted some questions answered. … Continue reading
Posted in Apache Products for Outsiders, Howto
Tagged Apache Superset, DATETIME, Docker, docker-compose, health data, PostgreSQL
Leave a comment
I built a working Hadoop-Spark-Hive cluster on Docker. Here is how.
TL;DR: I made a Docker compose that runs Hadoop, Spark and Hive in a multi-container environment. You can find the necessary files for it here: https://github.com/Marcel-Jan/docker-hadoop-spark [Update 2021-11-09: Since Docker Desktop turned “Expose daemon on tcp://localhost:2375 without TLS” off by … Continue reading
Posted in Howto, Spark
Tagged Apache Spark, Big Data Europe, DIKW, Docker, docker-compose, Hadoop, Hive
23 Comments
A humidity sensor network on a Raspberry Pi with Zigbee2MQTT
I was looking for a way to detect leakage in my appartement with some kind of IoT solution. Someone on the Dutch technology forum Tweakers.net told me Xiaomi Humidity sensors, combined with a Zigbee2MQTT might be a good fit. The … Continue reading
Posted in Howto
Tagged Domoticz, humidity sensors, Internet of Things, IoT, Raspberry Pi, Xiaomi Aqara, Zigbee2MQTT
Leave a comment
Neo4J: Loading rocket data in a graph database
When I first learned about graph databases, like Neo4J, I didn’t get it. That’s how I always start with new technology: not getting at all why people getting so enthusiastic about them. Then I read “Seven Databases in Seven Weeks, … Continue reading
Posted in Active Learning, Howto, NoSQL
Tagged Cypher, graph database, Jonathan's Space Page, Neo4J, Seven Databases in Seven Weeks
Leave a comment
Showing a complex Excel sheet who’s boss with Python and pandas
Data engineering isn’t always creating serverless APIs and ingressing terrabyte a minute streams with do-hickeys on Kubernetes. Sometimes people just want their Excel sheet in the data lake. Is that big data? Not even close. It’s very small. But for … Continue reading
Posted in Howto, Python
Tagged Excel, header, multiindex, pandas, Python, space fueling stations, stack, unstack
Leave a comment
Building HDP 2.6 on AWS, Part 3: the worker nodes
This is part 3 in a series on how to build a Hortonworks Data Platform 2.6 cluster on AWS. By now we have an edge node to run Ambari Server, three master nodes for Hadoop name nodes and such. Now … Continue reading
Posted in Howto
Tagged Amazon Web Services, AWS, cloning nodes, Hadoop, HDP, Hortonworks Data Platform, Ubuntu Server, worker nodes
Leave a comment
Fun with Data: Python and space rocks!
Last week I had a little fun with playing with Python, the pandas and matplotlib library and a JSON file with asteroid data. Here is what I did.
Posted in Howto, Python
Tagged asteroids, matplotlib, pandas, Python, Science, sentdex
Leave a comment
Building HDP 2.6 on AWS, Part 2: the master nodes
This is part 2 in a series on how to build a Hortonworks Data Platform 2.6 cluster on AWS. In part 1 we created an edge node where we will later install Ambari Server. The next step is creating the … Continue reading
Posted in Howto
Tagged Amazon Web Services, AWS, cloning nodes, Hadoop, HDP, Hortonworks Data Platform, master node, Ubuntu Server
5 Comments