Python executeの例

コード例 #1

import mlsql
from mlsql import execute

query = 'READ "data/iris.csv" SPLIT (train = .8, test = 0.2) CLASSIFY (predictors = [1,2,3,4], label = 5, algorithm = svm)'

execute(query)

コード例 #2

ファイル: mlsql_chronic.py プロジェクト: luckygong/ML-SQL

import mlsql
from mlsql import execute

print("Chronic Kidney Disease Logistic Regression")
query = 'READ "data/chronic.csv" (separator = ",", header = 0) \
REPLACE ("?", "mode") SPLIT (train = .8, test = 0.2) CLASSIFY \
(predictors = [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24],\
 label = 25, algorithm = logistic)'

execute(query, verbose=True)

コード例 #3

import mlsql
from mlsql import execute

query = 'READ "data/auto.csv" (separator = "\s+", header = None)\
 REPLACE ("?", "mode") SPLIT (train = .8, test = .2, validation = .0)\
  REGRESS (predictors = [2,3,4,5,6,7,8], label = 1, algorithm = simple)'

execute(query, verbose=False)