Shifting Non-Nan Values in Multiple Columns Row-Wise by Group with Pandas

Modifying Serial Numbers in Pandas DataFrames Using .loc and shift()