search

2DegreesInvesting / tiltToyData

Toy datasets for TILT
https://2degreesinvesting.github.io/tiltToyData/
GNU General Public License v3.0
0 stars 0 forks source link

Preview: All four datasets have required `isic_4digit` and `input_isic_4digit` columns #16

Closed kalashsinghal closed 7 months ago

kalashsinghal commented 7 months ago

@maurolepore emissions_profile_products and sector_profile_companies require isic_4digit column, and emissions_profile_upstream_products and sector_profile_upstream_products require input_isic_4digit column. All four datasets have the right columns needed for both tiltIndicator and tiltIndicatorAfter. Hence, no PR is needed to correct anything.

Please have a look at the data we already have in tilttoyData:

#> $emissions_profile_products.csv.gz
#> # A tibble: 5 × 7
#>   co2_footprint tilt_sector    tilt_subsector unit  isic_4digit
#>           <dbl> <chr>          <chr>          <chr>       <dbl>
#> 1        176.   Industry       Other          unit         2560
#> 2         58.1  Industry       Other          unit         2560
#> 3          4.95 Steel & Metals Steel          kg           2870
#> 4         12.5  Agriculture    Agriculture    kg           1780
#> 5          2.07 Industry       Other          kg           2679
#> # ℹ 2 more variables: activity_uuid_product_uuid <chr>, ei_activity_name <chr>

#> $emissions_profile_upstream_products.csv.gz
#> # A tibble: 33 × 7
#>    input_co2_footprint input_tilt_sector input_tilt_subsector input_unit
#>                  <dbl> <chr>             <chr>                <chr>     
#>  1             7.07e+0 Inudstry          Other                kg        
#>  2             3.99e+1 Inudstry          Other                kwh       
#>  3             5.12e-1 Inudstry          Other                kg        
#>  4             1.24e+0 Inudstry          Other                kg        
#>  5             2.12e+1 Inudstry          Other                kwh       
#>  6             1.24e-9 Inudstry          Other                kg        
#>  7             7   e-9 Inudstry          Other                kg        
#>  8             1.04e+0 Inudstry          Other                kg        
#>  9             1.12e+0 Inudstry          Other                kg        
#> 10             3.51e+0 Inudstry          Other                kg        
#> # ℹ 23 more rows
#> # ℹ 3 more variables: input_isic_4digit <dbl>,
#> #   input_activity_uuid_product_uuid <chr>, activity_uuid_product_uuid <chr>

#> $sector_profile_companies.csv.gz
#> # A tibble: 28 × 10
#>    companies_id        company_name clustered activity_uuid_produc…¹ isic_4digit
#>    <chr>               <chr>        <chr>     <chr>                        <dbl>
#>  1 fleischerei-stiefs… fleischerei… steel     0faa7ecb-fef2-5117-89…        2410
#>  2 fleischerei-stiefs… fleischerei… steel     0faa7ecb-fef2-5117-89…        2410
#>  3 pecheries-basques_… pecheries-b… nitrogen  03fbf989-9a1a-5e3d-a5…        2029
#>  4 pecheries-basques_… pecheries-b… nitrogen  03fbf989-9a1a-5e3d-a5…        2029
#>  5 hoche-butter-gmbh_… hoche-butte… waste     <NA>                            NA
#>  6 hoche-butter-gmbh_… hoche-butte… waste     <NA>                            NA
#>  7 hoche-butter-gmbh_… hoche-butte… car       <NA>                            NA
#>  8 hoche-butter-gmbh_… hoche-butte… car       <NA>                            NA
#>  9 hoche-butter-gmbh_… hoche-butte… heater    <NA>                            NA
#> 10 hoche-butter-gmbh_… hoche-butte… heater    <NA>                            NA
#> # ℹ 18 more rows
#> # ℹ abbreviated name: ¹​activity_uuid_product_uuid
#> # ℹ 5 more variables: tilt_sector <chr>, tilt_subsector <chr>, type <chr>,
#> #   sector <chr>, subsector <chr>

#> $sector_profile_upstream_products.csv.gz
#> # A tibble: 74 × 10
#>    activity_uuid_product_uuid      input_activity_uuid_…¹ input_reference_prod…²
#>    <chr>                           <chr>                  <chr>                 
#>  1 0a242b09-772a-5edf-8e82-9cb4ba… 5de8c337-dea9-5c1f-9d… biowaste              
#>  2 0a242b09-772a-5edf-8e82-9cb4ba… 5de8c337-dea9-5c1f-9d… biowaste              
#>  3 0a242b09-772a-5edf-8e82-9cb4ba… 1aeb18b9-8355-560f-82… chemical, inorganic   
#>  4 0a242b09-772a-5edf-8e82-9cb4ba… 1aeb18b9-8355-560f-82… chemical, inorganic   
#>  5 0a242b09-772a-5edf-8e82-9cb4ba… 22704506-7707-5ae7-99… chemical, organic     
#>  6 0a242b09-772a-5edf-8e82-9cb4ba… 22704506-7707-5ae7-99… chemical, organic     
#>  7 0a242b09-772a-5edf-8e82-9cb4ba… 92078219-1ed3-5215-9f… cow milk              
#>  8 0a242b09-772a-5edf-8e82-9cb4ba… 92078219-1ed3-5215-9f… cow milk              
#>  9 0a242b09-772a-5edf-8e82-9cb4ba… 9d483329-b09a-5513-b1… cream, from cow milk  
#> 10 0a242b09-772a-5edf-8e82-9cb4ba… 9d483329-b09a-5513-b1… cream, from cow milk  
#> # ℹ 64 more rows
#> # ℹ abbreviated names: ¹​input_activity_uuid_product_uuid,
#> #   ²​input_reference_product_name
#> # ℹ 7 more variables: input_unit <chr>, input_isic_4digit <dbl>,
#> #   input_tilt_sector <chr>, input_tilt_subsector <chr>, type <chr>,
#> #   sector <chr>, subsector <chr>