gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	59
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.9 KiB
Average record size in memory	154.2 B

Variable types

Numeric	6
Text	9
Categorical	2
DateTime	1

Dataset

Description	관내학교현황에 대한 데이터로 학교명, 학급수, 학생수, 교원수, 교장, 교감, 행정실장, 전화번호(교장실, 교무실, 행정실, 당직실), 팩스 등의 항목을 제공합니다.
URL	https://www.data.go.kr/data/3077536/fileData.do

Alerts

`데이터기준일자` has constant value ""	Constant
`교원수(교감)` is highly overall correlated with `학급수(일반)` and 2 other fields	High correlation
`교원수(교장)` is highly overall correlated with `교원수(교감)`	High correlation
`연번` is highly overall correlated with `교원수(교사)` and 1 other fields	High correlation
`학급수(일반)` is highly overall correlated with `학생수` and 3 other fields	High correlation
`학생수` is highly overall correlated with `학급수(일반)` and 3 other fields	High correlation
`교원수(교사)` is highly overall correlated with `연번` and 3 other fields	High correlation
`총 교원수` is highly overall correlated with `연번` and 3 other fields	High correlation
`교원수(교장)` is highly imbalanced (87.6%)	Imbalance
`교원수(교감)` is highly imbalanced (78.8%)	Imbalance
`연번` has unique values	Unique
`학교명` has unique values	Unique
`전화번호(교무실)` has unique values	Unique
`학급수(일반)` has 1 (1.7%) zeros	Zeros
`학급수(특수)` has 11 (18.6%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 20:14:42.628352
Analysis finished	2023-12-12 20:14:48.509165
Duration	5.88 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	59
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30

Minimum	1
Maximum	59
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	1
5-th percentile	3.9
Q1	15.5
median	30
Q3	44.5
95-th percentile	56.1
Maximum	59
Range	58
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	17.175564
Coefficient of variation (CV)	0.5725188
Kurtosis	-1.2
Mean	30
Median Absolute Deviation (MAD)	15
Skewness	0
Sum	1770
Variance	295
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	1.7%
2	1	1.7%
33	1	1.7%
34	1	1.7%
35	1	1.7%
36	1	1.7%
37	1	1.7%
38	1	1.7%
39	1	1.7%
40	1	1.7%
Other values (49)	49	83.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	1.7%
2	1	1.7%
3	1	1.7%
4	1	1.7%
5	1	1.7%
6	1	1.7%
7	1	1.7%
8	1	1.7%
9	1	1.7%
10	1	1.7%

Value	Count	Frequency (%)
59	1	1.7%
58	1	1.7%
57	1	1.7%
56	1	1.7%
55	1	1.7%
54	1	1.7%
53	1	1.7%
52	1	1.7%
51	1	1.7%
50	1	1.7%

학교명
Text

UNIQUE

Distinct	59
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	10
Median length	3
Mean length	3.559322
Min length	3

Characters and Unicode

Total characters	210
Distinct characters	65
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59 ?
Unique (%)	100.0%

Sample

1st row	송랑유치원
2nd row	양주유치원
3rd row	가납초
4th row	고암초
5th row	광사초

Value	Count	Frequency (%)
송랑유치원	1	1.7%
율정초	1	1.7%
은현초	1	1.7%
주원초	1	1.7%
천보초	1	1.7%
칠봉초	1	1.7%
회정초	1	1.7%
회천초	1	1.7%
효촌초	1	1.7%
고암중	1	1.7%
Other values (49)	49	83.1%

Most occurring characters

Value	Count	Frequency (%)
초	36	17.1%
덕	12	5.7%
양	11	5.2%
중	11	5.2%
고	10	4.8%
주	9	4.3%
정	8	3.8%
옥	6	2.9%
빛	4	1.9%
사	4	1.9%
Other values (55)	99	47.1%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	204	97.1%
Open Punctuation	3	1.4%
Close Punctuation	3	1.4%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
초	36	17.6%
덕	12	5.9%
양	11	5.4%
중	11	5.4%
고	10	4.9%
주	9	4.4%
정	8	3.9%
옥	6	2.9%
빛	4	2.0%
사	4	2.0%
Other values (53)	93	45.6%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	204	97.1%
Common	6	2.9%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
초	36	17.6%
덕	12	5.9%
양	11	5.4%
중	11	5.4%
고	10	4.9%
주	9	4.4%
정	8	3.9%
옥	6	2.9%
빛	4	2.0%
사	4	2.0%
Other values (53)	93	45.6%

Common

Value	Count	Frequency (%)
(	3	50.0%
)	3	50.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	204	97.1%
ASCII	6	2.9%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
초	36	17.6%
덕	12	5.9%
양	11	5.4%
중	11	5.4%
고	10	4.9%
주	9	4.4%
정	8	3.9%
옥	6	2.9%
빛	4	2.0%
사	4	2.0%
Other values (53)	93	45.6%

ASCII

Value	Count	Frequency (%)
(	3	50.0%
)	3	50.0%

학급수(일반)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	28
Distinct (%)	47.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.067797

Minimum	0
Maximum	60
Zeros	1
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	0
5-th percentile	6
Q1	8.5
median	17
Q3	27
95-th percentile	40
Maximum	60
Range	60
Interquartile range (IQR)	18.5

Descriptive statistics

Standard deviation	12.091411
Coefficient of variation (CV)	0.63412733
Kurtosis	0.95584636
Mean	19.067797
Median Absolute Deviation (MAD)	10
Skewness	0.92391252
Sum	1125
Variance	146.20222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
6	12	20.3%
14	5	8.5%
12	4	6.8%
27	4	6.8%
24	3	5.1%
34	3	5.1%
21	2	3.4%
40	2	3.4%
17	2	3.4%
19	2	3.4%
Other values (18)	20	33.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	1.7%
6	12	20.3%
7	1	1.7%
8	1	1.7%
9	1	1.7%
11	1	1.7%
12	4	6.8%
14	5	8.5%
15	1	1.7%
16	1	1.7%

Value	Count	Frequency (%)
60	1	1.7%
45	1	1.7%
40	2	3.4%
39	1	1.7%
34	3	5.1%
33	1	1.7%
31	1	1.7%
30	1	1.7%
29	1	1.7%
28	1	1.7%

학급수(특수)
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8813559

Minimum	0
Maximum	30
Zeros	11
Zeros (%)	18.6%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	3.1
Maximum	30
Range	30
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.8465602
Coefficient of variation (CV)	2.0445681
Kurtosis	51.456257
Mean	1.8813559
Median Absolute Deviation (MAD)	1
Skewness	6.9513444
Sum	111
Variance	14.796026
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	22	37.3%
1	20	33.9%
0	11	18.6%
3	3	5.1%
4	2	3.4%
30	1	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	18.6%
1	20	33.9%
2	22	37.3%
3	3	5.1%
4	2	3.4%
30	1	1.7%

Value	Count	Frequency (%)
30	1	1.7%
4	2	3.4%
3	3	5.1%
2	22	37.3%
1	20	33.9%
0	11	18.6%

학생수
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	93.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	480.37288

Minimum	36
Maximum	1679
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	36
5-th percentile	41.9
Q1	184.5
median	391
Q3	730
95-th percentile	1166
Maximum	1679
Range	1643
Interquartile range (IQR)	545.5

Descriptive statistics

Standard deviation	370.23142
Coefficient of variation (CV)	0.77071674
Kurtosis	0.59199384
Mean	480.37288
Median Absolute Deviation (MAD)	277
Skewness	0.89188246
Sum	28342
Variance	137071.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
390	2	3.4%
314	2	3.4%
391	2	3.4%
834	2	3.4%
78	1	1.7%
554	1	1.7%
536	1	1.7%
500	1	1.7%
224	1	1.7%
505	1	1.7%
Other values (45)	45	76.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36	1	1.7%
40	1	1.7%
41	1	1.7%
42	1	1.7%
48	1	1.7%
50	1	1.7%
53	1	1.7%
57	1	1.7%
59	1	1.7%
78	1	1.7%

Value	Count	Frequency (%)
1679	1	1.7%
1224	1	1.7%
1220	1	1.7%
1160	1	1.7%
1039	1	1.7%
994	1	1.7%
971	1	1.7%
902	1	1.7%
871	1	1.7%
868	1	1.7%

교원수(교장)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

1	58
0	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	1 ?
Unique (%)	1.7%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	58	98.3%
0	1	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	58	98.3%
0	1	1.7%

교원수(교감)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

1	56
2	2
0	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	1 ?
Unique (%)	1.7%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	56	94.9%
2	2	3.4%
0	1	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	56	94.9%
2	2	3.4%
0	1	1.7%

교원수(교사)
Real number (ℝ)

HIGH CORRELATION

Distinct	38
Distinct (%)	64.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.508475

Minimum	8
Maximum	78
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	8
5-th percentile	9
Q1	17
median	29
Q3	47
95-th percentile	73.1
Maximum	78
Range	70
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	20.690972
Coefficient of variation (CV)	0.61748474
Kurtosis	-0.74574417
Mean	33.508475
Median Absolute Deviation (MAD)	14
Skewness	0.63242245
Sum	1977
Variance	428.11631
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
9	6	10.2%
11	3	5.1%
63	3	5.1%
30	3	5.1%
27	2	3.4%
64	2	3.4%
17	2	3.4%
60	2	3.4%
21	2	3.4%
15	2	3.4%
Other values (28)	32	54.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	2	3.4%
9	6	10.2%
11	3	5.1%
14	1	1.7%
15	2	3.4%
17	2	3.4%
18	1	1.7%
19	1	1.7%
20	1	1.7%
21	2	3.4%

Value	Count	Frequency (%)
78	1	1.7%
76	1	1.7%
74	1	1.7%
73	1	1.7%
65	1	1.7%
64	2	3.4%
63	3	5.1%
60	2	3.4%
53	1	1.7%
52	1	1.7%

총 교원수
Real number (ℝ)

HIGH CORRELATION

Distinct	39
Distinct (%)	66.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.491525

Minimum	8
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	663.0 B

Quantile statistics

Minimum	8
5-th percentile	11
Q1	19
median	31
Q3	49
95-th percentile	75.1
Maximum	80
Range	72
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	20.760849
Coefficient of variation (CV)	0.58495229
Kurtosis	-0.74830243
Mean	35.491525
Median Absolute Deviation (MAD)	14
Skewness	0.62592761
Sum	2094
Variance	431.01286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
11	6	10.2%
65	3	5.1%
13	3	5.1%
32	3	5.1%
40	2	3.4%
29	2	3.4%
67	2	3.4%
31	2	3.4%
19	2	3.4%
23	2	3.4%
Other values (29)	32	54.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	1.7%
10	1	1.7%
11	6	10.2%
13	3	5.1%
16	1	1.7%
17	2	3.4%
19	2	3.4%
20	1	1.7%
21	1	1.7%
22	1	1.7%

Value	Count	Frequency (%)
80	1	1.7%
78	1	1.7%
76	1	1.7%
75	1	1.7%
67	2	3.4%
66	1	1.7%
65	3	5.1%
62	2	3.4%
55	1	1.7%
54	1	1.7%

교장
Text

Distinct	57
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	3
Median length	3
Mean length	2.9830508
Min length	2

Characters and Unicode

Total characters	176
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	93.2%

Sample

1st row	신지영
2nd row	김희숙
3rd row	김복선
4th row	홍순옥
5th row	정동수

Value	Count	Frequency (%)
양동용	2	3.4%
이희빈	2	3.4%
고대영	1	1.7%
고미숙	1	1.7%
박준성	1	1.7%
안민희	1	1.7%
신지영	1	1.7%
윤복실	1	1.7%
이숙희	1	1.7%
강종숙	1	1.7%
Other values (47)	47	79.7%

Most occurring characters

Value	Count	Frequency (%)
이	11	6.2%
숙	10	5.7%
희	10	5.7%
김	9	5.1%
현	6	3.4%
정	6	3.4%
박	6	3.4%
순	5	2.8%
경	5	2.8%
동	5	2.8%
Other values (60)	103	58.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	176	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
이	11	6.2%
숙	10	5.7%
희	10	5.7%
김	9	5.1%
현	6	3.4%
정	6	3.4%
박	6	3.4%
순	5	2.8%
경	5	2.8%
동	5	2.8%
Other values (60)	103	58.5%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	176	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
이	11	6.2%
숙	10	5.7%
희	10	5.7%
김	9	5.1%
현	6	3.4%
정	6	3.4%
박	6	3.4%
순	5	2.8%
경	5	2.8%
동	5	2.8%
Other values (60)	103	58.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	176	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
이	11	6.2%
숙	10	5.7%
희	10	5.7%
김	9	5.1%
현	6	3.4%
정	6	3.4%
박	6	3.4%
순	5	2.8%
경	5	2.8%
동	5	2.8%
Other values (60)	103	58.5%

교감
Text

Distinct	58
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	7
Median length	3
Mean length	3.0338983
Min length	2

Characters and Unicode

Total characters	179
Distinct characters	87
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	96.6%

Sample

1st row	김현숙
2nd row	박미선
3rd row	손민경
4th row	방성배
5th row	한대수

Value	Count	Frequency (%)
신길동	2	3.3%
신은하	1	1.7%
석용범	1	1.7%
이경훈	1	1.7%
한상현	1	1.7%
박옥자	1	1.7%
김순완	1	1.7%
곽희옥	1	1.7%
오인순	1	1.7%
유호형	1	1.7%
Other values (49)	49	81.7%

Most occurring characters

Value	Count	Frequency (%)
김	11	6.1%
영	7	3.9%
현	7	3.9%
이	6	3.4%
은	5	2.8%
용	5	2.8%
선	5	2.8%
신	4	2.2%
재	4	2.2%
희	4	2.2%
Other values (77)	121	67.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	177	98.9%
Other Punctuation	1	0.6%
Space Separator	1	0.6%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
김	11	6.2%
영	7	4.0%
현	7	4.0%
이	6	3.4%
은	5	2.8%
용	5	2.8%
선	5	2.8%
신	4	2.3%
재	4	2.3%
희	4	2.3%
Other values (75)	119	67.2%

Other Punctuation

Value	Count	Frequency (%)
,	1	100.0%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	177	98.9%
Common	2	1.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
김	11	6.2%
영	7	4.0%
현	7	4.0%
이	6	3.4%
은	5	2.8%
용	5	2.8%
선	5	2.8%
신	4	2.3%
재	4	2.3%
희	4	2.3%
Other values (75)	119	67.2%

Common

Value	Count	Frequency (%)
,	1	50.0%
	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	177	98.9%
ASCII	2	1.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
김	11	6.2%
영	7	4.0%
현	7	4.0%
이	6	3.4%
은	5	2.8%
용	5	2.8%
선	5	2.8%
신	4	2.3%
재	4	2.3%
희	4	2.3%
Other values (75)	119	67.2%

ASCII

Value	Count	Frequency (%)
,	1	50.0%
	1	50.0%

행정실장
Text

Distinct	57
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	5
Median length	3
Mean length	3
Min length	2

Characters and Unicode

Total characters	177
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	93.2%

Sample

1st row	정홍철
2nd row	최정우
3rd row	전지선
4th row	석현태
5th row	서상민

Value	Count	Frequency (%)
양미영	2	3.4%
공석	2	3.4%
정일용	1	1.7%
이수옥	1	1.7%
김규식	1	1.7%
양재연	1	1.7%
정홍철	1	1.7%
권오병	1	1.7%
양인서	1	1.7%
이보은	1	1.7%
Other values (47)	47	79.7%

Most occurring characters

Value	Count	Frequency (%)
김	12	6.8%
정	10	5.6%
이	9	5.1%
미	7	4.0%
영	6	3.4%
경	6	3.4%
최	6	3.4%
숙	5	2.8%
우	5	2.8%
양	4	2.3%
Other values (59)	107	60.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	177	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
김	12	6.8%
정	10	5.6%
이	9	5.1%
미	7	4.0%
영	6	3.4%
경	6	3.4%
최	6	3.4%
숙	5	2.8%
우	5	2.8%
양	4	2.3%
Other values (59)	107	60.5%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	177	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
김	12	6.8%
정	10	5.6%
이	9	5.1%
미	7	4.0%
영	6	3.4%
경	6	3.4%
최	6	3.4%
숙	5	2.8%
우	5	2.8%
양	4	2.3%
Other values (59)	107	60.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	177	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
김	12	6.8%
정	10	5.6%
이	9	5.1%
미	7	4.0%
영	6	3.4%
경	6	3.4%
최	6	3.4%
숙	5	2.8%
우	5	2.8%
양	4	2.3%
Other values (59)	107	60.5%

전화번호(교장실)
Text

Distinct	58
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	13
Median length	8
Mean length	8.0847458
Min length	8

Characters and Unicode

Total characters	477
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	96.6%

Sample

1st row	845-4010
2nd row	864-9261
3rd row	836-3032
4th row	858-5434
5th row	856-0390

Value	Count	Frequency (%)
860-5507	2	3.4%
856-9763	1	1.7%
863-6126	1	1.7%
855-1204	1	1.7%
860-6111	1	1.7%
866-0841	1	1.7%
859-2545	1	1.7%
859-6214	1	1.7%
859-8890	1	1.7%
871-3173	1	1.7%
Other values (48)	48	81.4%

Most occurring characters

Value	Count	Frequency (%)
8	83	17.4%
0	68	14.3%
-	60	12.6%
6	49	10.3%
5	37	7.8%
4	37	7.8%
1	37	7.8%
2	30	6.3%
9	28	5.9%
3	26	5.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	417	87.4%
Dash Punctuation	60	12.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	83	19.9%
0	68	16.3%
6	49	11.8%
5	37	8.9%
4	37	8.9%
1	37	8.9%
2	30	7.2%
9	28	6.7%
3	26	6.2%
7	22	5.3%

Dash Punctuation

Value	Count	Frequency (%)
-	60	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	477	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	83	17.4%
0	68	14.3%
-	60	12.6%
6	49	10.3%
5	37	7.8%
4	37	7.8%
1	37	7.8%
2	30	6.3%
9	28	5.9%
3	26	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	83	17.4%
0	68	14.3%
-	60	12.6%
6	49	10.3%
5	37	7.8%
4	37	7.8%
1	37	7.8%
2	30	6.3%
9	28	5.9%
3	26	5.5%

전화번호(교무실)
Text

UNIQUE

Distinct	59
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	10
Median length	8
Mean length	8.0338983
Min length	8

Characters and Unicode

Total characters	474
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59 ?
Unique (%)	100.0%

Sample

1st row	845-4050
2nd row	864-9260
3rd row	836-3009
4th row	858-5432
5th row	856-0391

Value	Count	Frequency (%)
845-4050	1	1.7%
859-8511	1	1.7%
868-8032	1	1.7%
860-6115	1	1.7%
866-0841	1	1.7%
859-2545	1	1.7%
859-6214	1	1.7%
859-8891	1	1.7%
871-3172	1	1.7%
859-2252	1	1.7%
Other values (49)	49	83.1%

Most occurring characters

Value	Count	Frequency (%)
8	81	17.1%
-	59	12.4%
6	54	11.4%
0	52	11.0%
5	45	9.5%
2	39	8.2%
1	39	8.2%
4	32	6.8%
3	28	5.9%
9	28	5.9%
Other values (2)	17	3.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	414	87.3%
Dash Punctuation	59	12.4%
Math Symbol	1	0.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	81	19.6%
6	54	13.0%
0	52	12.6%
5	45	10.9%
2	39	9.4%
1	39	9.4%
4	32	7.7%
3	28	6.8%
9	28	6.8%
7	16	3.9%

Dash Punctuation

Value	Count	Frequency (%)
-	59	100.0%

Math Symbol

Value	Count	Frequency (%)
~	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	474	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	81	17.1%
-	59	12.4%
6	54	11.4%
0	52	11.0%
5	45	9.5%
2	39	8.2%
1	39	8.2%
4	32	6.8%
3	28	5.9%
9	28	5.9%
Other values (2)	17	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	474	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	81	17.1%
-	59	12.4%
6	54	11.4%
0	52	11.0%
5	45	9.5%
2	39	8.2%
1	39	8.2%
4	32	6.8%
3	28	5.9%
9	28	5.9%
Other values (2)	17	3.6%

전화번호(행정실)
Text

Distinct	57
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	13
Median length	8
Mean length	8.0847458
Min length	8

Characters and Unicode

Total characters	477
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	93.2%

Sample

1st row	845-4060
2nd row	864-9262
3rd row	836-2747
4th row	858-5434
5th row	856-0393

Value	Count	Frequency (%)
863-4506	2	3.4%
863-6124	2	3.4%
826-6413	1	1.7%
859-2253	1	1.7%
866-8371	1	1.7%
070-4858-8442	1	1.7%
845-4060	1	1.7%
840-8160	1	1.7%
868-8033	1	1.7%
860-6113	1	1.7%
Other values (47)	47	79.7%

Most occurring characters

Value	Count	Frequency (%)
8	82	17.2%
-	60	12.6%
6	58	12.2%
0	49	10.3%
5	44	9.2%
4	40	8.4%
2	35	7.3%
3	34	7.1%
9	30	6.3%
1	27	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	417	87.4%
Dash Punctuation	60	12.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	82	19.7%
6	58	13.9%
0	49	11.8%
5	44	10.6%
4	40	9.6%
2	35	8.4%
3	34	8.2%
9	30	7.2%
1	27	6.5%
7	18	4.3%

Dash Punctuation

Value	Count	Frequency (%)
-	60	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	477	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	82	17.2%
-	60	12.6%
6	58	12.2%
0	49	10.3%
5	44	9.2%
4	40	8.4%
2	35	7.3%
3	34	7.1%
9	30	6.3%
1	27	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	82	17.2%
-	60	12.6%
6	58	12.2%
0	49	10.3%
5	44	9.2%
4	40	8.4%
2	35	7.3%
3	34	7.1%
9	30	6.3%
1	27	5.7%

전화번호(당직실)
Text

Distinct	58
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	14
Median length	8
Mean length	8.1016949
Min length	8

Characters and Unicode

Total characters	478
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	96.6%

Sample

1st row	845-4015
2nd row	864-9263
3rd row	836-3030
4th row	858-5435
5th row	856-0396

Value	Count	Frequency (%)
863-8066	2	3.3%
840-8161	1	1.7%
856-9772	1	1.7%
826-8454	1	1.7%
862-0203	1	1.7%
859-8426	1	1.7%
865-8298	1	1.7%
859-2547	1	1.7%
859-6213	1	1.7%
859-8894	1	1.7%
Other values (49)	49	81.7%

Most occurring characters

Value	Count	Frequency (%)
8	87	18.2%
6	66	13.8%
-	59	12.3%
5	51	10.7%
4	37	7.7%
9	36	7.5%
2	34	7.1%
0	33	6.9%
1	28	5.9%
3	27	5.6%
Other values (3)	20	4.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	417	87.2%
Dash Punctuation	59	12.3%
Other Punctuation	1	0.2%
Space Separator	1	0.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	87	20.9%
6	66	15.8%
5	51	12.2%
4	37	8.9%
9	36	8.6%
2	34	8.2%
0	33	7.9%
1	28	6.7%
3	27	6.5%
7	18	4.3%

Dash Punctuation

Value	Count	Frequency (%)
-	59	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	1	100.0%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	478	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	87	18.2%
6	66	13.8%
-	59	12.3%
5	51	10.7%
4	37	7.7%
9	36	7.5%
2	34	7.1%
0	33	6.9%
1	28	5.9%
3	27	5.6%
Other values (3)	20	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	478	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	87	18.2%
6	66	13.8%
-	59	12.3%
5	51	10.7%
4	37	7.7%
9	36	7.5%
2	34	7.1%
0	33	6.9%
1	28	5.9%
3	27	5.6%
Other values (3)	20	4.2%

팩스
Text

Distinct	57
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Length

Max length	13
Median length	8
Mean length	8.1694915
Min length	8

Characters and Unicode

Total characters	482
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	93.2%

Sample

1st row	845-4060
2nd row	864-9262
3rd row	836-3701
4th row	858-5434
5th row	856-0393

Value	Count	Frequency (%)
863-5506	2	3.4%
860-5377	2	3.4%
894-1809	1	1.7%
859-2253	1	1.7%
863-6124	1	1.7%
865-0686	1	1.7%
845-4060	1	1.7%
856-9769	1	1.7%
868-8032	1	1.7%
860-6113	1	1.7%
Other values (47)	47	79.7%

Most occurring characters

Value	Count	Frequency (%)
8	84	17.4%
-	61	12.7%
6	58	12.0%
0	50	10.4%
5	43	8.9%
3	35	7.3%
9	34	7.1%
4	33	6.8%
1	31	6.4%
2	28	5.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	421	87.3%
Dash Punctuation	61	12.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	84	20.0%
6	58	13.8%
0	50	11.9%
5	43	10.2%
3	35	8.3%
9	34	8.1%
4	33	7.8%
1	31	7.4%
2	28	6.7%
7	25	5.9%

Dash Punctuation

Value	Count	Frequency (%)
-	61	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	482	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	84	17.4%
-	61	12.7%
6	58	12.0%
0	50	10.4%
5	43	8.9%
3	35	7.3%
9	34	7.1%
4	33	6.8%
1	31	6.4%
2	28	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	84	17.4%
-	61	12.7%
6	58	12.0%
0	50	10.4%
5	43	8.9%
3	35	7.3%
9	34	7.1%
4	33	6.8%
1	31	6.4%
2	28	5.8%

데이터기준일자
Date

CONSTANT

Distinct	1
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	604.0 B

Minimum	2023-07-13 00:00:00
Maximum	2023-07-13 00:00:00

Histogram

Histogram with fixed size bins (bins=1)

Heatmap
Table

	연번	학교명	학급수(일반)	학급수(특수)	학생수	교원수(교장)	교원수(교감)	교원수(교사)	총 교원수	교장	교감	행정실장	전화번호(교장실)	전화번호(교무실)	전화번호(행정실)	전화번호(당직실)	팩스
연번	1.000	1.000	0.382	0.147	0.321	0.000	0.519	0.496	0.455	0.971	1.000	0.971	1.000	1.000	0.971	0.938	1.000
학교명	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
학급수(일반)	0.382	1.000	1.000	0.929	0.970	0.000	0.919	0.779	0.797	0.991	1.000	0.991	1.000	1.000	0.991	0.982	1.000
학급수(특수)	0.147	1.000	0.929	1.000	0.000	0.000	0.000	0.272	0.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
학생수	0.321	1.000	0.970	0.000	1.000	0.000	0.834	0.796	0.778	0.988	1.000	0.988	1.000	1.000	0.988	0.977	0.962
교원수(교장)	0.000	1.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	1.000	0.000
교원수(교감)	0.519	1.000	0.919	0.000	0.834	1.000	1.000	0.000	0.238	0.000	0.000	0.000	0.000	1.000	0.000	1.000	0.000
교원수(교사)	0.496	1.000	0.779	0.272	0.796	0.000	0.000	1.000	0.993	0.954	0.977	0.954	0.977	1.000	0.954	0.968	0.665
총 교원수	0.455	1.000	0.797	0.000	0.778	0.000	0.238	0.993	1.000	0.946	0.973	0.946	0.973	1.000	0.946	0.965	0.000
교장	0.971	1.000	0.991	1.000	0.988	0.000	0.000	0.954	0.946	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.999
교감	1.000	1.000	1.000	1.000	1.000	0.000	0.000	0.977	0.973	1.000	1.000	1.000	1.000	1.000	1.000	0.997	1.000
행정실장	0.971	1.000	0.991	1.000	0.988	0.000	0.000	0.954	0.946	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.999
전화번호(교장실)	1.000	1.000	1.000	1.000	1.000	0.000	0.000	0.977	0.973	1.000	1.000	1.000	1.000	1.000	1.000	0.997	1.000
전화번호(교무실)	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
전화번호(행정실)	0.971	1.000	0.991	1.000	0.988	0.000	0.000	0.954	0.946	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.999
전화번호(당직실)	0.938	1.000	0.982	1.000	0.977	1.000	1.000	0.968	0.965	1.000	0.997	1.000	0.997	1.000	1.000	1.000	0.992
팩스	1.000	1.000	1.000	1.000	0.962	0.000	0.000	0.665	0.000	0.999	1.000	0.999	1.000	1.000	0.999	0.992	1.000

Heatmap
Table

	교원수(교감)	교원수(교장)
교원수(교감)	1.000	0.991
교원수(교장)	0.991	1.000

Heatmap
Table

	연번	학급수(일반)	학급수(특수)	학생수	교원수(교사)	총 교원수	교원수(교장)	교원수(교감)
연번	1.000	0.316	-0.007	0.401	0.563	0.562	0.000	0.280
학급수(일반)	0.316	1.000	0.339	0.981	0.881	0.882	0.000	0.637
학급수(특수)	-0.007	0.339	1.000	0.352	0.426	0.427	0.000	0.000
학생수	0.401	0.981	0.352	1.000	0.929	0.929	0.000	0.514
교원수(교사)	0.563	0.881	0.426	0.929	1.000	1.000	0.000	0.000
총 교원수	0.562	0.882	0.427	0.929	1.000	1.000	0.000	0.126
교원수(교장)	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.991
교원수(교감)	0.280	0.637	0.000	0.514	0.000	0.126	0.991	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	연번	학교명	학급수(일반)	학급수(특수)	학생수	교원수(교장)	교원수(교감)	교원수(교사)	총 교원수	교장	교감	행정실장	전화번호(교장실)	전화번호(교무실)	전화번호(행정실)	전화번호(당직실)	팩스	데이터기준일자
0	1	송랑유치원	6	2	78	1	1	15	17	신지영	김현숙	정홍철	845-4010	845-4050	845-4060	845-4015	845-4060	2023-07-13
1	2	양주유치원	17	4	281	1	1	28	30	김희숙	박미선	최정우	864-9261	864-9260	864-9262	864-9263	864-9262	2023-07-13
2	3	가납초	17	2	390	1	1	26	28	김복선	손민경	전지선	836-3032	836-3009	836-2747	836-3030	836-3701	2023-07-13
3	4	고암초	12	1	314	1	1	19	21	홍순옥	방성배	석현태	858-5434	858-5432	858-5434	858-5435	858-5434	2023-07-13
4	5	광사초	28	1	724	1	1	38	40	정동수	한대수	서상민	856-0390	856-0391	856-0393	856-0396	856-0393	2023-07-13
5	6	광숭초	24	2	567	1	1	32	34	최일용	오태웅	김경란	856-9670	856-9674	856-9671	856-9678	856-9671	2023-07-13
6	7	남면초	9	1	171	1	1	15	17	양동용	신길동	양미영	860-5507	863-5506	863-4506	862-9074	863-5506	2023-07-13
7	8	양덕분교장	6	1	41	0	0	8	8	양동용	신길동	양미영	860-5507	866-9536	863-4506	869-5013	863-5506	2023-07-13
8	9	덕계초	20	2	474	1	1	31	33	이준숙	최승대	심보현	863-9213	864-9213	864-9215	864-9216	864-9215	2023-07-13
9	10	덕도초	6	0	50	1	1	8	10	서경희	유기영	이승현	855-1966	855-3069	855-6901	855-1069	855-7118	2023-07-13

	연번	학교명	학급수(일반)	학급수(특수)	학생수	교원수(교장)	교원수(교감)	교원수(교사)	총 교원수	교장	교감	행정실장	전화번호(교장실)	전화번호(교무실)	전화번호(행정실)	전화번호(당직실)	팩스	데이터기준일자
49	50	회천중	14	2	391	1	1	30	32	김수증	홍은기	배윤기	864-9458	864-9462	864-9460	864-9466	864-9460	2023-07-13
50	51	덕계고	24	2	691	1	1	52	54	이희승	강서경	이영표	860-2900	860-2911	260-2901	858-9695	860-5377	2023-07-13
51	52	덕정고	27	2	768	1	1	60	62	윤태련	이은영	김신숙	860-5301	860-5302	860-5303	858-6384	860-5377	2023-07-13
52	53	덕현고	34	2	994	1	1	73	75	양윤덕	윤영애	신희숙	850-2700	850-2600	850-2601	856-1268	850-2699	2023-07-13
53	54	양주고	24	1	668	1	1	53	55	김용각	전호근	이우탁	843-1201	843-1203	843-9996	843-1206	843-9996	2023-07-13
54	55	양주백석고	27	4	766	1	1	63	65	고대영	김광중	정일용	849-6701	826-6412	826-6413	826-6421	849-6719	2023-07-13
55	56	옥빛고	29	1	834	1	1	63	65	박래정	심현철	정춘우	894-1801	894-1820	894-1800	894-1894	894-1809	2023-07-13
56	57	옥정고	30	0	871	1	1	65	67	박준성	김의겸	김규식	839-1601	839-0620	866-8371	866-0666	839-0618	2023-07-13
57	58	한국외식과학고(사)	12	0	282	1	1	30	32	이희빈	석용범	공석	863-6126	863-6126	863-6124	863-8066	863-6124	2023-07-13
58	59	양주도담학교	0	30	183	1	1	63	65	박주훈	김재은	류우랑아랑	839-6210	839-6200	839-6205	839-6566	839-6298	2023-07-13

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Most occurring scripts

Most frequent character per script

Hangul

Most occurring blocks

Most frequent character per block

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Most occurring scripts

Most frequent character per script

Hangul

Most occurring blocks

Most frequent character per block

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters