Overview

Dataset statistics

Number of variables33
Number of observations2
Missing cells1
Missing cells (%)1.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory656.0 B
Average record size in memory328.0 B

Variable types

CAT32
BOOL1

Reproduction

Analysis started2020-10-02 07:38:04.081263
Analysis finished2020-10-02 07:38:09.578832
Duration5.5 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Department has constant value "Masters of Business Administration" Constant
Academic Year has constant value "2019-20" 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
Remarks: has 1 (50.0%) missing values Missing
df_index has unique values Unique
Name has unique values Unique
1. Punctuality in the Class has unique values Unique
2. Regularity in taking Classes has unique values Unique
3. Completes syllabus of the course in time has unique values Unique
4. Scheduled organization of Assignments Class tests , quizzes, Presentations has unique values Unique
5. Focus on Syllabi has unique values Unique
6.Communication ability and confidence in Class delivery has unique values Unique
7. Structuring of Class delivery has unique values Unique
8. Skill of creating interest by refering to real life cases and recent developments in the field has unique values Unique
9. Uses of teaching aids (OHP /Blackboard /PPT's) has unique values Unique
10.Uses of innovative teaching methods has unique values Unique
11.Shows the evaluated answer books of class tests and shares correct answer has unique values Unique
12.Helping approach towards varied academic interests of students has unique values Unique
13.Approach towards developing professional skills among students has unique values Unique
14.Helps students in realizing career goals has unique values Unique
15.Helps students in realizing their strengths and developmental needs has unique values Unique
16.Project/Dissertation guidance and monitoring has unique values Unique
17. Control mechanism in effectively conducting the class has unique values Unique
18. Students’ participation in the class has unique values Unique
19.Skills of addressing inappropriate behavior of student has unique values Unique
20.Inspires students for ethical conduct 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
2
1
1
1
ValueCountFrequency (%) 
2150.0%
 
1150.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

Name
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Surbhi raj
1
RAJWARDHAN
1
ValueCountFrequency (%) 
Surbhi raj150.0%
 
RAJWARDHAN150.0%
 

Length

Max length10
Median length10
Mean length10
Min length10

Department
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Masters of Business Administration
2
ValueCountFrequency (%) 
Masters of Business Administration2100.0%
 

Length

Max length34
Median length34
Mean length34
Min length34

Academic Year
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)50.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
2019-20
2
ValueCountFrequency (%) 
2019-202100.0%
 

Length

Max length7
Median length7
Mean length7
Min length7

1. Punctuality in the Class
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

2. Regularity in taking Classes
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

3. Completes syllabus of the course in time
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

4. Scheduled organization of Assignments Class tests , quizzes, Presentations
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

5. Focus on Syllabi
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

6.Communication ability and confidence in Class delivery
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

7. Structuring of Class delivery
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

8. Skill of creating interest by refering to real life cases and recent developments in the field
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

9. Uses of teaching aids (OHP /Blackboard /PPT's)
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

10.Uses of innovative teaching methods
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Good150.0%
 

Length

Max length9
Median length6.5
Mean length6.5
Min length4

11.Shows the evaluated answer books of class tests and shares correct answer
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

12.Helping approach towards varied academic interests of students
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Good150.0%
 

Length

Max length9
Median length6.5
Mean length6.5
Min length4

13.Approach towards developing professional skills among students
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

14.Helps students in realizing career goals
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

15.Helps students in realizing their strengths and developmental needs
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

16.Project/Dissertation guidance and monitoring
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Good150.0%
 

Length

Max length9
Median length6.5
Mean length6.5
Min length4

17. Control mechanism in effectively conducting the class
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

18. Students’ participation in the class
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

19.Skills of addressing inappropriate behavior of student
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

20.Inspires students for ethical conduct
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
Excellent
1
Very Good
1
ValueCountFrequency (%) 
Excellent150.0%
 
Very Good150.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

Remarks:
Categorical

MISSING

Distinct count1
Unique (%)100.0%
Missing1
Missing (%)50.0%
Memory size16.0 B
Our faculty is best
1
ValueCountFrequency (%) 
Our faculty is best150.0%
 
(Missing)150.0%
 

Length

Max length19
Median length11
Mean length11
Min length3

Timestamp
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
2020-08-01 05:16:10
1
2020-08-01 11:14:27
1
ValueCountFrequency (%) 
2020-08-01 05:16:10150.0%
 
2020-08-01 11:14:27150.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-08-01 05:16:10
1
2020-08-01 11:14:27
1
ValueCountFrequency (%) 
2020-08-01 05:16:10150.0%
 
2020-08-01 11:14:27150.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
1279
1
1276
1
ValueCountFrequency (%) 
1279150.0%
 
1276150.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Updated By
Categorical

HIGH CORRELATION
UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
1279
1
1276
1
ValueCountFrequency (%) 
1279150.0%
 
1276150.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

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
2409:4064:4e13:4288:4c3a:207f:e390:e89c
1
2409:4064:4e1b:5ab4::fd88:6d0c
1
ValueCountFrequency (%) 
2409:4064:4e13:4288:4c3a:207f:e390:e89c150.0%
 
2409:4064:4e1b:5ab4::fd88:6d0c150.0%
 

Length

Max length39
Median length34.5
Mean length34.5
Min length30

ID
Categorical

HIGH CORRELATION
UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
1930
1
1925
1
ValueCountFrequency (%) 
1930150.0%
 
1925150.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Key
Categorical

UNIQUE

Distinct count2
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.0 B
9vvtr
1
ihids
1
ValueCountFrequency (%) 
9vvtr150.0%
 
ihids150.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. Punctuality in the Class2. Regularity in taking Classes3. Completes syllabus of the course in time4. Scheduled organization of Assignments Class tests , quizzes, Presentations5. Focus on Syllabi6.Communication ability and confidence in Class delivery7. Structuring of Class delivery8. Skill of creating interest by refering to real life cases and recent developments in the field9. Uses of teaching aids (OHP /Blackboard /PPT's)10.Uses of innovative teaching methods11.Shows the evaluated answer books of class tests and shares correct answer12.Helping approach towards varied academic interests of students13.Approach towards developing professional skills among students14.Helps students in realizing career goals15.Helps students in realizing their strengths and developmental needs16.Project/Dissertation guidance and monitoring17. Control mechanism in effectively conducting the class18. Students’ participation in the class19.Skills of addressing inappropriate behavior of student20.Inspires students for ethical conductRemarks:TimestampLast UpdatedCreated ByUpdated ByDraftIPIDKey
01RAJWARDHANMasters of Business Administration2019-20ExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentOur faculty is best2020-08-01 05:16:102020-08-01 05:16:101276127602409:4064:4e13:4288:4c3a:207f:e390:e89c19259vvtr
12Surbhi rajMasters of Business Administration2019-20Very GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodGoodVery GoodGoodVery GoodVery GoodVery GoodGoodVery GoodVery GoodVery GoodVery GoodNaN2020-08-01 11:14:272020-08-01 11:14:271279127902409:4064:4e1b:5ab4::fd88:6d0c1930ihids

Last rows

df_indexNameDepartmentAcademic Year1. Punctuality in the Class2. Regularity in taking Classes3. Completes syllabus of the course in time4. Scheduled organization of Assignments Class tests , quizzes, Presentations5. Focus on Syllabi6.Communication ability and confidence in Class delivery7. Structuring of Class delivery8. Skill of creating interest by refering to real life cases and recent developments in the field9. Uses of teaching aids (OHP /Blackboard /PPT's)10.Uses of innovative teaching methods11.Shows the evaluated answer books of class tests and shares correct answer12.Helping approach towards varied academic interests of students13.Approach towards developing professional skills among students14.Helps students in realizing career goals15.Helps students in realizing their strengths and developmental needs16.Project/Dissertation guidance and monitoring17. Control mechanism in effectively conducting the class18. Students’ participation in the class19.Skills of addressing inappropriate behavior of student20.Inspires students for ethical conductRemarks:TimestampLast UpdatedCreated ByUpdated ByDraftIPIDKey
01RAJWARDHANMasters of Business Administration2019-20ExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentOur faculty is best2020-08-01 05:16:102020-08-01 05:16:101276127602409:4064:4e13:4288:4c3a:207f:e390:e89c19259vvtr
12Surbhi rajMasters of Business Administration2019-20Very GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodVery GoodGoodVery GoodGoodVery GoodVery GoodVery GoodGoodVery GoodVery GoodVery GoodVery GoodNaN2020-08-01 11:14:272020-08-01 11:14:271279127902409:4064:4e1b:5ab4::fd88:6d0c1930ihids