VERY IMPORTANT BEFORE WE START: The purpose of this post is not to tell you to “eliminate” outlier after detection, instead of that, I recommend you “study” the outlier. Removal should not be automatic We take 2D as an example, but this can be applied to Multi-dimensional scale Defintion of the Outlier — no one can define outlier except yourself an outlier…

It is very annoying to handle the open-source library version conflict while running the data pipeline. That is why we need DOCKER! Docker creates different containers to avoid version conflict. The container itself can be considered an independent development environment, the setting in another container does not affect another container…

A good programmer is a lazy programmer! As a developer, we always want to automize something, reduce the time of typing the long bash command, avoid spelling error…etc. Especially in some repeated tasks while developing, such as Install the package and setting the environment Check the code rule and style …

ANOVA (analysis of the variance) is a statistical method to test the equality of the group means. Furthermore, 2-way anova is used if there are 2 factors. In this story, we will use in-vivo gene expression data with biological replicates as the example for the 2-way ANOVA analysis. Data Information We have…

I often get a call from the head-hunter asking about the years of experience. there was a very ridiculous conversation once. Recruiter: “Could you tell me your experience in biostatistics?” I: “I think around 10 years until now” Recruiter: “But I saw you worked as a bioinformatician in the past…

Beer is one of the most famous drinks in Germany, and of course, is part of the German culture! One of the grocery delivery companies in Berlin has collected whole year data on beer sales and other factors. …

First of all, thanks for the help from Florian Riemann. He is a very experienced database manager, an analyst with excellent skills in SQL, and good knowledge of data science! Motivation A second-hand trading online platform would like to know how many unique users trading on their platform on a daily…

Motivation A (internal) python data-processing package is created because the high re-use rate for the data process modules, especially when the format of input are similar across different projects. This situation happens quite often within the organization. Namespace In order to avoid the dependency conflict between sub-packages, namespace is a common practice…

動機 我跟太太都是在柏林生活的台灣人，2021年初我們的寶寶在柏林出生了！因為網路上沒有很多關於文件準備的資訊，加上疫情的關係，很多手續都繁瑣很多。想記錄一下這樣一路以來準備的文件（超級多…) 希望也給以後在德國的台灣家庭作參考 前言 因為要準備的手續很多，我先大致分為兩個項目: 在德國生活所需和返台（出國）所需。在德國生活所需的文件，是比較一般的，就是幾乎 …