Dataset statistics
Number of variables | 28 |
---|---|
Number of observations | 828 |
Missing cells | 526 |
Missing cells (%) | 2.3% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 181.2 KiB |
Average record size in memory | 224.2 B |
Variable types
CAT | 23 |
---|---|
NUM | 4 |
BOOL | 1 |
Reproduction
Analysis started | 2020-10-02 07:33:29.954922 |
---|---|
Analysis finished | 2020-10-02 07:33:35.276001 |
Duration | 5.32 seconds |
Version | pandas-profiling v2.8.0 |
Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
Download configuration | config.yaml |
Academic Year has constant value "2019-20" | Constant |
Draft has constant value "0" | Constant |
Name has a high cardinality: 782 distinct values | High cardinality |
Remarks: has a high cardinality: 212 distinct values | High cardinality |
Timestamp has a high cardinality: 821 distinct values | High cardinality |
Last Updated has a high cardinality: 821 distinct values | High cardinality |
IP has a high cardinality: 781 distinct values | High cardinality |
Updated By is highly correlated with Created By | High correlation |
Created By is highly correlated with Updated By | High correlation |
ID is highly correlated with df_index | High correlation |
df_index is highly correlated with ID | High correlation |
Remarks: has 526 (63.5%) missing values | Missing |
Name is uniformly distributed | Uniform |
Timestamp is uniformly distributed | Uniform |
Last Updated is uniformly distributed | Uniform |
IP is uniformly distributed | Uniform |
df_index has unique values | Unique |
ID has unique values | Unique |
Key has unique values | Unique |
Distinct count | 828 |
---|---|
Unique (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 865.0591787439613 |
---|---|
Minimum | 0 |
Maximum | 1735 |
Zeros | 1 |
Zeros (%) | 0.1% |
Memory size | 6.5 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 70.05 |
Q1 | 397.75 |
median | 871.5 |
Q3 | 1328.25 |
95-th percentile | 1658.65 |
Maximum | 1735 |
Range | 1735 |
Interquartile range (IQR) | 930.5 |
Descriptive statistics
Standard deviation | 520.9741458 |
---|---|
Coefficient of variation (CV) | 0.6022410473 |
Kurtosis | -1.243682016 |
Mean | 865.0591787 |
Median Absolute Deviation (MAD) | 464 |
Skewness | -0.003261247962 |
Sum | 716269 |
Variance | 271414.0606 |
Value | Count | Frequency (%) | |
1735 | 1 | 0.1% | |
555 | 1 | 0.1% | |
585 | 1 | 0.1% | |
582 | 1 | 0.1% | |
579 | 1 | 0.1% | |
578 | 1 | 0.1% | |
566 | 1 | 0.1% | |
565 | 1 | 0.1% | |
564 | 1 | 0.1% | |
562 | 1 | 0.1% | |
Other values (818) | 818 | 98.8% |
Value | Count | Frequency (%) | |
0 | 1 | 0.1% | |
2 | 1 | 0.1% | |
3 | 1 | 0.1% | |
5 | 1 | 0.1% | |
7 | 1 | 0.1% |
Value | Count | Frequency (%) | |
1735 | 1 | 0.1% | |
1731 | 1 | 0.1% | |
1729 | 1 | 0.1% | |
1727 | 1 | 0.1% | |
1724 | 1 | 0.1% |
Distinct count | 782 |
---|---|
Unique (%) | 94.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Ankit Kumar | 4 |
---|---|
Rohit Raj | 3 |
Rajib Gope | 3 |
AKASH SAHA | 3 |
Ranojoy Chowdhury | 3 |
Other values (777) |
Value | Count | Frequency (%) | |
Ankit Kumar | 4 | 0.5% | |
Rohit Raj | 3 | 0.4% | |
Rajib Gope | 3 | 0.4% | |
AKASH SAHA | 3 | 0.4% | |
Ranojoy Chowdhury | 3 | 0.4% | |
Bishakha Kumari Mishra | 2 | 0.2% | |
SAYAN CHATTERJEE | 2 | 0.2% | |
Srijal Kumari | 2 | 0.2% | |
Arunabha Goswami | 2 | 0.2% | |
Soumita Roy | 2 | 0.2% | |
Other values (772) | 802 | 96.9% |
Length
Max length | 25 |
---|---|
Median length | 13 |
Mean length | 13.42512077 |
Min length | 5 |
Department
Categorical
Distinct count | 7 |
---|---|
Unique (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Electronics and Communication Engineering | |
---|---|
Electrical Engineering | |
Mechanical Engineering | |
Computer Science Engineering | |
Information Technology | |
Other values (2) |
Value | Count | Frequency (%) | |
Electronics and Communication Engineering | 278 | 33.6% | |
Electrical Engineering | 175 | 21.1% | |
Mechanical Engineering | 116 | 14.0% | |
Computer Science Engineering | 104 | 12.6% | |
Information Technology | 69 | 8.3% | |
Civil Engineering | 53 | 6.4% | |
Electronics and Instrumentation Engineering | 33 | 4.0% |
Length
Max length | 43 |
---|---|
Median length | 28 |
Mean length | 29.64975845 |
Min length | 17 |
Distinct count | 1 |
---|---|
Unique (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
2019-20 |
---|
Value | Count | Frequency (%) | |
2019-20 | 828 | 100.0% |
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 30 |
Disagree | 16 |
Value | Count | Frequency (%) | |
Agree | 470 | 56.8% | |
Strongly agree | 179 | 21.6% | |
Average | 133 | 16.1% | |
Neutral | 30 | 3.6% | |
Disagree | 16 | 1.9% |
Length
Max length | 14 |
---|---|
Median length | 5 |
Mean length | 7.397342995 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 28 |
Disagree | 6 |
Value | Count | Frequency (%) | |
Agree | 433 | 52.3% | |
Strongly agree | 188 | 22.7% | |
Average | 173 | 20.9% | |
Neutral | 28 | 3.4% | |
Disagree | 6 | 0.7% |
Length
Max length | 14 |
---|---|
Median length | 5 |
Mean length | 7.550724638 |
Min length | 5 |
3. Pre-requisite courses / topics are covered in the curriculum prior to introduction of a course
Categorical
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 19 |
Disagree | 7 |
Value | Count | Frequency (%) | |
Agree | 421 | 50.8% | |
Strongly agree | 214 | 25.8% | |
Average | 167 | 20.2% | |
Neutral | 19 | 2.3% | |
Disagree | 7 | 0.8% |
Length
Max length | 14 |
---|---|
Median length | 5 |
Mean length | 7.800724638 |
Min length | 5 |
4. Sufficient practical exposure is provided for the theoretical concepts in the courses
Categorical
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Average | |
Strongly agree | |
Neutral | 42 |
Disagree | 30 |
Value | Count | Frequency (%) | |
Agree | 370 | 44.7% | |
Average | 196 | 23.7% | |
Strongly agree | 190 | 22.9% | |
Neutral | 42 | 5.1% | |
Disagree | 30 | 3.6% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.748792271 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Average | |
Strongly agree | |
Neutral | 47 |
Disagree | 17 |
Value | Count | Frequency (%) | |
Agree | 407 | 49.2% | |
Average | 224 | 27.1% | |
Strongly agree | 133 | 16.1% | |
Neutral | 47 | 5.7% | |
Disagree | 17 | 2.1% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.161835749 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 32 |
Disagree | 10 |
Value | Count | Frequency (%) | |
Agree | 409 | 49.4% | |
Strongly agree | 200 | 24.2% | |
Average | 177 | 21.4% | |
Neutral | 32 | 3.9% | |
Disagree | 10 | 1.2% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.714975845 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 33 |
Disagree | 11 |
Value | Count | Frequency (%) | |
Agree | 397 | 47.9% | |
Strongly agree | 238 | 28.7% | |
Average | 149 | 18.0% | |
Neutral | 33 | 4.0% | |
Disagree | 11 | 1.3% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 8.066425121 |
Min length | 5 |
8. The library provides text book, reference book, and other e resources as and when required
Categorical
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 29 |
Disagree | 13 |
Value | Count | Frequency (%) | |
Agree | 335 | 40.5% | |
Strongly agree | 309 | 37.3% | |
Average | 142 | 17.1% | |
Neutral | 29 | 3.5% | |
Disagree | 13 | 1.6% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 8.81884058 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Average | |
Strongly agree | |
Neutral | |
Disagree |
Value | Count | Frequency (%) | |
Agree | 283 | 34.2% | |
Average | 250 | 30.2% | |
Strongly agree | 163 | 19.7% | |
Neutral | 75 | 9.1% | |
Disagree | 57 | 6.9% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.763285024 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 45 |
Disagree | 25 |
Value | Count | Frequency (%) | |
Agree | 362 | 43.7% | |
Strongly agree | 254 | 30.7% | |
Average | 142 | 17.1% | |
Neutral | 45 | 5.4% | |
Disagree | 25 | 3.0% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 8.303140097 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | |
Disagree | 31 |
Value | Count | Frequency (%) | |
Agree | 360 | 43.5% | |
Strongly agree | 204 | 24.6% | |
Average | 158 | 19.1% | |
Neutral | 75 | 9.1% | |
Disagree | 31 | 3.7% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.892512077 |
Min length | 5 |
12.The evaluation system of the university is always fair and results are declared in time
Categorical
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 41 |
Disagree | 18 |
Value | Count | Frequency (%) | |
Agree | 413 | 49.9% | |
Strongly agree | 222 | 26.8% | |
Average | 134 | 16.2% | |
Neutral | 41 | 5.0% | |
Disagree | 18 | 2.2% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 7.900966184 |
Min length | 5 |
13. All faculty members of the department are co-operative, always helpful even beyond class hours
Categorical
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 20 |
Disagree | 14 |
Value | Count | Frequency (%) | |
Agree | 356 | 43.0% | |
Strongly agree | 316 | 38.2% | |
Average | 122 | 14.7% | |
Neutral | 20 | 2.4% | |
Disagree | 14 | 1.7% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 8.828502415 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 27 |
Disagree | 8 |
Value | Count | Frequency (%) | |
Agree | 385 | 46.5% | |
Strongly agree | 241 | 29.1% | |
Average | 167 | 20.2% | |
Neutral | 27 | 3.3% | |
Disagree | 8 | 1.0% |
Length
Max length | 14 |
---|---|
Median length | 7 |
Mean length | 8.117149758 |
Min length | 5 |
Distinct count | 5 |
---|---|
Unique (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
Agree | |
---|---|
Strongly agree | |
Average | |
Neutral | 39 |
Disagree | 17 |
Value | Count | Frequency (%) | |
Agree | 425 | 51.3% | |
Strongly agree | 201 | 24.3% | |
Average | 146 | 17.6% | |
Neutral | 39 | 4.7% | |
Disagree | 17 | 2.1% |
Length
Max length | 14 |
---|---|
Median length | 5 |
Mean length | 7.693236715 |
Min length | 5 |
Distinct count | 212 |
---|---|
Unique (%) | 70.2% |
Missing | 526 |
Missing (%) | 63.5% |
Memory size | 6.5 KiB |
Good | 44 |
---|---|
good | 9 |
Excellent | 8 |
GOOD | 7 |
Very good | 6 |
Other values (207) |
Value | Count | Frequency (%) | |
Good | 44 | 5.3% | |
good | 9 | 1.1% | |
Excellent | 8 | 1.0% | |
GOOD | 7 | 0.8% | |
Very good | 6 | 0.7% | |
Good. | 6 | 0.7% | |
I AM VERY MUCH SATISFIED BY THE FACILITIES AND CO-OPERATION PROVIDED ON BEHALF OF MY COLLEGE. | 3 | 0.4% | |
very good | 3 | 0.4% | |
Overall good | 2 | 0.2% | |
overall its good | 2 | 0.2% | |
Other values (202) | 212 | 25.6% | |
(Missing) | 526 | 63.5% |
Length
Max length | 2159 |
---|---|
Median length | 3 |
Mean length | 41.01328502 |
Min length | 1 |
Distinct count | 821 |
---|---|
Unique (%) | 99.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
2020-07-26 13:49:16 | 2 |
---|---|
2020-07-23 08:03:43 | 2 |
2020-07-23 15:34:11 | 2 |
2020-07-23 08:28:03 | 2 |
2020-07-23 15:06:55 | 2 |
Other values (816) |
Value | Count | Frequency (%) | |
2020-07-26 13:49:16 | 2 | 0.2% | |
2020-07-23 08:03:43 | 2 | 0.2% | |
2020-07-23 15:34:11 | 2 | 0.2% | |
2020-07-23 08:28:03 | 2 | 0.2% | |
2020-07-23 15:06:55 | 2 | 0.2% | |
2020-07-31 09:52:33 | 2 | 0.2% | |
2020-07-23 07:40:12 | 2 | 0.2% | |
2020-07-28 07:06:30 | 1 | 0.1% | |
2020-07-28 05:33:11 | 1 | 0.1% | |
2020-07-26 18:05:12 | 1 | 0.1% | |
Other values (811) | 811 | 97.9% |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 19 |
Min length | 19 |
Distinct count | 821 |
---|---|
Unique (%) | 99.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
2020-07-26 13:49:16 | 2 |
---|---|
2020-07-23 08:03:43 | 2 |
2020-07-23 15:34:11 | 2 |
2020-07-23 08:28:03 | 2 |
2020-07-23 15:06:55 | 2 |
Other values (816) |
Value | Count | Frequency (%) | |
2020-07-26 13:49:16 | 2 | 0.2% | |
2020-07-23 08:03:43 | 2 | 0.2% | |
2020-07-23 15:34:11 | 2 | 0.2% | |
2020-07-23 08:28:03 | 2 | 0.2% | |
2020-07-23 15:06:55 | 2 | 0.2% | |
2020-07-31 09:52:33 | 2 | 0.2% | |
2020-07-23 07:40:12 | 2 | 0.2% | |
2020-07-28 07:06:30 | 1 | 0.1% | |
2020-07-28 05:33:11 | 1 | 0.1% | |
2020-07-26 18:05:12 | 1 | 0.1% | |
Other values (811) | 811 | 97.9% |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 19 |
Min length | 19 |
Distinct count | 789 |
---|---|
Unique (%) | 95.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 644.0869565217391 |
---|---|
Minimum | 0 |
Maximum | 1284 |
Zeros | 7 |
Zeros (%) | 0.8% |
Memory size | 6.5 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 65.7 |
Q1 | 332.5 |
median | 619.5 |
Q3 | 953.5 |
95-th percentile | 1211.3 |
Maximum | 1284 |
Range | 1284 |
Interquartile range (IQR) | 621 |
Descriptive statistics
Standard deviation | 362.2253264 |
---|---|
Coefficient of variation (CV) | 0.5623857505 |
Kurtosis | -1.2097571 |
Mean | 644.0869565 |
Median Absolute Deviation (MAD) | 308 |
Skewness | 0.04161235873 |
Sum | 533304 |
Variance | 131207.1871 |
Value | Count | Frequency (%) | |
0 | 7 | 0.8% | |
307 | 3 | 0.4% | |
140 | 3 | 0.4% | |
514 | 3 | 0.4% | |
316 | 2 | 0.2% | |
841 | 2 | 0.2% | |
59 | 2 | 0.2% | |
381 | 2 | 0.2% | |
502 | 2 | 0.2% | |
90 | 2 | 0.2% | |
Other values (779) | 800 | 96.6% |
Value | Count | Frequency (%) | |
0 | 7 | 0.8% | |
12 | 1 | 0.1% | |
13 | 1 | 0.1% | |
15 | 1 | 0.1% | |
16 | 1 | 0.1% |
Value | Count | Frequency (%) | |
1284 | 1 | 0.1% | |
1282 | 1 | 0.1% | |
1275 | 1 | 0.1% | |
1273 | 1 | 0.1% | |
1271 | 1 | 0.1% |
Distinct count | 789 |
---|---|
Unique (%) | 95.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 644.0869565217391 |
---|---|
Minimum | 0 |
Maximum | 1284 |
Zeros | 7 |
Zeros (%) | 0.8% |
Memory size | 6.5 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 65.7 |
Q1 | 332.5 |
median | 619.5 |
Q3 | 953.5 |
95-th percentile | 1211.3 |
Maximum | 1284 |
Range | 1284 |
Interquartile range (IQR) | 621 |
Descriptive statistics
Standard deviation | 362.2253264 |
---|---|
Coefficient of variation (CV) | 0.5623857505 |
Kurtosis | -1.2097571 |
Mean | 644.0869565 |
Median Absolute Deviation (MAD) | 308 |
Skewness | 0.04161235873 |
Sum | 533304 |
Variance | 131207.1871 |
Value | Count | Frequency (%) | |
0 | 7 | 0.8% | |
307 | 3 | 0.4% | |
140 | 3 | 0.4% | |
514 | 3 | 0.4% | |
316 | 2 | 0.2% | |
841 | 2 | 0.2% | |
59 | 2 | 0.2% | |
381 | 2 | 0.2% | |
502 | 2 | 0.2% | |
90 | 2 | 0.2% | |
Other values (779) | 800 | 96.6% |
Value | Count | Frequency (%) | |
0 | 7 | 0.8% | |
12 | 1 | 0.1% | |
13 | 1 | 0.1% | |
15 | 1 | 0.1% | |
16 | 1 | 0.1% |
Value | Count | Frequency (%) | |
1284 | 1 | 0.1% | |
1282 | 1 | 0.1% | |
1275 | 1 | 0.1% | |
1273 | 1 | 0.1% | |
1271 | 1 | 0.1% |
Distinct count | 1 |
---|---|
Unique (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
0 |
---|
Value | Count | Frequency (%) | |
0 | 828 | 100.0% |
Distinct count | 781 |
---|---|
Unique (%) | 94.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
42.110.217.91 | 3 |
---|---|
43.251.177.44 | 3 |
103.10.209.26 | 2 |
2409:4064:240d:9316:44d:8b94:2e97:2a6a | 2 |
47.11.235.212 | 2 |
Other values (776) |
Value | Count | Frequency (%) | |
42.110.217.91 | 3 | 0.4% | |
43.251.177.44 | 3 | 0.4% | |
103.10.209.26 | 2 | 0.2% | |
2409:4064:240d:9316:44d:8b94:2e97:2a6a | 2 | 0.2% | |
47.11.235.212 | 2 | 0.2% | |
2409:4064:810:ed68:9884:c5c0:589d:f0c6 | 2 | 0.2% | |
2409:4061:201c:eff::2a32:70b1 | 2 | 0.2% | |
2409:4061:2c1c:f92b:7c0d:c797:14f5:e559 | 2 | 0.2% | |
157.43.202.163 | 2 | 0.2% | |
2409:4061:2d15:aebc:50b8:c436:1005:84b9 | 2 | 0.2% | |
Other values (771) | 806 | 97.3% |
Length
Max length | 39 |
---|---|
Median length | 37 |
Mean length | 28.7089372 |
Min length | 10 |
Distinct count | 828 |
---|---|
Unique (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 951.06038647343 |
---|---|
Minimum | 13 |
Maximum | 2596 |
Zeros | 0 |
Zeros (%) | 0.0% |
Memory size | 6.5 KiB |
Quantile statistics
Minimum | 13 |
---|---|
5-th percentile | 85.05 |
Q1 | 419.75 |
median | 963.5 |
Q3 | 1474.25 |
95-th percentile | 1841.65 |
Maximum | 2596 |
Range | 2583 |
Interquartile range (IQR) | 1054.5 |
Descriptive statistics
Standard deviation | 585.2803945 |
---|---|
Coefficient of variation (CV) | 0.6153977212 |
Kurtosis | -1.24247292 |
Mean | 951.0603865 |
Median Absolute Deviation (MAD) | 533 |
Skewness | 0.05217567926 |
Sum | 787478 |
Variance | 342553.1402 |
Value | Count | Frequency (%) | |
1939 | 1 | 0.1% | |
579 | 1 | 0.1% | |
607 | 1 | 0.1% | |
604 | 1 | 0.1% | |
603 | 1 | 0.1% | |
591 | 1 | 0.1% | |
590 | 1 | 0.1% | |
589 | 1 | 0.1% | |
587 | 1 | 0.1% | |
584 | 1 | 0.1% | |
Other values (818) | 818 | 98.8% |
Value | Count | Frequency (%) | |
13 | 1 | 0.1% | |
15 | 1 | 0.1% | |
16 | 1 | 0.1% | |
18 | 1 | 0.1% | |
20 | 1 | 0.1% |
Value | Count | Frequency (%) | |
2596 | 1 | 0.1% | |
1939 | 1 | 0.1% | |
1933 | 1 | 0.1% | |
1927 | 1 | 0.1% | |
1924 | 1 | 0.1% |
Distinct count | 828 |
---|---|
Unique (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 6.5 KiB |
88daz | 1 |
---|---|
s5wal | 1 |
rjrr1 | 1 |
zgb4s | 1 |
tbgig | 1 |
Other values (823) |
Value | Count | Frequency (%) | |
88daz | 1 | 0.1% | |
s5wal | 1 | 0.1% | |
rjrr1 | 1 | 0.1% | |
zgb4s | 1 | 0.1% | |
tbgig | 1 | 0.1% | |
3okqf | 1 | 0.1% | |
ucwtq | 1 | 0.1% | |
7uzs1 | 1 | 0.1% | |
27tqt | 1 | 0.1% | |
tmzit | 1 | 0.1% | |
Other values (818) | 818 | 98.8% |
Length
Max length | 6 |
---|---|
Median length | 5 |
Mean length | 4.973429952 |
Min length | 3 |
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 | Draft | IP | ID | Key | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 0 | Amit Kumar singh | Computer Science Engineering | 2019-20 | Agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Outstanding 🙂 | 2020-07-23 06:22:32 | 2020-07-23 06:22:32 | 189 | 189 | 0 | 2409:4060:398:e094:ac5d:d1e9:305a:cfea | 13 | y51su |
1 | 2 | Rakesh Ranjan | Computer Science Engineering | 2019-20 | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | Average | NaN | 2020-07-23 06:28:50 | 2020-07-23 06:28:50 | 195 | 195 | 0 | 2409:4064:2516:19ed:489f:e1ff:fe51:ad10 | 15 | m4902 |
2 | 3 | AKASH PAUL | Computer Science Engineering | 2019-20 | Average | Agree | Agree | Neutral | Neutral | Agree | Average | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Agree | Average | Agree | Agree | NaN | 2020-07-23 06:29:41 | 2020-07-23 06:29:41 | 186 | 186 | 0 | 2401:4900:3826:a492:a23d:c27b:ed58:813a | 16 | iv1pu |
3 | 5 | Md Shahnawaz Ansari | Electronics and Instrumentation Engineering | 2019-20 | Neutral | Agree | Agree | Agree | Agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Excellent | 2020-07-23 06:31:47 | 2020-07-23 06:31:47 | 59 | 59 | 0 | 2409:4064:4e09:2fe6:a936:da62:a8fd:e53 | 18 | ov0ws |
4 | 7 | shubam kumar | Electronics and Communication Engineering | 2019-20 | 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-23 06:37:29 | 2020-07-23 06:37:29 | 40 | 40 | 0 | 2409:4064:e8f:440e:485e:45ef:f0f8:843a | 20 | 3fnlt |
5 | 8 | SURUCHI ADHIKARY | Computer Science Engineering | 2019-20 | Strongly agree | Agree | Strongly agree | Average | Agree | Agree | Agree | Agree | Average | Agree | Agree | Strongly agree | Strongly agree | Agree | Agree | EVERYTHING IS FINE AND ONLINE CLASSES ARE ALSO GOING WELL. PRE-REQUISITE CLASSES ARE GOING QUITE WELL.ALL OVER IT IS GOOD. | 2020-07-23 06:42:10 | 2020-07-23 06:42:10 | 197 | 197 | 0 | 2409:4061:701:1c77:9597:25e2:c089:d357 | 21 | o4kol |
6 | 10 | Jayeti Mukherjee | Electronics and Communication Engineering | 2019-20 | Agree | Agree | Agree | Average | Average | Average | Average | Agree | Disagree | Neutral | Average | Average | Average | Average | Average | NaN | 2020-07-23 06:50:02 | 2020-07-23 06:50:02 | 203 | 203 | 0 | 2409:4061:2e03:940f:6757:ad97:9731:77b6 | 23 | 1sm2k |
7 | 12 | Rahul Ranjan | Computer Science Engineering | 2019-20 | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Average | Average | Strongly agree | Agree | Strongly agree | Agree | Strongly agree | Strongly agree | The courses are great and the teachers provide great help and support. The college provides a perfect platform for the growth of our career. | 2020-07-23 06:55:40 | 2020-07-23 06:55:40 | 205 | 205 | 0 | 2409:4064:b13:ddcd:98d2:c4ff:2fc4:4d0f | 25 | 30vws |
8 | 13 | SUBHRADIP DUTTA | Electronics and Communication Engineering | 2019-20 | Agree | Agree | Agree | Average | Average | Agree | Agree | Strongly agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Agree | I M SATISFIED TO BE A STUDENT OF BCREC..It remains a colourful n blissful chapter for my life. | 2020-07-23 06:56:55 | 2020-07-23 06:56:55 | 209 | 209 | 0 | 202.142.71.247 | 26 | 3mazw |
9 | 14 | Neelanjana Giri | Electronics and Communication Engineering | 2019-20 | Strongly agree | Agree | Strongly agree | Strongly agree | Strongly agree | Agree | Agree | Strongly agree | Agree | Strongly agree | Average | Strongly agree | Strongly agree | Strongly agree | Agree | NaN | 2020-07-23 06:58:17 | 2020-07-23 06:58:17 | 206 | 206 | 0 | 116.193.142.75 | 27 | 2p2kn |
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 | Draft | IP | ID | Key | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
818 | 1716 | RAJA GARAIN | Electrical Engineering | 2019-20 | Average | Agree | Agree | Agree | Agree | Agree | Agree | Strongly agree | Neutral | Agree | Average | Disagree | Strongly agree | Average | Strongly agree | NaN | 2020-07-31 13:35:26 | 2020-07-31 13:35:26 | 1269 | 1269 | 0 | 2409:4061:413:abd2::261d:a0a5 | 1912 | hjmqn |
819 | 1717 | Ravikant kumar | Civil Engineering | 2019-20 | Agree | Average | Average | Neutral | Average | Strongly agree | Agree | Agree | Average | Agree | Strongly agree | Agree | Strongly agree | Agree | Strongly agree | exceeds expectations with the quality of their work. | 2020-07-31 14:37:37 | 2020-07-31 14:37:37 | 1270 | 1270 | 0 | 2409:4064:4dce:8d41::750b:510a | 1914 | u6swl |
820 | 1718 | Ankan Dutta | Information Technology | 2019-20 | Disagree | Average | Neutral | Agree | Agree | Agree | Agree | Average | Neutral | Disagree | Average | Neutral | Average | Agree | Agree | NaN | 2020-07-31 15:01:08 | 2020-07-31 15:01:08 | 1271 | 1271 | 0 | 42.110.212.10 | 1915 | xo1ii |
821 | 1720 | Ishita Lai | Electronics and Communication Engineering | 2019-20 | Agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Disagree | Agree | Agree | Neutral | Agree | Agree | Agree | Agree | In recent times, the library facility is very bad. | 2020-09-14 18:32:02 | 2020-09-14 18:32:02 | 351 | 351 | 0 | 2401:4900:3829:a10:f9ff:3d37:3784:f264 | 2596 | kp5v8 |
822 | 1723 | Prerona Dutta | Electronics and Instrumentation Engineering | 2019-20 | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Neutral | Agree | Agree | Agree | Agree | Blessed to be a part of BCREC. | 2020-07-31 15:54:39 | 2020-07-31 15:54:39 | 154 | 154 | 0 | 45.116.191.236 | 1919 | wf75i |
823 | 1724 | Bajradeepon Saha | Information Technology | 2019-20 | Strongly agree | Agree | Strongly agree | Neutral | Agree | Strongly agree | Strongly agree | Agree | Average | Disagree | Strongly agree | Strongly agree | Strongly agree | Agree | Agree | need to introduce student club and tech clubs. | 2020-07-31 16:08:17 | 2020-07-31 16:08:17 | 1273 | 1273 | 0 | 45.116.190.250 | 1920 | y1iy6 |
824 | 1727 | Ritick Ghosh | Electrical Engineering | 2019-20 | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree | NaN | 2020-08-01 03:11:14 | 2020-08-01 03:11:14 | 1275 | 1275 | 0 | 2409:4061:60b:37fb::fbc:18ac | 1924 | kam95 |
825 | 1729 | Simran | Information Technology | 2019-20 | Agree | Agree | Agree | Agree | Agree | Strongly agree | Agree | Agree | Average | Agree | Agree | Agree | Agree | Agree | Agree | NaN | 2020-08-01 08:55:15 | 2020-08-01 08:55:15 | 1282 | 1282 | 0 | 2409:4064:4e95:34a7:3ca0:b331:8ed8:300c | 1927 | da5ky |
826 | 1731 | Mohammad Faizan | Mechanical Engineering | 2019-20 | Disagree | Disagree | Disagree | Disagree | Disagree | Disagree | Disagree | Agree | Average | Average | Disagree | Average | Average | Disagree | Disagree | NaN | 2020-08-01 15:32:12 | 2020-08-01 15:32:12 | 594 | 594 | 0 | 2401:4900:3629:8c2a:1:1:7f27:acdd | 1933 | yelw8 |
827 | 1735 | Pronab Barman | Civil Engineering | 2019-20 | Agree | Agree | Agree | Average | Agree | Agree | Agree | Agree | Average | Agree | Agree | Agree | Agree | Agree | Agree | NaN | 2020-08-02 17:16:51 | 2020-08-02 17:16:51 | 1284 | 1284 | 0 | 117.194.103.213 | 1939 | o4mst |