How would I go about finding the date_of_birth or "What is the birth date of [investor_name]?" in a sheet with this format?
The headers are consistent, although it's all over the place. It doesn't stay in one column but it's sure to exist.
According to this answer, my only option is iterrow since I rely on the value one row previous the one I need.
