I’ve been working in Django a lot lately and needed to dump my database using Django’s dumpdata command. However, that produced an error. Here’s how I solved it. However, halfway the dump, my terminal returned an error. Apparently, there was a Byte Order Mark or BOM somewhere in my SQLite…
This article covers the transfer of files over SFTP (or Secure/SSH File Transfer Protocol). While there are quite some options to choose from, the Python package Paramiko is used to achieve it. Paramiko is a pure-python implementation of the SSH2 protocol. Although Paramiko is the foundation for some other packages…
In this article, we’ll discuss an error I ran into when trying to create SSH keys for a service account in Google Cloud Platform (GCP). Nevertheless, I assume it’s something that can happen in many situations where you’re trying to perform an operation as a service account. I hope to…
One of the most frequent operations I have to do in a data wrangling process is changing my values or frequencies to shares, relative to the group they are in. In this blog post, I want to elaborate on doing this in d(t)plyr, one of the most popular packages within…
A while ago I started working in the JavaScript library D3.js to create some interactive visualizations. I even took a rather great Coursera course on the subject — Information Visualization: Programming with D3.js. If you’re not familiar with modern JavaScript syntax, D3.js has a rather steep learning curve. During this…