Dan Nguyen dannguyen

## sample-aapl.tsv

          
            date
            close

            
              2-Jan-08
              194.84

            
              3-Jan-08
              194.93

            
              4-Jan-08
              180.05

            
              7-Jan-08
              177.64

            
              8-Jan-08
              171.25

            
              9-Jan-08
              179.40

            
              10-Jan-08
              178.02

            
              11-Jan-08
              172.69

            
              14-Jan-08
              178.78

## _twitter-ad-impressions-dan-README.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dannguyen
                / _twitter-ad-impressions-dan-README.md
            
            
              Last active
              February 6, 2020 17:16
            
              
                Twitter's ad-impressions.js file, on how @mckinsey and @boba targeted their promoted tweets
              
          
    Twitter's ad-impressions.js file, on how @mckinsey and @boba targeted their promoted tweets

The two JSON files in this gist are partial extracts from the ad-impressions.js file that Twitter gave me when I requested my personal data archive. This JSON file includes all the ads I expereinced on Twitter from December 8 2019 to Jan 8 2020.
I was just curious about ads from @McKinsey and @boba, particularly who they wanted to target, which is something that the ad-impressions.js file tells you.

tl;dr based on my personal data, I didn't really learn anything surprising. But read on for some details if you're kind of interested about social media data and ad targeting.


More info about requesting your own twitter data: https://help.twitter.com/en/managing-your-account/how-to-download-your-twitter-archive


## cbg.sh

# Helpful resources:
# https://superuser.com/questions/1188772/mac-command-to-change-the-background-color-in-a-terminal
# https://apple.stackexchange.com/questions/348762/how-to-have-a-random-background-color-in-terminal-app
# https://stackoverflow.com/questions/8063228/how-do-i-check-if-a-variable-exists-in-a-list-in-bash
cbg(){
    local OCMD=""
    local RED=0; local GRN=0; local BLU=0;
    local THEMES="pro basic grass homebrew ocean" ## preset themes
    local HELPMSG; read -r -d '' HELPMSG <<EOF

## _README.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dannguyen
                / _README.md
            
            
              Last active
              November 30, 2019 19:50
            
              
                hello.txt and world.txt, for dan's pydataproject-template to remotely collect
              
          
    This gist is meant just as remote storage for two text files, hello.txt and world.txt, as used by my data wrangling template project example:
https://github.com/dannguyen/pydataproject-template
Direct URLs for the files:
hello.txt: https://gist.github.com/dannguyen/df87d9d4cf42ed7b4f9549553ea5b8c8/raw/9bf95b5c6e234e491821cd355f6db1ec655cbe38/hello.txt
world.txt: https://gist.github.com/dannguyen/df87d9d4cf42ed7b4f9549553ea5b8c8/raw/9bf95b5c6e234e491821cd355f6db1ec655cbe38/world.txt

  
## PRODUCTION-READY-CODE.html
<!doctype html><title>PRODUCTION READY CODE MOTHAF KER!</title>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>

## visualise.py
import matplotlib.pyplot as plt
from PyQt5 import QtCore
import numpy as np
import time
import math


class VisualiseFrequency(QtCore.QThread):

    def __init__(self, song, canvas, player):

## spleeter-and-ffmpeg-quick-tutorial.md

      
              1 file
            
          
              2 forks
            
          
              1 comment
            
          
              8 stars
            
          
                dannguyen
                / spleeter-and-ffmpeg-quick-tutorial.md
            
            
              Last active
              November 29, 2022 04:23
            
              
                Example use of spleeter (Python+Tensorflow audio-extraction library and ffmpeg
              
          
    This is a guide that basically combines protolium's very helpful ffmpeg cheatsheet with the spleeter library.
Here's a tweet thread that shows a video snippet, with separate bass, vocals, and drums track:
https://twitter.com/dancow/status/1191068710968209408
Installing stuff


## nihao-excel-README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dannguyen
                / nihao-excel-README.md
            
            
              Last active
              October 25, 2019 19:18
            
              
                ni hao world (testing unicode in Excel)
              
          
    Does Excel correctly open utf8-encoded CSV files?

(using Office for Mac 16.16.15)
printf "hello,world\nNǐ hǎo,shìjiè\n你好,世界\n" > nihao.csv
# or:
# curl -o nihao.csv https://gist.githubusercontent.com/dannguyen/13d5c39d499e4bbec622e055283fbb19/raw/f1c50ced36033b9a3aed36ebbbf0cf8734a98809/nihao.csv
  
open -a 'Microsoft Excel' nihao.csv

  
## modern-cli.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              5 stars
            
          
                dannguyen
                / modern-cli.md
            
            
              Last active
              May 25, 2023 18:19
            
              
                my modern personal list of modern command-line utility replacements for macos bash
              
          
    Replacements


grep

rg (ripgrep)
ack


find

fd; HN discussion


cut (extracting delimited data)

xsv
csvkit


## overview-wapo-dea-pain-pills-db.md

      
              2 files
            
          
              0 forks
            
          
              3 comments
            
          
              2 stars
            
          
                dannguyen
                / overview-wapo-dea-pain-pills-db.md
            
            
              Last active
              May 5, 2020 18:09
            
              
                Working with the DEA ARCOS pain pills database https://www.washingtonpost.com/national/2019/07/18/how-download-use-dea-pain-pills-database/
              
          
    The full raw file can be downloaded from this WaPo article page (direct link here]
Here's a link to the Drug Enforcement Agency Office of Diversion Control's ARCOS Registrant Handbook
$ curl -Lo arcos_all_washpost.tsv.gz \
  https://d2ty8gaf6rmowa.cloudfront.net/dea-pain-pill-database/bulk/arcos_all_washpost.tsv.gz

$ gunzip arcos_all_washpost.tsv.gz
	date	close
	2-Jan-08	194.84
	3-Jan-08	194.93
	4-Jan-08	180.05
	7-Jan-08	177.64
	8-Jan-08	171.25
	9-Jan-08	179.40
	10-Jan-08	178.02
	11-Jan-08	172.69
	14-Jan-08	178.78

	# Helpful resources:
	# https://superuser.com/questions/1188772/mac-command-to-change-the-background-color-in-a-terminal
	# https://apple.stackexchange.com/questions/348762/how-to-have-a-random-background-color-in-terminal-app
	# https://stackoverflow.com/questions/8063228/how-do-i-check-if-a-variable-exists-in-a-list-in-bash
	cbg(){
	local OCMD=""
	local RED=0; local GRN=0; local BLU=0;
	local THEMES="pro basic grass homebrew ocean" ## preset themes
	local HELPMSG; read -r -d '' HELPMSG <<EOF
	<!doctype html><title>PRODUCTION READY CODE MOTHAF KER!</title>

	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
	<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
	import matplotlib.pyplot as plt
	from PyQt5 import QtCore
	import numpy as np
	import time
	import math


	class VisualiseFrequency(QtCore.QThread):

	def __init__(self, song, canvas, player):