Ruhong seahrh

seahrh / connect_psycopg2_to_pandas.py

Created September 18, 2020 02:08 — forked from jakebrinkmann/connect_psycopg2_to_pandas.py

Read SQL query from psycopg2 into pandas dataframe

	import pandas as pd
	import pandas.io.sql as sqlio
	import psycopg2

	conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
	sql = "select count(*) from table;"
	dat = sqlio.read_sql_query(sql, conn)
	conn = None

seahrh / aws-template-bucket-custom-acl.yaml

Created September 23, 2020 10:25 — forked from christianklotz/aws-template-bucket-custom-acl.yaml

CloudFormation template to create S3 bucket resource with custom role

	AWSTemplateFormatVersion: 2010-09-09
	Transform: AWS::Serverless-2016-10-31

	Parameters:
	BucketPrefix:
	Type: String
	Description: "The prefix used for all S3 buckets."
	AllowedPattern: "[a-z-]+"

	Resources:

seahrh / config

Created May 6, 2021 03:04 — forked from pksunkara/config

Sample of git config file (Example .gitconfig) (Place them in $XDG_CONFIG_HOME/git)

	[user]
	name = Pavan Kumar Sunkara
	email = [email protected]
	username = pksunkara
	[core]
	editor = vim
	whitespace = fix,-indent-with-non-tab,trailing-space,cr-at-eol
	pager = delta
	[sendemail]
	smtpencryption = tls

seahrh / iterm2-solarized.md

Created January 4, 2022 10:01 — forked from kevin-smets/iterm2-solarized.md

iTerm2 + Oh My Zsh + Solarized color scheme + Source Code Pro Powerline + Font Awesome + [Powerlevel10k] - (macOS)

Default

seahrh / negative-words.txt

Created February 5, 2022 10:51 — forked from mkulakowski2/negative-words.txt

	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
	;
	; Opinion Lexicon: Negative
	;
	; This file contains a list of NEGATIVE opinion words (or sentiment words).
	;
	; This file and the papers can all be downloaded from
	; http://www.cs.uic.edu/~liub/FBS/sentiment-analysis.html
	;
	; If you use this list, please cite one of the following two papers:

seahrh / strip_emoji.py

Created February 12, 2023 07:36 — forked from Alex-Just/strip_emoji.py

Python regex to strip emoji from a string

	import re

	# http://stackoverflow.com/a/13752628/6762004
	RE_EMOJI = re.compile('[\U00010000-\U0010ffff]', flags=re.UNICODE)

	def strip_emoji(text):
	return RE_EMOJI.sub(r'', text)

	print(strip_emoji('🙄🤔'))