00 Coding

About My Notes

About My Motivation I always believe in the notion that for you to truly understand, you must either teach or explain to others, so this di...

DT is better R table for EDA

When doing EDA Steps, sometimes showing prelim findings in table gives better visual with minimal efforts But table visualisation can be...

Jekyll Garden uses lunr js

JekyllGarden/jekyllgarden.github.io: A Digital Garden Theme for Jekyll. Jekyll Garden lets you create a static HTML version of your markdown notes ...

01 Power Query

#MOC / for notes sub to 00 Coding with focus on how I use Power Query

01 Jekyll

#MOC / for notes sub to 00 Coding with focus on how I use Jekyll

01 R programming

#MOC / for notes sub to 00 Coding with focus on how I use Jekyll

StackEdit custom css for Blogger

StackEdit already has a beautiful css formatting for html export, which can be used to publish to blogger but with few exceptions maxwid...

add mathjax to github pages and jekyll

this note is basically a copy from bodunhu.com blog, but edited for correction brief summary on how to add Mathjax v3 support to your Jeky...

add mermaid to github pages

using cdn to load mermaid js, we need to load the write the initialisation script after the body section else it won’t properly load ...

alternative to add mathjax

Here’s an alternative to loading mathjax for showing mathematical equations. Pulled from TeXt theme github repo but I haven’t test it {% raw ...

change file association in vscode if code chunk not detected

For first time setup for VS Code to run R Markdown, change the files association to enable it to run rmd file in code block chunks (like in R Studi...

css notes

Metadata topic:: 00 Coding updated:: 20220609 reviewed:: 20220609 #CodeNote Use attribute selector to s...

custom plugin not allowed in GitHub Pages but there is a workaround

GitHub pages doesn’t allow custom plugin for security reasons, as such I cannot manually load regex_replace or markdown_highlight altern...

enable better R plotting in VSCode

Enable R > Plot: Use httpgd is VS Code settings to have better support for R plots (especially multiple plot in single command) D...

extra space underneath image is due to CSS Flow algorithm

Designing a layout using CSS may present a classic “bewildering CSS” problem, where there’s a bit of extra space underneath the image that most peo...

how to add categories and tags in Jekyll

There seems to be 2 way (that I know of) to add categories or tags archive pages i.e. using JekyllArchive plugin or write your own liquid template ...

if else in power query dont have bracket

Metadata topic:: 00 Coding related:: 01 Power Query, Power BI updated:: reviewed:: ...

iterative web scrape using Power Query

Power Query can be used for iterative web scraping but will require the use of Parameters and Invoke Custom Function The setup is not th...

jekyll liquid for converting obsidian callout

this liquid snippet will find blockquote in jekyll website and detect whether it’s an obsidian callout – if so, tag with the appropriate class ...

jekyll process converts markdown first before applying layout

Jekyll’s rendering phase is further divisible into three optional stages with the output from a stage being the input for the succeeding stage: ...

load prism js for my digital garden syntax highlighting

Add prism.js and prism.css based on CDN to my blog or website (digitalgarden) to give a proper syntax highlighting add the following lin...

log scale for R plot

We can use the Scales package ready function to make the axis scaled non linearly e.g. scale_x_continuous() or scale_x_log10(...) we can...

macro for yes no selection based on cons level

Use Case when running economic model, sometimes I would need to run analysis of a group of projects incremental to another group of proj...

max function in power query

Metadata topic:: 00 Coding related:: 01 Power Query, Power BI updated:: 20220621 reviewed...

mermaid gantt chart template

Here’s a sort of complete example of the code block ```mermaid gantt title Gantt Chart Title dateFormat YYYYMMDD axisForm...

minimal mistakes favicon

Minimal Mistakes Jekyll theme does not provide direct way to add favicon, but we can manually add it using the following steps place fav...

replace == with mark for jekyll liquid

this latest snippet is a bit more refined and scalable. need to figure out other possible permutations currently doesn’t work well with...

run macro when value change

Use VBA’s Worksheet_Change() function to run code when specific cell changed in the specific worksheet sample code per below P...

scatter plot using Obsidian Chart

This scatter plot is using Obsidian Chart plugin (that uses chart js). The syntax is different a bit and code block is using advancedchart insted ...

use assignment or gsub to replace values in R

If the value to be replaced is the entire cell value (like replacing “” with 0), it’s easier to use simple assignment. For the rest, we can use gsu...

using css combinators to target specific element

css combinators descendant selector (space) child selector (>) adjacent sibling selector (+) general sibling se...

← BACK