Gimy: 3月 2020

2020年3月26日星期四

python train model

from sklearn import preprocessing
import numpy as np
import matplotlib.pyplot as plt
from sklearn import datasets
from sklearn.svm import SVC

cancer = datasets.load_breast_cancer()
x = cancer.data #feature
y = cancer.target # Label

from sklearn.model_selection import train_test_split
X_train,X_test,y_train,y_test = train_test_split(x,y,test_size=0.3, random_state=88)
# 建立要學習的模型
svm = SVC(kernel='linear', random_state=0)
#訓練==>
svm.fit(X_train, y_train)
y_pred = svm.predict(X_test)

print(y_pred)
print(y_test)
from sklearn.metrics import accuracy_score
accuracy_score(y_pred,y_test)

2020年3月18日星期三

jQuery ajax 定期更新跳訊息

<!DOCTYPE html>
<html>
<head>
<title></title>

<script src="https://code.jquery.com/jquery-3.4.1.min.js" type="text/javascript" ></script>
<script src="notice.js" type="text/javascript" ></script>
</head>
<body>
HELLO
<script>
$(document).ready(function () {
setInterval("startRequest()",1000);
});
function startRequest()
{
htmlobj=$.ajax({url:"ajax_info.txt",async:false});
$("#date").text((new Date()).toString());
$("#myDiv").html(htmlobj.responseText);

var dt = new Date();
if (dt.getSeconds()==0) {
pop();
}

}

function pop() {
var returnMsg = "內容";
$.show("標題",returnMsg,10000);
}

</script>

<div id="date">aaa</div>
<div id="myDiv"><h2>AJAX</h2></div>
</body>
</html>

2020年3月10日星期二

python to_txt

import pyodbc
import pandas as pd # 引用套件並縮寫為 pd

cnxn = pyodbc.connect("DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER=localhost; PORT=3306;DATABASE=my_db; UID=root; PASSWORD=gimy0710;OPTION=3;CHARSET=UTF8;")
SQL = "SELECT * FROM expense where PAY_DATE > '2020/1/1' order by PAY_DATE desc"
file_name = "test.txt"

df = pd.read_sql(SQL, cnxn)
cnxn.close()

txt = ""
for row in df.columns:
txt = txt + row + "|"
txt = txt + "\n"

for row in df.values:
for i in range(0,len(row)):
txt = txt + str(row[i]) + "|"
txt = txt + "\n"
#print(txt)
f = open(file_name,'w')
f.write(txt)
f.close()

2020年3月26日 星期四