Overview

Dataset statistics

Number of variables6
Number of observations28
Missing cells84
Missing cells (%)50.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory56.7 B

Variable types

Numeric1
Text2
Unsupported3

Dataset

Description순번,기업명,대표자,홈페이지,주소,전화
Author서울경제진흥원
URLhttps://data.seoul.go.kr/dataList/OA-2691/S/1/datasetView.do

Alerts

홈페이지 has 28 (100.0%) missing valuesMissing
주소 has 28 (100.0%) missing valuesMissing
전화 has 28 (100.0%) missing valuesMissing
순번 has unique valuesUnique
기업명 has unique valuesUnique
대표자 has unique valuesUnique
홈페이지 is an unsupported type, check if it needs cleaning or further analysisUnsupported
주소 is an unsupported type, check if it needs cleaning or further analysisUnsupported
전화 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-05-04 05:14:45.204144
Analysis finished2024-05-04 05:14:46.695404
Duration1.49 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.5
Minimum1
Maximum28
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-05-04T05:14:46.965174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.35
Q17.75
median14.5
Q321.25
95-th percentile26.65
Maximum28
Range27
Interquartile range (IQR)13.5

Descriptive statistics

Standard deviation8.2259751
Coefficient of variation (CV)0.56730863
Kurtosis-1.2
Mean14.5
Median Absolute Deviation (MAD)7
Skewness0
Sum406
Variance67.666667
MonotonicityStrictly decreasing
2024-05-04T05:14:47.460009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
28 1
 
3.6%
13 1
 
3.6%
1 1
 
3.6%
2 1
 
3.6%
3 1
 
3.6%
4 1
 
3.6%
5 1
 
3.6%
6 1
 
3.6%
7 1
 
3.6%
8 1
 
3.6%
Other values (18) 18
64.3%
ValueCountFrequency (%)
1 1
3.6%
2 1
3.6%
3 1
3.6%
4 1
3.6%
5 1
3.6%
6 1
3.6%
7 1
3.6%
8 1
3.6%
9 1
3.6%
10 1
3.6%
ValueCountFrequency (%)
28 1
3.6%
27 1
3.6%
26 1
3.6%
25 1
3.6%
24 1
3.6%
23 1
3.6%
22 1
3.6%
21 1
3.6%
20 1
3.6%
19 1
3.6%

기업명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-05-04T05:14:48.020752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length7.2857143
Min length4

Characters and Unicode

Total characters204
Distinct characters95
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row프로토타입
2nd row다른생각
3rd row보다컴퍼니
4th row에이치앤어소시에이츠
5th row제이큐씨컨설팅
ValueCountFrequency (%)
프로토타입 1
 
3.4%
주식회사 1
 
3.4%
주)인바이트 1
 
3.4%
주)인사이트코리아 1
 
3.4%
주)포커스컴퍼니 1
 
3.4%
주)아이디인큐 1
 
3.4%
주)서울마케팅리서치 1
 
3.4%
㈜비엔알아이 1
 
3.4%
㈜코리아리서치센터 1
 
3.4%
㈜아이앤아이마케팅 1
 
3.4%
Other values (19) 19
65.5%
2024-05-04T05:14:49.084285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 12
 
5.9%
아 8
 
3.9%
리 7
 
3.4%
주 7
 
3.4%
) 7
 
3.4%
㈜ 7
 
3.4%
( 7
 
3.4%
팅 6
 
2.9%
스 5
 
2.5%
트 4
 
2.0%
Other values (85) 134
65.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 179
87.7%
Close Punctuation 7
 
3.4%
Other Symbol 7
 
3.4%
Open Punctuation 7
 
3.4%
Uppercase Letter 3
 
1.5%
Space Separator 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 12
 
6.7%
아 8
 
4.5%
리 7
 
3.9%
주 7
 
3.9%
팅 6
 
3.4%
스 5
 
2.8%
트 4
 
2.2%
서 4
 
2.2%
마 4
 
2.2%
치 4
 
2.2%
Other values (78) 118
65.9%
Uppercase Letter
ValueCountFrequency (%)
S 1
33.3%
M 1
33.3%
C 1
33.3%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 186
91.2%
Common 15
 
7.4%
Latin 3
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 12
 
6.5%
아 8
 
4.3%
리 7
 
3.8%
주 7
 
3.8%
㈜ 7
 
3.8%
팅 6
 
3.2%
스 5
 
2.7%
트 4
 
2.2%
서 4
 
2.2%
마 4
 
2.2%
Other values (79) 122
65.6%
Common
ValueCountFrequency (%)
) 7
46.7%
( 7
46.7%
1
 
6.7%
Latin
ValueCountFrequency (%)
S 1
33.3%
M 1
33.3%
C 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 179
87.7%
ASCII 18
 
8.8%
None 7
 
3.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 12
 
6.7%
아 8
 
4.5%
리 7
 
3.9%
주 7
 
3.9%
팅 6
 
3.4%
스 5
 
2.8%
트 4
 
2.2%
서 4
 
2.2%
마 4
 
2.2%
치 4
 
2.2%
Other values (78) 118
65.9%
ASCII
ValueCountFrequency (%)
) 7
38.9%
( 7
38.9%
1
 
5.6%
S 1
 
5.6%
M 1
 
5.6%
C 1
 
5.6%
None
ValueCountFrequency (%)
㈜ 7
100.0%

대표자
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-05-04T05:14:49.652320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length3
Mean length3.0714286
Min length3

Characters and Unicode

Total characters86
Distinct characters51
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row서미진
2nd row조하림
3rd row원한수
4th row박용범
5th row서자영
ValueCountFrequency (%)
서미진 1
 
3.4%
양 1
 
3.4%
박인수 1
 
3.4%
문준열 1
 
3.4%
전진홍 1
 
3.4%
강예원 1
 
3.4%
윤주식 1
 
3.4%
박정민 1
 
3.4%
이주황 1
 
3.4%
김선휘 1
 
3.4%
Other values (19) 19
65.5%
2024-05-04T05:14:50.840451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
진 7
 
8.1%
박 4
 
4.7%
서 3
 
3.5%
조 3
 
3.5%
3
 
3.5%
원 3
 
3.5%
용 3
 
3.5%
식 3
 
3.5%
김 3
 
3.5%
영 3
 
3.5%
Other values (41) 51
59.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 83
96.5%
Space Separator 3
 
3.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
진 7
 
8.4%
박 4
 
4.8%
서 3
 
3.6%
조 3
 
3.6%
원 3
 
3.6%
용 3
 
3.6%
식 3
 
3.6%
김 3
 
3.6%
영 3
 
3.6%
이 3
 
3.6%
Other values (40) 48
57.8%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 83
96.5%
Common 3
 
3.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
진 7
 
8.4%
박 4
 
4.8%
서 3
 
3.6%
조 3
 
3.6%
원 3
 
3.6%
용 3
 
3.6%
식 3
 
3.6%
김 3
 
3.6%
영 3
 
3.6%
이 3
 
3.6%
Other values (40) 48
57.8%
Common
ValueCountFrequency (%)
3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 83
96.5%
ASCII 3
 
3.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
진 7
 
8.4%
박 4
 
4.8%
서 3
 
3.6%
조 3
 
3.6%
원 3
 
3.6%
용 3
 
3.6%
식 3
 
3.6%
김 3
 
3.6%
영 3
 
3.6%
이 3
 
3.6%
Other values (40) 48
57.8%
ASCII
ValueCountFrequency (%)
3
100.0%

홈페이지
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

전화
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

Interactions

2024-05-04T05:14:45.632190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-04T05:14:51.165564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번기업명대표자
순번1.0001.0001.000
기업명1.0001.0001.000
대표자1.0001.0001.000

Missing values

2024-05-04T05:14:46.062284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-04T05:14:46.518369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

순번기업명대표자홈페이지주소전화
028프로토타입서미진<NA><NA><NA>
127다른생각조하림<NA><NA><NA>
226보다컴퍼니원한수<NA><NA><NA>
325에이치앤어소시에이츠박용범<NA><NA><NA>
424제이큐씨컨설팅서자영<NA><NA><NA>
523클론컨설팅이상훈<NA><NA><NA>
622스트래티직마케팅(SMC)윤용로<NA><NA><NA>
721이그나잇스파크최환진<NA><NA><NA>
820비전아레나조용호<NA><NA><NA>
919로아컨설팅김진영<NA><NA><NA>
순번기업명대표자홈페이지주소전화
1810㈜리서치테라남영식<NA><NA><NA>
199㈜아이앤아이마케팅김선휘<NA><NA><NA>
208㈜코리아리서치센터이주황<NA><NA><NA>
217㈜비엔알아이박정민<NA><NA><NA>
226(주)서울마케팅리서치윤주식<NA><NA><NA>
235(주)아이디인큐강예원<NA><NA><NA>
244(주)포커스컴퍼니전진홍<NA><NA><NA>
253(주)인사이트코리아문준열<NA><NA><NA>
262(주)인바이트박인수<NA><NA><NA>
271(주)트루이스이훈행<NA><NA><NA>