1. Import údajov
Prvých 6 riadkov pôvodnej databázy
|
YEARS
|
COMPANIES
|
EXCHANGE.SECTOR
|
PRIMARY.BUSINESS
|
TOBIN.Q
|
MARKET.CAPITALIZATION
|
RETURN.ON.ASSETS
|
DEBT.TO.ASSET
|
FIRM.SIZE
|
SOCIAL.DISCLOSURE.INDEX
|
ENVIRONMENTAL.DISCLOSURE.INDEX
|
GOVERNANCE.DISCLOSURE.INDEX
|
ESG.INDEX
|
|
2013
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
NA
|
6.44
|
14.41
|
36.85
|
6.46
|
0.36
|
NA
|
0.38
|
0.25
|
|
2014
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.96
|
6.36
|
11.19
|
41.01
|
6.53
|
0.29
|
0
|
0.38
|
0.22
|
|
2015
|
Industrial & Medical Gases Nigeria
|
NA
|
Industrial Gases
|
0.75
|
6.20
|
5.74
|
34.32
|
6.51
|
0.29
|
0
|
0.38
|
0.22
|
|
NA
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.63
|
6.17
|
3.51
|
40.16
|
6.56
|
0.29
|
0
|
0.38
|
0.22
|
|
2017
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.60
|
NA
|
9.78
|
43.69
|
6.63
|
0.29
|
0
|
0.38
|
0.22
|
|
2018
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.70
|
6.24
|
13.43
|
40.72
|
6.65
|
0.29
|
0
|
0.38
|
0.22
|
2. Úprava názvov stĺpcov
Porovnanie pôvodných a skrátených názvov stĺpcov
|
Povodny_nazov
|
Skrateny_nazov
|
|
YEARS
|
YEAR
|
|
COMPANIES
|
COMP
|
|
EXCHANGE.SECTOR
|
EXCH
|
|
PRIMARY.BUSINESS
|
PRIM
|
|
TOBIN.Q
|
TOBI
|
|
MARKET.CAPITALIZATION
|
MARK
|
|
RETURN.ON.ASSETS
|
RETU
|
|
DEBT.TO.ASSET
|
DEBT
|
|
FIRM.SIZE
|
FIRM
|
|
SOCIAL.DISCLOSURE.INDEX
|
SOCI
|
|
ENVIRONMENTAL.DISCLOSURE.INDEX
|
ENVI
|
|
GOVERNANCE.DISCLOSURE.INDEX
|
GOVE
|
|
ESG.INDEX
|
ESG.
|
3. Počet chýbajúcich hodnôt pred imputáciou
Počet chýbajúcich hodnôt pred imputáciou
|
Premenna
|
Pocet_NA
|
|
YEAR
|
1
|
|
COMP
|
0
|
|
EXCH
|
1
|
|
PRIM
|
1
|
|
TOBI
|
1
|
|
MARK
|
2
|
|
RETU
|
0
|
|
DEBT
|
1
|
|
FIRM
|
1
|
|
SOCI
|
1
|
|
ENVI
|
1
|
|
GOVE
|
1
|
|
ESG.
|
0
|
4. Vzor chýbajúcich údajov
## COMP RETU ESG. YEAR EXCH PRIM TOBI DEBT FIRM SOCI ENVI GOVE MARK
## 753 1 1 1 1 1 1 1 1 1 1 1 1 1 0
## 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1
## 1 1 1 1 1 1 1 1 1 0 1 1 1 0 2
## 1 1 1 1 1 1 1 1 0 1 0 1 0 1 3
## 1 1 1 1 1 1 1 0 1 1 1 0 1 1 2
## 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1
## 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1
## 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1
## 0 0 0 1 1 1 1 1 1 1 1 1 2 11
##
## Variables sorted by number of missings:
## Variable Count
## MARK 0.002631579
## YEAR 0.001315789
## EXCH 0.001315789
## PRIM 0.001315789
## TOBI 0.001315789
## DEBT 0.001315789
## FIRM 0.001315789
## SOCI 0.001315789
## ENVI 0.001315789
## GOVE 0.001315789
## COMP 0.000000000
## RETU 0.000000000
## ESG. 0.000000000
5. Imputácia chýbajúcich údajov (metóda mice)
Prvých 6 riadkov databázy PO imputácii
|
YEAR
|
COMP
|
EXCH
|
PRIM
|
TOBI
|
MARK
|
RETU
|
DEBT
|
FIRM
|
SOCI
|
ENVI
|
GOVE
|
ESG.
|
|
2013
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
1.54
|
6.44
|
14.41
|
36.85
|
6.46
|
0.36
|
0
|
0.38
|
0.25
|
|
2014
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.96
|
6.36
|
11.19
|
41.01
|
6.53
|
0.29
|
0
|
0.38
|
0.22
|
|
2015
|
Industrial & Medical Gases Nigeria
|
NA
|
Industrial Gases
|
0.75
|
6.20
|
5.74
|
34.32
|
6.51
|
0.29
|
0
|
0.38
|
0.22
|
|
2018
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.63
|
6.17
|
3.51
|
40.16
|
6.56
|
0.29
|
0
|
0.38
|
0.22
|
|
2017
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.60
|
6.17
|
9.78
|
43.69
|
6.63
|
0.29
|
0
|
0.38
|
0.22
|
|
2018
|
Industrial & Medical Gases Nigeria
|
Natural Resources
|
Industrial Gases
|
0.70
|
6.24
|
13.43
|
40.72
|
6.65
|
0.29
|
0
|
0.38
|
0.22
|
6. Overenie — počet chýbajúcich hodnôt po imputácii
Počet chýbajúcich hodnôt po imputácii
|
Premenna
|
Pocet_NA_po
|
|
YEAR
|
0
|
|
COMP
|
0
|
|
EXCH
|
1
|
|
PRIM
|
1
|
|
TOBI
|
0
|
|
MARK
|
0
|
|
RETU
|
0
|
|
DEBT
|
0
|
|
FIRM
|
0
|
|
SOCI
|
0
|
|
ENVI
|
0
|
|
GOVE
|
0
|
|
ESG.
|
0
|
