Pandas dataframe doesnot append and missing the counter