import pandas as pd #import libraries
import numpy as np
from sklearn.neighbors import KNeighborsClassifier
from sklearn import preprocessing
from sklearn.model_selection import TimeSeriesSplit
#import data
df=pd.read_csv('C:/Users/nithi/Google Drive/Python/Student Data/SCADA_and_downtime.csv',skip_blank_lines=True)
list1=list(df['turbine_id'].unique()) #list of turbines to plot
list1=sorted(list1,key=int) #sort turbines in ascending order
list2=list(df['TurbineCategory_id'].unique()) #list of categories
list2=[g for g in list2 if g>=0] #remove NaN from list
list2=sorted(list2,key=int) #sort categories in ascending order
list2=[m for m in list2 if m not in (1,12,13,14,15,17,21,22)] #categories to remove
num=[] #empty list to hold optimal n values for all turbines
err=[] #empty list to hold minimum error readings for all turbines
for x in list1: #filter only data for turbine x
dfx=df[(df['turbine_id']==x)].copy()
for y in list2: #copying fault to new column (mins) (fault when turbine category id is y)
def f(c):
if c['TurbineCategory_id']==y:
return 0
else:
return 1
dfx['mins']=dfx.apply(f,axis=1)
dfx=dfx.sort_values(by="timestamp",ascending=False) #sort values by timestamp in descending order
dfx.reset_index(drop=True,inplace=True) #reset index
if dfx.loc[0,'mins']==0: #assigning value to first cell if it's not 0
dfx.set_value(0,'mins',0)
else:
dfx.set_value(0,'mins',999999999)
for i,e in enumerate(dfx['mins']): #using previous value's row to evaluate time
if e==1:
dfx.at[i,'mins']=dfx.at[i-1,'mins']+10
dfx=dfx.sort_values(by="timestamp") #sort in ascending order
dfx.reset_index(drop=True,inplace=True) #reset index
dfx['hours']=dfx['mins'].astype(np.int64) #convert to hours, then round to nearest hour
dfx['hours']=dfx['hours']/60
dfx['hours']=round(dfx['hours']).astype(np.int64)
def f1(c): #>48 hours - label as normal (999)
if c['hours']>48:
return 999
else:
return c['hours']
dfx['hours']=dfx.apply(f1,axis=1)
def f2(c): #filter out curtailment - curtailed when turbine is pitching outside 0deg<= normal <=3.5deg
if 0<=c['pitch']<=3.5 or c['hours']!=999 or ((c['pitch']>3.5 or c['pitch']<0) and
(c['ap_av']<=(.1*dfx['ap_av'].max())
or c['ap_av']>=(.9*dfx['ap_av'].max()))):
return 'normal'
else:
return 'curtailed'
dfx['curtailment']=dfx.apply(f2,axis=1)
def f3(c): #filter unusual readings, i.e. for normal operation, power <=0 in operating wind speeds, power >100...
#before cut-in, runtime <600 and other downtime categories
if c['hours']==999 and ((3<c['ws_av']<25 and (c['ap_av']<=0 or c['runtime']<600 or
c['EnvironmentalCategory_id']>1 or c['GridCategory_id']>1 or
c['InfrastructureCategory_id']>1 or
c['AvailabilityCategory_id']==2 or
12<=c['TurbineCategory_id']<=15 or
21<=c['TurbineCategory_id']<=22)) or
(c['ws_av']<3 and c['ap_av']>100)):
return 'unusual'
else:
return 'normal'
dfx['unusual']=dfx.apply(f3,axis=1)
def f4(c): #round to 6 hour intervals
if 1<=c['hours']<=6:
return 6
elif 7<=c['hours']<=12:
return 12
elif 13<=c['hours']<=18:
return 18
elif 19<=c['hours']<=24:
return 24
elif 25<=c['hours']<=30:
return 30
elif 31<=c['hours']<=36:
return 36
elif 37<=c['hours']<=42:
return 42
elif 43<=c['hours']<=48:
return 48
else:
return c['hours']
dfx['hours6']=dfx.apply(f4,axis=1)
def f5(c): #change label for unusual and curtailed data (9999)
if c['unusual']=='unusual' or c['curtailment']=='curtailed':
return 9999
else:
return c['hours6']
dfx['hours_%s'%y]=dfx.apply(f5,axis=1)
dfx=dfx.drop('hours6',axis=1) #drop unnecessary columns
dfx=dfx.drop('hours',axis=1)
dfx=dfx.drop('mins',axis=1)
dfx=dfx.drop('curtailment',axis=1)
dfx=dfx.drop('unusual',axis=1)
#separate features from classes for classification
features=['ap_av','ws_av','wd_av','pitch','ap_max','ap_dev','reactive_power','rs_av','gen_sp','nac_pos']
classes=[col for col in dfx.columns if 'hours' in col]
list3=features+classes+['timestamp'] #list of columns to copy into new df
df2=dfx[list3].copy()
df2=df2.dropna() #drop NaNs
X=df2[features]
X=preprocessing.normalize(X) #normalise features to values b/w 0 and 1
Y=df2[classes]
Y=Y.as_matrix() #convert from pd dataframe to np array
weights=['uniform','distance'] #subsetting just the odd ones
scores=[] #empty list that will hold average cross validation scores for each n
tscv=TimeSeriesSplit(n_splits=5) #cross validation using time series split
for w in weights: #looping for each value of n and defining random forest classifier
knn=KNeighborsClassifier(weights=w,n_jobs=-1)
p1=[] #empty list to hold score for each cross validation fold
for train_index,test_index in tscv.split(X): #looping for each cross validation fold
X_train,X_test=X[train_index],X[test_index] #split train and test sets
Y_train,Y_test=Y[train_index],Y[test_index]
knn1=knn.fit(X_train,Y_train) #fit to classifier and predict
pred=knn1.predict(X_test)
p2=np.sum(np.equal(Y_test,pred))/Y_test.size #accuracy score
p1.append(p2) #add to list
p=sum(p1)/len(p1) #average score across all cross validation folds
scores.append(p)
MSE=[1-x for x in scores] #changing to misclassification error
optimal=weights[MSE.index(min(MSE))] #determining best n
num.append(optimal)
err.append(min(MSE))