Skip to content

Instantly share code, notes, and snippets.

View data-henrik's full-sized avatar

Henrik Loeser data-henrik

View GitHub Profile
@data-henrik
data-henrik / download_from_notebook.py
Last active June 6, 2023 12:51
Python snippet to download pandas Data Frame as CSV or Excel from notebook in IBM Watson Studio
# Define functions to download as CSV or Excel
from IPython.display import HTML
import pandas as pd
import base64, io
# Download as CSV: data frame, optional title and filename
def create_download_link_csv(df, title = "Download CSV file", filename = "data.csv"):
# generate in-memory CSV, then base64-encode it
csv = df.to_csv(index=False)
b64 = base64.b64encode(csv.encode())
@data-henrik
data-henrik / 0intro.md
Last active November 25, 2022 01:36
SQL statements to dig into COVID-19 data

Introduction

Let's assume a simple schema consisting of two tables.

  1. STATISTICS for COVID-19 daily statistics like confirmed cases, deaths, etc.
  2. DEMOGRAPHICS with addition per-country data like population, area, population density and more

STATISTICS

This table could have columns such as

  • country_id: Identifies the country by ISO code
@data-henrik
data-henrik / main.tf
Created August 27, 2020 13:06
Create an IBM Cloud service ID, then create and download an API key for that service ID
# See https://cloud.ibm.com/docs/terraform?topic=terraform-getting-started
# for details on IBM Cloud and Terraform
# First, obtain an IBM Cloud IAM token
# Thereafter, create a new IAM service ID and as
# follow-up step, using a local execution environment,
# utilize curl to create and download an API key.
# Obtain the IBM Cloud IAM authentication token
# It is needed for the embedded curl command below
# this is not a script, but you may turn it into such
# it assumes that you already installed OBS Studio (sudo dnf install obs-studio)
# you could start by creating a project directory "obs"
# make obs
# cd obs
# clone the source for loopback device
git clone https://github.com/umlaeute/v4l2loopback
cd v4l2loopback