Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells8
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory742.2 KiB
Average record size in memory76.0 B

Variable types

DateTime1
Categorical6
Numeric1

Dataset

Description성남시 전통시장/발달상권/골목상권별 이용고객과 관련된 소비 비중정보현황에 대한 데이터로, 기준년월, 대분류업종, 준분류업종, 소속구역 명 등의 항목을 제공합니다.
Author경기도 성남시
URLhttps://www.data.go.kr/data/15098569/fileData.do

Alerts

소속구역명 is highly overall correlated with 상권구분코드(전통시장 1 발달상권 2 골목상권 3)High correlation
대분류업종명 is highly overall correlated with 준분류업종명High correlation
상권구분코드(전통시장 1 발달상권 2 골목상권 3) is highly overall correlated with 소속구역명High correlation
준분류업종명 is highly overall correlated with 대분류업종명High correlation
비중값 has 1137 (11.4%) zerosZeros

Reproduction

Analysis started2023-12-12 02:57:21.773133
Analysis finished2023-12-12 02:57:23.159767
Duration1.39 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년월
Date

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-10-01 00:00:00
2023-12-12T11:57:23.226203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:57:23.341937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)

상권구분코드(전통시장 1 발달상권 2 골목상권 3)
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
5170 
3
2820 
2
2010 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row3
3rd row2
4th row1
5th row3

Common Values

ValueCountFrequency (%)
1 5170
51.7%
3 2820
28.2%
2 2010
 
20.1%

Length

2023-12-12T11:57:23.490029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:57:23.615901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 5170
51.7%
3 2820
28.2%
2 2010
 
20.1%

소속구역명
Categorical

HIGH CORRELATION 

Distinct33
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
서현역로데오 상권
 
361
수내역로데오 상권
 
360
모란오거리 상권
 
358
서현 전통상권
 
355
정자동 상권
 
350
Other values (28)
8216 

Length

Max length11
Median length10
Mean length7.1671
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수내역로데오 상권
2nd row수내 전통상권
3rd row태평역상권
4th row신흥동 상권
5th row중앙동상권

Common Values

ValueCountFrequency (%)
서현역로데오 상권 361
 
3.6%
수내역로데오 상권 360
 
3.6%
모란오거리 상권 358
 
3.6%
서현 전통상권 355
 
3.5%
정자동 상권 350
 
3.5%
오리역 상권 349
 
3.5%
단대시장 상권 347
 
3.5%
야탑 먹자골목 346
 
3.5%
미금현대벤처빌 상권 344
 
3.4%
수진역-신흥역 상권 343
 
3.4%
Other values (23) 6487
64.9%

Length

2023-12-12T11:57:23.780470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
상권 6783
35.7%
전통상권 676
 
3.6%
정자동 661
 
3.5%
먹자골목 657
 
3.5%
서현역로데오 361
 
1.9%
수내역로데오 360
 
1.9%
모란오거리 358
 
1.9%
서현 355
 
1.9%
오리역 349
 
1.8%
단대시장 347
 
1.8%
Other values (28) 8103
42.6%

대분류업종명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
소매/유통
3860 
음식
3720 
생활서비스
1576 
여가/오락
844 

Length

Max length5
Median length5
Mean length3.884
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활서비스
2nd row소매/유통
3rd row여가/오락
4th row음식
5th row음식

Common Values

ValueCountFrequency (%)
소매/유통 3860
38.6%
음식 3720
37.2%
생활서비스 1576
15.8%
여가/오락 844
 
8.4%

Length

2023-12-12T11:57:23.922915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:57:24.041342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소매/유통 3860
38.6%
음식 3720
37.2%
생활서비스 1576
15.8%
여가/오락 844
 
8.4%

준분류업종명
Categorical

HIGH CORRELATION 

Distinct38
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
분식
 
357
종합소매점
 
353
음/식료품소매
 
347
의복/의류
 
345
제과/제빵/떡/케익
 
345
Other values (33)
8253 

Length

Max length10
Median length8
Mean length5.281
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세탁/가사서비스
2nd row서적/도서
3rd row취미/오락
4th row커피/음료
5th row고기요리

Common Values

ValueCountFrequency (%)
분식 357
 
3.6%
종합소매점 353
 
3.5%
음/식료품소매 347
 
3.5%
의복/의류 345
 
3.5%
제과/제빵/떡/케익 345
 
3.5%
한식 341
 
3.4%
닭/오리요리 338
 
3.4%
일반스포츠 338
 
3.4%
중식 333
 
3.3%
커피/음료 332
 
3.3%
Other values (28) 6571
65.7%

Length

2023-12-12T11:57:24.203229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
분식 357
 
3.6%
종합소매점 353
 
3.5%
음/식료품소매 347
 
3.5%
의복/의류 345
 
3.5%
제과/제빵/떡/케익 345
 
3.5%
한식 341
 
3.4%
닭/오리요리 338
 
3.4%
일반스포츠 338
 
3.4%
중식 333
 
3.3%
커피/음료 332
 
3.3%
Other values (28) 6571
65.7%

성별(남 1 여 2)
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
5031 
2
4969 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2
2nd row1
3rd row1
4th row2
5th row2

Common Values

ValueCountFrequency (%)
1 5031
50.3%
2 4969
49.7%

Length

2023-12-12T11:57:24.374998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:57:24.500135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 5031
50.3%
2 4969
49.7%

나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
5
2047 
1
2036 
3
1989 
4
1988 
2
1940 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5
2nd row4
3rd row3
4th row3
5th row2

Common Values

ValueCountFrequency (%)
5 2047
20.5%
1 2036
20.4%
3 1989
19.9%
4 1988
19.9%
2 1940
19.4%

Length

2023-12-12T11:57:24.633599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:57:24.777442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5 2047
20.5%
1 2036
20.4%
3 1989
19.9%
4 1988
19.9%
2 1940
19.4%

비중값
Real number (ℝ)

ZEROS 

Distinct7040
Distinct (%)70.5%
Missing8
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean0.099742064
Minimum0
Maximum1
Zeros1137
Zeros (%)11.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T11:57:24.969433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.0331975
median0.080265
Q30.14102
95-th percentile0.2590745
Maximum1
Range1
Interquartile range (IQR)0.1078225

Descriptive statistics

Standard deviation0.097533649
Coefficient of variation (CV)0.97785874
Kurtosis15.658379
Mean0.099742064
Median Absolute Deviation (MAD)0.05226
Skewness2.7564818
Sum996.6227
Variance0.0095128127
MonotonicityNot monotonic
2023-12-12T11:57:25.178813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 1137
 
11.4%
0.25 32
 
0.3%
0.16667 31
 
0.3%
0.33333 27
 
0.3%
0.5 26
 
0.3%
0.125 19
 
0.2%
0.2 19
 
0.2%
0.1 19
 
0.2%
0.14286 17
 
0.2%
1.0 16
 
0.2%
Other values (7030) 8649
86.5%
ValueCountFrequency (%)
0.0 1137
11.4%
0.00011 1
 
< 0.1%
0.00032 1
 
< 0.1%
0.0004 1
 
< 0.1%
0.00056 1
 
< 0.1%
0.00065 2
 
< 0.1%
0.00068 1
 
< 0.1%
0.00101 1
 
< 0.1%
0.00102 1
 
< 0.1%
0.00109 1
 
< 0.1%
ValueCountFrequency (%)
1.0 16
0.2%
0.82431 1
 
< 0.1%
0.8 1
 
< 0.1%
0.75 4
 
< 0.1%
0.72727 1
 
< 0.1%
0.70404 1
 
< 0.1%
0.67532 1
 
< 0.1%
0.66667 4
 
< 0.1%
0.65625 1
 
< 0.1%
0.64286 1
 
< 0.1%

Interactions

2023-12-12T11:57:22.696978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:57:25.325213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년월상권구분코드(전통시장 1 발달상권 2 골목상권 3)소속구역명대분류업종명준분류업종명성별(남 1 여 2)나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)비중값
기준년월1.0000.0000.0000.0000.0000.0000.0000.047
상권구분코드(전통시장 1 발달상권 2 골목상권 3)0.0001.0001.0000.0340.2260.0000.0040.029
소속구역명0.0001.0001.0000.1570.3790.0000.0000.140
대분류업종명0.0000.0340.1571.0001.0000.0000.0000.160
준분류업종명0.0000.2260.3791.0001.0000.0000.0000.243
성별(남 1 여 2)0.0000.0000.0000.0000.0001.0000.0070.116
나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)0.0000.0040.0000.0000.0000.0071.0000.489
비중값0.0470.0290.1400.1600.2430.1160.4891.000
2023-12-12T11:57:25.491985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소속구역명대분류업종명나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)성별(남 1 여 2)상권구분코드(전통시장 1 발달상권 2 골목상권 3)준분류업종명
소속구역명1.0000.0810.0000.0000.9980.087
대분류업종명0.0811.0000.0000.0000.0320.998
나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)0.0000.0001.0000.0090.0030.000
성별(남 1 여 2)0.0000.0000.0091.0000.0000.000
상권구분코드(전통시장 1 발달상권 2 골목상권 3)0.9980.0320.0030.0001.0000.114
준분류업종명0.0870.9980.0000.0000.1141.000
2023-12-12T11:57:25.642665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비중값상권구분코드(전통시장 1 발달상권 2 골목상권 3)소속구역명대분류업종명준분류업종명성별(남 1 여 2)나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)
비중값1.0000.0190.0490.0960.0860.0860.223
상권구분코드(전통시장 1 발달상권 2 골목상권 3)0.0191.0000.9980.0320.1140.0000.003
소속구역명0.0490.9981.0000.0810.0870.0000.000
대분류업종명0.0960.0320.0811.0000.9980.0000.000
준분류업종명0.0860.1140.0870.9981.0000.0000.000
성별(남 1 여 2)0.0860.0000.0000.0000.0001.0000.009
나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)0.2230.0030.0000.0000.0000.0091.000

Missing values

2023-12-12T11:57:22.871453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:57:23.056415image/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

기준년월상권구분코드(전통시장 1 발달상권 2 골목상권 3)소속구역명대분류업종명준분류업종명성별(남 1 여 2)나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)비중값
921992021-05-011수내역로데오 상권생활서비스세탁/가사서비스250.04549
372272021-05-013수내 전통상권소매/유통서적/도서140.18559
257372021-01-012태평역상권여가/오락취미/오락130.0
677882021-02-011신흥동 상권음식커피/음료230.15394
664512021-08-013중앙동상권음식고기요리220.05863
98812021-08-013중앙동상권음식커피/음료120.14247
8072021-05-011판교테크노밸리음식커피/음료110.05846
422042021-02-012금광1동 상권소매/유통의복/의류150.0
578712021-08-011모란상권 진흥구역생활서비스수의업220.5
840042021-02-011판교역로 상권음식일식/수산물240.04145
기준년월상권구분코드(전통시장 1 발달상권 2 골목상권 3)소속구역명대분류업종명준분류업종명성별(남 1 여 2)나이(20대 1 30대 2 40대 3 50대 4 60대이상 5)비중값
735192021-08-011야탑역 상권생활서비스수리서비스230.12171
483182021-06-012금광2동 상권소매/유통사무/교육용품210.0
653732021-02-011수내역로데오 상권여가/오락일반스포츠220.03972
142792021-09-013단대시장 상권음식고기요리120.12037
877132021-07-011복정상권여가/오락일반스포츠250.03529
822102021-04-012상대원3동 상권음식패스트푸드240.1
311812021-10-012정자동 상권음식일식/수산물140.16105
942772021-07-011정자1동 카페거리소매/유통선물/완구250.01819
751722021-06-011모란오거리 상권음식별식/퓨전요리230.1133
896162021-02-013서현 전통상권소매/유통가전제품250.11872