SQL LEFT JOIN with an extra condition
SQL LEFT JOIN with an extra condition.
Posts by Year
2021
How to install Elasticsearch with docker
Installing elastic search with docker and also with docker-compose
How to restore Microsoft SQL Server Database 2017 running in a linux docker container with Azure Data Studio
Dealing with the “Exclusive access could not be obtained because the database is in use”
2020
[TIL] 03-Sep-20
Why no posts?
[TIL] 08-May-2020
Dimensionality Reduction (PCA, SVD)
[TIL] 26-Apr-2020
Hierarchical clustering, K-Means Clustering, T-Confidence Intervals.
[TIL] 24-Apr-2020
Random Variables, Conditional Probability (contd.)
[TIL] 23-Apr-2020
Conditional Probability (contd.), Bayes Rule
[TIL] 22-Apr-2020
Conditional Probability (Atlast)
[TIL] 19-Apr-2020
Powershell, Common Probability Distributions.
[TIL] 31-Mar-2020
Getting/Cleaning Data, EDA
[EPI] 5.10 Apply Permutation to Array
Apply Permutation to Array - Elements of Programming Interviews (EPI)
[TIL] 18-Mar-2020
Graphs in R
[EPI] 5.9 Enumerate all Primes to n
Enumerate all Primes to n - Elements of Programming Interviews (EPI)
[EPI] 5.8 Computing an Alternation
Computing an Alternation - Elements of Programming Interviews (EPI)
[EPI] 5.6 Buy and Sell A Stock Once
Buy and Sell a Stock Once - Elements of Programming Interviews (EPI)
[EPI] 5.5 Delete duplicates from sorted array and shift
Delete duplicates from sorted array and shift - Elements of Programming Interviews (EPI)
[EPI] 5.4 Advancing through an array
Advancing through array - Elements of Programming Interviews (EPI)
[EPI] 5.3 Multiply 2 integers as arrays.
Multiply 2 integers as arrays - Elements of Programming Interviews (EPI)
[EPI] 5.2 Increment an integer as array
Increment an integer as array - Elements of Programming Interviews (EPI)
Adam Smith: The other side of Communism?
Adam Smith: The other side of Communism?
[TIL] 06-Mar-2020
50 Years of Data science
[TIL] 04-Mar-2020
R Simulation and Profiling
[EPI] 5.1 Dutch National Flag Problem
Dutch National Flag Problem - Elements of Programming Interviews (EPI)
[EPI] 4.11 Intersecting Rectangles
Intersecting Rectangles - Elements of Programming Interviews (EPI)
[TIL] 02-Mar-2020
Python arrays.
[EPI] 4.9 Is Integer Palindrome
Is Integer Palindrome - Elements of Programming Interviews (EPI)
[EPI] 4.8 Reverse Digits
Reverse Digits - Elements of Programming Interviews (EPI)
[EPI] 4.7 Compute \(x^y\)
Compute \(x^y\) - Elements of Programming Interviews (EPI)
[EPI] 4.10 Generate Uniform Random Numbers
Generate Uniform Random Numbers - Elements of Programming Interviews (EPI)
[TIL] 01-Mar-2020
Fix Ubuntu not responding, base 10 log in python
[EPI] 4.6 Division with shifting and addition
Division with Bit shifting - Elements of Programming Interviews (EPI)
[EPI] 4.5 Multiplication without Arithmetic Operators
Multiply without arithmetic - Elements of Programming Interviews (EPI)
[EPI] 4.4 Integer with same weight
Integer with same weight - Elements of Programming Interviews (EPI)
[EPI] 4.3 Reverse Bits
Reverse Bits - Elements of Programming Interviews (EPI)
[EPI] 4.2 Swap Bits
Swap Bits - Elements of Programming Interviews (EPI)
[TIL] 28-Feb-2020
Review of SGD / Mini-Batch, Online-Learning, intro Map-reduce, Linking posts in Jekyll, R loopy functions (lapply, sapply, tapply, vapply, split)
[EPI] 4.1 Parity and Primitive Types Bootcamp
Parity and Bit Manipulation - Elements of Programming Interviews (EPI)
[TIL] 27-Feb-2020
Python Bit Manipulation
[TIL] 26-Feb-2020
What is Statistics?, Basic Python.
[TIL] 24-Feb-2020
frozenset, Binary Search Trees.
[TIL] 20-Feb-2020
R control structures, lexical scope, dates, Anomaly Detection, Multivariate Gaussian.
[TIL] 19-Feb-2020
Docsify, Main Duties of Data Scientists.
[TIL] 18-Feb-2020
R library(patchwork)
[TIL] 17-Feb-2020
Binary Tree Traversal.
[TIL] 16-Feb-2020
ggplot2, fullwidth class, utility classes kramdown, R primer site, complete.cases()
[TIL] 15-Feb-2020
PCA, vim
[TIL] 13-Feb-2020
K-Means, Dimensionality Reduction
Sociological Theorists Summary
Sociological Theorists Summary CSS
[TIL] 10-Feb-2020
Embed pdf in github pages, Graphs, Spanning Trees, A* Algorithms, Tree traversal using Stacks(NLR)
[TIL] 29-Jan-2020
Data Storage, HDFS, ApacheSpark, Switching Fabric, RDD, bash alias vs script vs function, Ruby on Rails and Heroku, SVM (ML Coursera)
[TIL] 28-Jan-2020
JS in github pages, Pandas df.values, numpy argsort() / np.unique()
[TIL] 27-Jan-2020
Incremental Reading(Supermemo), Statistics
[TIL] 26-Jan-2020
Linear Programming, LibreElec MP2, Better Vocals, Baking, Pandas fillna(), geotiff
[TIL] 25-Jan-2020
Traveltime Maps, Population Density estimation.
[TIL] 24-Jan-2020
Intro Stats, Data Cleaning, Data Visualizations, Factfulness
[TIL] 21-Jan-2020
Intro to JS, Declarative/Imperative Programming, Spatial Relations from text, git
[TIL] 20-Jan-2020
Bash function, Jekyll debug, Logistic regression, Linked lists
[TIL] 19-Jan-2020
Ubuntu, RNN, Recall/Precision Fscore.
[TIL] 18-Jan-2020
Conv1d, Github images, gif animations, vim-plug, Ubuntu install from deb
[TIL] 17-Jan-2020
spaCy(displacy), node, react, jekyll
2019
Optimization Algorithms
So.. do I use vanilla SGD? SGD with momentum? Nesterov? RMSProp?? Adagrad? Adadelta? Adam?!? lookahead?? I am new to this deep learning business and after d...