Pandas Data Manipulation with Missing Values: Understanding the Discrepancy in Inter Group Length

Applying Pandas Series to Append Rows to an Existing DataFrame