import_balance_sheets: Import balancete CSV files with flexible header detection

In bacenR: Access Data from Brazilian Central Bank: IFdata, Active Institutions, Balance Sheets and Normative Acts

Import balancete CSV files with flexible header detection

Description

Imports CSV files from BCB by detecting the header line that contains the tokens "DOCUMENTO", "CONTA", and "SALDO" (case-insensitive). Automatically renames columns and removes unnecessary fields.

This function is intended for internal use by tidy_balance_sheets()

Usage

import_balance_sheets(file_paths)

Arguments

file_paths

Character vector of file paths to import.

Details

For each file:

1. Reads line-by-line searching for a header containing DOCUMENTO, CONTA, and SALDO

2. Auto-detects delimiter (⁠;⁠, ⁠,⁠, or whitespace)

3. Imports using data.table::fread for speed and robustness

4. Renames: DATA_BASE/DATA BASE/#DATA_BASE -> DATA, NOME INSTITUICAO -> nome_instituicao

5. Removes columns: ATRIBUTO, NOME CONTA, AGENCIA, COD_CONGL, NOME_CONGL, TAXONOMIA, NOME_CONTA

6. Returns combined data.frame from all files

Value

A data.frame combining all imported files, or NULL if no valid files.

bacenR documentation built on Oct. 24, 2026, 1:07 a.m.