Overview

Dataset statistics

Number of variables28
Number of observations2
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory576.0 B
Average record size in memory288.0 B

Variable types

CAT27
BOOL1

Reproduction

Analysis started2020-10-02 07:34:05.252574
Analysis finished2020-10-02 07:34:09.995557
Duration4.74 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 "2015-16" Constant
12.The evaluation system of the university is always fair and results are declared in time 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
df_index has unique values Unique
Name has unique values Unique
1. The curriculum is up to date and relevant from the point of view of employability. has unique values Unique
2. The core courses offer an in-depth exposure to the subject. has unique values Unique
3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course. has unique values Unique
4. Sufficient practical exposure is provided for the theoretical concepts in the courses has unique values Unique
5. Adequate exposure is provided to relevant software has unique values Unique
6. The courses enhance the analytical/ problem solving/ critical thinking/ innovative skills/Team work/communication skill has unique values Unique
7. College provides the opportunity to learn and grow with ethical principles and a sense of responsibility for the society and the environment has unique values Unique
8. The library provides text book, reference book, and other e resources as and when required has unique values Unique
9. The canteen facility is quite adequate and the quality of food is also good has unique values Unique
10. Classrooms are spacious, well ventilated and smart classroom facility is also available in the department has unique values Unique
11. The college provides hostel facilities with all necessary amenities to the student has unique values Unique
13. All faculty members of the department are co-operative, always helpful even beyond class hours has unique values Unique
14. Faculty members explains different topics through example and practical applications and often use computer aided methods of teaching (online/offline) has unique values Unique
15. Co-Curricular activities are encouraged and endorsed by faculty members . has unique values Unique
Remarks: 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 count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
10
1
12
1
ValueCountFrequency (%) 
10150.0%
 
12150.0%
 

Length

Max length2
Median length2
Mean length2
Min length2

Name
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Suvasree Bhattacharjee
1
Rahul Dev Garai
1
ValueCountFrequency (%) 
Suvasree Bhattacharjee150.0%
 
Rahul Dev Garai150.0%
 

Length

Max length22
Median length18.5
Mean length18.5
Min length15

Department
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Master of Computer Applications
2
ValueCountFrequency (%) 
Master of Computer Applications2100.0%
 

Length

Max length31
Median length31
Mean length31
Min length31

Academic Year
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
2015-16
2
ValueCountFrequency (%) 
2015-162100.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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Average
1
ValueCountFrequency (%) 
Agree150.0%
 
Average150.0%
 

Length

Max length7
Median length6
Mean length6
Min length5

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Average
1
ValueCountFrequency (%) 
Agree150.0%
 
Average150.0%
 

Length

Max length7
Median length6
Mean length6
Min length5

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Average
1
ValueCountFrequency (%) 
Agree150.0%
 
Average150.0%
 

Length

Max length7
Median length6
Mean length6
Min length5

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Average
1
Strongly agree
1
ValueCountFrequency (%) 
Average150.0%
 
Strongly agree150.0%
 

Length

Max length14
Median length10.5
Mean length10.5
Min length7

5. Adequate exposure is provided to relevant software
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Average
1
Strongly agree
1
ValueCountFrequency (%) 
Average150.0%
 
Strongly agree150.0%
 

Length

Max length14
Median length10.5
Mean length10.5
Min length7

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree150.0%
 
Strongly agree150.0%
 

Length

Max length14
Median length9.5
Mean length9.5
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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Average
1
Strongly agree
1
ValueCountFrequency (%) 
Average150.0%
 
Strongly agree150.0%
 

Length

Max length14
Median length10.5
Mean length10.5
Min length7

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Average
1
ValueCountFrequency (%) 
Agree150.0%
 
Average150.0%
 

Length

Max length7
Median length6
Mean length6
Min length5

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Neutral
1
Strongly agree
1
ValueCountFrequency (%) 
Neutral150.0%
 
Strongly agree150.0%
 

Length

Max length14
Median length10.5
Mean length10.5
Min length7

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree150.0%
 
Strongly agree150.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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Neutral
1
ValueCountFrequency (%) 
Agree150.0%
 
Neutral150.0%
 

Length

Max length7
Median length6
Mean length6
Min length5

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

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
2
ValueCountFrequency (%) 
Agree2100.0%
 

Length

Max length5
Median length5
Mean length5
Min length5

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree150.0%
 
Strongly agree150.0%
 

Length

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

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree150.0%
 
Strongly agree150.0%
 

Length

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

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

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Agree
1
Strongly agree
1
ValueCountFrequency (%) 
Agree150.0%
 
Strongly agree150.0%
 

Length

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

Remarks:
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Good
1
In the face of disrespect, misbehavior, and lack of student enthusiasm, teachers are the believers. They see the light at the end of the tunnel and they lead step by step..truly the greatest act of optimism..
1
ValueCountFrequency (%) 
Good150.0%
 
In the face of disrespect, misbehavior, and lack of student enthusiasm, teachers are the believers. They see the light at the end of the tunnel and they lead step by step..truly the greatest act of optimism..150.0%
 

Length

Max length208
Median length106
Mean length106
Min length4

Timestamp
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
2020-07-25 06:28:28
1
2020-07-25 06:41:06
1
ValueCountFrequency (%) 
2020-07-25 06:28:28150.0%
 
2020-07-25 06:41:06150.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Last Updated
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
2020-07-25 06:28:28
1
2020-07-25 06:41:06
1
ValueCountFrequency (%) 
2020-07-25 06:28:28150.0%
 
2020-07-25 06:41:06150.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Created By
Categorical

HIGH CORRELATION
UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
639
1
636
1
ValueCountFrequency (%) 
639150.0%
 
636150.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

Updated By
Categorical

HIGH CORRELATION
UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
639
1
636
1
ValueCountFrequency (%) 
639150.0%
 
636150.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

Draft
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
0
2
ValueCountFrequency (%) 
02100.0%
 

IP
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
116.75.105.104
1
117.226.243.64
1
ValueCountFrequency (%) 
116.75.105.104150.0%
 
117.226.243.64150.0%
 

Length

Max length14
Median length14
Mean length14
Min length14

ID
Categorical

HIGH CORRELATION
UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
859
1
863
1
ValueCountFrequency (%) 
859150.0%
 
863150.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

Key
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
bs3cr
1
yk0gb
1
ValueCountFrequency (%) 
bs3cr150.0%
 
yk0gb150.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
010Rahul Dev GaraiMaster of Computer Applications2015-16AverageAverageAverageAverageAverageAgreeAverageAgreeNeutralAgreeNeutralAgreeAgreeAgreeAgreeGood2020-07-25 06:28:282020-07-25 06:28:286396390117.226.243.64859bs3cr
112Suvasree BhattacharjeeMaster of Computer Applications2015-16AgreeAgreeAgreeStrongly agreeStrongly agreeStrongly agreeStrongly agreeAverageStrongly agreeStrongly agreeAgreeAgreeStrongly agreeStrongly agreeStrongly agreeIn the face of disrespect, misbehavior, and lack of student enthusiasm, teachers are the believers. They see the light at the end of the tunnel and they lead step by step..truly the greatest act of optimism..2020-07-25 06:41:062020-07-25 06:41:066366360116.75.105.104863yk0gb

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
010Rahul Dev GaraiMaster of Computer Applications2015-16AverageAverageAverageAverageAverageAgreeAverageAgreeNeutralAgreeNeutralAgreeAgreeAgreeAgreeGood2020-07-25 06:28:282020-07-25 06:28:286396390117.226.243.64859bs3cr
112Suvasree BhattacharjeeMaster of Computer Applications2015-16AgreeAgreeAgreeStrongly agreeStrongly agreeStrongly agreeStrongly agreeAverageStrongly agreeStrongly agreeAgreeAgreeStrongly agreeStrongly agreeStrongly agreeIn the face of disrespect, misbehavior, and lack of student enthusiasm, teachers are the believers. They see the light at the end of the tunnel and they lead step by step..truly the greatest act of optimism..2020-07-25 06:41:062020-07-25 06:41:066366360116.75.105.104863yk0gb