Overview

Dataset statistics

Number of variables28
Number of observations4
Missing cells2
Missing cells (%)1.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory256.0 B

Variable types

CAT27
BOOL1

Reproduction

Analysis started2020-10-02 07:34:21.603364
Analysis finished2020-10-02 07:34:25.337003
Duration3.73 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Department has constant value "Master of Computer Applications" Constant
Academic Year has constant value "2016-17" Constant
11. The college provides hostel facilities with all necessary amenities to the student has constant value "Agree" Constant
Draft has constant value "0" Constant
Created By is highly correlated with df_index and 2 other fieldsHigh correlation
df_index is highly correlated with Created By and 2 other fieldsHigh correlation
Updated By is highly correlated with df_index and 2 other fieldsHigh correlation
ID is highly correlated with df_index and 2 other fieldsHigh 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 6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill High correlation
6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill is highly correlated with 7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment High correlation
Remarks: has 2 (50.0%) missing values Missing
4. Sufficient practical exposure is provided for the theoretical concepts in the courses is uniformly distributed Uniform
10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department is uniformly distributed Uniform
15. Co-Curricular activities are encouraged and endorsed by faculty members . is uniformly distributed Uniform
Remarks: is uniformly distributed Uniform
df_index has unique values Unique
Name has unique values Unique
3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course. 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

Variables

df_index
Categorical

HIGH CORRELATION
UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
14
1
85
1
108
1
19
1
ValueCountFrequency (%) 
14125.0%
 
85125.0%
 
108125.0%
 
19125.0%
 

Length

Max length3
Median length2
Mean length2.25
Min length2

Name
Categorical

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Suvasree Bhattacharjee
1
MOUMITA AKHULY
1
Rahul Das
1
Arijit Dutta
1
ValueCountFrequency (%) 
Suvasree Bhattacharjee125.0%
 
MOUMITA AKHULY125.0%
 
Rahul Das125.0%
 
Arijit Dutta125.0%
 

Length

Max length22
Median length13
Mean length14.25
Min length9

Department
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)25.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Master of Computer Applications
4
ValueCountFrequency (%) 
Master of Computer Applications4100.0%
 

Length

Max length31
Median length31
Mean length31
Min length31

Academic Year
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)25.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
2016-17
4
ValueCountFrequency (%) 
2016-174100.0%
 

Length

Max length7
Median length7
Mean length7
Min length7

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

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
3
Strongly agree
1
ValueCountFrequency (%) 
Agree375.0%
 
Strongly agree125.0%
 

Length

Max length14
Median length5
Mean length7.25
Min length5

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

Distinct count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Average
1
Strongly agree
1
ValueCountFrequency (%) 
Agree250.0%
 
Average125.0%
 
Strongly agree125.0%
 

Length

Max length14
Median length6
Mean length7.75
Min length5

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

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
1
Agree
1
Average
1
Disagree
1
ValueCountFrequency (%) 
Strongly agree125.0%
 
Agree125.0%
 
Average125.0%
 
Disagree125.0%
 

Length

Max length14
Median length7.5
Mean length8.5
Min length5

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

UNIFORM

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Strongly agree
2
ValueCountFrequency (%) 
Agree250.0%
 
Strongly agree250.0%
 

Length

Max length14
Median length9.5
Mean length9.5
Min length5

5. Adequate exposure is provided to relevant software
Categorical

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
3
Strongly agree
1
ValueCountFrequency (%) 
Agree375.0%
 
Strongly agree125.0%
 

Length

Max length14
Median length5
Mean length7.25
Min length5

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

HIGH CORRELATION

Distinct count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
2
Agree
1
Average
1
ValueCountFrequency (%) 
Strongly agree250.0%
 
Agree125.0%
 
Average125.0%
 

Length

Max length14
Median length10.5
Mean length10
Min length5

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 count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
2
Agree
1
Neutral
1
ValueCountFrequency (%) 
Strongly agree250.0%
 
Agree125.0%
 
Neutral125.0%
 

Length

Max length14
Median length10.5
Mean length10
Min length5

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

Distinct count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Average
1
Strongly agree
1
ValueCountFrequency (%) 
Agree250.0%
 
Average125.0%
 
Strongly agree125.0%
 

Length

Max length14
Median length6
Mean length7.75
Min length5

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

Distinct count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Disagree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree250.0%
 
Disagree125.0%
 
Strongly agree125.0%
 

Length

Max length14
Median length6.5
Mean length8
Min length5

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

UNIFORM

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Strongly agree
2
ValueCountFrequency (%) 
Agree250.0%
 
Strongly agree250.0%
 

Length

Max length14
Median length9.5
Mean length9.5
Min length5

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

CONSTANT
REJECTED

Distinct count1
Unique (%)25.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
4
ValueCountFrequency (%) 
Agree4100.0%
 

Length

Max length5
Median length5
Mean length5
Min length5

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

Distinct count3
Unique (%)75.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
2
Agree
1
Average
1
ValueCountFrequency (%) 
Strongly agree250.0%
 
Agree125.0%
 
Average125.0%
 

Length

Max length14
Median length10.5
Mean length10
Min length5

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

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
3
Agree
1
ValueCountFrequency (%) 
Strongly agree375.0%
 
Agree125.0%
 

Length

Max length14
Median length14
Mean length11.75
Min length5

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

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Strongly agree
3
Average
1
ValueCountFrequency (%) 
Strongly agree375.0%
 
Average125.0%
 

Length

Max length14
Median length14
Mean length12.25
Min length7

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

UNIFORM

Distinct count2
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
Agree
2
Strongly agree
2
ValueCountFrequency (%) 
Agree250.0%
 
Strongly agree250.0%
 

Length

Max length14
Median length9.5
Mean length9.5
Min length5

Remarks:
Categorical

MISSING
UNIFORM

Distinct count2
Unique (%)100.0%
Missing2
Missing (%)50.0%
Memory size32.0 B
All of my respected teachers are very helpful.
1
Learning may begin in the classroom, but it certainly doesn’t end there. Teachers set up the signs for the road ahead that is life itself. They inspire students to learn wherever life may take them.
1
ValueCountFrequency (%) 
All of my respected teachers are very helpful.125.0%
 
Learning may begin in the classroom, but it certainly doesn’t end there. Teachers set up the signs for the road ahead that is life itself. They inspire students to learn wherever life may take them.125.0%
 
(Missing)250.0%
 

Length

Max length198
Median length24.5
Mean length62.5
Min length3

Timestamp
Categorical

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
2020-07-29 05:09:22
1
2020-07-27 07:08:25
1
2020-07-24 14:58:46
1
2020-07-25 07:13:11
1
ValueCountFrequency (%) 
2020-07-29 05:09:22125.0%
 
2020-07-27 07:08:25125.0%
 
2020-07-24 14:58:46125.0%
 
2020-07-25 07:13:11125.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Last Updated
Categorical

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
2020-07-29 05:09:22
1
2020-07-27 07:08:25
1
2020-07-24 14:58:46
1
2020-07-25 07:13:11
1
ValueCountFrequency (%) 
2020-07-29 05:09:22125.0%
 
2020-07-27 07:08:25125.0%
 
2020-07-24 14:58:46125.0%
 
2020-07-25 07:13:11125.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Created By
Categorical

HIGH CORRELATION
UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
1135
1
636
1
564
1
938
1
ValueCountFrequency (%) 
1135125.0%
 
636125.0%
 
564125.0%
 
938125.0%
 

Length

Max length4
Median length3
Mean length3.25
Min length3

Updated By
Categorical

HIGH CORRELATION
UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
1135
1
636
1
564
1
938
1
ValueCountFrequency (%) 
1135125.0%
 
636125.0%
 
564125.0%
 
938125.0%
 

Length

Max length4
Median length3
Mean length3.25
Min length3

Draft
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)25.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
0
4
ValueCountFrequency (%) 
04100.0%
 

IP
Categorical

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
116.75.105.104
1
2409:4061:2113:e978:fd12:a54:b01a:9fc9
1
42.110.228.225
1
42.110.212.160
1
ValueCountFrequency (%) 
116.75.105.104125.0%
 
2409:4061:2113:e978:fd12:a54:b01a:9fc9125.0%
 
42.110.228.225125.0%
 
42.110.212.160125.0%
 

Length

Max length38
Median length14
Mean length20
Min length14

ID
Categorical

HIGH CORRELATION
UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
1359
1
1710
1
761
1
872
1
ValueCountFrequency (%) 
1359125.0%
 
1710125.0%
 
761125.0%
 
872125.0%
 

Length

Max length4
Median length3.5
Mean length3.5
Min length3

Key
Categorical

UNIQUE

Distinct count4
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.0 B
11m99
1
z63h1
1
638jw
1
pots4
1
ValueCountFrequency (%) 
11m99125.0%
 
z63h1125.0%
 
638jw125.0%
 
pots4125.0%
 

Length

Max length5
Median length5
Mean length5
Min length5

Correlations

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.

Missing values

Sample

First rows

df_indexNameDepartmentAcademic Year1. 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 courses5. Adequate exposure is provided to relevant software6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment8. The library provides text book, reference book, and other e resources as and when required9. The canteen facility is quite adequate and the quality of food is also good10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department11. The college provides hostel facilities with all necessary amenities to the student12.The evaluation system of the university is always fair and results are declared in time13. All faculty members of the department are co-operative, always helpful even beyond class hours14. 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:TimestampLast UpdatedCreated ByUpdated ByDraftIPIDKey
014Suvasree BhattacharjeeMaster of Computer Applications2016-17AgreeAgreeDisagreeStrongly agreeStrongly agreeStrongly agreeStrongly agreeAverageStrongly agreeStrongly agreeAgreeAverageStrongly agreeStrongly agreeStrongly agreeLearning may begin in the classroom, but it certainly doesn’t end there. Teachers set up the signs for the road ahead that is life itself. They inspire students to learn wherever life may take them.2020-07-25 07:13:112020-07-25 07:13:116366360116.75.105.104872z63h1
119Rahul DasMaster of Computer Applications2016-17Strongly agreeStrongly agreeStrongly agreeStrongly agreeAgreeStrongly agreeStrongly agreeStrongly agreeAgreeStrongly agreeAgreeStrongly agreeStrongly agreeStrongly agreeAgreeAll of my respected teachers are very helpful.2020-07-24 14:58:462020-07-24 14:58:46564564042.110.228.225761pots4
285Arijit DuttaMaster of Computer Applications2016-17AgreeAverageAverageAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeStrongly agreeStrongly agreeNaN2020-07-27 07:08:252020-07-27 07:08:2593893802409:4061:2113:e978:fd12:a54:b01a:9fc91359638jw
3108MOUMITA AKHULYMaster of Computer Applications2016-17AgreeAgreeAgreeAgreeAgreeAverageNeutralAgreeDisagreeAgreeAgreeStrongly agreeStrongly agreeAverageAgreeNaN2020-07-29 05:09:222020-07-29 05:09:2211351135042.110.212.160171011m99

Last rows

df_indexNameDepartmentAcademic Year1. 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 courses5. Adequate exposure is provided to relevant software6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment8. The library provides text book, reference book, and other e resources as and when required9. The canteen facility is quite adequate and the quality of food is also good10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department11. The college provides hostel facilities with all necessary amenities to the student12.The evaluation system of the university is always fair and results are declared in time13. All faculty members of the department are co-operative, always helpful even beyond class hours14. 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:TimestampLast UpdatedCreated ByUpdated ByDraftIPIDKey
014Suvasree BhattacharjeeMaster of Computer Applications2016-17AgreeAgreeDisagreeStrongly agreeStrongly agreeStrongly agreeStrongly agreeAverageStrongly agreeStrongly agreeAgreeAverageStrongly agreeStrongly agreeStrongly agreeLearning may begin in the classroom, but it certainly doesn’t end there. Teachers set up the signs for the road ahead that is life itself. They inspire students to learn wherever life may take them.2020-07-25 07:13:112020-07-25 07:13:116366360116.75.105.104872z63h1
119Rahul DasMaster of Computer Applications2016-17Strongly agreeStrongly agreeStrongly agreeStrongly agreeAgreeStrongly agreeStrongly agreeStrongly agreeAgreeStrongly agreeAgreeStrongly agreeStrongly agreeStrongly agreeAgreeAll of my respected teachers are very helpful.2020-07-24 14:58:462020-07-24 14:58:46564564042.110.228.225761pots4
285Arijit DuttaMaster of Computer Applications2016-17AgreeAverageAverageAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeStrongly agreeStrongly agreeNaN2020-07-27 07:08:252020-07-27 07:08:2593893802409:4061:2113:e978:fd12:a54:b01a:9fc91359638jw
3108MOUMITA AKHULYMaster of Computer Applications2016-17AgreeAgreeAgreeAgreeAgreeAverageNeutralAgreeDisagreeAgreeAgreeStrongly agreeStrongly agreeAverageAgreeNaN2020-07-29 05:09:222020-07-29 05:09:2211351135042.110.212.160171011m99