Here to note one way to replace the NULL values in SQL with other specified values. Given 3 Tables A, B, C as follows: Table A id name 1 Mike 2 Cathy 3 Paul Table B id age
Anomaly Detection (a.k.a Outlier Detection) is a process of detecting unexpected observations in specified datasets. Anomaly detection has two basic assumptions: Anomalies only occur very rarely in the data; Their features differ from the normal instances
Censorships in data is a condition in which the value of a measurement or observation is only partially observed. Censored data is one kind of missing data, but is different from the common meaning of missing value in
Unlike Decision Tree Classifier, some machine learning models doesn't have the ability to deal with categorical data. The categorical data are often requires a certain transformation technique if we want to include them, namely Label Encoding and One-Hot
Imbalanced datasets are a common problem in classification tasks in machine learning. Take credit card fraud prediction as a simple example: the target values are either fraud (1) or not fraud (0), but the number of fraud (1)
MSE stands for mean squared error, MAE stands for mean absolute error. These are commonly used measurement of model prediction. MSE has several advantages over MAE, but also some disadvantages.
Take the following as an example to filter a data frame based on certain conditions: There are 2 users and some of their corresponding bill dates and bill amounts, we want to only keep one record for each
To log some useful Nginx Server Configurations. Rewrite Between Webstites server { listen 80; server_name old.com www.old.com; return 301 $scheme://www.new.com$request_uri; } 301 = permanent; 302 = temporary $scheme is used to define the
