6.401 – Capital fixe brut total (AN.11) par branche - encours en fin d’année à prix courants (En milliards d’euros) - t_6401

Données - INSEE

Auteur

François Geerolf

year

Code 
t_6401 |>
  group_by(year) |>
  summarise(Nobs = n()) |>
  print_table_conditional()

2019

Simplifié - 38 postes

Code 
t_6401 |>
  filter(year == "2020") |>
  select(-year) |>
  mutate(share = round(100*value/ value[sector == "TOTAL"], 1)) |>
  mutate(value = round(value) |> paste0(" Mds€")) |>
  arrange(-share) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Return

Code 
t_6401 |>
  rename(fixed_assets = value) |>
  left_join(t_6207, by = c("sector", "Sector", "year")) |>
  rename(revenue = value) |>
  mutate(return = revenue/fixed_assets) |>
  filter(year == "2019") |>
  select(sector, Sector, fixed_assets, revenue, return) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}