StuffbyYuki

select username as schema_name
from sys.all_users
order by username;

StuffbyYuki

select count(*)
from all_tab_columns
where owner = 'SOME_USER' --put yours
  and table_name = 'SOME_TABLE'; --put yours in upper case. lower(table_name) for lower case
  
/*
e.g.
select count(*)
from all_tab_columns
where owner = 'IRIRPT'

StuffbyYuki

DESCRIBE YourTableHere;

StuffbyYuki

//You specify an array of item in the argument
function random_item(items) {
    return items[Math.floor(Math.random()*items.length)]; 
};

StuffbyYuki

//The follwoing will work
var nums = [1, 2, 3]
Math.min.apply(Math, nums)    // 1
Math.max.apply(Math, nums)    // 3
Math.min.apply(null, nums)    // 1
Math.max.apply(null, nums)    // 3

//This doesn't work
var nums = [1, 2, 3]
Math.min(nums)    // NaN

StuffbyYuki

def autolabel(rects, xpos='center'):
    """
    Attach a text label above each bar in *rects*, displaying its height.

    *xpos* indicates which side to place the text w.r.t. the center of
    the bar. It can be one of the following {'center', 'right', 'left'}.
    """

    xpos = xpos.lower()  # normalize the case of the parameter
    ha = {'center': 'center', 'right': 'left', 'left': 'right'}

StuffbyYuki

#Refer to the documentaions for details -> https://packaging.python.org/guides/installing-using-pip-and-virtual-environments/

#Mac
python3 -m venv env
source env/bin/activate

#Windows
python -m venv env
.\env\Scripts\activate

StuffbyYuki

#Do when your virtual environment is active
#source env/bin/activate
#pip install YOURPACKAGE

pip freeze > requirements.txt #Write installed pip packages to a text tile
pip install -r requirement.txt #install all packages in requirement.txt

StuffbyYuki

// Toggle between terminal and editor focus
{ "key": "ctrl+`", "command": "workbench.action.terminal.focus"},
{ "key": "ctrl+`", "command": "workbench.action.focusActiveEditorGroup", "when": "terminalFocus"}
 

StuffbyYuki

import numpy as np
def trimmean(arr, percent):
    n = len(arr)
    k = int(round(n*(float(percent)/100)/2))
    return np.mean(arr[k+1:n-k])