mac os doesn't recognize \t
as tab charactor.
sed -e 's/[[:cntrl:]]/,/g' text
mac os doesn't recognize \t
as tab charactor.
sed -e 's/[[:cntrl:]]/,/g' text
copy table_name from 's3://bucket/path/' CREDENTIALS
'aws_access_key_id=[access_key];aws_secret_access_key=[secret_key]'
delimiter '\t' gzip maxerror 100;
When importing csv data from s3 to redshift,
We can use delimiter ','
or CSV
option.
There two options are different.
If we use CSV
option, we can import such as this file
123,aaa ...
psql -h localhost -U hoge mydb -c "select id,name from users" -A -F, -t > user.csv
-A, --no-align : unaligned table output mode
-F, --field-separator=STRING : field separator for unaligned ...
go to chrome setting page chrome://settings/
en https://www.google.com/search?q=%s&hl=en
alc http://eow.alc.co.jp/search?q=%s
ama https://www.amazon.co.jp/s?field-keywords=%s
y http://www.youtube.com/results?search_query=%s
h http://b.hatena.ne ...
Download mecab core and dictionary.
http://taku910.github.io/mecab/#download
files are on google drive, if you want to use cli, need to add option like this.
wget 'https://drive.google.com/uc?export=download&id=0B4y35FiV1wh7cENtOXlicTFaRUE' -O mecab-0.996.tar.gz
wget 'https://drive.google.com/uc ...
cd /opt/
sudo wget -N https://services.gradle.org/distributions/gradle-2.6-all.zip
sudo unzip gradle-2.6-all.zip
sudo rm gradle-2.6-all.zip
sudo ln -s gradle-2.6 gradle
sudo printf "export GRADLE_HOME=/opt/gradle\nexport PATH=\$PATH:\$GRADLE_HOME/bin" > /etc/profile.d/gradle-env.sh
source ...
requires python 2.X
brew install q
you can read help by -h option.
q -h
if csv has header, we need append -H.
q -d , -H "select * from tmp.csv"
1,aaa,23
2,bbb,54
3,ccc,12
4,ddd,65 ...
Narrative Clip is a kind of life logging gadget. It takes a photo every 30 seconds (default setting). If we wear a Narrative Clip 10 hour a day, we get 1200 photos. This script make it possible to crop all photos square and combine them and ...
EyeTribe is the world's first affordable eye tracker.
It enables us to get the eye movement trajectories and develop some tools with it.
Today I'll show you a demo play.
Github Fork Me
The eyetribe sercer gives 30 fps data by default setting.
The upper limit is 60 ...
"hoge".split("");
// ["", "h", "o", "g", "e"]
"hoge".split("(?<=.)");
// ["h", "o", "g", "e"]
"hoge".split("");
// ["h", "o", "g", "e"]