input_file_path_1=file_location+'\\input\\sludgeDatasetFromOriginal.tsv'#'input/sludgeWithSmiles.tsv' "Your concatenate the different iterations, so your index is not continuous!!!!"
rateconstant=row['rateconstant']/row['total_suspended_solids_concentration_start']# I think the possible problem is that the length between rateconstant and TSS is different
#filter the empty row or the zero value in the merge data
# valid_data = data_merge[data_merge['rateconstant'].notnull() & data_merge['rateconstant'] != 0].copy() #you need to let python know to work on original data or the copy of data, or it might modify your original data