Overview

Dataset statistics

Number of variables33
Number of observations1
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory392.0 B
Average record size in memory392.0 B

Variable types

CAT32
BOOL1

Reproduction

Analysis started2020-10-02 07:37:38.946620
Analysis finished2020-10-02 07:37:39.956179
Duration1.01 second
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

df_index has constant value "3" Constant
Name has constant value "Vicky Prakash" Constant
Department has constant value "Masters of Business Administration" Constant
Academic Year has constant value "2015-16" Constant
1. Punctuality in the Class has constant value "Very Good" Constant
2. Regularity in taking Classes has constant value "Excellent" Constant
3. Completes syllabus of the course in time has constant value "Excellent" Constant
4. Scheduled organization of Assignments Class tests , quizzes, Presentations has constant value "Excellent" Constant
5. Focus on Syllabi has constant value "Excellent" Constant
6.Communication ability and confidence in Class delivery has constant value "Excellent" Constant
7. Structuring of Class delivery has constant value "Excellent" Constant
8. Skill of creating interest by refering to real life cases and recent developments in the field has constant value "Excellent" Constant
9. Uses of teaching aids (OHP /Blackboard /PPT's) has constant value "Excellent" Constant
10.Uses of innovative teaching methods has constant value "Excellent" Constant
11.Shows the evaluated answer books of class tests and shares correct answer has constant value "Excellent" Constant
12.Helping approach towards varied academic interests of students has constant value "Excellent" Constant
13.Approach towards developing professional skills among students has constant value "Excellent" Constant
14.Helps students in realizing career goals has constant value "Excellent" Constant
15.Helps students in realizing their strengths and developmental needs has constant value "Excellent" Constant
16.Project/Dissertation guidance and monitoring has constant value "Excellent" Constant
17. Control mechanism in effectively conducting the class has constant value "Excellent" Constant
18. Students’ participation in the class has constant value "Very Good" Constant
19.Skills of addressing inappropriate behavior of student has constant value "Very Good" Constant
20.Inspires students for ethical conduct has constant value "Excellent" Constant
Remarks: has constant value "The Best Time of My life, Missing it Very Much!!😎👑✌🏻" Constant
Timestamp has constant value "2020-08-02 19:16:15" Constant
Last Updated has constant value "2020-08-02 19:16:15" Constant
Created By has constant value "1285" Constant
Updated By has constant value "1285" Constant
Draft has constant value "0" Constant
IP has constant value "2405:204:3096:6109:7cf1:8086:7696:1b96" Constant
ID has constant value "1940" Constant
Key has constant value "y7wam" Constant

Variables

df_index
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
3
1
ValueCountFrequency (%) 
31100.0%
 

Length

Max length1
Median length1
Mean length1
Min length1

Name
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Vicky Prakash
1
ValueCountFrequency (%) 
Vicky Prakash1100.0%
 

Length

Max length13
Median length13
Mean length13
Min length13

Department
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Masters of Business Administration
1
ValueCountFrequency (%) 
Masters of Business Administration1100.0%
 

Length

Max length34
Median length34
Mean length34
Min length34

Academic Year
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
2015-16
1
ValueCountFrequency (%) 
2015-161100.0%
 

Length

Max length7
Median length7
Mean length7
Min length7

1. Punctuality in the Class
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Very Good
1
ValueCountFrequency (%) 
Very Good1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

2. Regularity in taking Classes
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

5. Focus on Syllabi
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

7. Structuring of Class delivery
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

10.Uses of innovative teaching methods
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Very Good
1
ValueCountFrequency (%) 
Very Good1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Very Good
1
ValueCountFrequency (%) 
Very Good1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9
Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
Excellent
1
ValueCountFrequency (%) 
Excellent1100.0%
 

Length

Max length9
Median length9
Mean length9
Min length9

Remarks:
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
The Best Time of My life, Missing it Very Much!!😎👑✌🏻
1
ValueCountFrequency (%) 
The Best Time of My life, Missing it Very Much!!😎👑✌🏻1100.0%
 

Length

Max length53
Median length53
Mean length53
Min length53

Timestamp
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
2020-08-02 19:16:15
1
ValueCountFrequency (%) 
2020-08-02 19:16:151100.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Last Updated
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
2020-08-02 19:16:15
1
ValueCountFrequency (%) 
2020-08-02 19:16:151100.0%
 

Length

Max length19
Median length19
Mean length19
Min length19

Created By
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
1285
1
ValueCountFrequency (%) 
12851100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Updated By
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
1285
1
ValueCountFrequency (%) 
12851100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Draft
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
0
1
ValueCountFrequency (%) 
01100.0%
 

IP
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
2405:204:3096:6109:7cf1:8086:7696:1b96
1
ValueCountFrequency (%) 
2405:204:3096:6109:7cf1:8086:7696:1b961100.0%
 

Length

Max length38
Median length38
Mean length38
Min length38

ID
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
1940
1
ValueCountFrequency (%) 
19401100.0%
 

Length

Max length4
Median length4
Mean length4
Min length4

Key
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.0 B
y7wam
1
ValueCountFrequency (%) 
y7wam1100.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.

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
03Vicky PrakashMasters of Business Administration2015-16Very GoodExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentVery GoodVery GoodExcellentThe Best Time of My life, Missing it Very Much!!😎👑✌🏻2020-08-02 19:16:152020-08-02 19:16:151285128502405:204:3096:6109:7cf1:8086:7696:1b961940y7wam

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
03Vicky PrakashMasters of Business Administration2015-16Very GoodExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentExcellentVery GoodVery GoodExcellentThe Best Time of My life, Missing it Very Much!!😎👑✌🏻2020-08-02 19:16:152020-08-02 19:16:151285128502405:204:3096:6109:7cf1:8086:7696:1b961940y7wam