So we need to specifically mention that if we get an index error (which means we are checking the last value) we want to merge or write until the last row of the dataframe.Ĥc) Finally i did not take into consideration if the column contains blank or null cells. In that case we need to replace the merge_range with the write method.Ĥb) With this algorithm you 'll get an index error when trying to write the last value of the list (because it is comparing it with the value in the next index postion, and because it is the last value of the list there is not a next index position). For that purpose create a list and add the first row 1 because we will start for sure from there.Ĥ) Then start iterating over the rows of that list and check some conditions:Ĥa) If we only have one row with a value the merge_range method will give an error because it can not merge one cell. Your logic is almost correct, however i approached your problem through a slightly different approach:ġ) Sort the column, make sure that all the values are grouped together.Ģ) Reset the index (using reset_index() and maybe pass the arg drop=True).ģ) Then we have to capture the rows where the value is new. #from there apply rge_range('A0:A2','', merge_format) for example lets say rows 0-2 are similar I would get 'A0:A2' which I can then put in the code below #find starting point based off index, then get range by adding number of rows to starting point. #3.Based off the length run the merge_range function from xlsxwriter, rge_range('range_found_from_loop','Name', merge_format)įor row_index in range(1,len(car_report)): #2.Get the length of the rows that have the same Name #1.Loop through data frame where row n Name = row n -1 Name rge_range('A3:A4','value you want in merged cells', merge_format) Here is what I have thus far: #This is the logic you use to merge cells in xlsxwriter (just an example) (As you can see based off the image above I'm trying to merge cells under the Name column when they have the same values). However I'm trying to apply some rule-based formatting specifically trying to merge cells that have the same value, but having trouble coming up with how to write the loop. I'm trying to output a Pandas dataframe into an excel file using xlsxwriter.

Find and merge duplicate rows in excel