Create Random Pairs in Excel & Google Sheets

This week, I got this task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve this. Here are the detailed steps to achieve a random pair of two. All the example data and formula can be found in this Google Sheet Random Pairs. Step 1 - Generate random numbers using RAND() Step 2 - Copy the random number values to a new column named Value Excel or Google Sheets will automatic re-generate a new series of random numbers with the RAND() function....

November 16, 2022 · 1 min · 212 words · Eric

Configure Java Environment on macOS Big Sur

Starting from macOS Big Sur (ver. 11.2.3), macOS doesn’t include pre-installed Java any more, the best option is to install AdoptOpenJDK. You can download the OpenJDK pkg binary and install it manually like here, or install AdoptOpenJDK via brew in your favourite terminal: 1 brew install --cask adoptopenjdk Hope it helps. Reference wolfpaulus.com: Installing Java on macOS 11 Big Sur github.com/AdoptOpenJDK: AdoptOpenJDK - HomeBrew TAP

April 7, 2021 · 1 min · 65 words · Eric

Git - how to move a folder from one repo to another and keep its commits history

I was encountered into this situation that I need to transfer some existing code to another separated GitHub repository. Ideally it would be perfect to keep all historic git commit histories so that we can still be able to revert back if necessary. After digging into Google and Stack Overflow, luckily I found there are others who need to achieve similar things. Here is the solution I used to resolve this problem eventually....

March 15, 2020 · 2 min · 386 words · Eric

Resolve VT-X not enabled on Windows 10

Using VirtualBox on Windows 10 is a little bit different with other os. The first time when loading a virtual box image into VirtualBox, you may meet the VT-X is not enabled error. Solution To solve this, there are two steps you need to do. Step 1: Turn off Hyper-V Platform in Windows Feature Step 2: Open a command prompt as Administrator and run the following command 1 dism.exe /Online /Disable-Feature:Microsoft-Hyper-V After that, you can try to restart your workstation and this may take several minutes to let Windows complete all underneath setting....

May 22, 2019 · 1 min · 117 words · Eric

GitHub Projects

Interview Preparation https://github.com/jwasham/coding-interview-university https://github.com/yangshun/tech-interview-handbook https://github.com/taizilongxu/interview_python Data Engineering https://github.com/high-performance-spark/high-performance-spark-examples https://github.com/kerbelp/redshift-utils https://github.com/mozilla/telemetry-airflow https://github.com/igorbarinov/awesome-data-engineering Data Science https://github.com/shirkeyaws/sagemaker-recommender-workshop https://github.com/JifuZhao/DS-Take-Home https://github.com/jupyter/notebook Tutorial https://github.com/dask/dask-tutorial https://github.com/lopusz/gists/ https://github.com/Birne94/rds-s3-database-backup https://github.com/traviscrawford/airflow-pex-example https://github.com/awslabs/lambda-streams-to-firehose https://github.com/GoogleCloudPlatform/python-docs-samples https://github.com/kumarawsbit/awsbit https://github.com/coursera/dataduct https://github.com/mumoshu/kube-airflow https://github.com/segmentio/stack Utility Download Netease CloudMusic

April 16, 2019 · 1 min · 31 words · Eric