Skip to content

Adds display_tables() method to FBS - #246

Merged
matthewlchambers merged 2 commits into
USEPA:seea-recursivefrom
matthewlchambers:seea-recursive
Jul 11, 2022
Merged

matthewlchambers merged 2 commits into
USEPA:seea-recursivefrom
matthewlchambers:seea-recursive

Conversation

@matthewlchambers

Copy link
Copy Markdown
Contributor

This PR adds to FlowBySector a display_tables() method which generates and saves (as a multi-sheet Excel file) nice display tables, which may be customized (if desired) in the FBS method_yaml, like this:

display_tables:
  <Table 1 title>:
    selection_fields:
      # exactly as used elsewhere
    industry_spec:
      # formatted as elsewhere, but can be used to produce a table that is more aggregated than the underlying FBS
    replace_dict:
      <column>:
        <to_replace>: <new_value>
        <to_replace>: <new_value>
        # etc.

matthewlchambers added 2 commits July 11, 2022 18:08
@matthewlchambers
matthewlchambers merged commit 697cbe4 into USEPA:seea-recursive Jul 11, 2022
@bl-young

Copy link
Copy Markdown
Contributor

@matthewlchambers I saw in one of your recent commits you were working on a summary table by BEA sector. I wanted to alert you to this function which can be used to map a df from NAICS to BEA. It may or may not be useful to you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants