Tree using CSV

[pandeyrishabh]

I have a CSV dataset having columns like ID,Name,ParentId and I want to visualise it in Tree format Please Help anybody
id,Name,ParentId
ACAD0100,Academics,
ACAD0101,Science,ACAD0100
ACAD0201,Maths,ACAD0100
ACAD0301,Social Science,ACAD0100
ACAD0102,Biology ,ACAD0101
ACAD0103,Biotechnology,ACAD0101
ACAD0105,Health & Wellness,ACAD0101
ACAD0202, Algebra,ACAD0201
ACAD0203,Calculus,ACAD0201
ACAD0204,Geometry,ACAD0201
ACAD0302, Anthropology,ACAD0301
ACAD0303, Psychology,ACAD0301
This is just small part of dataset.

[Gribouillis]

What does it mean to visualize it in tree format?

[Axel_Erfurt]

you mean a table view ?

PyQt5 CSV

looks like this

[snippsat]

May his name is a hint pandeyrishabh

visualise it in Tree format

This is as mention unclear.

import pandas as pd
from io import StringIO
 
data = StringIO('''\
id,Name,ParentId
ACAD0100,Academics,
ACAD0101,Science,ACAD0100
ACAD0201,Maths,ACAD0100
ACAD0301,Social Science,ACAD0100
ACAD0102,Biology ,ACAD0101
ACAD0103,Biotechnology,ACAD0101
ACAD0105,Health & Wellness,ACAD0101
ACAD0202, Algebra,ACAD0201
ACAD0203,Calculus,ACAD0201
ACAD0204,Geometry,ACAD0201
ACAD0302, Anthropology,ACAD0301
ACAD0303, Psychology,ACAD0301''')
 
df = pd.read_csv(data, sep=",")
df

[pandeyrishabh]

I want to do something like this.
https://drive.google.com/file/d/1itMYLEU...sp=sharing

please check the image file

[Gribouillis]

I want to do something like this.

How will the computer know that Anthropology is not a part of Maths ?

EDIT: sorry, I didn't see the parent ID

[pandeyrishabh]

Same thing I am also searching as in data ParentId and Id is defined. I have to just visualise like Physics, chemistry maths comes under science, in the same manner, I want something to work upon dataset.
If you have some better way please suggest.

[Gribouillis]

I would recommend using module asciitree to print a simple tree in the terminal, or pydot or pydotplus to create an image file.