Load Data from a Data Frame or Tibble into a Ladybug Table

Efficiently copies data from an R data.frame or tibble into a specified table in the Ladybug database.

Usage

lb_copy_from_df(conn, df, table_name)

Arguments

conn: A Ladybug connection object.
df: A data.frame or tibble containing the data to load. Column names in the data frame should match the property names in the Ladybug table.
table_name: A string specifying the name of the destination table in Ladybug.

Value

This function is called for its side effect of loading data and does not return a value.

Details

When loading into a relationship table, Ladybug assumes the first two columns in the file are: FROM Node Column: The primary key of the FROM nodes. TO Node Column: The primary key of the TO nodes.

Examples

# \donttest{
  conn <- lb_connection(":memory:")
#> Error in py_run_string_impl(code, local, convert): AttributeError: 'NoneType' object has no attribute 'Database'
#> Run `reticulate::py_last_error()` for details.
  lb_execute(conn, "CREATE NODE TABLE User(name STRING, age INT64,
  PRIMARY KEY (name))")
#> Error: object 'conn' not found
  lb_execute(conn, "CREATE REL TABLE Knows(FROM User TO User)")
#> Error: object 'conn' not found

  # Load from a data.frame
  users_df <- data.frame(name = c("Carol", "Dan"), age = c(35, 40))
  lb_copy_from_df(conn, users_df, "User")
#> Error: object 'conn' not found

  # Load from a tibble (requires pre-existing nodes)
  lb_execute(conn, "CREATE (u:User {name: 'Alice'}), (v:User {name: 'Bob'})")
#> Error: object 'conn' not found
  knows_df <- data.frame(from_person = c("Alice", "Bob"),
  to_person = c("Bob", "Carol"))
  lb_copy_from_df(conn, knows_df, "Knows")
#> Error: object 'conn' not found

  result <- lb_execute(conn, "MATCH (a:User) RETURN a.name, a.age")
#> Error: object 'conn' not found
  print(as.data.frame(result))
#> Error: object 'result' not found

  result_rel <- lb_execute(conn, "MATCH (a:User)-[k:Knows]->(b:User)
  RETURN a.name, b.name")
#> Error: object 'conn' not found
  print(as.data.frame(result_rel))
#> Error: object 'result_rel' not found
# }