data visualization - How can I generate a simple dendrogram in R with 'edges' already known and the 'level' of the tree in a separate column?

Question

I have a very wide horticultural dataset describing multiplication of lab cultures and their branching into greater numbers of cultures over time. So essentially it's a parent/child table containing columns 'to' and 'from' to show cennections; and a 'level' column which describes the respective order of the tree that I'm trying to make.

I can't figure out how to transform this into a readable format for R as.dendrogram. The actual number of columns is much greater than that shown. The 'to plate' and 'from plate' are the connections I need in the tree. The 'level' denotes the desired level in the tree, beginning at 1 (root node) and ideally a root 0 since there are multiple level 1's. Representation of the data format below:

media	line	Level	To Plate	From Plate
multi	xxg	3	102	961
multi	xxg	3	103	961
multi	xxg	3	101	961
multi	xxh	2	961	1021
multi	xxh	1	1021	root node

question from:https://stackoverflow.com/questions/66056474/how-can-i-generate-a-simple-dendrogram-in-r-with-edges-already-known-and-the

Answer 1

Waitting for answers