Breaking News: Grepper is joining You.com. Read the official announcement!

Pandas dataframe to tree

Athul Mathew answered on August 1, 2022 Popularity 3/10 Helpfulness 2/10

answer Pandas dataframe to tree

Pandas dataframe to tree

Comment

df['Parent_child'] = df['Parent'] + ',' + df['child'] # column of comma separated Parent,child

    i = 0
    for index, row in df.iterrows():
        if row['child']==row['Parent']:  # I modified the DataFrame by concatenating a 
                                         # dataframe of all the roots in my data, then 
                                         # copied in into both parent and child columns.  
                                         # This can be skipped by statically setting the 
                                         # roots, only making sure the assumption 
                                         # highlighted by @Fabien in the above quoted 
                                         # answer still holds true (This assumes that the 
                                         # entries are in such an order that a parent node 
                                         # was always introduced as a child of another 
                                         # node beforehand)

            root = Node(row['Parent'])
            nodes = {}
            nodes[root.name] = root
            i=i+1
        else:
            line = row['Parent_child'].split(",")
            name = "".join(line[1:]).strip()
            nodes[name] = Node(name, parent=nodes[line[0]])
            #predecessor = df['child_Parent'].values[i]
            i=i+1
                
    for pre, _, node in RenderTree(root):
        print("%s%s" % (pre, node.name))

Popularity 3/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: dataframe pandas python tree

Link to this answer
Share Copy Link

Contributed on Aug 01 2022

Athul Mathew

0 Answers Avg Quality 2/10

Pandas dataframe to tree

Contents

More Related Answers

Pandas dataframe to tree

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.