Hi R-helpers, i am using the following dataset.This dataset is stored in a
mysql database.
W(x) pH(y)
10 1
15 1
20 4
5
7.5 3
13
9 5
11.5
13.5 3
16 2
1
9.6 1
I am using RJDBC package to read the data from the database into a
dataFrame.The commands used are,
jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver",
classPath="E:/PAS/trunk/lib/mysql-connector-java-5.1.13-bin.jar",
identifier.quote = NA)
conn<-dbConnect(jdbcDriver,"jdbc:mysql://localhost/mysql","root","sa")
dbSendQuery(conn,"SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED")
dataFrame<-dbReadTable(conn,"1392_1_Result")
But, the resulting dataFrame has 0.0 /0 in place of the missing values.Can
you please let me know how i can avoid this and retain the missing values as
NA in my dataFrame?
--
View this message in context:
http://r.789695.n4.nabble.com/Reg-read-missing-values-from-database-using-RJDBC-tp3257766p3257766.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
