Create a Ladybug Table from a Data Frame — lb_create_table_from

Infers a schema from an R data.frame or tibble and creates a corresponding NODE table in the Ladybug database.

Usage

lb_create_table_from_df(conn, df, table_name, primary_key)

Arguments

conn: A Ladybug connection object.
df: A data.frame or tibble from which to infer the schema.
table_name: A string specifying the name of the new table in Ladybug.
primary_key: An optional string specifying the column to be used as the primary key. If not provided, no primary key will be set.

Value

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

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.

  my_df <- data.frame(
    name = c("Alice", "Bob"),
    age = c(25L, 30L),
    height = c(1.75, 1.80),
    is_student = c(TRUE, FALSE),
    birth_date = as.Date(c("1999-01-01", "1994-05-15"))
  )

  lb_create_table_from_df(conn, my_df, "Person", primary_key = "name")
#> Error: object 'conn' not found

  # Now you can load data into the created table
  lb_copy_from_df(conn, my_df, "Person")
#> Error: object 'conn' not found

  result <- lb_execute(conn, "MATCH (p:Person) RETURN *")
#> Error: object 'conn' not found
  print(as.data.frame(result))
#> Error: object 'result' not found
# }