0

library Gmum.r is not support SVR(Support vector regression)?

    library(RODBC)
    sqlConnString = "driver={SQL 
    Server};server=140.136.156.36;database=RealEstate_final;uid={sa};pwd=
    {Root1234}" 
    conn <- odbcDriverConnect(sqlConnString) 
    EstateNew <- sqlQuery(conn, " SELECT * FROM EstateNew ") 
    #head(FraudDF1, 5) 
    odbcClose(conn) 

expectcol<-delete neednt column

expectcol <- 
    c("ID","Address","RealAddr","NonUrbanZone","NonUrbanLand","Aport_ID"
    ,"ParkB_ID","Univ_ID","ParkR_ID","Rzone_ID","Rzone_CentDistance"
    ,"Flood_ID","Flood_CentDistance","SoilLiq_ID","MRT_ID","MRT_OrderS"         
    ,"MRT_LID","MRT_OrderLS","Fway_ID","Fway_OrderS","Fway_LID","Fway_OrderLS"            
    ,"TRA_ID","TRA_OrderS","TRA_LID","TRA_OrderLS","THSR_ID","THSR_OrderS"
    ,"THSR_LID","THSR_OrderLS","River_ID","River_OrderLS","Fault_ID"
    ,"Fault_OrderLS","A001_ID","A002_ID","A003_ID","A004_ID","E001_ID"               
    ,"E002_ID","L001_ID","L002_ID","L003_ID","L004_ID","B001_ID","B002_ID"
    ,"B003_ID","Lng_X","Lat_Y","Section","Rzone","ParkingType","ParkingArea"
    ,"ParkingPrice","ParkingLot","TotalPrice")
    #EstateNew$TransDate<-as.Date(EstateNew$TransDate)
    #EstateNew$HouseDate<-as.Date(EstateNew$HouseDate)
    #,"TransDate","HouseDate"
    #將expectcol剃除
    tempdata <- EstateNew[,!names(EstateNew) %in% expectcol,drop=FALSE]

choose department

tempdata<-subset(tempdata, 
                 tempdata$TransType==3 & tempdata$ZoneUse==2 
                 & tempdata$HouseUse==1 & tempdata$HouseType==1)

delete na data

sum(complete.cases(tempdata))
tempdata <- na.omit(tempdata)

house age

transyear<-as.numeric(substr(tempdata$TransDate, 1, 4))
    houseyear<-as.numeric(substr(tempdata$HouseDate, 1, 4))

    age_frame <- data.frame(HouseAge = transyear-houseyear)
    tempdata<-cbind(tempdata,age_frame)
    expectcol <-c("TransDate","HouseDate")
    tempdata <- tempdata[,!names(tempdata) %in% expectcol,drop=FALSE]

FEATURE SELECTION VALUE

finaldata<-subset(tempdata,  
              select = c("Lng","Pcode5_ID","TransFloor","HouseArea"                          ,"Lat","River_LineDistance","A002_Distance","ParkB_Distance"
                         ,"MRT_LineDistance","LandArea","A003_Distance"
                         ,"L002_Distance","L003_Distance"
                         ,"HouseAge","Price"))

    index <- 1:nrow(finaldata)
    np = ceiling(1*nrow(finaldata))
    test.index = sample(1:nrow(finaldata),np)
    #testdata = finaldata[test.index,]
    traindata = finaldata[test.index,]

SVR

library(gmum.r)
svm.rbf <- SVM(formula=Price~., data=traindata, core="libsvm", kernel="rbf", 
C=1.0, gamma=0.5)

train Support vector regression model has some error

WARNING_LEVEL: using -h 0 may be faster optimization finished, #iter = 1024

  • > sessionInfo() R version 3.4.0 (2017-04-21) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 7 x64 (build 7601) Service Pack 1 – Chia-Hsien Lee Jun 28 '17 at 05:08
  • You may need to make a reproducible example (see [here](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example)). – Roman Luštrik Jun 28 '17 at 05:56

0 Answers0