Why pd.concat Doesn't Behave as Expected When Appending a Series with an Index Matching Columns

Understanding Pandas Dataframe Manipulation Through Concatenation and Transposition