rmysql和data.frame:nas通过强制到整数范围引入

bqujaahr  于 2021-06-19  发布在  Mysql
关注(0)|答案(0)|浏览(217)

我正在从mysql数据库中提取数据。mysql中的数据是float结构,但我在将它们加载到Dataframe时收到以下错误:“nas通过强制引入到integer range”
下面是mysql函数:

  1. ##
  2. ## MySQL function
  3. ##
  4. library(RMySQL)
  5. rozDB <- function(q,type) {
  6. mysql_conn <- dbConnect(
  7. MySQL(),
  8. user="",
  9. password="",
  10. dbname="",
  11. host="")
  12. if(type == "select") {
  13. query <- dbSendQuery(mysql_conn, q)
  14. result <- fetch(query, n = Inf)
  15. check <- dbHasCompleted(query)
  16. }
  17. if(type == "insert") {
  18. query <- dbSendQuery(mysql_conn, q)
  19. result <- "Complete"
  20. }
  21. dbClearResult(query)
  22. dbDisconnect(mysql_conn)
  23. return(result)
  24. }

数据调用:

  1. ###
  2. ### Build condition map and number of sessions
  3. ###
  4. conditions <- c()
  5. query1 <- paste0("SELECT notebook_condition conditions, COUNT(notebook_condition) count FROM key_map GROUP BY notebook_condition;")
  6. conditions <- rozDB(query1, "select")
  7. ###
  8. ### Get 1 day of 1 condition
  9. ###
  10. selectedCondition <- conditions[3,]
  11. for(i in 1:selectedCondition[1,2]){
  12. query3 <- paste0("SELECT kx,ky,kz FROM dataread3 WHERE `datetime` BETWEEN (SELECT `start_time` FROM key_map WHERE `cond` = '",selectedCondition[1,1],"' LIMIT ",i,",1) AND (SELECT `end_time` FROM key_map WHERE `cond` = '",selectedCondition[1,1],"' LIMIT ",i,",1);")
  13. print(query3)
  14. data <- rozDB(query3,"select")
  15. }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题