TIL

Today I Learned

Collection of things I've learned, that I'd otherwise quickly forget. (Again.)

---

Categories

• AWS
• Databases
• Django
• Docker
• GeoPandas
• Linux
• Math
• Pandas
• Python
• Scraping
• Web
• Theory

---

AWS

• Access a Container Running in ECS
• Access RDS from Lambda
• Get Data from an S3 Object
• Increase Storage for Windows EC2
• Run Lambda Containers Locally
• Setup awscli
• Troubleshoot ECS

Databases

• mdb
• pyodbc

Django

• Dockerize Django App
• Expose foreign key field in serializer
• Log to console under runserver

Docker

• Enter a Running Container
• Execute a Command on a Running Container
• Include Environment Variables
• Resolve Unusual Timeout Error
• RUN vs. CMD

Flutter

• Install Flutter

GeoPandas

• Convert Lat/Lon Coordinates to Lambert Azimuthal Equal Area Projection

Javascript

• Call npm From Another Directory
• Example - Cheerio
• Find Object by Property in an Array of Objects
• For loops
• Pretty Print Objects in the Console
• Variables: null, undefined
• Variables: var, let, const

Linux

• awk Notes
• Bash Arguments - Equal Separated
• Bash Arguments - Space Separated
• Bash - Best Practices
• Change the Endian-ness of a File
• Create PDF from Images
• Create a Key Mapping in Vim
• cronjob Setup
• Encryption with GNU PGP
• Grep
• Open vim at the Last Line
• Preview CSV
• rsync
• sed Replace
• Sort By Version Number
• SSH Config
• SSH Key Generation

Lua

• Read File
• Syntax

Math

• Entropy and Information Gain
• Linear Regression
• Unimodal vs Multimodal

Matplotlib

• Rotate x-tick Labels

Pandas

• Break Big Data into Chunks
• Convert Column to datetime
• Define a New Column
• Drop rows/cols with missing data
• Filter by datetime
• Filter by regex
• Find Duplicates
• Pivot Table
• Replace np.nan with None
• Spatial Interpolation
• Upsert

PowerShell

• Check PID on Port
• Kill Process by PID

Python

• Abstract Base Classes
• Argmax Without NumPy
• Debugging with iceream
• Debugging with pdb
• Default Value for User Input
• End of Month Calculation
• Generate MIDI Music
• Move File
• Multiprocessing
• Print an ASCII Table
• Profiling with cProfile
• Progress Bar for Multiprocessing
• Show Current Python Version Running Jupyter
• List of Tools
• Show Package Dependencies Using pip
• Random Bitmap in PyGame
• Relatve Date
• Union of Multiple Sets
• Union of Two dict
• Create Zipped Download in Flask

Scraping

• Get HTML from Element
• Hover Over an Item
• Parse an HTML Table
• Use chromedriver Binary on a Mac

Tailwind

• Set Style Globally
• Setup in Vue3

Theory

• Circular Linked List
• Segment Tree
• Segment Tree in 2D

Vue

• Make Array in Vuex Reactive
• Relative Paths in index.html
• Vuex: Dispatch Between Stores

Web

• Authorization Token Gotcha
• Blue-Green Deployment
• Content Type for XLSX
• Deploy Django to Heroku
• DNS Gotcha
• Get Your IP
• Gunicorn Gotcha
• NGINX - Use CORS with Mulitple Subdomains
• NPM Error - Cannot find module ../package.json
• Web Sockets

---

About

I shamelessly stole this idea from jbranchaud/til.

Other TIL Collections

• Today I Learned by Hashrocket
• jwworth/til
• thoughtbot/til

License

© 2021 Connor Johnson

This repository is licensed under the MIT license. See LICENSE for details.