Fix erroneous columns in basic 10k extraction

[katie-lamb]

Overview

During the basic 10K extraction there are some column names that get added to the output like ]fiscal_year_end, ]irs_number, ]state_of_incorporation, instead of fiscal_year_end, irs_number, and state_of_incorporation. While I haven't dug into this yet, this is probably cropping up from a bad field name in the raw basic 10k text itself (an added [ in front of the field name). I think this can be fixed by just stripping special characters from the field names, or defining the schema/field names ahead of time and enforcing that extracted field names fit into these preset fields.

Success Criteria

How will we know that we're done?

• Extracted field names fit into a standard set of columns

Next steps

Preview Give feedback

1. Set standardized field names in basic 10K output table
2. Add cleaning to field names to enforce that standardized field names are met
3. Remove the _remove_weird_sec_cols method from the SEC output processing module