Awk

Handy Command-Line One-liners for Starting Data Scientists

[6/5/2017 update: I was asked if I had a PDF version of the one-liners below. Here it is — Data-Science-One-Liners.pdf]

Experienced data scientists use Unix/Linux command-line utilities (like grep, sed…

How to explore Facebook data at the command-line? (Part I — Data preview)

Exploring Facebook data at the command-line (Part II)

[nginx] 특정 시간대 IP + URI 추출하기

시간대 별 IP 와 URL를 추출할 일이 있어서 정리합니다.

아래는 nginx access.log로그 패턴입니다.

52.78.xxx.yyy — — [05/Jul/2017:17:00:00 +0900] “POST /user HTTP/1.1” 200 0 “-” “-” “52.78.xxx.yyy”

Converting a MySQL dump to CSV files

I needed to migrate a set of tables from MySQL/MariaDB to a different SQL database recently. My source was not an actual live connection to the source database, but a SQL dump created by the mysqldump backup utility.

HOW TO CAPTURE YOUR SCREEN OUTPUT INTO AN ANIMATION (GIF)

Обработка данных и формирование отчёта с помощью утилиты awk

Помимо ведения твиттера, где я показываю различные приёмы работы с командной строкой в Unix-системах, иногда хочется писать и небольшие посты на эту тему. Попробуем написать первый. Сегодня я хочу показать небольшой пример и…

[python] subprocess.Popen awk

python으로 subprocess.Popen으로 awk를 사용하려는데 계속 <type ‘exceptions.KeyError’>가 발생합니다. 그래서 awk명령어를 python으로 구현하려다가 다시 폭풍 구글링. 생각보다 해결법이 간단하네요.

awk ‘{print $7}’ -> awk ‘{{print $7}}’

Keeping your copyrights up to date.

tristansokol/copyright-updater

Recently I took the SDI assessment, and in the process I was told that I liked things with structure and order, which really resonated with me when thinking about one of the things that I…