Make PX-Files in R
Add cell name to keywords that support it (see px-specification)
Add a data frame as a sheet to an Excel workbook
Add language, other than the main langue, to keyword
Add boolean main_language column
Add a sub key word (see px-specification for details on sub keys)
Add total level to variable
Add total levels to multiple variables
Get data set from aggregation file
Align data frames
Split long strings at commas
Change pivot variables
Regexp that matches a classification file section heading
Create code to construct data frame
Create constructing code
Create a tibble with dummy values
Get languages used in px object
Download parquet or PX-file and return path
Drop rows with only NA values
Add lines numbers
Throw error if argument is not a character string
Throw error
Get section in .vs or .agg file
Fix some common issues in px objects
Format df for px format
Get lines for PX-file from px object
Format time values for PX-file
Get data cube used in PX-file format
Return data table from px object
Default encoding to read and save PX-file in
Get encoding listed in PX-file
Get specific sheet from Excel workbook
Get figures variable from Excel workbook
Get the main language from metadata
A list of which variables should be in each sheet
Get metadata df from px lines
Get metadata df from px object
Get names of pivot variables
Regular expression to parse header in PX-file
Return lines in section
Get time scale code from values (see TIMEVAL in px-specification)
Get time values from TIMEVAL string
Get variable code and label
Guess encoding of file
Check if a path has a specific extension (function factory)
Get a sorted list of distinct values in list
Put two named lists together, remove duplicates and sort
Change language in px object
Change language in table
Add or modify value
Change all variables to character
Create new classification object
Create new px object
Add total levels to variables
AGGREGALLOWED
AUTOPEN
AXIS-VERSION
BASEPERIOD
CELLNOTE
CELLNOTEX
CFPRICES
CHARSET
px classification from data frame
px classification from path
Create a classification object
CODEPAGE
CONFIDENTIAL
CONTACT
CONTENTS
CONTVARIABLE
COPYRIGHT
CREATION-DATE
DATA
DECIMALS
DESCRIPTION
DESCRIPTIONDEFAULT
DOMAIN
ELIMINATION
Change figures variable
Create a minimal px object from a data frame
Create a px object from an Excel workbook
Create a px object form a PX-file
HEADING
INFOFILE
LANGUAGE
LANGUAGES
LAST-UPDATED
LINK
MAP
MATRIX
Create micro PX-files
NEXT-UPDATE
NOTE
NOTEX
OFFICIAL-STATISTICS
Change value order
PRECISION
Save classification as .vs and .agg files
Save px object to file
SHOWDECIMALS
SOURCE
STOCKFA
STUB
SUBJECT-AREA
SUBJECT-CODE
TABLEID
TIMEVAL
TITLE
UNITS
UPDATE-FREQUENCY
Check px object
VALUENOTE
VALUENOTEX
VALUES
Change VARIABLE-LABEL
VARIABLE-TYPE
Create a px object
pxmake: Make PX-Files in R
Add quotes around unless in some very specific cases required by the p...
Get PX-file content as lines
Read lines from file with guessed encoding
Read lines with specific encoding
Impute missing language
Return px object
Save px object to PX-file
Save px object as an R script
Save px object as an Excel workbook
Get index of first and last line of section
Smallest larger value
Sort data table by order
Sort metadata data frame
Add quotes around string
Create and return path to temporary directory
Create temporary file
Add value as data table in x
Check all arguments to px()
Check all arguments to px_classification
Check all arguments to px_data
Check all arguments to px_micro()
Check all arguments to px_save()
Convert a variable to a list
Save classification as .agg file
Save classification as .vs file
Zips list
Create PX-files from scratch or read and modify existing ones. Includes a function for every PX keyword, making metadata manipulation simple and human-readable.
Useful links