Steven Vo stevenvo

## numpy-array-sort.py
# sort array with regards to nth column
arr = arr[arr[:,n].argsort()]

## struct.go
// Definition
type identifier struct {
  field1 type1
  field2 type2
  ...
}

// Example struct defintion for use below
type struct1 struct {   // struct definition
  i1 int

## useful_pandas_snippets.py
###### FORCE DATA FORMAT IN PANDAS ######
pd.options.display.float_format = '{:,.2f}'.format


# NOTES:
# 1. DO NOT update row in df.iterrows() -> https://stackoverflow.com/questions/25478528/updating-value-in-iterrow-for-pandas
#    Use df.loc[idx, '<col>'] = <value>


###### REGEX on DataFrame ######

## s3_cp.sh
aws s3 cp s3://<bucket_name> <local_folder>/ --recursive --exclude "*" --include "*201906*json" --include "*201906*pColdStart*" --exclude "*baseline*" --exclude "*candidate*"

## jasonette.json
{
  "$jason": {
    "head": {
      "title": "{ ˃̵̑ᴥ˂̵̑}",
      "actions": {
        "$foreground": {
          "type": "$reload"
        }
      }
    },

## sql.sql
-- Redshift - Query usage --
select
  sum(capacity)/1024 as capacity_gbytes,
  sum(used)/1024 as used_gbytes,
  (sum(capacity) - sum(used))/1024 as free_gbytes
from
  stv_partitions where part_begin=0;

-- usage by tables --


## git.cmd
# Pulling a git repository as a git module into your project
# "master" is the branch of the remote repository to use
git submodule add -b master https://github.com/Komodo/trackchanges.git src/modules/trackchanges


# get status recursively
git submodule status --recursive


# Iterate through all git submodule to add and comment and commit

## useful_python_snippets.py
#############################################################################
# Generate Dict from a List of Dict
ticker = [
 {
   'symbol': 'ABC',
   'price': 100.0
 },
 {
   'symbol': 'CDE',
   'price': 105.0

## .gitignore
*.DS_Store
*.pyc

## xz.sh
$ brew install xz
$ xz -d to-extract.xz
	# sort array with regards to nth column
	arr = arr[arr[:,n].argsort()]
	// Definition
	type identifier struct {
	field1 type1
	field2 type2
	...
	}

	// Example struct defintion for use below
	type struct1 struct { // struct definition
	i1 int
	###### FORCE DATA FORMAT IN PANDAS ######
	pd.options.display.float_format = '{:,.2f}'.format


	# NOTES:
	# 1. DO NOT update row in df.iterrows() -> https://stackoverflow.com/questions/25478528/updating-value-in-iterrow-for-pandas
	# Use df.loc[idx, '<col>'] = <value>


	###### REGEX on DataFrame ######
	{
	"$jason": {
	"head": {
	"title": "{ ˃̵̑ᴥ˂̵̑}",
	"actions": {
	"$foreground": {
	"type": "$reload"
	}
	}
	},
	-- Redshift - Query usage --
	select
	sum(capacity)/1024 as capacity_gbytes,
	sum(used)/1024 as used_gbytes,
	(sum(capacity) - sum(used))/1024 as free_gbytes
	from
	stv_partitions where part_begin=0;

	-- usage by tables --
	# Pulling a git repository as a git module into your project
	# "master" is the branch of the remote repository to use
	git submodule add -b master https://github.com/Komodo/trackchanges.git src/modules/trackchanges


	# get status recursively
	git submodule status --recursive


	# Iterate through all git submodule to add and comment and commit
	#############################################################################
	# Generate Dict from a List of Dict
	ticker = [
	{
	'symbol': 'ABC',
	'price': 100.0
	},
	{
	'symbol': 'CDE',
	'price': 105.0