python


Is there a way for me to view the classes of particular instances in binary classified dataset using scikit learn


Is there a way for me to view the classes of particular instances in a binary classified dataset(classes are 0 or 1) using the scikit learn library. I have a program that performs knn on a dataset and inserts the model built into a database. I want to view instances in the the data that are classified as 0 or 1. This is the link to the dataset I am using https://drive.google.com/open?id=0B9cQtdthFqv3YVNBNk1peVltZkk
from sklearn import neighbors,datasets,preprocessing
from sklearn.cross_validation import train_test_split
import urllib.request
from sklearn.metrics import accuracy_score
import pandas as pd
import matplotlib.pyplot as plt
from sklearn import model_selection
from sklearn.metrics import precision_recall_fscore_support as score
from sklearn.externals import joblib
from sklearn.model_selection import cross_val_score
from pandas import read_csv
from sklearn.ensemble import ExtraTreesClassifier
import pandas as pd
import numpy as np
import sys
import pickle
import mysql.connector as mc
def doSupervised(username,fileid,filename):
try:
connection = mc.connect (host = "localhost",
user = "**",
passwd = "**",
db = "**")
except mc.Error as e:
print("Error %d: %s" % (e.args[0], e.args[1]))
sys.exit(1)
cursor = connection.cursor()
# load data
dataframe = pd.DataFrame.from_csv(filename)
X= np.array(dataframe)
y = np.array(dataframe['Class'])
# fit an Extra Trees model to the data
model = ExtraTreesClassifier()
model.fit_transform(X, y)
# display the relative importance of each attribute
#print(model.feature_importances_)
X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2)
clf = neighbors.KNeighborsClassifier(algorithm='auto')
#fit the data to the model
clf.fit(X_train, y_train)
y_pred = clf.predict(X_test)
#print (y_pred)
algorithmType="Supervised"
accuracy =accuracy_score(y_test, y_pred )
print(accuracy)
#save classifier to a file
name="supervisedmodel.pkl"
data = joblib.dump(clf, name)
#name = 'supervisedmodel.sav'
#data = pickle.dump(clf, open(name, 'wb'))
sql_command = "INSERT INTO machinelearningmodel (username, fileID,
name,data,accuracy,algorithmType ) VALUES (%s, %s, %s, %s, %s, %s)",
(username, str(fileid), name, str(data), str(accuracy),algorithmType)
cursor.execute(*sql_command)
#print(sql_command)
cursor.close()
connection.commit()
connection.close()
if __name__ == "__main__":
doSupervised(sys.argv[1],sys.argv[2],sys.argv[3])

Related Links

Pywinauto Windows Exists but not Visible
Changing pixel values in of a 50x50 square 2d numpy array
Read in multi-level, complicated dictionary from text file in Python?
How to make random algorithm more efficient
How to force google to allow user to choose accounts during oauth?
PyQt: Qtablewidget itemClick
Pandas column indexing for searching?
Buildozer/Kivy: TextInput crashes on numeric input in Android
Adding markers or lines to colorbar in matplotlib
Code against Pywin32 on OS X?
Pandas: Find previous row of matching value
PyGtk3, ToggleButton, “toggled-or-untoggled” event
Reaplce img value with value from list Python
Python - Displaying json data
Partial patch in Python with mock
Radio button does not get clicked in Selenium / Python

Categories

HOME
python
jar
rotation
playframework
recyclerview
console
i2c
google-spreadsheet-api
shader
desktop
google-shopping
finite-group-theory
public-key-encryption
viber
gwtp
scenebuilder
android-toolbar
flat-file
propel2
kadanes-algorithm
flexboxgrid
countif
kitematic
source-maps
sumo
java-ee-7
onesignal
web-frontend
google-api-dotnet-client
thinking-sphinx
multichoiceitems
piecewise
twitter-bootstrap-2
read-write
transient
lego
bigcartel
parent
rule
ivona
mouseclick-event
maintenance
tcserver
modelattribute
opencpu
vici
sqldatareader
master
hspec
push-diffusion
manifest.mf
windows-nt
nssplitview
contour
spatial-query
twgl.js
asymptote
hornetq
uialertview
sqoop2
jcr-sql2
node-inspector
genetic-programming
libssh2
phpdocx
zipalign
flash-cc
sqljdbc
magicalrecord-2.2
bfd
nsmatrix
va-list
mstsc
icsharpcode
rose-db-object
point-sprites
hashalgorithm
fileutils
surf
newsstand-kit
requestfactory
recordset
sitemappath
camtasia
file-encodings
visual-studio-2010-beta-2
database-diagramming

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App