Calculating Development Column from Previous Two Columns in SQL Using Window Functions and Conditional Aggregation

Pandas Equivalent of Excel Concatenation for Column Values - Python 3