Program MSE

Stuti Kulkarni, Tejaswini Reddy

Build a Sankey diagram to show how students move across elective courses from Year 1 to Year 3.

Step 1: Load the Required Libraries

Step 2: Import, load and explore the Dataset from the system location.

    Roll.Number Subject_1 Subject_2 Subject_3 Subject_4 Subject_5 Subject_6
1       21CS001         D         C         A         C         U         U
2       21CS002         D         B         A         A         S         C
3       21CS003         S         A         E         D         C         D
4       21CS004         A         D         E         C         S         A
5       21CS005         A         B         E         S         S         D
6       21CS006         U         S         D         B         U         D
7       21CS007         E         A         U         D         A         E
8       21CS008         C         C         A         S         A         U
9       21CS009         D         D         C         E         D         D
10      21CS010         E         A         E         C         S         S
11      21CS011         C         B         A         E         E         E
12      21CS012         B         D         B         D         D         U
13      21CS013         U         C         D         U         B         U
14      21CS014         U         D         A         U         A         E
15      21CS015         A         S         S         U         E         B
16      21CS016         S         D         E         C         S         D
17      21CS017         U         C         D         D         D         U
18      21CS018         C         S         A         U         A         U
19      21CS019         A         A         B         S         E         S
20      21CS020         D         A         S         U         A         B
21      21CS021         E         U         D         E         C         E
22      21CS022         A         S         U         D         E         U
23      21CS023         D         A         D         S         C         S
24      21CS024         C         S         C         E         U         U
25      21CS025         E         E         U         B         D         C
26      21CS026         B         C         A         D         C         D
27      21CS027         C         B         A         E         D         B
28      21CS028         S         B         B         C         C         U
29      21CS029         U         D         S         U         S         S
30      21CS030         C         S         E         S         E         D
31      21CS031         U         A         C         A         B         S
32      21CS032         E         E         C         A         D         A
33      21CS033         A         S         S         U         E         A
34      21CS034         D         U         C         C         A         D
35      21CS035         U         E         B         C         C         A
36      21CS036         B         S         U         A         B         S
37      21CS037         A         B         B         U         C         S
38      21CS038         B         U         C         D         B         D
39      21CS039         C         B         C         E         B         A
40      21CS040         C         E         B         A         D         S
41      21CS041         E         S         U         A         B         C
42      21CS042         C         C         E         B         D         U
43      21CS043         U         B         B         U         D         A
44      21CS044         C         A         S         A         E         U
45      21CS045         D         C         A         U         U         D
46      21CS046         D         B         A         C         A         D
47      21CS047         S         C         U         U         A         E
48      21CS048         U         S         D         S         A         U
49      21CS049         S         B         U         A         E         S
50      21CS050         B         B         B         S         D         U
51      21CS051         B         C         A         C         S         B
52      21CS052         S         C         D         A         C         S
53      21CS053         E         E         A         C         E         C
54      21CS054         U         A         S         U         U         C
55      21CS055         A         B         A         E         E         U
56      21CS056         C         C         E         U         S         E
57      21CS057         D         S         B         A         E         E
58      21CS058         S         A         U         S         E         D
59      21CS059         E         D         B         E         A         S
60      21CS060         E         A         S         S         D         S
61      21CS061         U         D         E         C         S         C
62      21CS062         S         B         U         U         E         B
63      21CS063         D         C         C         D         B         S
64      21CS064         S         C         D         B         S         S
65      21CS065         S         A         U         C         C         E
66      21CS066         S         E         E         S         B         A
67      21CS067         B         D         B         S         C         B
68      21CS068         A         B         E         B         E         B
69      21CS069         B         A         A         A         U         U
70      21CS070         E         B         S         A         S         U
71      21CS071         S         E         D         A         A         C
72      21CS072         C         A         U         D         S         U
73      21CS073         D         A         U         S         D         B
74      21CS074         D         A         C         U         C         U
75      21CS075         S         U         U         B         S         C
76      21CS076         C         S         A         S         E         S
77      21CS077         B         U         D         A         B         D
78      21CS078         E         S         D         B         C         S
79      21CS079         E         U         A         U         S         U
80      21CS080         A         B         U         C         C         S
81      21CS081         C         E         S         A         U         C
82      21CS082         U         A         S         S         E         A
83      21CS083         D         B         S         S         B         E
84      21CS084         B         B         C         B         D         U
85      21CS085         U         S         S         E         D         A
86      21CS086         C         S         A         A         E         B
87      21CS087         D         U         S         A         B         U
88      21CS088         A         B         E         E         U         S
89      21CS089         B         U         B         C         A         B
90      21CS090         D         C         C         B         S         U
91      21CS091         S         E         D         B         U         E
92      21CS092         S         S         C         S         C         U
93      21CS093         A         C         B         B         E         B
94      21CS094         D         D         U         C         C         U
95      21CS095         E         E         U         U         S         U
96      21CS096         E         S         S         E         U         A
97      21CS097         S         A         E         S         A         D
98      21CS098         D         C         E         A         S         A
99      21CS099         U         E         B         S         B         S
100     21CS100         A         U         E         B         D         B
    Subject_7 Subject_8 Subject_9 Subject_10         Elective
1           B         C         C          S   Cyber Security
2           A         B         E          E     Data Science
3           U         A         E          U     Data Science
4           E         S         S          U     Data Science
5           A         S         E          C   Cyber Security
6           S         U         B          A     Data Science
7           D         E         U          E Machine Learning
8           E         A         B          B     Data Science
9           S         U         C          D     Data Science
10          U         S         A          S     Data Science
11          A         C         A          A   Cyber Security
12          E         S         S          B Machine Learning
13          A         U         B          C     Data Science
14          E         E         S          C     Data Science
15          E         E         D          A Machine Learning
16          C         B         C          S Machine Learning
17          S         U         S          B   Cyber Security
18          C         C         C          C  Cloud Computing
19          C         C         A          C       Blockchain
20          S         S         C          S     Data Science
21          D         S         D          U   Cyber Security
22          E         E         U          A   Cyber Security
23          C         U         C          E   Cyber Security
24          B         D         B          A       Blockchain
25          D         D         B          E     Data Science
26          E         U         U          A     Data Science
27          A         C         C          E  Cloud Computing
28          D         S         A          A       Blockchain
29          S         E         S          A   Cyber Security
30          B         B         B          A   Cyber Security
31          U         C         E          S Machine Learning
32          E         S         D          E     Data Science
33          E         S         A          U       Blockchain
34          B         D         U          E   Cyber Security
35          C         S         C          D       Blockchain
36          C         B         C          E Machine Learning
37          B         D         D          C       Blockchain
38          E         B         E          D Machine Learning
39          D         A         E          C Machine Learning
40          C         D         A          A  Cloud Computing
41          D         S         C          C  Cloud Computing
42          B         E         E          E Machine Learning
43          B         A         U          D       Blockchain
44          U         U         D          B Machine Learning
45          E         D         E          E Machine Learning
46          A         U         A          D   Cyber Security
47          S         U         S          U Machine Learning
48          E         D         U          A  Cloud Computing
49          B         U         C          U     Data Science
50          S         U         C          A       Blockchain
51          E         D         B          B     Data Science
52          U         E         D          D     Data Science
53          S         A         S          E   Cyber Security
54          B         B         D          U Machine Learning
55          S         E         D          E     Data Science
56          D         E         C          D     Data Science
57          S         U         S          E  Cloud Computing
58          S         E         U          D Machine Learning
59          C         C         S          S Machine Learning
60          U         A         D          E       Blockchain
61          U         C         C          E       Blockchain
62          A         D         S          E  Cloud Computing
63          S         D         C          C Machine Learning
64          S         D         C          B     Data Science
65          E         A         U          C     Data Science
66          S         U         D          S   Cyber Security
67          D         U         D          D     Data Science
68          A         E         A          S     Data Science
69          S         C         C          D       Blockchain
70          C         B         B          C Machine Learning
71          C         D         S          C       Blockchain
72          B         C         E          E       Blockchain
73          B         E         S          D     Data Science
74          A         S         C          E   Cyber Security
75          U         U         A          S  Cloud Computing
76          U         A         E          C       Blockchain
77          E         A         C          A     Data Science
78          U         E         U          E     Data Science
79          E         B         E          A     Data Science
80          D         E         S          S       Blockchain
81          S         U         S          U     Data Science
82          C         U         A          S       Blockchain
83          S         D         S          E     Data Science
84          D         A         E          E Machine Learning
85          S         D         S          U Machine Learning
86          B         U         C          B     Data Science
87          C         C         S          U Machine Learning
88          U         C         B          U     Data Science
89          S         A         B          C     Data Science
90          D         B         A          B  Cloud Computing
91          B         E         C          D  Cloud Computing
92          C         A         E          S   Cyber Security
93          B         A         D          A     Data Science
94          U         D         C          A Machine Learning
95          U         C         S          C Machine Learning
96          C         U         D          C       Blockchain
97          A         B         U          B  Cloud Computing
98          U         E         E          B       Blockchain
99          A         S         D          S       Blockchain
100         A         D         B          C Machine Learning
  Roll.Number Subject_1 Subject_2 Subject_3 Subject_4 Subject_5 Subject_6
1     21CS001         D         C         A         C         U         U
2     21CS002         D         B         A         A         S         C
3     21CS003         S         A         E         D         C         D
4     21CS004         A         D         E         C         S         A
5     21CS005         A         B         E         S         S         D
6     21CS006         U         S         D         B         U         D
  Subject_7 Subject_8 Subject_9 Subject_10       Elective
1         B         C         C          S Cyber Security
2         A         B         E          E   Data Science
3         U         A         E          U   Data Science
4         E         S         S          U   Data Science
5         A         S         E          C Cyber Security
6         S         U         B          A   Data Science
'data.frame':   100 obs. of  12 variables:
 $ Roll.Number: chr  "21CS001" "21CS002" "21CS003" "21CS004" ...
 $ Subject_1  : chr  "D" "D" "S" "A" ...
 $ Subject_2  : chr  "C" "B" "A" "D" ...
 $ Subject_3  : chr  "A" "A" "E" "E" ...
 $ Subject_4  : chr  "C" "A" "D" "C" ...
 $ Subject_5  : chr  "U" "S" "C" "S" ...
 $ Subject_6  : chr  "U" "C" "D" "A" ...
 $ Subject_7  : chr  "B" "A" "U" "E" ...
 $ Subject_8  : chr  "C" "B" "A" "S" ...
 $ Subject_9  : chr  "C" "E" "E" "S" ...
 $ Subject_10 : chr  "S" "E" "U" "U" ...
 $ Elective   : chr  "Cyber Security" "Data Science" "Data Science" "Data Science" ...
 Roll.Number         Subject_1          Subject_2          Subject_3        
 Length:100         Length:100         Length:100         Length:100        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  
  Subject_4          Subject_5          Subject_6          Subject_7        
 Length:100         Length:100         Length:100         Length:100        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  
  Subject_8          Subject_9          Subject_10          Elective        
 Length:100         Length:100         Length:100         Length:100        
 Class :character   Class :character   Class :character   Class :character  
 Mode  :character   Mode  :character   Mode  :character   Mode  :character  

Step 3: Analysing the Dataset and Select one subject per year

Step 5: Sankey Diagram Elective Pathway (Year 1 —>3)

Step 6: Creating a violin plot for the same sankey diagram data to compare