Skip to content

Instantly share code, notes, and snippets.

# Executable transcript of https://www.digitalocean.com/community/tutorials/how-to-set-up-an-openvpn-server-on-ubuntu-16-04
sudo apt update
sudo apt install -y openvpn easy-rsa python
make-cadir ~/openvpn-ca
cd ~/openvpn-ca
cat <<EOT >> vars
# New values
export KEY_COUNTRY="EE"
export KEY_PROVINCE="Some Province"
@konstantint
konstantint / dsw-1.py
Created December 2, 2018 02:45
The Data Science Workflow blogpost, code snippet 1
import sqlalchemy as sa
import pandas as pd
e = sa.create_engine("sqlite:///raw_data.sqlite")
pd.read_csv("raw_data.csv").to_sql("raw_data", e)
@konstantint
konstantint / dsw-2.sql
Created December 2, 2018 02:50
The Data Science Workflow post, snippet 2
select
s.Key
v1.AverageTimeSpent,
v1.NumberOfClicks,
v2.Country
v3.Purchase as Target
from vw_TrainSample s
left join vw_BehaviourFeatures v1 on v1.Key = s.Key
left join vw_ProfileFeatures v2 on v2.Key = s.Key
left join vw_TargetFeatures v3 on v3.Key = s.Key
@konstantint
konstantint / dsw-3.sql
Created December 2, 2018 02:52
The Data Science Workflow blogpost, snippet 3
with _BehaviourFeatures as (
... inline the view definition ...
),
_ProfileFeatures as (
... inline the view definition ...
),
_ModelInputs as (
... concatenate the feature columns ...
)
select
// https://nauka.leprosorium.ru/comments/2349993/
#include <iostream>
#include <chrono>
using namespace std;
using namespace std::chrono;
long long f(int x) {
if (x < 0) return 0;
// Greedy solver for https://leprosorium.ru/comments/2379244/
let modeMap = {"fa-ellipsis-v": ":",
"fa-ellipsis-h": "..",
"fa-arrows-alt-v": "|",
"fa-arrows-alt-h": "-",
"fa-plus": "+",
"fa-bomb": "[]",
"fa-trash": "X",
"fa-skull": "@"};