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.
| Check | Result |
|---|---|
| Sheet rows read | 122 |
| Header row | Excel row 4 |
| Title rows above the header | 3 |
| Rows kept as RFI records | 112 |
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.
| Field | Blank rows | Filled rows |
|---|---|---|
| rfi_number | 0 | 112 |
| from_party | 5 | 107 |
| tasked_to | 5 | 107 |
| date_received | 5 | 107 |
| question | 5 | 107 |
| response | 13 | 99 |
| notes | 40 | 72 |
| status_raw | 112 | 0 |
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.
| Measure | Characters |
|---|---|
| Shortest question | 66 |
| Median question | 464 |
| Longest question | 2,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.
| Measure | Characters |
|---|---|
| Shortest response | 6 |
| Median response | 111 |
| Longest response | 737 |
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.
| FROM | RFIs |
|---|---|
| DAVID BOLAND, INC | 71 |
| Carbon Recall Chattanooga | 11 |
| Dobco, Inc. | 8 |
| Richard Group LCC | 8 |
| Willdan | 8 |
| Schweitzer Engineering Laboratories, Inc. | 1 |
| Blank | 5 |
Section 10Tasked parties
TASKED shows who was asked to answer. AE is the main reviewer. A few rows name more than one party.
| TASKED | RFIs |
|---|---|
| AE | 66 |
| CT | 15 |
| PM | 9 |
| JBMDL | 8 |
| AE/JBMDL | 4 |
| AE/JBMDL/PM | 1 |
| AE/PM | 1 |
| CT/PM | 1 |
| JBMDL/AE | 1 |
| USACE DB | 1 |
| Blank | 5 |