This article shows how to calculate the descriptive analysis on
amount of companies for emission and sector profile.
Example subset of product-level output of transition risk
profile.
| subdermal_chipmunk |
france |
high |
high |
medium |
construction |
construction residential |
retailer |
| subdermal_chipmunk |
france |
high |
high |
high |
construction |
construction residential |
retailer |
| subdermal_chipmunk |
france |
medium |
high |
medium |
construction |
construction residential |
retailer |
| antimonarchy_canine |
germany |
high |
high |
medium |
construction |
construction residential |
distributor |
| antimonarchy_canine |
germany |
high |
high |
high |
construction |
construction residential |
distributor |
| antimonarchy_canine |
germany |
medium |
high |
medium |
construction |
construction residential |
distributor |
| nonphilosophical_llama |
germany |
low |
low |
low |
metals |
other metals |
distributor |
| nonphilosophical_llama |
germany |
low |
low |
high |
metals |
other metals |
distributor |
| nonphilosophical_llama |
germany |
low |
low |
medium |
metals |
other metals |
distributor |
| nonphilosophical_llama |
germany |
low |
high |
low |
metals |
other metals |
distributor |
Number of distinct companies
cat("Number of distinct firms: ", n_distinct(transition_risk_product_example$companies_id))
Number of distinct firms: 7
Number of companies that have atleast one product with
emission_profile, with sector_profile, and
with transition_risk_category
cat("Number of firms that have atleast one product with `emission_profile`:", companies_atleast_one_product_with_profile(transition_risk_product_example, "emission_category"))
Number of firms that have atleast one product with
emission_profile: 7
cat("Number of firms that have atleast one product with `sector_profile`:", companies_atleast_one_product_with_profile(transition_risk_product_example, "sector_category"))
Number of firms that have atleast one product with
sector_profile: 7
cat("Number of firms that have atleast one product with `transition_risk_category`:", companies_atleast_one_product_with_profile(transition_risk_product_example, "transition_risk_category"))
Number of firms that have atleast one product with
transition_risk_category: 7
Number of companies that have more than one tilt_sectors
cat("Number of firms that have more than one tilt_sectors: ", companies_with_multiple_tilt_sectors(transition_risk_product_example))
Number of firms that have more than one tilt_sectors: 1
Number of companies that have more than one tilt_subsectors
cat("Number of firms that have more than one tilt_subsectors: ", companies_with_multiple_tilt_subsectors(transition_risk_product_example))
Number of firms that have more than one tilt_subsectors: 1
Number of companies per tilt_sector
# of firms per tilt_sector
|
tilt_sector
|
# of firms
|
|
construction
|
5
|
|
metals
|
3
|
Number of companies per tilt_subsector
# of firms per tilt_subsector
|
tilt_subsector
|
# of firms
|
|
construction residential
|
5
|
|
iron & steel
|
1
|
|
other metals
|
2
|
Number of companies per country
# of firms per country
|
country
|
# of firms
|
|
france
|
1
|
|
germany
|
5
|
|
netherlands
|
2
|
Number of companies per country and tilt_sector
# of firms per country and tilt_sector
|
country
|
tilt_sector
|
# of firms
|
|
france
|
construction
|
1
|
|
germany
|
construction
|
2
|
|
metals
|
3
|
|
netherlands
|
construction
|
2
|
Number of companies per country and tilt_subsector
# of firms per country and tilt_subsector
|
country
|
tilt_subsector
|
# of firms
|
|
france
|
construction residential
|
1
|
|
germany
|
construction residential
|
2
|
|
iron & steel
|
1
|
|
other metals
|
2
|
|
netherlands
|
construction residential
|
2
|
Number of companies per main_activity
# of firms per main_activity
|
main_activity
|
# of firms
|
|
agent/ representative
|
2
|
|
distributor
|
3
|
|
manufacturer/ producer
|
1
|
|
retailer
|
1
|
|
wholesaler
|
1
|
Number of companies per main_activity and tilt_sector
# of firms per main_activity and tilt_sector
|
main_activity
|
tilt_sector
|
# of firms
|
|
agent/ representative
|
construction
|
1
|
|
distributor
|
construction
|
2
|
|
retailer
|
construction
|
1
|
|
wholesaler
|
construction
|
1
|
Number of companies per main_activity and tilt_subsector
# of firms per main_activity and tilt_subsector
|
main_activity
|
tilt_subsector
|
# of firms
|
|
agent/ representative
|
construction residential
|
1
|
|
other metals
|
1
|
|
distributor
|
construction residential
|
2
|
|
other metals
|
1
|
|
manufacturer/ producer
|
iron & steel
|
1
|
|
retailer
|
construction residential
|
1
|
|
wholesaler
|
construction residential
|
1
|
Number of companies per main_activity and country
# of firms per main_activity and country
|
main_activity
|
country
|
# of firms
|
|
agent/ representative
|
germany
|
1
|
|
netherlands
|
1
|
|
distributor
|
germany
|
2
|
|
netherlands
|
1
|
|
manufacturer/ producer
|
germany
|
1
|
|
retailer
|
france
|
1
|
|
wholesaler
|
germany
|
1
|
Number of companies per main_activity, country, and tilt_sector
# of firms per main_activity, country, and tilt_sector
|
main_activity
|
country
|
tilt_sector
|
# of firms
|
|
agent/ representative
|
germany
|
metals
|
1
|
|
netherlands
|
construction
|
1
|
|
distributor
|
germany
|
construction
|
1
|
|
metals
|
1
|
|
netherlands
|
construction
|
1
|
|
manufacturer/ producer
|
germany
|
metals
|
1
|
|
retailer
|
france
|
construction
|
1
|
|
wholesaler
|
germany
|
construction
|
1
|