Code
bop_euins6_q %>%
left_join(currency, by = "currency") %>%
group_by(currency, Currency) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| currency | Currency | Nobs |
|---|---|---|
| EUR | Euro | 12356481 |
Data - Eurostat
bop_euins6_q %>%
left_join(currency, by = "currency") %>%
group_by(currency, Currency) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| currency | Currency | Nobs |
|---|---|---|
| EUR | Euro | 12356481 |
bop_euins6_q %>%
left_join(bop_item, by = "bop_item") %>%
group_by(bop_item, Bop_item) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}bop_euins6_q %>%
left_join(sector10, by = "sector10") %>%
group_by(sector10, Sector10) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| sector10 | Sector10 | Nobs |
|---|---|---|
| S1 | Total economy | 6549860 |
| S13 | General Government | 5054975 |
| S12M | Financial corporations other than MFIs | 751646 |
bop_euins6_q %>%
left_join(sectpart, by = "sectpart") %>%
group_by(sectpart, Sectpart) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| sectpart | Sectpart | Nobs |
|---|---|---|
| S1 | Total economy | 7959670 |
| S13 | General Government | 4124232 |
| S1P | Other sectors than MFIs and general government | 255939 |
| S1W | Other sectors than General Government | 16640 |
bop_euins6_q %>%
left_join(stk_flow, by = "stk_flow") %>%
group_by(stk_flow, Stk_flow) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| stk_flow | Stk_flow | Nobs |
|---|---|---|
| BAL | Balance | 4881214 |
| DEB | Debit | 4111381 |
| CRE | Credit | 1806511 |
| ASS | Assets | 737426 |
| NET | Net | 725409 |
| LIAB | Liabilities | 94540 |
bop_euins6_q %>%
left_join(partner, by = "partner") %>%
group_by(partner, Partner) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}bop_euins6_q %>%
left_join(geo, by = "geo") %>%
group_by(geo, Geo) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| geo | Geo | Nobs |
|---|---|---|
| EUI_X_EAI | EU institutions except the institutions of the euro area (aggregate changing according to the context) | 5261198 |
| COMM | European Commission | 4955165 |
| EDF | European Development Fund | 1283782 |
| EIB | European Investment Bank (EIB) | 856336 |