jameschin007 发表于 2017-10-13 09:31
用sqldf 包
select A.gene , A.sample , (A.weight-B.Weight) as adjusted_weigh from A left join ...
你好,我想问下,R中使用Update进行数据修改的时候,语法跟SQL的有区别吗?我按照SQL里面的语法写的,如下:
Data1=sqldf('update Data set mean_data.Item_Weight=Data.Item_Weight where Data.Item_Identifier=mean_data.Item_Identifier and Data.Item_Weight=""')
出现错误:Error in rsqlite_send_query(conn@ptr, statement) : near ".": syntax error