R SQLITE表升级
R SQLITE表升级
提问于 2021-10-19 20:36:30
我想要更新表，并且我正在R中使用SQLite。我得到一个接近“良好”的systax错误。我找不到问题所在。
library(RSQLite)
library(ggplot2)
View(diamonds)
conn <- dbConnect(RSQLite::SQLite(),"diamonds.db")
dbListTables(conn)
dbWriteTable(conn, "pqr", diamonds,overwrite = TRUE)
dbListTables(conn)
d_1 <-dbGetQuery(conn, "SELECT * FROM pqr")
d_2 <- d_1[10,]
v_carat <- d_2$carat
v_cut <- d_2$cut
v_color <- d_2$color
#high test quality to be updated in clarity
this_p <- "high test quality"
dbExecute(conn, sprintf("UPDATE pqr SET clarity = '%s' where carat =%f and cut =%s and color =%s" ,
this_p, v_carat,v_cut,v_color))请指点一下。谢谢并致以问候，R
回答 1
Stack Overflow用户
发布于 2021-10-19 20:41:00
这两个字符串未加引号
> sprintf("UPDATE pqr SET clarity = '%s' where carat =%f and cut =%s and color =%s" ,
+ this_p, v_carat,v_cut,v_color)
[1] "UPDATE pqr SET clarity = 'high test quality' where carat =0.230000 and cut =Very Good and color =H"如果我们让它们成为'H'和'Very Good'，它应该可以工作
dbExecute(conn, sprintf("UPDATE pqr SET clarity = '%s' where carat =%f and cut ='%s' and color ='%s'" ,
this_p, v_carat,v_cut,v_color))
[1] 8-checking
> d_1 <-dbGetQuery(conn, "SELECT * FROM pqr")
>
> d_1[10,]
carat cut color clarity depth table price x y z
10 0.23 Very Good H high test quality 59.4 61 338 4 4.05 2.39-checking数据
> library(dplyr)
> d_1 %>%
filter(clarity == this_p, cut == v_cut, color == v_color)
carat cut color clarity depth table price x y z
1 0.23 Very Good H high test quality 59.4 61 338 4.00 4.05 2.39
2 0.23 Very Good H high test quality 61.0 57 353 3.94 3.96 2.41
3 0.23 Very Good H high test quality 62.4 55 431 3.91 3.94 2.45
4 0.23 Very Good H high test quality 62.6 56 431 3.92 3.95 2.46
5 0.23 Very Good H high test quality 61.6 56 434 3.94 3.97 2.43
6 0.23 Very Good H high test quality 63.9 55 369 3.89 3.90 2.49
7 0.23 Very Good H high test quality 62.0 55 378 3.93 3.95 2.44
8 0.23 Very Good H high test quality 59.2 61 389 4.00 4.04 2.38
> d_1 %>%
filter(clarity != this_p) %>%
head
carat cut color clarity depth table price x y z
1 0.23 Ideal E SI2 61.5 55 326 3.95 3.98 2.43
2 0.21 Premium E SI1 59.8 61 326 3.89 3.84 2.31
3 0.23 Good E VS1 56.9 65 327 4.05 4.07 2.31
4 0.29 Premium I VS2 62.4 58 334 4.20 4.23 2.63
5 0.31 Good J SI2 63.3 58 335 4.34 4.35 2.75
6 0.24 Very Good J VVS2 62.8 57 336 3.94 3.96 2.48页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/69637375
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号