Felan Carlo Garcia cadrev

## delete_jpeg
find . -type f -iname \*.jpg -delete

## copy_jpeg
find . -type f \( -iname "*.jpg" -o -iname "*.jpeg" \) -exec cp '{}' /dirname \;

## pandas_shuffle.py
'''
Title  : Pandas Row Shuffler
Author : Felan Carlo Garcia
'''
import numpy as np
import pandas as pd

def shuffler(filename):
  df = pd.read_csv(filename, header=0)
  # return the pandas dataframe

## port-process-finder
sudo fuser -n tcp [local_port]

## sql-joins-cheatsheet.sql
-- Inner Join
SELECT * FROM A INNER JOIN B ON A.key = B.key

-- Left Join
SELECT * FROM A LEFT JOIN B ON A.key = B.key

-- Left Join without Intersection
SELECT * FROM A INNER JOIN B ON A.key = B.key where B.key IS NULL

-- Right Join

## conda-lockerror-solution
conda clean --lock

## chown sample
chown username -R /whatever/floats/your/boat/dir

## reg-ex.py
'''
Removes punctuations and non Alpha-numeric characters, removes trailing spaces
and prints the string in lowercase
'''

import re

text       = " sample_ @$@string %*hi^*&there "
clean_text = re.sub(r'[^A-Za-z0-9\s]+','',text).lower().strip()

## sys-ad-py-scripts
http://www.pixelbeat.org/scripts/

## clean-scrollbar.css
/**
 * Like, basically PERFECT scrollbars
 */

/*
   It's pure CSS.
   Since a quick google search will confirm people going crazy about Mac OS Lion scrollbars...
   this has no fade-out effect.

   In Mac OS Lion, the lowest common denominator is always showing scrollbars by a setting.
	'''
	Title : Pandas Row Shuffler
	Author : Felan Carlo Garcia
	'''
	import numpy as np
	import pandas as pd

	def shuffler(filename):
	df = pd.read_csv(filename, header=0)
	# return the pandas dataframe
	-- Inner Join
	SELECT * FROM A INNER JOIN B ON A.key = B.key

	-- Left Join
	SELECT * FROM A LEFT JOIN B ON A.key = B.key

	-- Left Join without Intersection
	SELECT * FROM A INNER JOIN B ON A.key = B.key where B.key IS NULL

	-- Right Join
	'''
	Removes punctuations and non Alpha-numeric characters, removes trailing spaces
	and prints the string in lowercase
	'''

	import re

	text = " sample_ @$@string %hi^&there "
	clean_text = re.sub(r'[^A-Za-z0-9\s]+','',text).lower().strip()
	/**
	* Like, basically PERFECT scrollbars
	*/

	/*
	It's pure CSS.
	Since a quick google search will confirm people going crazy about Mac OS Lion scrollbars...
	this has no fade-out effect.

	In Mac OS Lion, the lowest common denominator is always showing scrollbars by a setting.