Appending rows to a dataframe is seemingly inconsistent and confusing