Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	19
Missing cells	14
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.3 KiB
Average record size in memory	230.7 B

Variable types

CAT	23
NUM	4
BOOL	1

Reproduction

Analysis started	2020-10-02 07:34:36.909880
Analysis finished	2020-10-02 07:34:42.276335
Duration	5.37 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Department` has constant value "Master of Computer Applications"	Constant
`Academic Year` has constant value "2017-18"	Constant
`Draft` has constant value "0"	Constant
`Updated By` is highly correlated with `Created By` and 1 other fields	High correlation
`Created By` is highly correlated with `Updated By` and 1 other fields	High correlation
`ID` is highly correlated with `Created By` and 1 other fields	High correlation
`3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course.` is highly correlated with `Name` and 2 other fields	High correlation
`Name` is highly correlated with `3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course.` and 11 other fields	High correlation
`5. Adequate exposure is provided to relevant software` is highly correlated with `Name` and 2 other fields	High correlation
`6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill` is highly correlated with `Name` and 2 other fields	High correlation
`7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment` is highly correlated with `Name` and 4 other fields	High correlation
`10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department` is highly correlated with `Name` and 5 other fields	High correlation
`13. All faculty members of the department are co-operative, always helpful even beyond class hours` is highly correlated with `Name`	High correlation
`14. Faculty members explains different topics through example and practical applications and often use computer aided methods of teaching (online/offline)` is highly correlated with `Name` and 3 other fields	High correlation
`Remarks:` is highly correlated with `Name` and 12 other fields	High correlation
`2. The core courses offer an in-depth exposure to the subject.` is highly correlated with `Remarks:`	High correlation
`8. The library provides text book, reference book, and other e resources as and when required` is highly correlated with `Remarks:`	High correlation
`9. The canteen facility is quite adequate and the quality of food is also good` is highly correlated with `Remarks:`	High correlation
`12.The evaluation system of the university is always fair and results are declared in time` is highly correlated with `Remarks:`	High correlation
`Timestamp` is highly correlated with `Name` and 6 other fields	High correlation
`Last Updated` is highly correlated with `Name` and 6 other fields	High correlation
`IP` is highly correlated with `Name` and 9 other fields	High correlation
`Key` is highly correlated with `Name` and 9 other fields	High correlation
`Remarks:` has 14 (73.7%) missing values	Missing
`Remarks:` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`Name` has unique values	Unique
`Timestamp` has unique values	Unique
`Last Updated` has unique values	Unique
`Created By` has unique values	Unique
`Updated By` has unique values	Unique
`IP` has unique values	Unique
`ID` has unique values	Unique
`Key` has unique values	Unique
`df_index` has 1 (5.3%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE
ZEROS

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48.578947368421055
Minimum	0
Maximum	114
Zeros	1
Zeros (%)	5.3%
Memory size	152.0 B

Quantile statistics

Minimum	0
5-th percentile	4.5
Q1	28
median	44
Q3	69
95-th percentile	105
Maximum	114
Range	114
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	30.89645033
Coefficient of variation (CV)	0.6360049365
Kurtosis	-0.1169921975
Mean	48.57894737
Median Absolute Deviation (MAD)	21
Skewness	0.5347490721
Sum	923
Variance	954.5906433

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
60	1	5.3%
75	1	5.3%
65	1	5.3%
35	1	5.3%
5	1	5.3%
39	1	5.3%
104	1	5.3%
73	1	5.3%
32	1	5.3%
44	1	5.3%
Other values (9)	9	47.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	5.3%
5	1	5.3%
20	1	5.3%
21	1	5.3%
24	1	5.3%

Value	Count	Frequency (%)
114	1	5.3%
104	1	5.3%
80	1	5.3%
75	1	5.3%
73	1	5.3%

Name
Categorical

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Deep Basak	1
Syed Babar Ali	1
Nitesh Kumar	1
AMBIKA	1
Suvasree Bhattacharjee	1
Other values (14)	14

Common Values
Length

Value	Count	Frequency (%)
Deep Basak	1	5.3%
Syed Babar Ali	1	5.3%
Nitesh Kumar	1	5.3%
AMBIKA	1	5.3%
Suvasree Bhattacharjee	1	5.3%
Soumya Kanti Roy	1	5.3%
avik das	1	5.3%
Chaitali Nandi	1	5.3%
MD SALMAN KHURSHID	1	5.3%
Sayan Roy	1	5.3%
Other values (9)	9	47.4%

Length

Max length	22
Median length	13
Mean length	12.68421053
Min length	6

Department
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Master of Computer Applications	19

Common Values
Length

Value	Count	Frequency (%)
Master of Computer Applications	19	100.0%

Length

Max length	31
Median length	31
Mean length	31
Min length	31

Academic Year
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

2017-18	19

Common Values
Length

Value	Count	Frequency (%)
2017-18	19	100.0%

Length

Max length	7
Median length	7
Mean length	7
Min length	7

1. The curriculum is up to date and relevant from the point of view of employability.
Categorical

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	8
Average	5
Strongly agree	4
Neutral	2

Common Values
Length

Value	Count	Frequency (%)
Agree	8	42.1%
Average	5	26.3%
Strongly agree	4	21.1%
Neutral	2	10.5%

Length

Max length	14
Median length	7
Mean length	7.631578947
Min length	5

2. The core courses offer an in-depth exposure to the subject.
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	8
Average	8
Strongly agree	3

Common Values
Length

Value	Count	Frequency (%)
Agree	8	42.1%
Average	8	42.1%
Strongly agree	3	15.8%

Length

Max length	14
Median length	7
Mean length	7.263157895
Min length	5

3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course.
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Average	8
Strongly agree	6
Agree	5

Common Values
Length

Value	Count	Frequency (%)
Average	8	42.1%
Strongly agree	6	31.6%
Agree	5	26.3%

Length

Max length	14
Median length	7
Mean length	8.684210526
Min length	5

4. Sufficient practical exposure is provided for the theoretical concepts in the courses
Categorical

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	8
Strongly agree	8
Average	3

Common Values
Length

Value	Count	Frequency (%)
Agree	8	42.1%
Strongly agree	8	42.1%
Average	3	15.8%

Length

Max length	14
Median length	7
Mean length	9.105263158
Min length	5

5. Adequate exposure is provided to relevant software
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Average	7
Agree	6
Strongly agree	6

Common Values
Length

Value	Count	Frequency (%)
Average	7	36.8%
Agree	6	31.6%
Strongly agree	6	31.6%

Length

Max length	14
Median length	7
Mean length	8.578947368
Min length	5

6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Average	8
Strongly agree	7
Agree	4

Common Values
Length

Value	Count	Frequency (%)
Average	8	42.1%
Strongly agree	7	36.8%
Agree	4	21.1%

Length

Max length	14
Median length	7
Mean length	9.157894737
Min length	5

7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment
Categorical

HIGH CORRELATION

Distinct count	3
Unique (%)	15.8%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	9
Average	5
Strongly agree	5

Common Values
Length

Value	Count	Frequency (%)
Agree	9	47.4%
Average	5	26.3%
Strongly agree	5	26.3%

Length

Max length	14
Median length	7
Mean length	7.894736842
Min length	5

8. The library provides text book, reference book, and other e resources as and when required
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Strongly agree	8
Average	7
Agree	3
Disagree	1

Common Values
Length

Value	Count	Frequency (%)
Strongly agree	8	42.1%
Average	7	36.8%
Agree	3	15.8%
Disagree	1	5.3%

Length

Max length	14
Median length	7
Mean length	9.684210526
Min length	5

9. The canteen facility is quite adequate and the quality of food is also good
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Average	8
Agree	5
Strongly agree	3
Neutral	3

Common Values
Length

Value	Count	Frequency (%)
Average	8	42.1%
Agree	5	26.3%
Strongly agree	3	15.8%
Neutral	3	15.8%

Length

Max length	14
Median length	7
Mean length	7.578947368
Min length	5

10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Strongly agree	11
Agree	4
Average	3
Neutral	1

Common Values
Length

Value	Count	Frequency (%)
Strongly agree	11	57.9%
Agree	4	21.1%
Average	3	15.8%
Neutral	1	5.3%

Length

Max length	14
Median length	14
Mean length	10.63157895
Min length	5

11. The college provides hostel facilities with all necessary amenities to the student
Categorical

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	10
Strongly agree	4
Neutral	3
Average	2

Common Values
Length

Value	Count	Frequency (%)
Agree	10	52.6%
Strongly agree	4	21.1%
Neutral	3	15.8%
Average	2	10.5%

Length

Max length	14
Median length	5
Mean length	7.421052632
Min length	5

12.The evaluation system of the university is always fair and results are declared in time
Categorical

HIGH CORRELATION

Distinct count	5
Unique (%)	26.3%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Agree	8
Strongly agree	6
Neutral	2
Average	2
Disagree	1

Common Values
Length

Value	Count	Frequency (%)
Agree	8	42.1%
Strongly agree	6	31.6%
Neutral	2	10.5%
Average	2	10.5%
Disagree	1	5.3%

Length

Max length	14
Median length	7
Mean length	8.421052632
Min length	5

13. All faculty members of the department are co-operative, always helpful even beyond class hours
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Strongly agree	13
Agree	3
Average	2
Neutral	1

Common Values
Length

Value	Count	Frequency (%)
Strongly agree	13	68.4%
Agree	3	15.8%
Average	2	10.5%
Neutral	1	5.3%

Length

Max length	14
Median length	14
Mean length	11.47368421
Min length	5

14. Faculty members explains different topics through example and practical applications and often use computer aided methods of teaching (online/offline)
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Strongly agree	7
Agree	7
Average	4
Disagree	1

Common Values
Length

Value	Count	Frequency (%)
Strongly agree	7	36.8%
Agree	7	36.8%
Average	4	21.1%
Disagree	1	5.3%

Length

Max length	14
Median length	7
Mean length	8.894736842
Min length	5

15. Co-Curricular activities are encouraged and endorsed by faculty members .
Categorical

Distinct count	4
Unique (%)	21.1%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

Strongly agree	7
Agree	7
Neutral	3
Average	2

Common Values
Length

Value	Count	Frequency (%)
Strongly agree	7	36.8%
Agree	7	36.8%
Neutral	3	15.8%
Average	2	10.5%

Length

Max length	14
Median length	7
Mean length	8.842105263
Min length	5

Remarks:
Categorical

HIGH CORRELATION
MISSING
UNIFORM

Distinct count	5
Unique (%)	100.0%
Missing	14
Missing (%)	73.7%
Memory size	152.0 B

I think the course in the First and Second semester are for the basics those who are not from the computer background i.e came from B.Sc (Maths) so the curriculum is good for them.	1
Good	1
All of my respected teachers are very helpful.	1
Nice learning experience	1
Sometimes, the truth hurts. Students are taught to respect those who lead with a firm..and often stern hand because they know that the teachers are rooting for them.	1

Common Values
Length

Value	Count	Frequency (%)
I think the course in the First and Second semester are for the basics those who are not from the computer background i.e came from B.Sc (Maths) so the curriculum is good for them.	1	5.3%
Good	1	5.3%
All of my respected teachers are very helpful.	1	5.3%
Nice learning experience	1	5.3%
Sometimes, the truth hurts. Students are taught to respect those who lead with a firm..and often stern hand because they know that the teachers are rooting for them.	1	5.3%
(Missing)	14	73.7%

Length

Max length	180
Median length	3
Mean length	24.26315789
Min length	3

Timestamp
Categorical

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

2020-07-26 06:16:12	1
2020-07-25 09:36:06	1
2020-07-25 13:32:59	1
2020-07-25 13:51:03	1
2020-07-28 13:04:21	1
Other values (14)	14

Common Values
Length

Value	Count	Frequency (%)
2020-07-26 06:16:12	1	5.3%
2020-07-25 09:36:06	1	5.3%
2020-07-25 13:32:59	1	5.3%
2020-07-25 13:51:03	1	5.3%
2020-07-28 13:04:21	1	5.3%
2020-07-25 03:37:57	1	5.3%
2020-07-25 08:08:57	1	5.3%
2020-07-25 09:35:57	1	5.3%
2020-07-25 19:49:41	1	5.3%
2020-07-25 08:16:47	1	5.3%
Other values (9)	9	47.4%

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Last Updated
Categorical

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

2020-07-26 06:16:12	1
2020-07-25 09:36:06	1
2020-07-25 13:32:59	1
2020-07-25 13:51:03	1
2020-07-28 13:04:21	1
Other values (14)	14

Common Values
Length

Value	Count	Frequency (%)
2020-07-26 06:16:12	1	5.3%
2020-07-25 09:36:06	1	5.3%
2020-07-25 13:32:59	1	5.3%
2020-07-25 13:51:03	1	5.3%
2020-07-28 13:04:21	1	5.3%
2020-07-25 03:37:57	1	5.3%
2020-07-25 08:08:57	1	5.3%
2020-07-25 09:35:57	1	5.3%
2020-07-25 19:49:41	1	5.3%
2020-07-25 08:16:47	1	5.3%
Other values (9)	9	47.4%

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Created By
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	691.9473684210526
Minimum	564
Maximum	1101
Zeros	0
Zeros (%)	0.0%
Memory size	152.0 B

Quantile statistics

Minimum	564
5-th percentile	567.6
Q1	607
median	653
Q3	671.5
95-th percentile	1011
Maximum	1101
Range	537
Interquartile range (IQR)	64.5

Descriptive statistics

Standard deviation	148.3915518
Coefficient of variation (CV)	0.2144549694
Kurtosis	2.860546653
Mean	691.9473684
Median Absolute Deviation (MAD)	37
Skewness	1.869116336
Sum	13147
Variance	22020.05263

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
671	1	5.3%
1101	1	5.3%
667	1	5.3%
616	1	5.3%
649	1	5.3%
664	1	5.3%
652	1	5.3%
653	1	5.3%
654	1	5.3%
733	1	5.3%
Other values (9)	9	47.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
564	1	5.3%
568	1	5.3%
571	1	5.3%
573	1	5.3%
598	1	5.3%

Value	Count	Frequency (%)
1101	1	5.3%
1001	1	5.3%
904	1	5.3%
733	1	5.3%
672	1	5.3%

Updated By
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	691.9473684210526
Minimum	564
Maximum	1101
Zeros	0
Zeros (%)	0.0%
Memory size	152.0 B

Quantile statistics

Minimum	564
5-th percentile	567.6
Q1	607
median	653
Q3	671.5
95-th percentile	1011
Maximum	1101
Range	537
Interquartile range (IQR)	64.5

Descriptive statistics

Standard deviation	148.3915518
Coefficient of variation (CV)	0.2144549694
Kurtosis	2.860546653
Mean	691.9473684
Median Absolute Deviation (MAD)	37
Skewness	1.869116336
Sum	13147
Variance	22020.05263

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
671	1	5.3%
1101	1	5.3%
667	1	5.3%
616	1	5.3%
649	1	5.3%
664	1	5.3%
652	1	5.3%
653	1	5.3%
654	1	5.3%
733	1	5.3%
Other values (9)	9	47.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
564	1	5.3%
568	1	5.3%
571	1	5.3%
573	1	5.3%
598	1	5.3%

Value	Count	Frequency (%)
1101	1	5.3%
1001	1	5.3%
904	1	5.3%
733	1	5.3%
672	1	5.3%

Draft
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

0	19

Frequency Table

Value	Count	Frequency (%)
0	19	100.0%

IP
Categorical

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

2409:4061:717:7097:544c:438c:f748:1468	1
2409:4064:79b:898d::82b:68a4	1
2409:4061:2d98:a80:54:792a:ac03:95ce	1
2409:4064:208f:2610:f495:c043:ba1b:c02b	1
42.110.217.161	1
Other values (14)	14

Common Values
Length

Value	Count	Frequency (%)
2409:4061:717:7097:544c:438c:f748:1468	1	5.3%
2409:4064:79b:898d::82b:68a4	1	5.3%
2409:4061:2d98:a80:54:792a:ac03:95ce	1	5.3%
2409:4064:208f:2610:f495:c043:ba1b:c02b	1	5.3%
42.110.217.161	1	5.3%
2409:4061:2e02:16ec:f589:51c7:ae5a:f75b	1	5.3%
103.10.209.99	1	5.3%
42.110.248.198	1	5.3%
146.196.45.79	1	5.3%
2409:4064:b0c:9524:20a0:5ef0:3137:ad1c	1	5.3%
Other values (9)	9	47.4%

Length

Max length	39
Median length	14
Mean length	24.42105263
Min length	12

ID
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1004.1052631578947
Minimum	779
Maximum	1628
Zeros	0
Zeros (%)	0.0%
Memory size	152.0 B

Quantile statistics

Minimum	779
5-th percentile	815.9
Q1	884
median	914
Q3	1017.5
95-th percentile	1492.1
Maximum	1628
Range	849
Interquartile range (IQR)	133.5

Descriptive statistics

Standard deviation	223.9471403
Coefficient of variation (CV)	0.2230315371
Kurtosis	2.991003786
Mean	1004.105263
Median Absolute Deviation (MAD)	41
Skewness	1.878154323
Sum	19078
Variance	50152.32164

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
894	1	5.3%
874	1	5.3%
897	1	5.3%
1098	1	5.3%
900	1	5.3%
1477	1	5.3%
926	1	5.3%
1628	1	5.3%
873	1	5.3%
779	1	5.3%
Other values (9)	9	47.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
779	1	5.3%
820	1	5.3%
873	1	5.3%
874	1	5.3%
879	1	5.3%

Value	Count	Frequency (%)
1628	1	5.3%
1477	1	5.3%
1281	1	5.3%
1098	1	5.3%
1043	1	5.3%

Key
Categorical

HIGH CORRELATION
UNIQUE

Distinct count	19
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	152.0 B

9th2m	1
lwp1k	1
o40ku	1
uisvo	1
wm60u	1
Other values (14)	14

Common Values
Length

Value	Count	Frequency (%)
9th2m	1	5.3%
lwp1k	1	5.3%
o40ku	1	5.3%
uisvo	1	5.3%
wm60u	1	5.3%
g2u0m	1	5.3%
2bpnm	1	5.3%
kt0me	1	5.3%
pld00	1	5.3%
63gkp	1	5.3%
Other values (9)	9	47.4%

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	Name	Department	Academic Year	1. The curriculum is up to date and relevant from the point of view of employability.	2. The core courses offer an in-depth exposure to the subject.	3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course.	4. Sufficient practical exposure is provided for the theoretical concepts in the courses	5. Adequate exposure is provided to relevant software	6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill	7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment	8. The library provides text book, reference book, and other e resources as and when required	9. The canteen facility is quite adequate and the quality of food is also good	10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department	11. The college provides hostel facilities with all necessary amenities to the student	12.The evaluation system of the university is always fair and results are declared in time	13. All faculty members of the department are co-operative, always helpful even beyond class hours	14. Faculty members explains different topics through example and practical applications and often use computer aided methods of teaching (online/offline)	15. Co-Curricular activities are encouraged and endorsed by faculty members .	Remarks:	Timestamp	Last Updated	Created By	Updated By	IP	ID	Key
0	0	Soumya Kanti Roy	Master of Computer Applications	2017-18	Agree	Agree	Agree	Strongly agree	Strongly agree	Average	Agree	Strongly agree	Neutral	Strongly agree	Agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	NaN	2020-07-24 16:26:14	2020-07-24 16:26:14	573	573	146.196.45.79	779	76kjh
1	5	Jayant Kr Mandal	Master of Computer Applications	2017-18	Agree	Agree	Strongly agree	Strongly agree	Agree	Strongly agree	Strongly agree	Strongly agree	Average	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	I think the course in the First and Second semester are for the basics those who are not from the computer background i.e came from B.Sc (Maths) so the curriculum is good for them.	2020-07-25 03:37:57	2020-07-25 03:37:57	571	571	2409:4061:717:7097:544c:438c:f748:1468	820	i56zh
2	20	Suvasree Bhattacharjee	Master of Computer Applications	2017-18	Agree	Agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Disagree	Strongly agree	Strongly agree	Agree	Disagree	Strongly agree	Strongly agree	Strongly agree	Sometimes, the truth hurts. Students are taught to respect those who lead with a firm..and often stern hand because they know that the teachers are rooting for them.	2020-07-25 07:17:44	2020-07-25 07:17:44	636	636	116.75.105.104	873	g2u0m
3	21	Joydeep	Master of Computer Applications	2017-18	Average	Average	Average	Average	Average	Average	Average	Average	Agree	Agree	Agree	Average	Strongly agree	Average	Average	NaN	2020-07-25 07:35:42	2020-07-25 07:35:42	568	568	2409:4061:2c08:a14a:3a89:fa:dbf1:cd12	874	2bpnm
4	24	Mita Rakshit	Master of Computer Applications	2017-18	Average	Average	Average	Agree	Average	Agree	Average	Average	Neutral	Average	Average	Agree	Agree	Agree	Agree	NaN	2020-07-25 07:42:46	2020-07-25 07:42:46	598	598	47.11.154.32	879	b3y9c
5	32	SAPTARSHI BISWAS	Master of Computer Applications	2017-18	Strongly agree	Agree	Agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	NaN	2020-07-25 08:01:29	2020-07-25 08:01:29	653	653	2409:4061:2d98:a80:54:792a:ac03:95ce	889	w0xp6
6	35	Kumkum Kumari	Master of Computer Applications	2017-18	Average	Average	Average	Agree	Average	Agree	Agree	Agree	Average	Agree	Agree	Agree	Strongly agree	Agree	Average	NaN	2020-07-25 08:08:57	2020-07-25 08:08:57	652	652	2409:4064:208f:2610:f495:c043:ba1b:c02b	894	o40ku
7	37	MD SALMAN KHURSHID	Master of Computer Applications	2017-18	Average	Average	Average	Average	Average	Average	Average	Average	Average	Neutral	Neutral	Neutral	Neutral	Disagree	Neutral	NaN	2020-07-25 08:12:58	2020-07-25 08:12:58	616	616	2409:4064:79b:898d::82b:68a4	897	hbcnw
8	39	avik das	Master of Computer Applications	2017-18	Average	Average	Average	Average	Average	Average	Average	Average	Average	Average	Average	Agree	Average	Average	Neutral	NaN	2020-07-25 08:16:47	2020-07-25 08:16:47	654	654	103.94.87.148	900	1r07f
9	44	Mrinal roy	Master of Computer Applications	2017-18	Neutral	Agree	Agree	Strongly agree	Agree	Agree	Agree	Average	Strongly agree	Strongly agree	Neutral	Agree	Strongly agree	Average	Neutral	NaN	2020-07-25 08:51:19	2020-07-25 08:51:19	664	664	103.10.209.99	914	wj9bi

Last rows

	df_index	Name	Department	Academic Year	1. The curriculum is up to date and relevant from the point of view of employability.	2. The core courses offer an in-depth exposure to the subject.	3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course.	4. Sufficient practical exposure is provided for the theoretical concepts in the courses	5. Adequate exposure is provided to relevant software	6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill	7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment	8. The library provides text book, reference book, and other e resources as and when required	9. The canteen facility is quite adequate and the quality of food is also good	10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department	11. The college provides hostel facilities with all necessary amenities to the student	12.The evaluation system of the university is always fair and results are declared in time	13. All faculty members of the department are co-operative, always helpful even beyond class hours	14. Faculty members explains different topics through example and practical applications and often use computer aided methods of teaching (online/offline)	15. Co-Curricular activities are encouraged and endorsed by faculty members .	Remarks:	Timestamp	Last Updated	Created By	Updated By	IP	ID	Key
9	44	Mrinal roy	Master of Computer Applications	2017-18	Neutral	Agree	Agree	Strongly agree	Agree	Agree	Agree	Average	Strongly agree	Strongly agree	Neutral	Agree	Strongly agree	Average	Neutral	NaN	2020-07-25 08:51:19	2020-07-25 08:51:19	664	664	103.10.209.99	914	wj9bi
10	47	Shafali Agrawal	Master of Computer Applications	2017-18	Agree	Average	Agree	Agree	Agree	Average	Agree	Strongly agree	Agree	Strongly agree	Agree	Agree	Strongly agree	Strongly agree	Agree	NaN	2020-07-25 09:35:57	2020-07-25 09:35:57	671	671	2409:4064:b0c:9524:20a0:5ef0:3137:ad1c	925	pld00
11	48	Nitesh Kumar	Master of Computer Applications	2017-18	Agree	Average	Agree	Agree	Agree	Average	Agree	Strongly agree	Agree	Strongly agree	Agree	Average	Agree	Agree	Agree	NaN	2020-07-25 09:36:06	2020-07-25 09:36:06	672	672	2409:4064:4e8c:257:7dc0:74d8:5b2d:1f8d	926	lwp1k
12	60	AMBIKA	Master of Computer Applications	2017-18	Neutral	Agree	Average	Agree	Average	Agree	Agree	Average	Neutral	Agree	Neutral	Agree	Strongly agree	Agree	Agree	Nice learning experience	2020-07-25 19:49:41	2020-07-25 19:49:41	733	733	182.66.139.30	1043	kt0me
13	65	MONIDEEPA PAUL	Master of Computer Applications	2017-18	Agree	Average	Average	Agree	Agree	Average	Agree	Average	Average	Agree	Agree	Agree	Agree	Agree	Agree	NaN	2020-07-26 06:16:12	2020-07-26 06:16:12	649	649	2401:4900:382d:9833:10e:2732:9faf:8755	1098	wm60u
14	73	Deep Basak	Master of Computer Applications	2017-18	Agree	Agree	Strongly agree	Agree	Average	Strongly agree	Average	Agree	Average	Strongly agree	Strongly agree	Neutral	Strongly agree	Agree	Agree	NaN	2020-07-25 13:32:59	2020-07-25 13:32:59	667	667	42.110.217.161	989	uisvo
15	75	Rahul Das	Master of Computer Applications	2017-18	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Agree	Strongly agree	Agree	Strongly agree	Agree	Strongly agree	Strongly agree	Agree	Strongly agree	All of my respected teachers are very helpful.	2020-07-25 13:51:03	2020-07-25 13:51:03	564	564	42.110.248.198	992	9th2m
16	80	Chaitali Nandi	Master of Computer Applications	2017-18	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Average	Strongly agree	Agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	NaN	2020-07-27 04:47:58	2020-07-27 04:47:58	904	904	150.242.174.19	1281	63gkp
17	104	Sayan Roy	Master of Computer Applications	2017-18	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	Strongly agree	NaN	2020-07-28 13:04:21	2020-07-28 13:04:21	1101	1101	103.102.121.9	1628	40wb0
18	114	Syed Babar Ali	Master of Computer Applications	2017-18	Agree	Agree	Average	Agree	Agree	Average	Agree	Agree	Average	Average	Agree	Agree	Average	Average	Agree	Good	2020-07-27 14:56:24	2020-07-27 14:56:24	1001	1001	2409:4061:2e02:16ec:f589:51c7:ae5a:f75b	1477	fp7q4

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows