gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	672
Missing cells	22
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	90.0 KiB
Average record size in memory	137.2 B

Variable types

Numeric	6
Text	2
Categorical	8

Dataset

Description	대전광역시 유성구 CCTV 설치 현황 상세정보 조회하는 데이터로 관리번호, 카메라대수, 설치위치 등을 제공합니다.사용좌표계: EPSG 2097
Author	대전광역시 유성구
URL	https://www.data.go.kr/data/15108945/fileData.do

Alerts

`시도코드` has constant value ""	Constant
`시도이름` has constant value ""	Constant
`시군구코드` has constant value ""	Constant
`시군구이름` has constant value ""	Constant
`기준일자` has constant value ""	Constant
`번호` is highly overall correlated with `카메라대수`	High correlation
`카메라대수` is highly overall correlated with `번호`	High correlation
`위도` is highly overall correlated with `경도` and 4 other fields	High correlation
`경도` is highly overall correlated with `위도` and 4 other fields	High correlation
`행정동코드` is highly overall correlated with `위도` and 4 other fields	High correlation
`법정동코드` is highly overall correlated with `위도` and 4 other fields	High correlation
`행정동이름` is highly overall correlated with `위도` and 4 other fields	High correlation
`법정동이름` is highly overall correlated with `위도` and 4 other fields	High correlation
`관리번호` has 19 (2.8%) missing values	Missing
`법정동코드` is highly skewed (γ1 = -25.91749745)	Skewed
`번호` has unique values	Unique

Reproduction

Analysis started	2023-12-12 03:49:01.515102
Analysis finished	2023-12-12 03:49:08.658176
Duration	7.14 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	672
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	336.5

Minimum	1
Maximum	672
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	1
5-th percentile	34.55
Q1	168.75
median	336.5
Q3	504.25
95-th percentile	638.45
Maximum	672
Range	671
Interquartile range (IQR)	335.5

Descriptive statistics

Standard deviation	194.13397
Coefficient of variation (CV)	0.57692117
Kurtosis	-1.2
Mean	336.5
Median Absolute Deviation (MAD)	168
Skewness	0
Sum	226128
Variance	37688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
452	1	0.1%
444	1	0.1%
445	1	0.1%
446	1	0.1%
447	1	0.1%
448	1	0.1%
449	1	0.1%
450	1	0.1%
451	1	0.1%
Other values (662)	662	98.5%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
672	1	0.1%
671	1	0.1%
670	1	0.1%
669	1	0.1%
668	1	0.1%
667	1	0.1%
666	1	0.1%
665	1	0.1%
664	1	0.1%
663	1	0.1%

관리번호
Text

MISSING

Distinct	653
Distinct (%)	100.0%
Missing	19
Missing (%)	2.8%
Memory size	5.4 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	3918
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	653 ?
Unique (%)	100.0%

Sample

1st row	08-001
2nd row	08-002
3rd row	08-003
4th row	08-004
5th row	08-005

Value	Count	Frequency (%)
11-042	1	0.2%
16-465	1	0.2%
16-450	1	0.2%
16-442	1	0.2%
16-444	1	0.2%
16-445	1	0.2%
16-446	1	0.2%
16-447	1	0.2%
16-448	1	0.2%
16-449	1	0.2%
Other values (643)	643	98.5%

Most occurring characters

Value	Count	Frequency (%)
1	946	24.1%
-	653	16.7%
2	340	8.7%
5	327	8.3%
3	307	7.8%
0	297	7.6%
6	277	7.1%
4	262	6.7%
9	179	4.6%
8	172	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3265	83.3%
Dash Punctuation	653	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	946	29.0%
2	340	10.4%
5	327	10.0%
3	307	9.4%
0	297	9.1%
6	277	8.5%
4	262	8.0%
9	179	5.5%
8	172	5.3%
7	158	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	653	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3918	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	946	24.1%
-	653	16.7%
2	340	8.7%
5	327	8.3%
3	307	7.8%
0	297	7.6%
6	277	7.1%
4	262	6.7%
9	179	4.6%
8	172	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3918	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	946	24.1%
-	653	16.7%
2	340	8.7%
5	327	8.3%
3	307	7.8%
0	297	7.6%
6	277	7.1%
4	262	6.7%
9	179	4.6%
8	172	4.4%

유형
Categorical

Distinct	4
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

방범용	417
도시공원놀이터	128
어린이보호구역	108
차량번호인식	19

Length

Max length	7
Median length	3
Mean length	4.4895833
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	방범용
2nd row	방범용
3rd row	방범용
4th row	방범용
5th row	방범용

Common Values

Value	Count	Frequency (%)
방범용	417	62.1%
도시공원놀이터	128	19.0%
어린이보호구역	108	16.1%
차량번호인식	19	2.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
방범용	417	62.1%
도시공원놀이터	128	19.0%
어린이보호구역	108	16.1%
차량번호인식	19	2.8%

카메라대수
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	1.0%
Missing	1
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.6065574

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.69554139
Coefficient of variation (CV)	0.43293903
Kurtosis	8.2146335
Mean	1.6065574
Median Absolute Deviation (MAD)	1
Skewness	1.8037952
Sum	1078
Variance	0.48377783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	320	47.6%
2	311	46.3%
3	30	4.5%
4	7	1.0%
6	1	0.1%
5	1	0.1%
7	1	0.1%
(Missing)	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	320	47.6%
2	311	46.3%
3	30	4.5%
4	7	1.0%
5	1	0.1%
6	1	0.1%
7	1	0.1%

Value	Count	Frequency (%)
7	1	0.1%
6	1	0.1%
5	1	0.1%
4	7	1.0%
3	30	4.5%
2	311	46.3%
1	320	47.6%

설치위치
Text

Distinct	659
Distinct (%)	98.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

Length

Max length	76
Median length	58
Mean length	32.135417
Min length	16

Characters and Unicode

Total characters	21595
Distinct characters	333
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

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

Unique

Unique	648 ?
Unique (%)	96.4%

Sample

1st row	대전광역시 유성구 구암동 598-1 유성대로 680번길 46
2nd row	대전광역시 유성구 구암동 619-1 월드컵대로 275번길 34
3rd row	대전광역시 유성구 장대동 317-5 유성대로 822번길 20
4th row	대전광역시 유성구 궁동 1-11 궁동로68
5th row	대전광역시 유성구 궁동 417-7궁동로2번길 9-2

Value	Count	Frequency (%)
대전광역시	672	18.5%
유성구	672	18.5%
장대동	45	1.2%
구암동	45	1.2%
봉명동	40	1.1%
주변	32	0.9%
지족동	30	0.8%
관평동	29	0.8%
덕명동	26	0.7%
궁동	26	0.7%
Other values (1324)	2012	55.4%

Most occurring characters

Value	Count	Frequency (%)
	3519	16.3%
대	906	4.2%
성	803	3.7%
동	789	3.7%
1	786	3.6%
구	780	3.6%
유	746	3.5%
전	722	3.3%
광	680	3.1%
시	675	3.1%
Other values (323)	11189	51.8%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	12334	57.1%
Decimal Number	4373	20.3%
Space Separator	3519	16.3%
Dash Punctuation	552	2.6%
Close Punctuation	386	1.8%
Open Punctuation	386	1.8%
Uppercase Letter	23	0.1%
Other Punctuation	18	0.1%
Math Symbol	4	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
대	906	7.3%
성	803	6.5%
동	789	6.4%
구	780	6.3%
유	746	6.0%
전	722	5.9%
광	680	5.5%
시	675	5.5%
역	673	5.5%
로	496	4.0%
Other values (293)	5064	41.1%

Uppercase Letter

Value	Count	Frequency (%)
C	6	26.1%
I	5	21.7%
G	2	8.7%
A	2	8.7%
B	2	8.7%
K	1	4.3%
U	1	4.3%
S	1	4.3%
J	1	4.3%
T	1	4.3%

Decimal Number

Value	Count	Frequency (%)
1	786	18.0%
2	529	12.1%
5	488	11.2%
3	480	11.0%
4	439	10.0%
6	397	9.1%
0	339	7.8%
8	337	7.7%
7	319	7.3%
9	259	5.9%

Other Punctuation

Value	Count	Frequency (%)
/	13	72.2%
.	4	22.2%
@	1	5.6%

Math Symbol

Value	Count	Frequency (%)
~	2	50.0%
→	2	50.0%

Space Separator

Value	Count	Frequency (%)
	3519	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	552	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	386	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	386	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	12334	57.1%
Common	9238	42.8%
Latin	23	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
대	906	7.3%
성	803	6.5%
동	789	6.4%
구	780	6.3%
유	746	6.0%
전	722	5.9%
광	680	5.5%
시	675	5.5%
역	673	5.5%
로	496	4.0%
Other values (293)	5064	41.1%

Common

Value	Count	Frequency (%)
	3519	38.1%
1	786	8.5%
-	552	6.0%
2	529	5.7%
5	488	5.3%
3	480	5.2%
4	439	4.8%
6	397	4.3%
)	386	4.2%
(	386	4.2%
Other values (9)	1276	13.8%

Latin

Value	Count	Frequency (%)
C	6	26.1%
I	5	21.7%
G	2	8.7%
A	2	8.7%
B	2	8.7%
K	1	4.3%
U	1	4.3%
S	1	4.3%
J	1	4.3%
T	1	4.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	12334	57.1%
ASCII	9259	42.9%
Arrows	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3519	38.0%
1	786	8.5%
-	552	6.0%
2	529	5.7%
5	488	5.3%
3	480	5.2%
4	439	4.7%
6	397	4.3%
)	386	4.2%
(	386	4.2%
Other values (19)	1297	14.0%

Hangul

Value	Count	Frequency (%)
대	906	7.3%
성	803	6.5%
동	789	6.4%
구	780	6.3%
유	746	6.0%
전	722	5.9%
광	680	5.5%
시	675	5.5%
역	673	5.5%
로	496	4.0%
Other values (293)	5064	41.1%

Arrows

Value	Count	Frequency (%)
→	2	100.0%

위도
Real number (ℝ)

HIGH CORRELATION

Distinct	610
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	340851.82

Minimum	328613
Maximum	347375
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	328613
5-th percentile	337255.15
Q1	338841.5
median	340505.5
Q3	342059.25
95-th percentile	346233.15
Maximum	347375
Range	18762
Interquartile range (IQR)	3217.75

Descriptive statistics

Standard deviation	2869.8199
Coefficient of variation (CV)	0.008419553
Kurtosis	0.16406897
Mean	340851.82
Median Absolute Deviation (MAD)	1631
Skewness	0.30008857
Sum	2.2905242 × 10⁸
Variance	8235866.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
343149	12	1.8%
338621	4	0.6%
344695	4	0.6%
340557	3	0.4%
337537	3	0.4%
340023	3	0.4%
338053	3	0.4%
340152	3	0.4%
340243	3	0.4%
339151	3	0.4%
Other values (600)	631	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
328613	1	0.1%
332831	1	0.1%
332849	1	0.1%
333276	1	0.1%
333662	1	0.1%
333873	1	0.1%
334150	1	0.1%
334214	1	0.1%
334372	1	0.1%
334603	1	0.1%

Value	Count	Frequency (%)
347375	1	0.1%
347235	1	0.1%
347189	1	0.1%
347148	1	0.1%
347074	1	0.1%
347011	1	0.1%
347000	1	0.1%
346998	1	0.1%
346976	1	0.1%
346914	1	0.1%

경도
Real number (ℝ)

HIGH CORRELATION

Distinct	614
Distinct (%)	91.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	418763.24

Minimum	407849
Maximum	432778
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	407849
5-th percentile	411309.55
Q1	416521.75
median	418148
Q3	421202.75
95-th percentile	426082.4
Maximum	432778
Range	24929
Interquartile range (IQR)	4681

Descriptive statistics

Standard deviation	4171.9337
Coefficient of variation (CV)	0.0099625118
Kurtosis	0.27926059
Mean	418763.24
Median Absolute Deviation (MAD)	2631.5
Skewness	0.10902689
Sum	2.8140889 × 10⁸
Variance	17405031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
420015	12	1.8%
424672	4	0.6%
417244	3	0.4%
414037	3	0.4%
421246	3	0.4%
422721	3	0.4%
417198	3	0.4%
412892	3	0.4%
420925	2	0.3%
417959	2	0.3%
Other values (604)	634	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
407849	1	0.1%
407992	1	0.1%
408302	1	0.1%
408309	1	0.1%
409054	1	0.1%
409075	1	0.1%
409116	1	0.1%
409209	1	0.1%
409432	1	0.1%
409506	1	0.1%

Value	Count	Frequency (%)
432778	1	0.1%
432682	1	0.1%
431807	1	0.1%
430561	1	0.1%
430476	1	0.1%
428681	1	0.1%
428314	1	0.1%
427608	1	0.1%
427596	1	0.1%
427539	1	0.1%

시도코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

3000000000	672

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
3000000000	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3000000000	672	100.0%

시도이름
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

대전광역시	672

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	대전광역시
2nd row	대전광역시
3rd row	대전광역시
4th row	대전광역시
5th row	대전광역시

Common Values

Value	Count	Frequency (%)
대전광역시	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
대전광역시	672	100.0%

시군구코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

3020000000	672

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
3020000000	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3020000000	672	100.0%

시군구이름
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

유성구	672

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	유성구
2nd row	유성구
3rd row	유성구
4th row	유성구
5th row	유성구

Common Values

Value	Count	Frequency (%)
유성구	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
유성구	672	100.0%

행정동코드
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	2.2%
Missing	2
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	3.0200639 × 10⁹

Minimum	3.0170586 × 10⁹
Maximum	3.023058 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	3.0170586 × 10⁹
5-th percentile	3.020052 × 10⁹
Q1	3.020053 × 10⁹
median	3.0200546 × 10⁹
Q3	3.020055 × 10⁹
95-th percentile	3.020061 × 10⁹
Maximum	3.023058 × 10⁹
Range	5999400
Interquartile range (IQR)	2000

Descriptive statistics

Standard deviation	231921.67
Coefficient of variation (CV)	7.679363 × 10^-5
Kurtosis	165.1972
Mean	3.0200639 × 10⁹
Median Absolute Deviation (MAD)	1600
Skewness	6.4150746
Sum	2.0234428 × 10¹²
Variance	5.3787662 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
3020052000	105	15.6%
3020053000	101	15.0%
3020054000	92	13.7%
3020055000	67	10.0%
3020054700	48	7.1%
3020061000	48	7.1%
3020058000	47	7.0%
3020060000	37	5.5%
3020054600	37	5.5%
3020057000	31	4.6%
Other values (5)	57	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3017058600	1	0.1%
3020052000	105	15.6%
3020052600	24	3.6%
3020052700	5	0.7%
3020053000	101	15.0%
3020054000	92	13.7%
3020054600	37	5.5%
3020054700	48	7.1%
3020054800	24	3.6%
3020055000	67	10.0%

Value	Count	Frequency (%)
3023058000	3	0.4%
3020061000	48	7.1%
3020060000	37	5.5%
3020058000	47	7.0%
3020057000	31	4.6%
3020055000	67	10.0%
3020054800	24	3.6%
3020054700	48	7.1%
3020054600	37	5.5%
3020054000	92	13.7%

행정동이름
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

진잠동	105
온천1동	101
온천2동	92
신성동	67
노은2동	48
Other values (11)	259

Length

Max length	4
Median length	4
Mean length	3.5252976
Min length	3

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	온천1동
2nd row	온천1동
3rd row	온천2동
4th row	온천2동
5th row	온천2동

Common Values

Value	Count	Frequency (%)
진잠동	105	15.6%
온천1동	101	15.0%
온천2동	92	13.7%
신성동	67	10.0%
노은2동	48	7.1%
원신흥동	48	7.1%
구즉동	47	7.0%
관평동	37	5.5%
노은1동	37	5.5%
전민동	31	4.6%
Other values (6)	59	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
진잠동	105	15.6%
온천1동	101	15.0%
온천2동	92	13.7%
신성동	67	10.0%
노은2동	48	7.1%
원신흥동	48	7.1%
구즉동	47	7.0%
관평동	37	5.5%
노은1동	37	5.5%
전민동	31	4.6%
Other values (6)	59	8.8%

법정동코드
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	48
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0200077 × 10⁹

Minimum	3.0170113 × 10⁹
Maximum	3.0200153 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	3.0170113 × 10⁹
5-th percentile	3.0200102 × 10⁹
Q1	3.0200112 × 10⁹
median	3.0200119 × 10⁹
Q3	3.0200132 × 10⁹
95-th percentile	3.0200146 × 10⁹
Maximum	3.0200153 × 10⁹
Range	3004000
Interquartile range (IQR)	2000

Descriptive statistics

Standard deviation	115769
Coefficient of variation (CV)	3.8334009 × 10^-5
Kurtosis	671.81085
Mean	3.0200077 × 10⁹
Median Absolute Deviation (MAD)	800
Skewness	-25.917497
Sum	2.0294452 × 10¹²
Variance	1.3402462 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
3020011100	50	7.4%
3020011200	48	7.1%
3020011700	43	6.4%
3020012000	31	4.6%
3020014600	29	4.3%
3020010100	28	4.2%
3020011300	27	4.0%
3020012500	26	3.9%
3020012200	26	3.9%
3020014100	24	3.6%
Other values (38)	340	50.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3017011300	1	0.1%
3020010100	28	4.2%
3020010200	12	1.8%
3020010300	10	1.5%
3020010400	9	1.3%
3020010500	13	1.9%
3020010600	16	2.4%
3020010700	2	0.3%
3020010800	4	0.6%
3020010900	7	1.0%

Value	Count	Frequency (%)
3020015300	1	0.1%
3020015000	2	0.3%
3020014900	2	0.3%
3020014800	2	0.3%
3020014700	21	3.1%
3020014600	29	4.3%
3020014500	19	2.8%
3020014400	6	0.9%
3020014300	5	0.7%
3020014200	2	0.3%

법정동이름
Categorical

HIGH CORRELATION

Distinct	48
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

봉명동	50
구암동	48
장대동	43
지족동	31
관평동	29
Other values (43)	471

Length

Max length	4
Median length	3
Mean length	2.9375
Min length	2

Unique

Unique	5 ?
Unique (%)	0.7%

Sample

1st row	구암동
2nd row	구암동
3rd row	장대동
4th row	궁동
5th row	궁동

Common Values

Value	Count	Frequency (%)
봉명동	50	7.4%
구암동	48	7.1%
장대동	43	6.4%
지족동	31	4.6%
관평동	29	4.3%
원내동	28	4.2%
덕명동	27	4.0%
신성동	26	3.9%
궁동	26	3.9%
전민동	24	3.6%
Other values (38)	340	50.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
봉명동	50	7.4%
구암동	48	7.1%
장대동	43	6.4%
지족동	31	4.6%
관평동	29	4.3%
원내동	28	4.2%
덕명동	27	4.0%
신성동	26	3.9%
궁동	26	3.9%
전민동	24	3.6%
Other values (38)	340	50.6%

기준일자
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

2022	672

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2022	672	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022	672	100.0%

Heatmap
Table

	번호	유형	카메라대수	위도	경도	행정동코드	행정동이름	법정동코드	법정동이름
번호	1.000	0.585	0.445	0.301	0.428	0.287	0.494	NaN	0.665
유형	0.585	1.000	0.362	0.216	0.227	0.090	0.273	NaN	0.560
카메라대수	0.445	0.362	1.000	0.193	0.000	0.119	0.212	NaN	0.781
위도	0.301	0.216	0.193	1.000	0.738	0.425	0.853	NaN	0.980
경도	0.428	0.227	0.000	0.738	1.000	0.566	0.899	NaN	0.976
행정동코드	0.287	0.090	0.119	0.425	0.566	1.000	1.000	NaN	0.882
행정동이름	0.494	0.273	0.212	0.853	0.899	1.000	1.000	NaN	0.984
법정동코드	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.000	NaN
법정동이름	0.665	0.560	0.781	0.980	0.976	0.882	0.984	NaN	1.000

Heatmap
Table

	행정동이름	법정동이름	유형
행정동이름	1.000	0.810	0.157
법정동이름	0.810	1.000	0.288
유형	0.157	0.288	1.000

Heatmap
Table

	번호	카메라대수	위도	경도	행정동코드	법정동코드	유형	행정동이름	법정동이름
번호	1.000	0.558	-0.154	-0.144	-0.065	-0.128	0.390	0.207	0.286
카메라대수	0.558	1.000	-0.208	-0.013	-0.137	-0.052	0.256	0.097	0.436
위도	-0.154	-0.208	1.000	0.556	0.637	0.603	0.092	0.543	0.732
경도	-0.144	-0.013	0.556	1.000	0.694	0.941	0.138	0.610	0.805
행정동코드	-0.065	-0.137	0.637	0.694	1.000	0.770	0.060	0.992	0.783
법정동코드	-0.128	-0.052	0.603	0.941	0.770	1.000	0.000	0.990	0.965
유형	0.390	0.256	0.092	0.138	0.060	0.000	1.000	0.157	0.288
행정동이름	0.207	0.097	0.543	0.610	0.992	0.990	0.157	1.000	0.810
법정동이름	0.286	0.436	0.732	0.805	0.783	0.965	0.288	0.810	1.000

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	번호	관리번호	유형	카메라대수	설치위치	위도	경도	시도코드	시도이름	시군구코드	시군구이름	행정동코드	행정동이름	법정동코드	법정동이름	기준일자
0	1	08-001	방범용	2	대전광역시 유성구 구암동 598-1 유성대로 680번길 46	340321	417224	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
1	2	08-002	방범용	1	대전광역시 유성구 구암동 619-1 월드컵대로 275번길 34	340197	416825	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
2	3	08-003	방범용	1	대전광역시 유성구 장대동 317-5 유성대로 822번길 20	340946	418419	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020011700	장대동	2022
3	4	08-004	방범용	1	대전광역시 유성구 궁동 1-11 궁동로68	342050	418340	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012200	궁동	2022
4	5	08-005	방범용	1	대전광역시 유성구 궁동 417-7궁동로2번길 9-2	341695	418073	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012200	궁동	2022
5	6	08-006	방범용	1	대전광역시 유성구 궁동 427-11대학로159번길 2	341963	417975	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012200	궁동	2022
6	7	08-007	방범용	1	대전광역시 유성구 구암동 544-23유성대로668번길 107	340549	416996	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
7	8	08-008	방범용	1	대전광역시 유성구 구암동 622-12월드컵대로253번안길 1	340003	416828	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
8	9	08-009	방범용	1	대전광역시 유성구 원내동 213-5원내로 5	338826	411257	3000000000	대전광역시	3020000000	유성구	3020052000	진잠동	3020010100	원내동	2022
9	10	08-010	방범용	2	대전광역시 유성구 궁동 458-13문화원로47번길 47	341143	418143	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012200	궁동	2022

	번호	관리번호	유형	카메라대수	설치위치	위도	경도	시도코드	시도이름	시군구코드	시군구이름	행정동코드	행정동이름	법정동코드	법정동이름	기준일자
662	667	21-667	방범용	2	대전광역시 유성구 구암동 98-6	340072	417550	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
663	668	21-668	방범용	2	대전광역시 유성구 구암동 83-3	340030	417244	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
664	669	21-669	방범용	2	대전광역시 유성구 구암동 83-3	340030	417244	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
665	670	21-670	방범용	3	대전광역시 유성구 원내동 394원내로 52	338621	409733	3000000000	대전광역시	3020000000	유성구	3020052000	진잠동	3020010100	원내동	2022
666	671	21-671	방범용	3	대전광역시 유성구 장대동 317-7유성대로822번길 332	328613	418462	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020011700	장대동	2022
667	672	21-672	방범용	2	대전광역시 유성구 구암동 595-2 유성대로680번길90주변	340343	417263	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011200	구암동	2022
668	97	11-097	도시공원놀이터	<NA>	대전광역시 유성구 어은동 108 (어은어린이공원)대학로203번길 30	342345	418192	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012300	어은동	2022
669	564	18-564	어린이보호구역	2	대전광역시 유성구 죽동 689(죽동초등학교-2)	343149	420015	3000000000	대전광역시	3020000000	유성구	3020055000	신성동	3020012600	가정동	2022
670	520	17-520	방범용	2	대전광역시 유성구 궁동 471-7 주변 대학로75번길 17주변	341244	417910	3000000000	대전광역시	3020000000	유성구	3020054000	온천2동	3020012200	궁동	2022
671	511	17-511	방범용	2	대전광역시 유성구 봉명동 544-15 (레젼드호텔앞) 계룡로141번길 14-5	341568	417148	3000000000	대전광역시	3020000000	유성구	3020053000	온천1동	3020011100	봉명동	2022

Overview

Variables

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

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Arrows

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample