I have data frame
df = pd.DataFrame({'Branch': ['ECE', 'ICE', 'IT', 'CSE', 'CHE','ECE', 'IT', 'CSE'],
'CGPA': [8.15, 9.03, 7.85, 8.55, 9.45,7.89, 8.89, 9.90],
'Name': ['Sanjay', 'Aman', 'Ankit', 'Ravi', 'Komal', 'sunny', 'venky', 'Monal'],
'Roll': [111, 112, 113, 114, 115, 116, 117, 118]})
I want the data frame based column Branch and the branch column order should be ECE<CSE<IT<CHE<ICE
output should be:
Branch CGPA NAME Roll
ECE 8.85 Sanjay 111
ECE 8.89 Sunny 116
CSE 8.55 Ravi 114
CSE 9.90 Monal 118
IT 7.85 Ankit 113
IT 8.89 Venky 117
CHE 9.45 Komal 115
ICE 9.03 Aman 112