merged npp data into output dataframe