program creek seems to be a good site for handy references of python modules. For e.g. when I wanted to know how to use Stratified Shuffle module, the examples shown on this page were very useful.

https://www.programcreek.com/python/example/91149/sklearn.model_selection.StratifiedShuffleSplit

This code will change the standard out to a file so that jupyter notebook cell's responses are saved to a file.

import sys
oldStdout = sys.stdout
file = open('logFile', 'w')
sys.stdout = file

While creating amazon config file in a shell script, use cat with heredoc like this..

cat > myconfigfile.txt << "heredoc"
[default]
aws_access_key_id=XXX
aws_secret_access_key=XXX
region=us-east-1
heredoc

export AWS_CONFIG_FILE=./myconfigfile.txt

This is how to set the colors in pandas

mapper = {v: k for k, v in enumerate(colors.unique())}

ccolors.cat.reorder_categories(mapper).cat.codes

tee output.txt
show global variables;
show engine innodb status\G
show full processlist;
show global status;
select sleep(60);
show engine innodb status\G
show full processlist;
show global status;
notee;

Amazon API gateway allows us to host serverless API's those can talk to cloud or on-premises databases. Here is 5 lines of python code to use the API

from urllib.request import Request, urlopen

url='https://xxx.execute-api.ap-south-1.amazonaws.com/stag'

q = Request(url)
q.add_header('uname', '472202986990')
data = urlopen(q).read().decode('UTF-8')

In the bad old days, the glacier class used to have different layers.

import boto.glacier.layer2
l2 = boto.glacier.layer2.Layer2(aws_access_key_id='xxx', aws_secret_access_key='xxx')

Now the client is all you need!

import boto3
gc = boto3.client("glacier",
aws_access_key_id="xxx", aws_secret_access_key="xxx",)

3 steps to install percona utility...

yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL

wget percona.com/get/pt-show-grants 

perl pt-show-grants -h 1.2.3.4 -uroot -pPasswd

a) Method Execution - Get Method Request - URL Query String Parameters - add a variable: cmnumber

b) Method Execution - Get Integration Request - Mapping Templates - Content-Type - application/json - Mapping template

{"mnumber": "$input.params('cmnumber')"}

"requestTemplates": {
     "application/json": {
        "querystring": "$input.params().querystring"
      }
 }

Here is how to change the color of negative values to red in pandas.

def color_negative_red(val):
color = 'red' if val < 0 else 'black'
return 'color: %s' % color

df = df.style.applymap(color_negative_red)