Relational databases are commonly used as data storage for web contents, big businesses and other data platforms. The PostgreSQL is a type of data storage called a relational database.It is one of the biggest open source relational databases. So, this is my code, and "mydata1" is a csv file with 2 columns.In this article, we will discuss two different ways to populate a PostgresSQL database with a csv file. #> # is_focus, is_unscheduled, total_sales Ĭreated on by the reprex package (v0.2.0).
#> # brand_name, qty_sales, line_type, is_mss , #> # prod_name, prod_code, outlet_type, categ_name , #> # distributor_code, outlet_name, outletid , #> # beat_name, beat_type, distributor_name , with 69 more rows, and 18 more variables: territory_name , #> 9 Trip… 3272 rajan.d… 96120… Front Li… Reshamba… West Tri… #> 8 Trip… 3272 rajan.d… 96120… Front Li… Dhaleswar West Tri… #> 7 Trip… 3272 rajan.d… 96120… Front Li… Dhaleswar West Tri… #> 6 Trip… 3272 rajan.d… 96120… Front Li… Reshamba… West Tri… #> 5 Trip… 2107 abhi.ba… 89746… Front Li… Krishna … West Tri… #> 4 Trip… 2107 abhi.ba… 89746… Front Li… Krishna … West Tri… #> 3 Trip… 2107 abhi.ba… 89746… Front Li… Ram Nagar West Tri… #> 2 Trip… 2107 abhi.ba… 89746… Front Li… Krishna … West Tri…
#> 1 Trip… 2107 abhi.ba… 89746… Front Li… Ram Nagar West Tri… #> state emp_code salesman mobile role_name order_date area_name zone_name Something like this could work, in this case: library("rjson")
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 kommentar(er)
