2DegreesInvesting / tiltToyData

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

'emissions' (inputs) products gain the column `(input_)tilt_subsector` #6

Closed maurolepore closed 10 months ago

maurolepore commented 10 months ago

This PR adds columns that @kalashsinghal requested. They come from raw data in tiltIndicator v0.0.0.9088.

library(tiltToyData)
library(dplyr, warn.conflicts = FALSE)
library(readr, warn.conflicts = FALSE)

read_csv(toy_emissions_profile_products()) |> 
  relocate(matches("subsector"))
#> Rows: 5 Columns: 7
#> ── Column specification ────────────────────────────────────────────────────────
#> Delimiter: ","
#> chr (5): tilt_sector, tilt_subsector, unit, activity_uuid_product_uuid, ei_a...
#> dbl (2): co2_footprint, isic_4digit
#> 
#> ℹ Use `spec()` to retrieve the full column specification for this data.
#> ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
#> # A tibble: 5 × 7
#>   tilt_subsector co2_footprint tilt_sector    unit  isic_4digit
#>   <chr>                  <dbl> <chr>          <chr>       <dbl>
#> 1 Other                 176.   Industry       unit         2560
#> 2 Other                  58.1  Industry       unit         2560
#> 3 Steel                   4.95 Steel & Metals kg           2870
#> 4 Agriculture            12.5  Agriculture    kg           1780
#> 5 Other                   2.07 Industry       kg           2679
#> # ℹ 2 more variables: activity_uuid_product_uuid <chr>, ei_activity_name <chr>

read_csv(toy_emissions_profile_upstream_products()) |> 
  relocate(matches("subsector"))
#> Rows: 33 Columns: 7
#> ── Column specification ────────────────────────────────────────────────────────
#> Delimiter: ","
#> chr (5): input_tilt_sector, input_tilt_subsector, input_unit, input_activity...
#> dbl (2): input_co2_footprint, input_isic_4digit
#> 
#> ℹ Use `spec()` to retrieve the full column specification for this data.
#> ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
#> # A tibble: 33 × 7
#>    input_tilt_subsector input_co2_footprint input_tilt_sector input_unit
#>    <chr>                              <dbl> <chr>             <chr>     
#>  1 Other                            7.07e+0 Inudstry          kg        
#>  2 Other                            3.99e+1 Inudstry          kwh       
#>  3 Other                            5.12e-1 Inudstry          kg        
#>  4 Other                            1.24e+0 Inudstry          kg        
#>  5 Other                            2.12e+1 Inudstry          kwh       
#>  6 Other                            1.24e-9 Inudstry          kg        
#>  7 Other                            7   e-9 Inudstry          kg        
#>  8 Other                            1.04e+0 Inudstry          kg        
#>  9 Other                            1.12e+0 Inudstry          kg        
#> 10 Other                            3.51e+0 Inudstry          kg        
#> # ℹ 23 more rows
#> # ℹ 3 more variables: input_isic_4digit <dbl>,
#> #   input_activity_uuid_product_uuid <chr>, activity_uuid_product_uuid <chr>

Created on 2023-08-29 with reprex v2.0.2


TODO

EXCEPTIONS