Report ยท Chapter 2

Raw data profile

What the first read of the USACE RFI workbook showed, before any cleaning or interpretation.

Source: data/raw/rfi_log.xlsx Read only 3 October 2026
Pale blueprint of a tower crane and an open building frame.

Section 1Workbook shape

01_raw_data_profiling.py opened data/raw/rfi_log.xlsx and did not change the workbook. The sheet has title rows above the real table.

CheckResult
Sheet rows read122
Header rowExcel row 4
Title rows above the header3
Rows kept as RFI records112

The header columns are RFI #, FROM, TASKED, DATE RECEIVED, QUESTION, RESPONSE, NOTES, and Status. The three rows above that header are title rows, not RFI records.

Section 2Missing values

Every kept row has an RFI identifier. Five rows have an identifier and no submitting party, tasked party, date, or question.

FieldBlank rowsFilled rows
rfi_number0112
from_party5107
tasked_to5107
date_received5107
question5107
response1399
notes4072
status_raw1120

Section 3Duplicate RFI IDs

No RFI number is repeated. The 112 identifiers are unique, so a later duplicate check does not have to merge conflicting records.

Section 4Dates

107 rows have a received date. All 107 values are Excel serial numbers, not formatted calendar dates. Date conversion belongs in the cleaning step, not in this profile.

Section 5Question length

107 questions contain text. The questions are long engineering notes, not short titles.

MeasureCharacters
Shortest question66
Median question464
Longest question2,217

Section 6Response completeness

99 of 112 records have response text. Thirteen responses are blank. Where a response exists, it is usually shorter than the question.

MeasureCharacters
Shortest response6
Median response111
Longest response737

Section 7Notes

72 records have notes. Forty notes are blank. The filled notes are the source for a later document-impact check.

Section 8Status

The Status column is blank on all 112 records. The source does not provide an original status to preserve. Any later status, such as Answered or Open, will be a derived field.

Section 9Submitting parties

FROM shows who submitted the RFI. One contractor accounts for most of the register.

FROMRFIs
DAVID BOLAND, INC71
Carbon Recall Chattanooga11
Dobco, Inc.8
Richard Group LCC8
Willdan8
Schweitzer Engineering Laboratories, Inc.1
Blank5

Section 10Tasked parties

TASKED shows who was asked to answer. AE is the main reviewer. A few rows name more than one party.

TASKEDRFIs
AE66
CT15
PM9
JBMDL8
AE/JBMDL4
AE/JBMDL/PM1
AE/PM1
CT/PM1
JBMDL/AE1
USACE DB1
Blank5