kalligator

#!/bin/bash

# Apply custom color theme for Pantheon Terminal ver 5.3+
# 1) preview and choose a color theme from http://mayccoll.github.io/Gogh/
# 2) open the equivalent bash file containing the color values at https://github.com/Mayccoll/Gogh/tree/master/themes
# 3) concatenate all 16 colors at the top with colon ":", then replace it at the palette variable below
# 4) replace color for foreground, background, and cursor; choose whether your theme is light or dark
# 5) sudo apt-get install dconf-tools
# 6) execute this script

kalligator

DROP TABLE IF EXISTS wp_users;
CREATE TABLE wp_users (
  ID bigint(20) unsigned NOT NULL auto_increment,
  user_login varchar(60) NOT NULL default '',
  user_pass varchar(64) NOT NULL default '',
  user_nicename varchar(50) NOT NULL default '',
  user_email varchar(100) NOT NULL default '',
  user_url varchar(100) NOT NULL default '',
  user_registered datetime NOT NULL default '0000-00-00 00:00:00',
  user_activation_key varchar(60) NOT NULL default '',

kalligator

# -------------------------------------------------
# CDN CONFIGURATION
# -------------------------------------------------

#    Show "Not Found" 404 errors in place of other NGINX errors
  error_page 403 /404;
  error_page 404 /404;
  error_page 405 /404;
  error_page 500 501 502 503 504 /404;
  location  /404 {

kalligator

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)