Dan Nguyen dannguyen

## autotimestamp-column-in-google-sheets.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dannguyen
                / autotimestamp-column-in-google-sheets.md
            
            
              Last active May 29, 2020
            
              
                a Google Sheets script that automatically adds a timestamp to a corresponding row when the first column is created
              
          
      View autotimestamp-column-in-google-sheets.md
  
    
    How to automatically timestamp a column when a row in Google Sheets is created
Couldn't be bothered to look up the latest workout tracking app, so decided to stick to Google Sheets for now. One problem with this approach is that while it is easy on desktop GSheets to fill out a current timestamp (Command-Option-Shift-semicolon in MacOS), no such shortcut is available AFAIK in the iOS version of Google Sheets.

So I wrote a little custom function in Google Apps Script to do the following:
In an active Google Sheets spreadsheet, given a tab/sheet named myworkouts with a header named datetime, the following script updates a row's corresponding "datetime" column when a value is entered into a first column cell:

  
## nyt-local-news-sites.json
[
  {
    "id": 0,
    "name": "Adirondack Explorer",
    "homepageUrl": "https://www.adirondackexplorer.org",
    "supportUrl": "https://www.adirondackexplorer.org/subscription-center/new-combined-digital-and-print-subscription",
    "city": "Saranac Lake",
    "state": 36,
    "lat": "44.329496",
    "long": "-74.1312662"

## 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 Feb 6, 2020
            
              
                Twitter's ad-impressions.js file, on how @mckinsey and @boba targeted their promoted tweets
              
          
      View _twitter-ad-impressions-dan-README.md
  
    
    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 Nov 30, 2019
            
              
                hello.txt and world.txt, for dan's pydataproject-template to remotely collect
              
          
      View _README.md
  
    
    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
            
          
              1 fork
            
          
              0 comments
            
          
              2 stars
            
          
                dannguyen
                / spleeter-and-ffmpeg-quick-tutorial.md
            
            
              Last active May 29, 2020
            
              
                Example use of spleeter (Python+Tensorflow audio-extraction library and ffmpeg
              
          
      View spleeter-and-ffmpeg-quick-tutorial.md
  
    
    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 Oct 25, 2019
            
              
                ni hao world (testing unicode in Excel)
              
          
      View nihao-excel-README.md
  
    
    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
	[
	{
	"id": 0,
	"name": "Adirondack Explorer",
	"homepageUrl": "https://www.adirondackexplorer.org",
	"supportUrl": "https://www.adirondackexplorer.org/subscription-center/new-combined-digital-and-print-subscription",
	"city": "Saranac Lake",
	"state": 36,
	"lat": "44.329496",
	"long": "-74.1312662"
	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):