# # Work Package 2: Textual Analysis # #

Read in data, turn into a df

aif_corpus <- corpus(text_df, text_field = "text",  docvars = c("num", "type", "company", "date"))
aif_tok <- tokens(aif_corpus,
                      remove_numbers = TRUE,
                      split_hyphens = TRUE,
                      remove_punct = TRUE,
                      remove_symbols = TRUE,
                      remove_separators = TRUE,
                      remove_url = TRUE) %>%
                 tokens_tolower() %>%
                 tokens_remove(c(stopwords("english"),
                               "may", "shall", "can", "company",
                               "must", "upon", "with", "without",
                               "form", "k", "*.htm", "htm", "d.c",
                               "total", "table", "million",
                               "corporation", "billion", "lavalin")) %>%
                 tokens_select(min_nchar = 3)
aif_dfm_bigram <- tokens_subset(aif_tok) %>%
  tokens_ngrams(n = 2) %>%
  dfm(stem = TRUE, select = c("*risk*")) %>% 
  dfm_trim(min_termfreq = 3, min_docfreq = 2)
aif_top_bigram <- topfeatures(aif_dfm_bigram, 50)
aif_top_bigrams_names <- as.vector(names(aif_top_bigram))
aif_top_bigram_freq <- as.vector(aif_top_bigram)
aif_top_df_bigrams <- data.frame(aif_top_bigrams_names, aif_top_bigram_freq)
bigram_hist <- ggplot(aif_top_df_bigrams, aes(x=reorder(aif_top_bigrams_names,
                                                -aif_top_bigram_freq), y=aif_top_bigram_freq))
bigram_hist <- bigram_hist+geom_bar(stat="identity", fill="darkred")+
  theme(axis.text.x = element_text(angle = 90, hjust = 1, vjust = 0.5))
bigram_hist <- bigram_hist+ggtitle("Top 50 bigrams in the sample")
bigram_hist <- bigram_hist+xlab("bigrams")
bigram_hist <- bigram_hist+ylab("frequency")
bigram_hist

kwic_aif <- kwic(aif_corpus, "risk", window = 3, valuetype = "glob", case_insensitive = T)
head(kwic_aif, n = 50)
##                                                      
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 1561]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 6985]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 7057]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 7114]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 7125]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 7180]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 7202]
##   [800558_AIF_SNC-LavalinGroupInc_18052001.pdf, 8354]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 1810]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8047]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8109]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8143]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8157]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8331]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8342]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8400]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 8423]
##   [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 9350]
##  [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 11509]
##  [800559_AIF_SNC-LavalinGroupInc_16052002.pdf, 11749]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 1430]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 2240]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7232]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7275]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7310]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7325]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7374]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7396]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7463]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7650]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7680]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7718]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7843]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 7917]
##   [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 9401]
##  [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 10886]
##  [800560_AIF_SNC-LavalinGroupInc_16052003.pdf, 11178]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 1291]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 6445]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 6463]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 6477]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 7383]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 9325]
##   [800561_AIF_SNC-LavalinGroupInc_19052004.pdf, 9633]
##   [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 1155]
##   [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 6479]
##   [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 7626]
##   [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 7646]
##   [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 7660]
##  [800562_AIF_SNC-LavalinGroupInc_31032005.pdf, 11830]
##                                                                        
##                      . 8 4.5 | RISK | MANAGEMENT..                     
##               reference. 4.5 | RISK | MANAGEMENT SNC-                  
##         and applies rigorous | risk | mitigation and management        
##          commitment to sound | risk | management practices when        
##         , includes technical | risk | assessment, rigorous             
##         guarantees and other | risk | mitigating measures.             
##               element in the | risk | management process.              
##           subject to minimal | risk | of changes in                    
##                      . 9 4.5 | RISK | MANAGEMENT..                     
##               reference. 4.5 | RISK | MANAGEMENT SNC-Lavalin's business
##         and applies rigorous | risk | mitigation and management        
##           the following main | risk | factors: Cost                    
##               portion of the | risk | for cost overruns                
##          commitment to sound | risk | management practices when        
##         , includes technical | risk | assessment, rigorous             
##         guarantees and other | risk | mitigating measures.             
##               element in the | risk | management process of            
##           subject to minimal | risk | of changes in                    
##             General Manager, | Risk | and Insurance Saint-Lambert      
##                and Chairman, | Risk | Evaluation Committee Ahuntsic    
##                      . 9 4.5 | RISK | MANAGEMENT..                     
##          11 Foreign currency | risk | ...                              
##               reference. 4.5 | RISK | MANAGEMENT SNC-Lavalin's business
##         and applies rigorous | risk | assessment, mitigation           
##          commitment to sound | risk | management practices when        
##         , includes technical | risk | assessment, rigorous             
##         guarantees and other | risk | mitigating measures.             
##         -9- in SNC-Lavalin's | risk | management process.              
##               portion of the | risk | for cost overruns                
##                 to limit its | risk | to the amount                    
##                   level. The | risk | of erosion of                    
##           mitigated by sound | risk | management practices when        
##                       , is a | risk | factor for which                 
##           . Foreign currency | risk | Its significant international    
##             . Factoring such | risk | into the discounted              
##             General Manager, | Risk | and Insurance Saint-Lambert      
##                and Chairman, | Risk | Evaluation Committee Ahuntsic    
##                     . 11 4.5 | RISK | MANAGEMENT..                     
##               reference. 4.5 | RISK | MANAGEMENT A discussion          
##            of SNC- Lavalin's | risk | management practices is          
##                and Analysis- | Risk | Management",                     
##             . Factoring such | risk | into the discounted              
##             General Manager, | Risk | and Saint-Lambert,               
##  Malkhassian Vice-President, | Risk | Evaluation Committee Montreal    
##                     . 10 4.4 | RISK | FACTORS..                        
##                 to share the | risk | of refurbishing and              
##                      10- 4.4 | RISK | FACTORS A discussion             
##          as of SNC-Lavalin's | risk | management practices is          
##                and Analysis- | Risk | Management",                     
##               such policies; | Risk | and Uncertainty(
aif_dic_bigrams <- list(
  financial_risk = c("busi_risk", "manag_risk", "risk_insur", "insur_risk", "risk_financi", "financi_risk",  "project_risk", "market_risk","risk_materi", "risk_compani", "credit_risk", "strateg_risk", "materi_risk", "econom_risk", "risk_opportun"),
  societal_risk = c("environment_risk", "subject_risk", "inform_risk", "hazard_risk", "polit_risk", "regulatori_risk", "regulatori_risk"))
aif_dic_bigrams
## $financial_risk
##  [1] "busi_risk"     "manag_risk"    "risk_insur"    "insur_risk"   
##  [5] "risk_financi"  "financi_risk"  "project_risk"  "market_risk"  
##  [9] "risk_materi"   "risk_compani"  "credit_risk"   "strateg_risk" 
## [13] "materi_risk"   "econom_risk"   "risk_opportun"
## 
## $societal_risk
## [1] "environment_risk" "subject_risk"     "inform_risk"      "hazard_risk"     
## [5] "polit_risk"       "regulatori_risk"  "regulatori_risk"
library(keyATM)
keyATM_aif_bigram <- keyATM_read(aif_dfm_bigram)
summary(keyATM_aif_bigram)
## keyATM_docs object of: 78 documents.
## Length of documents:
##   Avg: 167.282
##   Min: 12
##   Max: 623
##    SD: 167.42
## Number of unique words: 662

KeyATM using LDA identified 2 predefined topics and 2 topics without keywords

out_bigrams_base <- keyATM(docs      = keyATM_aif_bigram,    # text input
              no_keyword_topics = 2,                 # number of topics without keywords
              keywords          = aif_dic_bigrams,       # keywords
              model             = "base",            # select the model
              options           = list(seed = 250))
top_words(out_bigrams_base)
##    1_financial_risk      2_societal_risk      Other_1          Other_2
## 1        risk_manag          risk_factor    risk_aris risk_uncertainti
## 2   credit_risk [✓]     risk_uncertainti    risk_also      risk_factor
## 3         risk_risk           risk_manag   model_risk       risk_manag
## 4       risk_review          risk_associ  liquid_risk      risk_assess
## 5        risk_relat environment_risk [✓]    oper_risk    risk_committe
## 6       risk_factor        busi_risk [1]  risk_advers       price_risk
## 7         risk_base      inform_risk [✓] increas_risk     section_risk
## 8    manag_risk [✓]            oper_risk  risk_result     discuss_risk
## 9   market_risk [✓]     financi_risk [1]  longev_risk       risk_chang
## 10   risk_insur [✓]           regul_risk   estat_risk      risk_associ
top_docs(out_bigrams_base)
##    1_financial_risk 2_societal_risk Other_1 Other_2
## 1                26              47      40      12
## 2                27              45      41      11
## 3                25              48      39       6
## 4                28              67      38       5
## 5                24              46      37       9
## 6                22              68      36      10
## 7                23              49      35      13
## 8                29              44      34       8
## 9                30              51      33      15
## 10               31              65      30      16

The frequency of bigrams by topic

key_viz <- visualize_keywords(docs = keyATM_aif_bigram, keywords = aif_dic_bigrams)
key_viz

The figure helps check the frequency of keywords. Proportion is defined as a number of times a keyword occurs in the corpus divided by the total length of documents. This measures the frequency of the keyword in the corpus.

values_fig(key_viz)
## # A tibble: 22 x 5
## # Groups:   Topic [2]
##    Word         WordCount `Proportion(%)` Ranking Topic           
##    <chr>            <int>           <dbl>   <int> <fct>           
##  1 credit_risk        277           2.12        1 1_financial_risk
##  2 busi_risk          129           0.989       2 1_financial_risk
##  3 manag_risk         111           0.851       3 1_financial_risk
##  4 market_risk         97           0.743       4 1_financial_risk
##  5 risk_insur          90           0.69        5 1_financial_risk
##  6 financi_risk        81           0.621       6 1_financial_risk
##  7 insur_risk          76           0.582       7 1_financial_risk
##  8 risk_financi        63           0.483       8 1_financial_risk
##  9 project_risk        59           0.452       9 1_financial_risk
## 10 econom_risk         34           0.261      10 1_financial_risk
## # … with 12 more rows

Top Bigrams and Top Docs

out_bigrams_base$theta  # Document-topic distribution
##       1_financial_risk 2_societal_risk      Other_1      Other_2
##  [1,]       0.31180602     0.058271247 0.0021459677 0.6277767610
##  [2,]       0.40928367     0.014606878 0.0018420071 0.5742674444
##  [3,]       0.30817482     0.135742788 0.0011011502 0.5549812458
##  [4,]       0.19507602     0.077439343 0.0028518753 0.7246327602
##  [5,]       0.15999052     0.018547570 0.0023389498 0.8191229577
##  [6,]       0.15772388     0.011705405 0.0014761154 0.8290946040
##  [7,]       0.17893437     0.057113994 0.0012314944 0.7627201406
##  [8,]       0.15526017     0.057113994 0.0012314944 0.7863943417
##  [9,]       0.15349695     0.028685971 0.0010564244 0.8167606570
## [10,]       0.16074735     0.026530754 0.0009770538 0.8117448370
## [11,]       0.11287962     0.028685971 0.0010564244 0.8573779805
## [12,]       0.08895774     0.027566302 0.0010151901 0.8824607711
## [13,]       0.08027434     0.121497550 0.0007512761 0.7974768367
## [14,]       0.26615978     0.044180426 0.0006734641 0.6889863306
## [15,]       0.17783562     0.044759916 0.0006822975 0.7767221630
## [16,]       0.21203583     0.015313294 0.0005639459 0.7720869259
## [17,]       0.20119456     0.026154568 0.0005639459 0.7720869259
## [18,]       0.29634563     0.021304290 0.0004593640 0.6818907161
## [19,]       0.27332162     0.115387466 0.0008097502 0.6104811638
## [20,]       0.33030490     0.070894828 0.0008357705 0.5979645065
## [21,]       0.64812549     0.072618234 0.1368828134 0.1423734662
## [22,]       0.79744277     0.182211925 0.0039288615 0.0164164471
## [23,]       0.78428478     0.081241707 0.0005701268 0.1339033877
## [24,]       0.82666397     0.045848877 0.0005405068 0.1269466502
## [25,]       0.92195373     0.003708190 0.0274363214 0.0469017576
## [26,]       0.94937750     0.003675152 0.0004634567 0.0464838876
## [27,]       0.93067816     0.035232328 0.0323540085 0.0017355066
## [28,]       0.89530901     0.010072009 0.0788078480 0.0158111367
## [29,]       0.74785353     0.054332113 0.1965597086 0.0012546460
## [30,]       0.72090348     0.024624575 0.2539033060 0.0005686347
## [31,]       0.71043886     0.035089202 0.2512871491 0.0031847916
## [32,]       0.71043886     0.032473046 0.2539033060 0.0031847916
## [33,]       0.55101475     0.056287817 0.3751853865 0.0175120486
## [34,]       0.54766104     0.058123414 0.3823331363 0.0118824136
## [35,]       0.53288730     0.038496712 0.4055748124 0.0230411762
## [36,]       0.50795028     0.056270592 0.4103109562 0.0254681734
## [37,]       0.50592542     0.031732554 0.4550737365 0.0072682932
## [38,]       0.47806380     0.039487087 0.4820975396 0.0003515705
## [39,]       0.45804869     0.044125452 0.4974759863 0.0003498727
## [40,]       0.42999192     0.066553893 0.5031048813 0.0003493105
## [41,]       0.43662400     0.059932870 0.4982890902 0.0051540346
## [42,]       0.20406855     0.779281766 0.0006822975 0.0159673897
## [43,]       0.13966031     0.771416370 0.0004990251 0.0884242944
## [44,]       0.15870001     0.814771497 0.0004220901 0.0261064025
## [45,]       0.10572515     0.892174310 0.0004056331 0.0016949068
## [46,]       0.12727578     0.870520575 0.0004255431 0.0017780991
## [47,]       0.07849902     0.919671499 0.0003532898 0.0014761944
## [48,]       0.12372700     0.874727014 0.0002985445 0.0012474454
## [49,]       0.16974672     0.828652153 0.0003091916 0.0012919334
## [50,]       0.18070585     0.807427525 0.0107300650 0.0011365556
## [51,]       0.17283215     0.809829596 0.0164555604 0.0008826954
## [52,]       0.21706642     0.759506383 0.0002854390 0.0231417541
## [53,]       0.12147360     0.806029543 0.0416687269 0.0308281299
## [54,]       0.14335305     0.792823767 0.0262797362 0.0375434467
## [55,]       0.14191110     0.767304923 0.0400120029 0.0507719699
## [56,]       0.16416037     0.756410963 0.0470870524 0.0323416177
## [57,]       0.11857755     0.780132684 0.0686081442 0.0326816262
## [58,]       0.13831656     0.800102592 0.0353945784 0.0261862730
## [59,]       0.18450625     0.752141910 0.0490677269 0.0142841144
## [60,]       0.17741713     0.753126895 0.0471824408 0.0222735371
## [61,]       0.25203973     0.689536720 0.0452506349 0.0131729201
## [62,]       0.20681299     0.761823131 0.0004990251 0.0308648570
## [63,]       0.23719560     0.759361495 0.0006648564 0.0027780517
## [64,]       0.30674665     0.688547319 0.0009087762 0.0037972517
## [65,]       0.18508191     0.809092553 0.0011249639 0.0047005758
## [66,]       0.24996649     0.745067190 0.0009590403 0.0040072764
## [67,]       0.12143625     0.874235779 0.0008357705 0.0034922030
## [68,]       0.13322215     0.862584616 0.0008097502 0.0033834795
## [69,]       0.18958616     0.776154017 0.0007853013 0.0334745245
## [70,]       0.16937556     0.782714561 0.0447247233 0.0031851514
## [71,]       0.20551540     0.789694899 0.0009249351 0.0038647704
## [72,]       0.21198827     0.766584112 0.0008780950 0.0205495181
## [73,]       0.17822734     0.732823182 0.0008780950 0.0880713787
## [74,]       0.22150035     0.675006400 0.0007405803 0.1027526679
## [75,]       0.21333800     0.636173101 0.0007622855 0.1497266109
## [76,]       0.26867125     0.603345649 0.0006482847 0.1273348153
## [77,]       0.24026649     0.600886264 0.0006734641 0.1581737870
## [78,]       0.32293503     0.540034770 0.0006325191 0.1363976765
out_bigrams_base$phi    # Topic-word distribution
##                    risk_manag outlook_risk  credit_risk project_risk
## 1_financial_risk 7.008773e-02 1.909695e-06 5.291607e-02 1.128341e-02
## 2_societal_risk  4.582108e-02 2.756626e-03 2.747374e-05 2.747374e-05
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          5.359997e-02 5.650514e-03 9.401854e-06 9.401854e-06
##                   risk_provid   refer_risk   rigor_risk   risk_mitig
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 5.921965e-03
## 2_societal_risk  2.503747e-06 1.026787e-02 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          1.317200e-02 7.530885e-03 2.829958e-03 9.401854e-06
##                    legal_risk    risk_type  risk_requir   share_risk
## 1_financial_risk 3.248392e-03 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 2.829958e-03 4.710329e-03 2.829958e-03
##                   risk_corpor   sound_risk technic_risk  risk_assess
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.255876e-03 2.503747e-06 2.503747e-06 6.512246e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 3.770143e-03 2.829958e-03 4.325793e-02
##                  guarante_risk   minim_risk   risk_chang  risk_factor
## 1_financial_risk  3.248392e-03 1.909695e-06 1.909695e-06 2.941122e-02
## 2_societal_risk   2.503747e-06 1.004003e-03 2.503747e-06 8.813440e-02
## Other_1           3.592444e-06 3.592444e-06 6.469992e-03 3.592444e-06
## Other_2           9.401854e-06 1.889773e-03 2.257385e-02 6.112145e-02
##                     main_risk portion_risk   manag_risk   risk_insur
## 1_financial_risk 1.909695e-06 1.909695e-06 2.120961e-02 1.720095e-02
## 2_societal_risk  2.503747e-06 2.503747e-06 2.747374e-05 2.747374e-05
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          2.829958e-03 3.770143e-03 9.401854e-06 9.401854e-06
##                  chairman_risk   risk_evalu risk_uncertainti   risk_relat
## 1_financial_risk  2.484514e-03 1.909695e-06     1.909695e-06 3.743194e-02
## 2_societal_risk   2.503747e-06 2.503747e-06     5.733831e-02 7.012996e-03
## Other_1           3.592444e-06 3.592444e-06     3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 5.650514e-03     1.288148e-01 9.401854e-06
##                  currenc_risk  risk_econom risk_signific lavalin_risk
## 1_financial_risk 1.909695e-06 1.909695e-06  1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06  2.503747e-06 2.503747e-06
## Other_1          8.984703e-03 3.592444e-06  3.596037e-03 3.592444e-06
## Other_2          9.411256e-03 4.710329e-03  1.889773e-03 9.411256e-03
##                   follow_risk   limit_risk  risk_associ   level_risk
## 1_financial_risk 8.404569e-03 9.567574e-04 4.967118e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 4.431883e-02 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 1.881311e-02 1.129163e-02
##                   risk_specif exchang_risk  risk_advers  number_risk
## 1_financial_risk 1.909695e-06 3.439361e-03 1.909695e-06 1.909695e-06
## 2_societal_risk  1.004003e-03 2.503747e-06 2.503747e-06 9.516743e-03
## Other_1          3.592444e-06 3.592444e-06 1.796581e-02 3.596037e-03
## Other_2          9.401854e-06 9.401854e-06 2.829958e-03 9.401854e-06
##                  risk_uncertain   polit_risk     risk_due  assess_risk
## 1_financial_risk   1.909695e-06 2.099853e-05 1.909695e-06 1.909695e-06
## 2_societal_risk    2.503747e-06 4.022672e-03 1.254377e-03 8.264869e-03
## Other_1            3.592444e-06 7.906970e-03 3.596037e-03 3.592444e-06
## Other_2            3.770143e-03 9.401854e-06 9.401854e-06 9.401854e-06
##                   factor_risk risk_discount discuss_risk analysi_risk
## 1_financial_risk 4.967118e-03  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06  3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06  2.829958e-03 2.445422e-02 1.129163e-02
##                   presid_risk  includ_risk signific_risk   price_risk
## 1_financial_risk 1.909695e-06 9.741356e-03  1.909695e-06 1.909695e-06
## 2_societal_risk  1.001749e-02 6.762621e-03  1.477461e-02 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06  7.547726e-03 1.185866e-02
## Other_2          9.401854e-06 8.471070e-03  1.693274e-02 3.667663e-02
##                   polici_risk  market_risk   risk_price   indic_risk
## 1_financial_risk 3.057422e-03 1.853717e-02 1.909695e-06 6.303904e-03
## 2_societal_risk  2.503747e-06 2.747374e-05 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 1.799815e-03 3.592444e-06
## Other_2          1.881311e-02 9.401854e-06 1.505237e-02 1.411218e-02
##                  backlog_risk risk_debentur  health_risk    risk_will
## 1_financial_risk 1.909695e-06  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06  3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          1.411218e-02  2.829958e-03 7.530885e-03 1.881311e-02
##                  investor_risk     snc_risk  involv_risk  inform_risk
## 1_financial_risk  1.909695e-06 1.909695e-06 2.866453e-03 2.099853e-05
## 2_societal_risk   2.503747e-06 2.503747e-06 2.503747e-06 2.025316e-02
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           1.411218e-02 8.471070e-03 1.505237e-02 9.401854e-06
##                   safeti_risk environ_risk section_risk risk_accomplish
## 1_financial_risk 1.909695e-06 7.640691e-03 9.567574e-04    1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06    2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06    3.592444e-06
## Other_2          3.770143e-03 9.401854e-06 3.385608e-02    5.650514e-03
##                   risk_regist  person_risk correct_risk  risk_compet
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          6.590700e-03 6.590700e-03 2.829958e-03 1.035144e-02
##                     well_risk  corpor_risk   addit_risk   activ_risk
## 1_financial_risk 1.147727e-03 1.909695e-06 3.248392e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 6.512246e-03 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 4.710329e-03 9.401854e-06 5.650514e-03
##                   reward_risk  report_risk risk_identifi risk_implement
## 1_financial_risk 1.909695e-06 1.909695e-06  1.909695e-06   1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06  2.005501e-03   2.503747e-06
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06   3.592444e-06
## Other_2          3.770143e-03 1.223181e-02  6.590700e-03   1.035144e-02
##                    risk_engin  import_risk    risk_risk  risk_includ
## 1_financial_risk 1.909695e-06 1.909695e-06 4.220618e-02 1.165105e-02
## 2_societal_risk  2.503747e-06 3.257375e-03 2.503747e-06 8.515244e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 9.343948e-03
## Other_2          4.710329e-03 1.035144e-02 9.401854e-06 9.401854e-06
##                  various_risk certain_risk   expos_risk risk_increas
## 1_financial_risk 6.494874e-03 8.213600e-03 5.158087e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 5.510747e-03 2.503747e-06 3.758124e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 4.314526e-03
## Other_2          9.401854e-06 9.401854e-06 1.411218e-02 5.650514e-03
##                    secur_risk subject_risk statement_risk present_risk
## 1_financial_risk 1.909695e-06 2.099853e-05   1.909695e-06 1.909695e-06
## 2_societal_risk  4.759623e-03 1.304696e-02   2.503747e-06 5.032532e-04
## Other_1          1.081326e-03 3.592444e-06   3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 5.650514e-03   9.411256e-03 9.411256e-03
##                   risk_cancel risk_control  risk_review financi_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 3.915066e-02 2.099853e-05
## 2_societal_risk  2.503747e-06 4.509249e-03 2.503747e-06 1.630183e-02
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          5.650514e-03 9.401854e-06 9.401854e-06 1.505237e-02
##                   improv_risk  remedi_risk comprehens_risk risk_committe
## 1_financial_risk 1.338696e-03 1.909695e-06    1.909695e-06  1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06    2.503747e-06  2.503747e-06
## Other_1          3.592444e-06 3.592444e-06    3.592444e-06  3.596037e-03
## Other_2          9.401854e-06 2.829958e-03    4.710329e-03  4.137756e-02
##                     risk_base   mitig_risk   relat_risk  risk_profil
## 1_financial_risk 2.349116e-02 5.349057e-03 5.921965e-03 1.356075e-02
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     head_risk uncertainti_risk   reduc_risk   adequ_risk
## 1_financial_risk 4.012270e-03     1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  3.758124e-03     2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06     7.188481e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06     3.770143e-03 6.590700e-03 2.829958e-03
##                  process_risk risk_exploit    hsse_risk control_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          5.650514e-03 2.829958e-03 5.650514e-03 5.650514e-03
##                    risk_level  risk_matric determin_risk   risk_inher
## 1_financial_risk 1.909695e-06 1.909695e-06  1.909695e-06 1.529666e-03
## 2_societal_risk  2.503747e-06 2.503747e-06  2.503747e-06 4.008499e-03
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06 3.592444e-06
## Other_2          6.590700e-03 2.829958e-03  2.829958e-03 1.035144e-02
##                  risk_investig   audit_risk    busi_risk perform_risk
## 1_financial_risk  1.909695e-06 4.776148e-03 6.513963e-03 3.821300e-03
## 2_societal_risk   2.503747e-06 2.503747e-06 2.381307e-02 2.503747e-06
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           2.829958e-03 9.401854e-06 9.401854e-06 9.401854e-06
##                   integr_risk construct_risk   evalu_risk    risk_make
## 1_financial_risk 2.102575e-03   1.909695e-06 1.909695e-06 1.529666e-03
## 2_societal_risk  2.503747e-06   2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06   3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06   9.411256e-03 2.829958e-03 9.401854e-06
##                   effect_risk  overal_risk  financ_risk    oper_risk
## 1_financial_risk 1.720636e-03 3.248392e-03 1.909695e-06 9.550387e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 1.878061e-02
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 2.048053e-02
## Other_2          9.401854e-06 9.401854e-06 2.829958e-03 9.401854e-06
##                   materi_risk risk_potenti  execut_risk  risk_within
## 1_financial_risk 3.838766e-03 1.126911e-02 1.909695e-06 1.529666e-03
## 2_societal_risk  2.747374e-05 2.503747e-06 2.255876e-03 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 7.188481e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   regard_risk risk_foreign    risk_busi   futur_risk
## 1_financial_risk 1.909695e-06 2.102575e-03 5.730996e-03 3.439361e-03
## 2_societal_risk  1.504752e-03 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    lower_risk   risk_activ   insur_risk  liquid_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.452851e-02 1.909695e-06
## 2_societal_risk  2.503747e-06 1.004003e-03 2.747374e-05 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 2.155826e-02
## Other_2          3.770143e-03 9.401854e-06 9.401854e-06 9.401854e-06
##                   govern_risk default_risk risk_financi   chair_risk
## 1_financial_risk 1.529666e-03 1.069620e-02 1.204697e-02 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.747374e-05 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.596037e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    chief_risk   risk_offic  risk_compon  invest_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 9.168447e-03 6.112935e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          8.984703e-03 8.984703e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_interest    rate_risk implement_risk   capit_risk
## 1_financial_risk  4.967118e-03 1.451559e-02   2.102575e-03 1.909695e-06
## 2_societal_risk   2.503747e-06 6.261872e-03   2.503747e-06 2.503747e-06
## Other_1           3.592444e-06 3.592444e-06   3.592444e-06 8.984703e-03
## Other_2           9.401854e-06 9.401854e-06   9.401854e-06 9.401854e-06
##                   risk_polici  amount_risk   estat_risk risk_underwritten
## 1_financial_risk 1.909695e-06 1.720636e-03 1.909695e-06      1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06      2.503747e-06
## Other_1          4.314526e-03 3.592444e-06 1.509186e-02      9.343948e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06      9.401854e-06
##                  risk_respect increas_risk environment_risk reinsur_risk
## 1_financial_risk 4.776148e-03 1.909695e-06     2.099853e-05 1.909695e-06
## 2_societal_risk  2.503747e-06 1.254377e-03     3.523516e-02 2.503747e-06
## Other_1          3.592444e-06 1.796581e-02     3.592444e-06 8.984703e-03
## Other_2          9.401854e-06 9.401854e-06     9.401854e-06 9.401854e-06
##                   risk_mortal concentr_risk policyhold_risk    risk_face
## 1_financial_risk 6.303904e-03  1.909695e-06    1.911605e-03 3.248392e-03
## 2_societal_risk  2.503747e-06  2.503747e-06    2.503747e-06 2.503747e-06
## Other_1          3.592444e-06  4.673770e-03    3.592444e-06 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06    9.401854e-06 9.401854e-06
##                    risk_capit    risk_sell    risk_loss  risk_system
## 1_financial_risk 5.921965e-03 1.909695e-06 6.112935e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 4.673770e-03 3.592444e-06 1.799815e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     also_risk   risk_addit  risk_invest     risk_sun
## 1_financial_risk 2.866453e-03 1.911605e-03 1.909695e-06 7.258752e-03
## 2_societal_risk  7.764120e-03 2.503747e-06 3.007000e-03 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_materi    base_risk    hedg_risk  risk_preval
## 1_financial_risk 4.793207e-03 2.866453e-03 3.057422e-03 1.909695e-06
## 2_societal_risk  2.747374e-05 3.758124e-03 2.503747e-06 1.004003e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     area_risk    wide_risk   deriv_risk   assum_risk
## 1_financial_risk 1.911605e-03 1.909695e-06 1.147727e-03 2.293544e-03
## 2_societal_risk  2.503747e-06 1.755127e-03 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_measur   risk_assum     risk_act    laps_risk
## 1_financial_risk 1.909695e-06 7.657878e-04 1.909695e-06 4.012270e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.005501e-03 2.503747e-06
## Other_1          1.440570e-03 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_among   risk_toler  measur_risk    risk_cash
## 1_financial_risk 1.909695e-06 9.567574e-04 2.293544e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 2.877548e-03
## Other_2          3.770143e-03 9.401854e-06 9.401854e-06 9.401854e-06
##                      risk_set    risk_issu  requir_risk   risk_refer
## 1_financial_risk 1.909695e-06 1.720636e-03 2.675483e-03 1.720636e-03
## 2_societal_risk  7.536279e-04 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     vari_risk risk_characterist     risk_iii develop_risk
## 1_financial_risk 7.657878e-04      2.102575e-03 3.821300e-03 3.630331e-03
## 2_societal_risk  2.503747e-06      2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06      3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06      9.401854e-06 9.401854e-06 9.401854e-06
##                  reflect_risk  mixtur_risk risk_regulatori fluctuat_risk
## 1_financial_risk 5.158087e-03 5.748183e-04    1.909695e-06  7.657878e-04
## 2_societal_risk  2.503747e-06 2.503747e-06    2.756626e-03  2.503747e-06
## Other_1          3.592444e-06 3.592444e-06    3.592444e-06  3.592444e-06
## Other_2          9.401854e-06 9.401854e-06    9.401854e-06  9.401854e-06
##                      iii_risk  differ_risk  member_risk risk_reinsur
## 1_financial_risk 1.909695e-06 1.147727e-03 3.630331e-03 3.057422e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          2.829958e-03 9.401854e-06 9.401854e-06 9.401854e-06
##                   matter_risk  risk_segreg risk_describ   chang_risk
## 1_financial_risk 3.630331e-03 4.012270e-03 4.967118e-03 3.057422e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_movement    fund_risk  risk_balanc     six_risk
## 1_financial_risk  1.338696e-03 2.102575e-03 2.675483e-03 2.866453e-03
## 2_societal_risk   2.005501e-03 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_restrict   risk_howev  liabil_risk risk_surrend
## 1_financial_risk  1.529666e-03 9.567574e-04 1.909695e-06 9.567574e-04
## 2_societal_risk   2.503747e-06 2.503747e-06 2.506251e-03 2.503747e-06
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     bear_risk   group_risk countri_risk    asia_risk
## 1_financial_risk 5.748183e-04 1.529666e-03 5.748183e-04 5.748183e-04
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  committe_risk    issu_risk risk_categori  risk_affect
## 1_financial_risk  9.741356e-03 1.909695e-06  5.158087e-03 1.909695e-06
## 2_societal_risk   2.503747e-06 2.503747e-06  2.503747e-06 3.507750e-03
## Other_1           3.592444e-06 3.596037e-03  3.592444e-06 8.625459e-03
## Other_2           9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                      new_risk     law_risk strategi_risk  review_risk
## 1_financial_risk 4.203240e-03 7.657878e-04  2.293544e-03 5.748183e-04
## 2_societal_risk  2.503747e-06 3.758124e-03  2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                      inc_risk  valuat_risk   given_risk   under_risk
## 1_financial_risk 6.494874e-03 2.484514e-03 1.529666e-03 3.248392e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_lower similar_risk   risk_exist   china_risk
## 1_financial_risk 1.529666e-03 5.748183e-04 5.748183e-04 1.529666e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_spread strateg_risk  canada_risk risk_product
## 1_financial_risk 5.748183e-04 1.166329e-03 8.786508e-03 4.394209e-03
## 2_societal_risk  2.503747e-06 2.747374e-05 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 8.984703e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  director_risk    term_risk  risk_credit  risk_borrow
## 1_financial_risk  4.012270e-03 5.748183e-04 1.909695e-06 3.821300e-03
## 2_societal_risk   2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           3.592444e-06 3.592444e-06 1.078093e-02 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  commensur_risk varieti_risk resourc_risk    risk_rate
## 1_financial_risk   3.057422e-03 1.909695e-06 3.630331e-03 1.909695e-06
## 2_societal_risk    2.503747e-06 2.503747e-06 2.503747e-06 2.255876e-03
## Other_1            3.592444e-06 3.596037e-03 3.592444e-06 3.592444e-06
## Other_2            9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_market    risk_aris heighten_risk catastroph_risk
## 1_financial_risk 1.909695e-06 1.338696e-03  1.909695e-06    1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06  2.503747e-06    2.503747e-06
## Other_1          1.473261e-02 3.305408e-02  5.033015e-03    5.392259e-03
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06    9.401854e-06
##                    litig_risk risk_general januari_risk   risk_natur
## 1_financial_risk 3.630331e-03 3.248392e-03 7.657878e-04 3.248392e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 1.254377e-03 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                      set_risk industri_risk  terror_risk channel_risk
## 1_financial_risk 1.909695e-06  7.657878e-04 1.909695e-06 1.720636e-03
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.440570e-03  3.592444e-06 2.159059e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_review1 respect_risk  risk_declin     aif_risk
## 1_financial_risk 9.567574e-04 9.567574e-04 5.748183e-04 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 1.504752e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.596037e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  monitor_risk    risk_oper appropri_risk    life_risk
## 1_financial_risk 1.909695e-06 1.909695e-06  1.529666e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.756626e-03  2.503747e-06 2.503747e-06
## Other_1          2.159059e-03 1.185866e-02  3.592444e-06 3.236792e-03
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                     risk_life    basi_risk   risk_model   model_risk
## 1_financial_risk 1.909695e-06 3.057422e-03 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.799815e-03 3.592444e-06 5.033015e-03 2.299524e-02
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  competit_risk    risk_forc risk_volatil    risk_caus
## 1_financial_risk  1.909695e-06 1.909695e-06 1.909695e-06 1.338696e-03
## 2_societal_risk   1.252124e-02 2.503747e-06 5.009998e-03 2.503747e-06
## Other_1           3.596037e-03 4.673770e-03 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  continu_risk counterparti_risk   avail_risk     usa_risk
## 1_financial_risk 1.720636e-03      1.909695e-06 7.657878e-04 7.657878e-04
## 2_societal_risk  2.503747e-06      1.755127e-03 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06      3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06      9.401854e-06 9.401854e-06 9.401854e-06
##                  resources1_risk specifi_risk   adopt_risk risk_principl
## 1_financial_risk    7.657878e-04 1.909695e-06 1.909695e-06  1.909695e-06
## 2_societal_risk     2.503747e-06 2.503747e-06 2.503747e-06  2.503747e-06
## Other_1             3.592444e-06 2.159059e-03 3.955281e-03  3.236792e-03
## Other_2             9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                  risk_compani risk_counterparti compani_risk england_risk
## 1_financial_risk 4.029654e-03      1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.747374e-05      1.755127e-03 9.516743e-03 2.503747e-06
## Other_1          3.592444e-06      3.592444e-06 3.592444e-06 1.799815e-03
## Other_2          9.401854e-06      9.401854e-06 9.401854e-06 9.401854e-06
##                    state_risk   risk_occur relationship_risk    risk_also
## 1_financial_risk 1.909695e-06 6.112935e-03      1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06      2.503747e-06 2.503747e-06
## Other_1          4.314526e-03 3.592444e-06      5.751503e-03 2.515070e-02
## Other_2          9.401854e-06 9.401854e-06      9.401854e-06 9.401854e-06
##                    posit_risk  risk_equiti  equiti_risk    risk_basi
## 1_financial_risk 2.102575e-03 4.012270e-03 1.909695e-06 3.821300e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 1.329564e-02 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     risk_hedg risk_policyhold risk_exposur  risk_result
## 1_financial_risk 1.909695e-06    1.909695e-06 1.642529e-02 1.909695e-06
## 2_societal_risk  2.503747e-06    2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          5.392259e-03    8.625459e-03 3.592444e-06 1.724733e-02
## Other_2          9.401854e-06    9.401854e-06 9.401854e-06 9.401854e-06
##                  multipl_risk behaviour_risk   risk_incur  morbid_risk
## 1_financial_risk 2.293544e-03   4.585179e-03 1.529666e-03 1.909695e-06
## 2_societal_risk  2.503747e-06   2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06   3.592444e-06 3.592444e-06 1.257715e-02
## Other_2          9.401854e-06   9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_futur  associ_risk  longev_risk     risk_mis
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 1.504752e-03 2.503747e-06 2.503747e-06
## Other_1          1.293639e-02 4.673770e-03 1.652884e-02 4.314526e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_failur technolog_risk risk_environment    type_risk
## 1_financial_risk 1.911605e-03   1.909695e-06     3.838488e-04 1.909695e-06
## 2_societal_risk  2.756626e-03   6.261872e-03     4.008499e-03 2.503747e-06
## Other_1          3.592444e-06   6.469992e-03     3.592444e-06 5.751503e-03
## Other_2          9.401854e-06   9.401854e-06     9.401854e-06 9.401854e-06
##                  potenti_risk adequaci_risk introduc_risk  object_risk
## 1_financial_risk 1.909695e-06  3.630331e-03  1.909695e-06 2.484514e-03
## 2_societal_risk  3.758124e-03  2.503747e-06  2.503747e-06 2.503747e-06
## Other_1          3.955281e-03  3.592444e-06  6.110748e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06  9.401854e-06 9.401854e-06
##                  risk_section privaci_risk risk_certain   risk_litig
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.006244e-02 2.877548e-03 5.033015e-03 4.314526e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_class  elimin_risk  risk_liquid  risk_consid
## 1_financial_risk 1.909695e-06 1.909695e-06 4.967118e-03 4.012270e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 3.758124e-03
## Other_1          4.314526e-03 5.392259e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   specif_risk  result_risk  risk_outlin downturn_risk
## 1_financial_risk 1.909695e-06 7.657878e-04 1.909695e-06  5.748183e-04
## 2_societal_risk  3.007000e-03 2.255876e-03 5.009998e-03  2.503747e-06
## Other_1          4.673770e-03 3.592444e-06 3.592444e-06  3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                  ineffect_risk risk_introduc  risk_purpos  provid_risk
## 1_financial_risk  1.909695e-06  5.748183e-04 5.748183e-04 1.338696e-03
## 2_societal_risk   2.503747e-06  2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           1.440570e-03  3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_framework risk_necessarili categori_risk risk_program
## 1_financial_risk   5.748183e-04     5.748183e-04  1.909695e-06 1.909695e-06
## 2_societal_risk    2.503747e-06     2.503747e-06  2.503747e-06 2.503747e-06
## Other_1            3.592444e-06     3.592444e-06  1.081326e-03 2.877548e-03
## Other_2            9.401854e-06     9.401854e-06  9.401854e-06 9.401854e-06
##                      risk_see risk_sustain  risk_elimin  consid_risk
## 1_financial_risk 1.147727e-03 1.909695e-06 1.909695e-06 5.748183e-04
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 1.081326e-03 1.081326e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_suffici risk_downgrad    loss_risk experienc_risk
## 1_financial_risk 5.748183e-04  7.657878e-04 5.748183e-04   5.748183e-04
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06   2.503747e-06
## Other_1          3.592444e-06  3.592444e-06 3.592444e-06   3.592444e-06
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06   9.401854e-06
##                   risk_driver mismatch_risk risk_discriminatori   risk_error
## 1_financial_risk 5.748183e-04  5.748183e-04        1.338696e-03 1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06        2.503747e-06 2.503747e-06
## Other_1          3.592444e-06  3.592444e-06        3.592444e-06 3.236792e-03
## Other_2          9.401854e-06  9.401854e-06        9.401854e-06 9.401854e-06
##                    risk_third   block_risk interact_risk risk_descript
## 1_financial_risk 1.720636e-03 5.748183e-04  5.748183e-04  5.748183e-04
## 2_societal_risk  2.503747e-06 2.503747e-06  2.503747e-06  2.503747e-06
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06  3.592444e-06
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06  9.401854e-06
##                    risk_inter    mani_risk distribut_risk address_risk
## 1_financial_risk 1.909695e-06 1.909695e-06   1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 6.261872e-03   2.503747e-06 4.008499e-03
## Other_1          2.518304e-03 5.033015e-03   6.829237e-03 5.392259e-03
## Other_2          9.401854e-06 9.401854e-06   9.401854e-06 9.401854e-06
##                  opinion_risk risk_default  risk_issuer risk_particular
## 1_financial_risk 1.720636e-03 1.909695e-06 1.909695e-06    1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06    2.503747e-06
## Other_1          3.592444e-06 4.314526e-03 3.236792e-03    3.236792e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06    9.401854e-06
##                     deal_risk   risk_capac risk_current     use_risk
## 1_financial_risk 3.057422e-03 1.911605e-03 2.484514e-03 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 4.673770e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  product_risk    risk_rais   risk_expos  risk_common
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 2.484514e-03
## 2_societal_risk  4.258874e-03 2.503747e-06 2.255876e-03 2.503747e-06
## Other_1          1.042168e-02 3.236792e-03 5.751503e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_appli risk_connect   regul_risk  risk_repres
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 1.254377e-03 1.527536e-02 2.503747e-06
## Other_1          3.236792e-03 5.033015e-03 3.592444e-06 3.236792e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  descript_risk   risk_indic  residu_risk  within_risk
## 1_financial_risk  1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk   2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           3.236792e-03 3.236792e-03 3.236792e-03 1.293639e-02
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     risk_take risk_appetit  adjust_risk    flow_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.255876e-03 2.503747e-06
## Other_1          8.266214e-03 1.257715e-02 3.236792e-03 3.955281e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_manifest consequ_risk  expens_risk  risk_expens
## 1_financial_risk  1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk   2.506251e-03 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           2.877548e-03 3.596037e-03 1.401413e-02 3.236792e-03
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    align_risk reassess_risk     risk_tax   risk_unabl
## 1_financial_risk 1.909695e-06  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          2.877548e-03  3.236792e-03 6.110748e-03 3.236792e-03
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                    reput_risk    risk_fail  system_risk   found_risk
## 1_financial_risk 2.102575e-03 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 1.504752e-03 2.503747e-06
## Other_1          3.592444e-06 1.799815e-03 3.236792e-03 2.159059e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     sale_risk    rang_risk    risk_abil   assur_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 9.567574e-04 1.338696e-03
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.236792e-03 3.596037e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    board_risk identifi_risk enterpris_risk risk_princip
## 1_financial_risk 1.909695e-06  1.909695e-06   9.567574e-04 1.909695e-06
## 2_societal_risk  5.009998e-03  5.260373e-03   4.759623e-03 2.503747e-06
## Other_1          3.592444e-06  3.592444e-06   3.592444e-06 2.518304e-03
## Other_2          9.401854e-06  9.401854e-06   9.401854e-06 9.401854e-06
##                  exposur_risk   creat_risk  entiti_risk investig_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06  1.909695e-06
## 2_societal_risk  2.506251e-03 7.536279e-04 2.503747e-06  2.503747e-06
## Other_1          3.592444e-06 3.628369e-04 1.799815e-03  1.440570e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                   growth_risk  risk_return  global_risk actuari_risk
## 1_financial_risk 5.748183e-04 5.748183e-04 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 3.592444e-06 2.877548e-03 1.081326e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  describ_risk   risk_reduc  risk_period  risk_recent
## 1_financial_risk 7.657878e-04 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 2.159059e-03 1.081326e-03 1.440570e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_oversight  risk_global risk_solvenc   exist_risk
## 1_financial_risk   1.147727e-03 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk    2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1            3.592444e-06 1.440570e-03 3.236792e-03 1.440570e-03
## Other_2            9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  slowdown_risk risk_inappropri risk_substanti   risk_joint
## 1_financial_risk  1.909695e-06    1.909695e-06   1.909695e-06 1.909695e-06
## 2_societal_risk   2.503747e-06    2.503747e-06   2.503747e-06 2.503747e-06
## Other_1           1.440570e-03    2.159059e-03   1.799815e-03 1.081326e-03
## Other_2           9.401854e-06    9.401854e-06   9.401854e-06 9.401854e-06
##                  risk_currenc risk_opportun risk_prescrib    risk_long
## 1_financial_risk 1.909695e-06  3.456989e-03  1.909695e-06 1.720636e-03
## 2_societal_risk  2.503747e-06  2.747374e-05  2.503747e-06 2.503747e-06
## Other_1          1.440570e-03  3.592444e-06  2.877548e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06  9.401854e-06 9.401854e-06
##                     face_risk  risk_number  spread_risk  risk_longev
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          6.469992e-03 2.877548e-03 8.266214e-03 3.236792e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_purchas     risk_key  risk_depend risk_technolog
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06   1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06   2.503747e-06
## Other_1          2.877548e-03 2.877548e-03 3.955281e-03   3.955281e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06   9.401854e-06
##                   risk_govern risk_strategi  arrang_risk sustain_risk
## 1_financial_risk 1.909695e-06  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  3.257375e-03  3.507750e-03 2.255876e-03 2.503747e-06
## Other_1          3.592444e-06  3.592444e-06 3.592444e-06 1.081326e-03
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                    least_risk guidelin_risk    link_risk   howev_risk
## 1_financial_risk 5.748183e-04  5.748183e-04 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06 2.503747e-06 1.755127e-03
## Other_1          3.592444e-06  3.592444e-06 1.081326e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                  complianc_risk  risk_qualif risk_incorpor  econom_risk
## 1_financial_risk   1.909695e-06 9.567574e-04  1.909695e-06 6.511203e-03
## 2_societal_risk    2.503747e-06 2.503747e-06  2.503747e-06 2.747374e-05
## Other_1            5.751503e-03 3.592444e-06  2.518304e-03 3.592444e-06
## Other_2            9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                  prescrib_risk probabl_risk     risk_low  risk_impact
## 1_financial_risk  1.909695e-06 1.338696e-03 2.293544e-03 1.909695e-06
## 2_societal_risk   2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           2.518304e-03 3.592444e-06 3.592444e-06 7.547726e-03
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_extern risk_concentr  period_risk     risk_use
## 1_financial_risk 1.338696e-03  1.909695e-06 1.909695e-06 3.057422e-03
## 2_societal_risk  2.503747e-06  2.503747e-06 2.005501e-03 2.503747e-06
## Other_1          3.592444e-06  2.877548e-03 2.518304e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                     naic_risk    risk_pose risk_various risk_possibl
## 1_financial_risk 7.657878e-04 5.748183e-04 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06 1.081326e-03 9.703192e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    major_risk  outlin_risk     one_risk   risk_evolv
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 3.507750e-03 2.503747e-06 2.503747e-06
## Other_1          2.159059e-03 1.799815e-03 2.159059e-03 3.596037e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_competit   risk_enter  risk_inform   risk_uniqu
## 1_financial_risk  1.909695e-06 9.567574e-04 3.057422e-03 1.529666e-03
## 2_societal_risk   2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1           3.236792e-03 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    uniqu_risk   occur_risk    note_risk   risk_escal
## 1_financial_risk 1.909695e-06 1.909695e-06 9.567574e-04 1.909695e-06
## 2_societal_risk  2.503747e-06 7.536279e-04 2.503747e-06 2.756626e-03
## Other_1          1.799815e-03 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     risk_debt    valu_risk support_risk     sum_risk
## 1_financial_risk 1.529666e-03 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.592444e-06 2.877548e-03 3.236792e-03 4.314526e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  conduct_risk risk_crystal  profil_risk risk_subject
## 1_financial_risk 1.909695e-06 9.567574e-04 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          3.596037e-03 3.592444e-06 1.799815e-03 4.673770e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_formul risk_disrupt    part_risk    risk_fair
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 9.567574e-04
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.799815e-03 3.236792e-03 2.159059e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                      risk_aif    risk_real  around_risk risk_present
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.799815e-03 1.799815e-03 1.799815e-03 2.877548e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    recov_risk risk_indemnif risk_therefor     key_risk
## 1_financial_risk 1.909695e-06  9.567574e-04  1.909695e-06 1.338696e-03
## 2_societal_risk  2.503747e-06  2.503747e-06  2.503747e-06 2.503747e-06
## Other_1          1.799815e-03  3.592444e-06  1.799815e-03 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06  9.401854e-06 9.401854e-06
##                    media_risk   risk_reput   parti_risk   risk_engag
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.799815e-03 1.799815e-03 2.159059e-03 1.799815e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  disrupt_risk  pandem_risk  risk_intern   risk_inabl
## 1_financial_risk 9.567574e-04 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 5.510747e-03 2.503747e-06
## Other_1          3.592444e-06 1.799815e-03 3.592444e-06 1.799815e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   disabl_risk  risk_aggreg   risk_licat    risk_free
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.081326e-03 1.440570e-03 1.440570e-03 3.596037e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                     five_risk risk_transfer transfer_risk risk_diversif
## 1_financial_risk 1.909695e-06  1.909695e-06  1.909695e-06  1.909695e-06
## 2_societal_risk  2.503747e-06  2.503747e-06  2.503747e-06  2.503747e-06
## Other_1          2.159059e-03  1.440570e-03  1.440570e-03  1.440570e-03
## Other_2          9.401854e-06  9.401854e-06  9.401854e-06  9.401854e-06
##                     real_risk  risk_entiti  risk_outcom     risk_u.k
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.440570e-03 1.440570e-03 2.518304e-03 1.081326e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  minimum_risk   risk_defin   defin_risk  risk_experi
## 1_financial_risk 1.909695e-06 1.909695e-06 7.657878e-04 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.440570e-03 1.440570e-03 3.592444e-06 1.440570e-03
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_continu    risk_sale advisor_risk transact_risk
## 1_financial_risk 1.147727e-03 1.909695e-06 1.909695e-06  5.748183e-04
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06  2.503747e-06
## Other_1          3.592444e-06 1.440570e-03 1.440570e-03  3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                  risk_exacerb  impact_risk risk_conduct  margin_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 6.261872e-03 2.503747e-06 5.761122e-03
## Other_1          1.440570e-03 3.592444e-06 7.547726e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_facilit  risk_overse   appli_risk pressur_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 9.567574e-04
## 2_societal_risk  2.503747e-06 2.503747e-06 2.503747e-06 2.503747e-06
## Other_1          1.081326e-03 1.081326e-03 1.081326e-03 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   risk_implic  client_risk risk_possess   cyber_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.503747e-06 2.503747e-06 2.506251e-03 1.254377e-03
## Other_1          1.081326e-03 1.081326e-03 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_regul  physic_risk employe_risk risk_success
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  7.536279e-04 7.536279e-04 2.005501e-03 1.427386e-02
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    inher_risk    high_risk    risk_well risk_project
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.755127e-03 1.755127e-03 1.755127e-03 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  prudent_risk  hazard_risk    risk_fire  risk_normal
## 1_financial_risk 1.909695e-06 2.099853e-05 1.909695e-06 1.909695e-06
## 2_societal_risk  3.507750e-03 7.789090e-03 4.008499e-03 9.767118e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  particular_risk    unit_risk  risk_suncor maintain_risk
## 1_financial_risk    1.909695e-06 1.909695e-06 1.909695e-06  1.909695e-06
## 2_societal_risk     3.507750e-03 7.536279e-04 1.001749e-02  6.011497e-03
## Other_1             3.592444e-06 3.592444e-06 3.592444e-06  3.592444e-06
## Other_2             9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                  circumst_risk  occurr_risk risk_recoveri  higher_risk
## 1_financial_risk  1.909695e-06 1.909695e-06  1.909695e-06 1.909695e-06
## 2_societal_risk   5.260373e-03 3.758124e-03  3.758124e-03 1.504752e-03
## Other_1           3.592444e-06 3.592444e-06  3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                      see_risk    cost_risk risk_element      u._risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.255876e-03 1.755127e-03 7.536279e-04 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_inadequ  risk_canada relianc_risk   separ_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  7.536279e-04 7.536279e-04 2.255876e-03 3.007000e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   suncor_risk risk_government  approv_risk instrument_risk
## 1_financial_risk 1.909695e-06    1.909695e-06 1.909695e-06    1.909695e-06
## 2_societal_risk  2.506251e-03    3.507750e-03 3.007000e-03    1.254377e-03
## Other_1          3.592444e-06    3.592444e-06 3.592444e-06    3.592444e-06
## Other_2          9.401854e-06    9.401854e-06 9.401854e-06    9.401854e-06
##                    numer_risk risk_downstream  risk_involv   risk_moodi
## 1_financial_risk 1.909695e-06    1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  7.536279e-04    1.254377e-03 1.755127e-03 1.254377e-03
## Other_1          3.592444e-06    3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06    9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_avail although_risk  risk_exclus    plan_risk
## 1_financial_risk 1.909695e-06  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  7.536279e-04  1.004003e-03 1.004003e-03 2.756626e-03
## Other_1          3.592444e-06  3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_confidenti risk_sabotag princip_risk recoveri_risk
## 1_financial_risk    1.909695e-06 1.909695e-06 1.909695e-06  1.909695e-06
## 2_societal_risk     1.254377e-03 3.758124e-03 9.015993e-03  3.007000e-03
## Other_1             3.592444e-06 3.592444e-06 3.592444e-06  3.592444e-06
## Other_2             9.401854e-06 9.401854e-06 9.401854e-06  9.401854e-06
##                   risk_matter     risk_oil regulatori_risk    risk_four
## 1_financial_risk 1.909695e-06 1.909695e-06    2.099853e-05 1.909695e-06
## 2_societal_risk  2.005501e-03 2.506251e-03    5.520871e-03 1.004003e-03
## Other_1          3.592444e-06 3.592444e-06    3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06    9.401854e-06 9.401854e-06
##                  risk_classifi classifi_risk  risk_direct  reclam_risk
## 1_financial_risk  1.909695e-06  1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk   1.004003e-03  1.004003e-03 1.504752e-03 1.755127e-03
## Other_1           3.592444e-06  3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06  9.401854e-06 9.401854e-06 9.401854e-06
##                  independ_risk  condit_risk  detail_risk   risk_refin
## 1_financial_risk  1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk   2.255876e-03 7.012996e-03 7.536279e-04 1.004003e-03
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  resourc_unrisk unrisk_arithmet risk_difficulti upstream_risk
## 1_financial_risk   1.909695e-06    1.909695e-06    1.909695e-06  1.909695e-06
## 2_societal_risk    1.254377e-03    7.536279e-04    2.255876e-03  2.255876e-03
## Other_1            3.592444e-06    3.592444e-06    3.592444e-06  3.592444e-06
## Other_2            9.401854e-06    9.401854e-06    9.401854e-06  9.401854e-06
##                   risk_reward    sole_risk divestitur_risk  risk_public
## 1_financial_risk 1.909695e-06 1.909695e-06    1.909695e-06 1.909695e-06
## 2_societal_risk  4.509249e-03 1.254377e-03    1.504752e-03 1.254377e-03
## Other_1          3.592444e-06 3.592444e-06    3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06    9.401854e-06 9.401854e-06
##                  document_risk primari_risk identif_risk protect_risk
## 1_financial_risk  1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk   2.255876e-03 3.257375e-03 1.254377e-03 2.756626e-03
## Other_1           3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2           9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    carri_risk risk_consist  suppli_risk  risk_object
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.255876e-03 2.255876e-03 2.255876e-03 2.005501e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  contribut_risk   trade_risk  risk_proper   risk_limit
## 1_financial_risk   1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk    7.536279e-04 6.512246e-03 7.536279e-04 1.504752e-03
## Other_1            3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2            9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   school_risk  unrest_risk   facil_risk proceed_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.504752e-03 1.504752e-03 2.506251e-03 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_widen   risk_creat risk_monitor   risk_accid
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.004003e-03 2.005501e-03 1.755127e-03 1.254377e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   remain_risk  risk_annual  risk_author  risk_report
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.755127e-03 1.504752e-03 7.536279e-04 1.755127e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   dollar_risk    date_risk risk_constrain     risk_one
## 1_financial_risk 1.909695e-06 1.909695e-06   1.909695e-06 1.909695e-06
## 2_societal_risk  7.536279e-04 2.503747e-06   1.504752e-03 1.504752e-03
## Other_1          3.592444e-06 3.592444e-06   3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 2.829958e-03   9.401854e-06 9.401854e-06
##                    crime_risk corrupt_risk    risk_time   risk_assur
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.504752e-03 1.504752e-03 7.536279e-04 1.004003e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                   carbon_risk risk_bitumen risk_canadian   liabl_risk
## 1_financial_risk 1.909695e-06 1.909695e-06  1.909695e-06 1.909695e-06
## 2_societal_risk  3.007000e-03 7.536279e-04  7.536279e-04 1.004003e-03
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                   forego_risk risk_assumpt treatment_risk  medium_risk
## 1_financial_risk 1.909695e-06 1.909695e-06   1.909695e-06 1.909695e-06
## 2_societal_risk  1.004003e-03 1.004003e-03   1.004003e-03 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06   3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06   9.401854e-06 9.401854e-06
##                    speci_risk complex_risk   risk_repay  manner_risk
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  2.255876e-03 7.536279e-04 7.536279e-04 7.536279e-04
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                    risk_audit risk_statement risk_accompani     tax_risk
## 1_financial_risk 1.909695e-06   1.909695e-06   1.909695e-06 1.909695e-06
## 2_societal_risk  1.755127e-03   1.004003e-03   7.536279e-04 2.255876e-03
## Other_1          3.592444e-06   3.592444e-06   3.592444e-06 3.592444e-06
## Other_2          9.401854e-06   9.401854e-06   9.401854e-06 9.401854e-06
##                    risk_organ risk_transcanada transcanada_risk    risk_vice
## 1_financial_risk 1.909695e-06     1.909695e-06     1.909695e-06 1.909695e-06
## 2_societal_risk  2.255876e-03     4.258874e-03     2.005501e-03 1.504752e-03
## Other_1          3.592444e-06     3.592444e-06     3.592444e-06 3.592444e-06
## Other_2          9.401854e-06     9.401854e-06     9.401854e-06 9.401854e-06
##                      risk_gas   risk_power greatest_risk    risk_baa1
## 1_financial_risk 1.909695e-06 1.909695e-06  1.909695e-06 1.909695e-06
## 2_societal_risk  1.254377e-03 2.506251e-03  7.536279e-04 2.506251e-03
## Other_1          3.592444e-06 3.592444e-06  3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06  9.401854e-06 9.401854e-06
##                  risk_discuss  expert_risk  risk_energi   risk_peopl
## 1_financial_risk 1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk  1.504752e-03 7.536279e-04 3.507750e-03 2.255876e-03
## Other_1          3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2          9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  risk_unforeseen   ethic_risk assumpt_risk   spill_risk
## 1_financial_risk    1.909695e-06 1.909695e-06 1.909695e-06 1.909695e-06
## 2_societal_risk     1.254377e-03 1.504752e-03 2.255876e-03 7.536279e-04
## Other_1             3.592444e-06 3.592444e-06 3.592444e-06 3.592444e-06
## Other_2             9.401854e-06 9.401854e-06 9.401854e-06 9.401854e-06
##                  infrastructur_risk    risk_area    cobe_risk risk_complianc
## 1_financial_risk       1.909695e-06 1.909695e-06 1.909695e-06   1.909695e-06
## 2_societal_risk        1.504752e-03 1.254377e-03 2.503747e-06   7.536279e-04
## Other_1                3.592444e-06 3.592444e-06 3.592444e-06   3.592444e-06
## Other_2                9.401854e-06 9.401854e-06 4.710329e-03   9.401854e-06
##                  risk_throughout risk_wastewat
## 1_financial_risk    1.909695e-06  1.909695e-06
## 2_societal_risk     7.536279e-04  7.536279e-04
## Other_1             3.592444e-06  3.592444e-06
## Other_2             9.401854e-06  9.401854e-06

Model Fitness check

bigram_fig_modelfit <- plot_modelfit(out_bigrams_base)
bigram_fig_modelfit

save_fig(bigram_fig_modelfit, "figures/base_modelfit.pdf", width = 7, height = 5)

If the model is working as expected, we would observe an increase trend for the log-likelihood and an decrease trend for the perplexity.

visualized 𝜶, the prior for the document-topic distribution, and 𝝅, the probability that each topic uses keyword topic-word distribution

base_model_alpha <- plot_alpha(out_bigrams_base)
base_model_pi <- plot_pi(out_bigrams_base)
save_fig(base_model_alpha, "figures/base_model_alpha.jpg", width = 7, height = 5)
save_fig(base_model_pi, "figures/base_model_pi.jpg", width = 7, height = 5)

Values of these parameters should also stabilize over time.

## ## KeyATM with covariates ## ##

vars <- docvars(aif_dfm_bigram)
head(vars)
##      num type             company date
## 1 800558  AIF SNC-LavalinGroupInc 2001
## 2 800559  AIF SNC-LavalinGroupInc 2002
## 3 800560  AIF SNC-LavalinGroupInc 2003
## 4 800561  AIF SNC-LavalinGroupInc 2004
## 5 800562  AIF SNC-LavalinGroupInc 2005
## 6 800563  AIF SNC-LavalinGroupInc 2006

A set of covariates (derived from metadata)

library(dplyr)
vars_selected <- vars %>%
  as_tibble() %>%
  mutate(Period = case_when(date <= 2011 ~ "2000-2010",
                            TRUE ~ "2011-2020")) %>%
  mutate(Company = case_when(company == "SNC-LavalinGroupInc" ~ "SNC-LavalinGroupInc",
                             company == "SunLifeFinancialInc" ~ "SunLifeFinancialInc",
                             company == "SuncorEnergyInc" ~ "SuncorEnergyInc")) %>%
  select(Period, Company)
table(vars_selected)
##            Company
## Period      SNC-LavalinGroupInc SuncorEnergyInc SunLifeFinancialInc
##   2000-2010                  11              19                  12
##   2011-2020                   9              18                   9

Baseline = SNC-LavalinGroupInc (can be changed)

vars_selected <- vars_selected %>%
  mutate(Company  = factor(Company,
                         levels = c("SNC-LavalinGroupInc", "SuncorEnergyInc", "SunLifeFinancialInc")),
         Period = factor(Period,
                         levels = c("2000-2010", "2011-2020")))

head(model.matrix(~ Company + Period, data = vars_selected))
##   (Intercept) CompanySuncorEnergyInc CompanySunLifeFinancialInc Period2011-2020
## 1           1                      0                          0               0
## 2           1                      0                          0               0
## 3           1                      0                          0               0
## 4           1                      0                          0               0
## 5           1                      0                          0               0
## 6           1                      0                          0               0

#Fitting the model with covariates

out_bigrams_cov <- keyATM(docs          = keyATM_aif_bigram,
              no_keyword_topics = 2,
              keywords          = aif_dic_bigrams,
              model             = "covariates",
              model_settings    = list(covariates_data    = vars_selected,
                                       covariates_formula = ~ Company + Period),
              options           = list(seed = 250))
#save the model with save() for replication
covariates_info(out_bigrams_cov)
## Colnames: (Intercept), CompanySuncorEnergyInc, CompanySunLifeFinancialInc, Period2011-2020
## Standardization: non-factor
## Formula: ~ Company + Period
## 
## Preview:
##   (Intercept) CompanySuncorEnergyInc CompanySunLifeFinancialInc Period2011-2020
## 1           1                      0                          0               0
## 2           1                      0                          0               0
## 3           1                      0                          0               0
## 4           1                      0                          0               0
## 5           1                      0                          0               0
## 6           1                      0                          0               0
used_covariates <- covariates_get(out_bigrams_cov)
head(used_covariates)
##   (Intercept) CompanySuncorEnergyInc CompanySunLifeFinancialInc Period2011-2020
## 1           1                      0                          0               0
## 2           1                      0                          0               0
## 3           1                      0                          0               0
## 4           1                      0                          0               0
## 5           1                      0                          0               0
## 6           1                      0                          0               0

Model Fitness check

bigram_cov_fig_modelfit <- plot_modelfit(out_bigrams_cov)
bigram_cov_fig_modelfit

save_fig(bigram_cov_fig_modelfit, "figures/bigram_cov_fig_modelfit.jpg", width = 7, height = 5)
bigram_model_alpha <- plot_pi(out_bigrams_cov)
save_fig(bigram_model_alpha, "figures/bigram_model_alpha.jpg", width = 7, height = 5)

#Covariates and document-topic distributions

the marginal posterior means of document-topic distributions for each value of (discrete) covariates.

strata_topic <- by_strata_DocTopic(out_bigrams_cov, by_var = "Period2011-2020",
                                   labels = c("2000-2010", "2011-2020"))
fig_doctopic <- plot(strata_topic, var_name = "Period", show_topic = c(1, 2))
fig_doctopic

save_fig(fig_doctopic, "figures/fig_doctopic.jpg", width = 7, height = 5)
fig_doctopic_cov <- plot(strata_topic, var_name = "Period",
                     show_topic = c(1, 2), by = "covariate")
fig_doctopic_cov

90% CI of the differences in the mean of document-topic distribution

theta1 <- strata_topic$theta[[1]]  # 2000-2010
theta2 <- strata_topic$theta[[2]]  # 2011-2020
theta_diff <- theta1[, c(1, 2)] - theta2[, c(1, 2)]  # focus on two topics
theta_diff_quantile <- apply(theta_diff, 2, quantile, c(0.05, 0.5, 0.95))
theta_diff_quantile
##     1_financial_risk 2_societal_risk
## 5%       -0.08322426     -0.03312140
## 50%      -0.01615150      0.01577279
## 95%       0.05270171      0.11607188

## ## Predicted mean of the document-topic distribution for three companies ## ##

strata_suncor <- by_strata_DocTopic(out_bigrams_cov, by_var = "CompanySuncorEnergyInc",
                                 labels = c("Non-SuncorEnergyInc", "SuncorEnergyInc"))
strata_sunlife <- by_strata_DocTopic(out_bigrams_cov, by_var = "CompanySunLifeFinancialInc",
                                 labels = c("Non-SunLifeFinancialInc", "SunLifeFinancialInc"))

est_suncor <- summary(strata_suncor)[["SuncorEnergyInc"]]  # Republican data
est_sunife <- summary(strata_sunlife)[["SunLifeFinancialInc"]]  # Democratic data

Setting the baseline for SNC-LavalinGroupInc

new_data <- covariates_get(out_bigrams_cov)

# Setting both Republican and Democratic dummy to 0 means `Others`
new_data[, "CompanySuncorEnergyInc"] <- 0
new_data[, "CompanySunLifeFinancialInc"] <- 0
pred <- predict(out_bigrams_cov, new_data, label = "SNC-LavalinGroupInc")

Plot of marginal posterior means of document-topic distributions and the 90% confidence intervals of them for each value of covariates

res <- bind_rows(est_suncor, est_sunife, pred) %>%
          filter(TopicId %in% c(1, 2))  # Select two topics
labels <- unique(res$label)

library(ggplot2)
final_plot<-ggplot(res, aes(x = label, ymin = Lower, ymax = Upper, group = Topic)) +
  geom_errorbar(width = 0.1) +
  coord_flip() +
  facet_wrap(~Topic) +
  geom_point(aes(x = label, y = Point)) +
  scale_x_discrete(limits = rev(labels)) +
  xlab("Company") +
  ylab(expression(paste("Mean of ", theta))) +
  theme_bw()

save_fig(fig_doctopic, "figures/final_plot.jpg", width = 7, height = 5)

Covariates and topic-word distribution

This demonstrates top words associated to each topic for AIFs from different companies using the Company covariate.

cov_tw_dist_out <- keyATM(docs       = keyATM_aif_bigram,
              no_keyword_topics = 2,
              keywords          = aif_dic_bigrams,
              model             = "covariates",
              model_settings    = list(covariates_data    = vars_selected,
                                       covariates_formula = ~ Company + Period),
              options           = list(seed = 250),
              keep              = c("Z", "S"))
strata_tw <- by_strata_TopicWord(cov_tw_dist_out, keyATM_aif_bigram,
                                 by = as.vector(vars_selected$Company))
top_words(strata_tw, n = 5)
## $`SNC-LavalinGroupInc`
##   1_financial_risk 2_societal_risk       Other_1      Other_2
## 1 risk_uncertainti     risk_associ   risk_review risk_potenti
## 2      risk_factor inform_risk [✓] chairman_risk  execut_risk
## 3       risk_manag     risk_factor  certain_risk   futur_risk
## 4 project_risk [✓]     risk_includ  exchang_risk perform_risk
## 5      risk_assess      risk_relat   improv_risk risk_foreign
## 
## $SunLifeFinancialInc
##   1_financial_risk      2_societal_risk     Other_1         Other_2
## 1       risk_manag environment_risk [✓]  risk_manag credit_risk [1]
## 2      risk_factor       polit_risk [✓] risk_review       risk_risk
## 3  market_risk [✓]          risk_factor   risk_base       risk_aris
## 4   insur_risk [✓]          risk_associ  risk_relat       oper_risk
## 5 risk_financi [✓]      inform_risk [✓]   rate_risk  manag_risk [1]
## 
## $SuncorEnergyInc
##   1_financial_risk      2_societal_risk       Other_1         Other_2
## 1       risk_manag          risk_factor     also_risk     execut_risk
## 2      risk_factor          risk_associ   canada_risk credit_risk [1]
## 3    busi_risk [✓]     risk_uncertainti committe_risk       risk_also
## 4 risk_uncertainti           risk_manag  continu_risk    risk_possibl
## 5  credit_risk [✓] environment_risk [✓]   differ_risk    risk_product