You'd need to go over the imported json and fill-in the missing data with NA. # dbWriteTable(con, newdatatable,"combineddata",overwrite = T ) Any help would be very appreciated, i am struck here library("rjson")ĭbWriteTable(con, "newTable", json_data1, row.names=FALSE, append=TRUE)Ĭombineddata = rbind(json_data1,json_data2) Unable to find an inherited method for function ‘dbWriteTable’ for signature ‘"PostgreSQLConnection", "character", "list"’" above the line of code "dbWriteTable(con,"newdatatable", json_data1 )". I get the errors as "Error in (function (., row.names = NULL, check.rows = FALSE, check.names = TRUE, :Īrguments imply differing number of rows: 1, 0" above the line of code "json_data1 <- ame(json_data1)" and error "Error in (function (classes, fdef, mtable) : Also, these 2 apis don't have same number of rows, because of which cbind fill is needed, but that doesn't help. My aim is to merge 2 api into a data frame and then store it i a table in pgadmin4. I read them and store them in a data frame and when i try to export it to pgadmin4 to a table, i get errors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |