Superjisan

import os
from sqlalchemy import create_engine, text
from icecream import ic
import snowflake.connector

user = os.getenv("SNOWFLAKE_USERNAME")
password = os.getenv("SNOWFLAKE_PASSWORD")
account_identifier = os.getenv("SNOWFLAKE_ACCOUNTNAME")
role = "GENERAL_DEV_LOADER_ROLE"

Superjisan

CREATE OR REPLACE TRANSIENT TABLE ANALYTICS_DEV.DBT_JISAN_SPP.FORECAST_SFS_BLEND_EXTRACTED CLONE ANALYTICS.PROD_SPP.FORECAST_SFS_BLEND_EXTRACTED;
create or replace TRANSIENT TABLE ANALYTICS_DEV.DBT_JISAN_SPP.NODAL_VALUATION_FORECAST CLONE ANALYTICS.PROD_SPP.NODAL_VALUATION_FORECAST;
create or replace TRANSIENT TABLE ANALYTICS_DEV.DBT_JISAN_SPP.PATH_TOTAL_CONTRIBUTIONS CLONE ANALYTICS.PROD_SPP.PATH_TOTAL_CONTRIBUTIONS;
create or replace TRANSIENT TABLE ANALYTICS_DEV.DBT_JISAN_SPP.LONG_SHORT_GROUPS CLONE ANALYTICS.PROD_SPP.LONG_SHORT_GROUPS;

Superjisan

// bubble sort recursive
const bubbleSortArray = function(nums) {
    const sortArrRecursive = (arr, currIndex) => {
        if(currIndex == arr.length) return arr
    
        for(let i = 0; i < arr.length; i++) {
            if(arr[i] > arr[i + 1]) {
                let temp = arr[i];
                arr[i] = arr[i + 1];
                arr[i + 1] = temp;

Superjisan

Computer/Browser Hacks

Browser

Browser Tab Switching

• Chrome & Firefox
  • Switch from one tab to the next in rotation - Ctrl + Tab
  • Switch from one tab BACKWARDS to the previous in rotation - Ctrl + Shift + Tab
• To go to the specific SLOTTED Tab - Cmd + [Slot Number] or Ctrl + [Slot Number]

Superjisan

var conquer = function(left, right) {
  var sorted = [];
  var i = 0; //left tracker
  var j = 0; //right tracker

  while (i < left.length || j < right.length) {
    if (i < left.length && j < right.length){
      if (left[i] < right[j]){
        sorted.push(left[i]);
        i++;

Superjisan

{  
   "Arizona Cardinals" : [
       "Bill Bidwill"
   ],
   "Atlanta Falcons": [
       "Arthur Blank"
   ],
   "Baltimore Ravens": [
       "Steve Bisciotti"
   ],

Superjisan

{"AL":[  
   "http://vote-usa.org/Image.aspx?Id=ALByrneBradley&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALRobyMartha&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALRogersMikeD&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALAderholtRobertB&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALBrooksMo&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALPalmerGary&Col=Headshot100&Def=Headshot100",
   "http://vote-usa.org/Image.aspx?Id=ALSewellTerriA&Col=Headshot100&Def=Headshot100"
],
"AK":[  

Superjisan

var states = $("h2:not(:first-child) .mw-headline").each(function(){console.log('id', $(this).attr('id'))})

Superjisan

//images
var imgs = [];
$('.sortable.wikitable tbody tr td:nth-child(2) a img').each(function(){imgs.push($(this).attr('src'))})

//text
var arr = [];
$('.sortable.wikitable tbody tr td:nth-child(3) span.vcard .fn a').each(function(){arr.push($(this).text())})

Superjisan

/**
 * @param {number[]} digits
 * @return {number[]}
 */
var plusOne = function(digits) {
  var result = [];
  var digitsstring = digits.join("");
  var num = parseInt(digits.join("")) + 1;
  console.log("num", num, "digits", parseInt(digits.join("")))
  var numstring = num + "";