JS 筆記

parseInt("abc")            // 傳回NaN
parseInt("123abc")         // 傳回 123
parseInt("abc123")         // 傳回 NaN
parseInt("      123abc")   // 傳回 123

parseFloat("20");            //傳回20
parseFloat("30.00");         //傳回30
parseFloat("10.68");         //傳回10.68
parseFloat("12 22 32");      //傳回12
parseFloat("        80   "); //傳回80
parseFloat("378abc");        //傳回378
parseFloat("abc378");        //傳回NaN

Number(true);               //傳回1
Number(false);              //傳回0
Number(new Date());         //傳回1970/1/1到現在的毫秒數
Number("123");              //傳回123
Number("123 456");          //傳回NaN

背景執行 gunicorn

安裝

sudo pip install gunicorn

背景執行

sudo gunicorn -w 1 -b 0.0.0.0:80 run:app --daemon

結束

查PID

ps -ef | grep gunicorn

sudo kill -9 12705

pip

pip install opencv-python

pip install tqdm

資料前處理

from sklearn.preprocessing import MinMaxScaler

scaler = MinMaxScaler()

df["population_density"] = scaler.fit_transform(df["population_density"].values.reshape(-1, 1))

python df heatmap

heatmap = df[["city","class"]]

heatmap["cnt"] = 1

heatmap = heatmap.groupby(["city","class"]).sum().unstack().fillna(0)

sigmoid

def sigmoid(X):  # define activation: sigmoid

    output = 1 / (1 + np.exp(-X))

    return output

def sigmoid_gradient(X):

    output = sigmoid(X)*(1-sigmoid(X))

    return output

def softmax(X):  # define activation: softmax

    return np.exp(X) / np.sum(np.exp(X), axis=1, keepdims=True)

def cross_entropy(p, q):

    epsilon = 1e-15

    H = 0

    for i in range(len(p)):

        H += -p[i]*np.log(q[i]+epsilon)

    H = H.sum()/p.shape[0]

    return H

from tensorflow import keras

# 做 One-hot encoding

y = keras.utils.to_categorical(array)

SQL (MySQL)

查詢table更新時間

select UPDATE_TIME FROM information_schema.TABLES where TABLE_NAME='{}'

SHOW VARIABLES LIKE '%group_concat%';

SET GLOBAL group_concat_max_len=102400;

SET SESSION group_concat_max_len=102400;

ON DUPLICATE KEY UPDATE

ALTER TABLE Persons ADD UNIQUE (Id_P) 

GROUP_CONCAT()

update update_test A inner join (select PAY_DATE,sum(EXPENSE) as U1,max(EXPENSE) as U2 from expense where PAY_DATE >= '2020/4/1' group by PAY_DATE) B on A.PAY_DATE=B.PAY_DATE set A.SUM_PAY=B.U1,A.MAX_PAY=B.U2;

數字轉字串
CONVERT(1,CHAR)

修改表格名
ALTER TABLE `原表格名` RENAME TO `新表格名`

改欄位名稱
ALTER TABLE `表格名` CHANGE COLUMN `舊欄位名` `新欄位名` 欄位類型
ALTER TABLE mfg_skill CHANGE COLUMN STAGE DEPT varchar(6)