read_ABS: reads in a sheet from a standard ONS ABS spreadsheet

Description Usage Arguments Value

Description

Expects a 'standard' ABS spreadsheet as published at (link). Applies standard column names and variable types, skips the first 8 header lines, and removes blank lines. Fills down SIC codes into empty cells, but does not do this for SIC descriptions, since some are displayed on multiple lines.

Usage

1
read_ABS(file, sheet)

Arguments

file

spreadsheet file name

sheet

spreadsheet sheet name

Value

a data frame


lee269/TFP documentation built on May 14, 2019, 2:08 p.m.