Overview

Dataset statistics

Number of variables23
Number of observations52
Missing cells19
Missing cells (%)1.6%
Total size in memory9.5 KiB
Average record size in memory186.5 B

Variable types

Unsupported14
Categorical9

Warnings

Unnamed: 3 has a high cardinality: 51 distinct values High cardinality
Unnamed: 4 has a high cardinality: 51 distinct values High cardinality
대한민국 2018년 매출 상위 500대 기업 (단위 : 백만 원) has 1 (1.9%) missing values Missing
Unnamed: 1 has 1 (1.9%) missing values Missing
Unnamed: 2 has 1 (1.9%) missing values Missing
Unnamed: 3 has 1 (1.9%) missing values Missing
Unnamed: 4 has 1 (1.9%) missing values Missing
Unnamed: 5 has 1 (1.9%) missing values Missing
Unnamed: 6 has 1 (1.9%) missing values Missing
Unnamed: 8 has 1 (1.9%) missing values Missing
Unnamed: 9 has 1 (1.9%) missing values Missing
Unnamed: 11 has 1 (1.9%) missing values Missing
Unnamed: 12 has 1 (1.9%) missing values Missing
Unnamed: 14 has 1 (1.9%) missing values Missing
Unnamed: 15 has 1 (1.9%) missing values Missing
Unnamed: 16 has 1 (1.9%) missing values Missing
Unnamed: 17 has 1 (1.9%) missing values Missing
Unnamed: 19 has 1 (1.9%) missing values Missing
Unnamed: 20 has 1 (1.9%) missing values Missing
Unnamed: 21 has 1 (1.9%) missing values Missing
Unnamed: 22 has 1 (1.9%) missing values Missing
대한민국 2018년 매출 상위 500대 기업 (단위 : 백만 원) is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysis Unsupported

Reproduction

Analysis started2022-06-15 05:14:01.239410
Analysis finished2022-06-15 05:14:01.313475
Duration0.07 seconds
Software versionpandas-profiling v3.0.0
Download configurationconfig.json

Variables

대한민국 2018년 매출 상위 500대 기업 (단위 : 백만 원)
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 1
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 2
Categorical

MISSING

Distinct23
Distinct (%)45.1%
Missing1
Missing (%)1.9%
Memory size544.0 B
-
7 
▲ 4
6 
▼ 2
5 
▼ 3
4 
▲ 1
3 
Other values (18)
26 

Unique

Unique11 ?
Unique (%)21.6%

Sample

1st row변동
2nd row-
3rd row-
4th row▲ 1
5th row▼ 1

Common Values

ValueCountFrequency (%)
-7
13.5%
▲ 46
 
11.5%
▼ 25
 
9.6%
▼ 34
 
7.7%
▲ 13
 
5.8%
▲ 53
 
5.8%
▼ 42
 
3.8%
▲ 22
 
3.8%
▼ 52
 
3.8%
▼ 92
 
3.8%
Other values (13)15
28.8%

Unnamed: 3
Categorical

HIGH CARDINALITY
MISSING

Distinct51
Distinct (%)100.0%
Missing1
Missing (%)1.9%
Memory size544.0 B
기업명
 
1
한국산업은행
 
1
우리은행
 
1
신한은행
 
1
CJ제일제당
 
1
Other values (46)
46 

Unique

Unique51 ?
Unique (%)100.0%

Sample

1st row기업명
2nd row삼성전자
3rd row현대자동차
4th row포스코
5th rowLG전자

Common Values

ValueCountFrequency (%)
기업명1
 
1.9%
한국산업은행1
 
1.9%
우리은행1
 
1.9%
신한은행1
 
1.9%
CJ제일제당1
 
1.9%
두산1
 
1.9%
국민은행1
 
1.9%
한국토지주택공사1
 
1.9%
롯데쇼핑1
 
1.9%
DB손해보험1
 
1.9%
Other values (41)41
78.8%

Unnamed: 4
Categorical

HIGH CARDINALITY
MISSING

Distinct51
Distinct (%)100.0%
Missing1
Missing (%)1.9%
Memory size544.0 B
법인 등록번호
 
1
110135-0000937
 
1
110111-0023393
 
1
110111-0012809
 
1
110111-3748253
 
1
Other values (46)
46 

Unique

Unique51 ?
Unique (%)100.0%

Sample

1st row법인 등록번호
2nd row130111-0006246
3rd row110111-0085450
4th row174611-0000741
5th row110111-2487050

Common Values

ValueCountFrequency (%)
법인 등록번호1
 
1.9%
110135-00009371
 
1.9%
110111-00233931
 
1.9%
110111-00128091
 
1.9%
110111-37482531
 
1.9%
110111-00137741
 
1.9%
110111-23653211
 
1.9%
135671-00333551
 
1.9%
110111-00000861
 
1.9%
110111-00952851
 
1.9%
Other values (41)41
78.8%

Unnamed: 5
Categorical

MISSING

Distinct50
Distinct (%)98.0%
Missing1
Missing (%)1.9%
Memory size544.0 B
2011.01.01
 
2
1984.04.20
 
1
1954.04.01
 
1
1899.01.30
 
1
1897.02.19
 
1
Other values (45)
45 

Unique

Unique49 ?
Unique (%)96.1%

Sample

1st row설립일
2nd row1969.01.13
3rd row1967.12.29
4th row1968.03.25
5th row2002.04.01

Common Values

ValueCountFrequency (%)
2011.01.012
 
3.8%
1984.04.201
 
1.9%
1954.04.011
 
1.9%
1899.01.301
 
1.9%
1897.02.191
 
1.9%
2007.09.011
 
1.9%
1933.12.181
 
1.9%
2001.11.011
 
1.9%
2009.10.011
 
1.9%
1970.07.021
 
1.9%
Other values (40)40
76.9%

Unnamed: 6
Categorical

MISSING

Distinct16
Distinct (%)31.4%
Missing1
Missing (%)1.9%
Memory size544.0 B
석유화학
8 
보험
6 
은행
6 
IT전기전자
5 
조선.기계.설비
3 
Other values (11)
23 

Unique

Unique3 ?
Unique (%)5.9%

Sample

1st row업종
2nd rowIT전기전자
3rd row자동차.부품
4th row철강
5th rowIT전기전자

Common Values

ValueCountFrequency (%)
석유화학8
15.4%
보험6
11.5%
은행6
11.5%
IT전기전자5
9.6%
조선.기계.설비3
 
5.8%
자동차.부품3
 
5.8%
공기업3
 
5.8%
상사3
 
5.8%
건설 및 건자재3
 
5.8%
철강2
 
3.8%
Other values (6)9
17.3%

Unnamed: 7
Unsupported

REJECTED
UNSUPPORTED

Missing0
Missing (%)0.0%
Memory size544.0 B

Unnamed: 8
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 9
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 10
Unsupported

REJECTED
UNSUPPORTED

Missing0
Missing (%)0.0%
Memory size544.0 B

Unnamed: 11
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 12
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 13
Categorical

Distinct3
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size544.0 B
연결
50 
2018년
 
1
기준
 
1

Unique

Unique2 ?
Unique (%)3.8%

Sample

1st row2018년
2nd row기준
3rd row연결
4th row연결
5th row연결

Common Values

ValueCountFrequency (%)
연결50
96.2%
2018년1
 
1.9%
기준1
 
1.9%

Unnamed: 14
Categorical

MISSING

Distinct2
Distinct (%)3.9%
Missing1
Missing (%)1.9%
Memory size544.0 B
2018/12
50 
결산 연월
 
1

Unique

Unique1 ?
Unique (%)2.0%

Sample

1st row결산 연월
2nd row2018/12
3rd row2018/12
4th row2018/12
5th row2018/12

Common Values

ValueCountFrequency (%)
2018/1250
96.2%
결산 연월1
 
1.9%
(Missing)1
 
1.9%

Unnamed: 15
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 16
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 17
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 18
Categorical

Distinct3
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size544.0 B
연결
50 
2017년
 
1
기준
 
1

Unique

Unique2 ?
Unique (%)3.8%

Sample

1st row2017년
2nd row기준
3rd row연결
4th row연결
5th row연결

Common Values

ValueCountFrequency (%)
연결50
96.2%
2017년1
 
1.9%
기준1
 
1.9%

Unnamed: 19
Categorical

MISSING

Distinct2
Distinct (%)3.9%
Missing1
Missing (%)1.9%
Memory size544.0 B
2017/12
50 
결산 연월
 
1

Unique

Unique1 ?
Unique (%)2.0%

Sample

1st row결산 연월
2nd row2017/12
3rd row2017/12
4th row2017/12
5th row2017/12

Common Values

ValueCountFrequency (%)
2017/1250
96.2%
결산 연월1
 
1.9%
(Missing)1
 
1.9%

Unnamed: 20
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 21
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B

Unnamed: 22
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1
Missing (%)1.9%
Memory size544.0 B