Relative Content

Tag Archive for pythonpandasexceldatabasedataframe

Having a hard time removing duplicates between separate columns after merging dataframes in pandas

I’m comparing to excel sheets and I created dataframes from an identical column from each file. I’m trying to output the compared dataframes to a new excel file however I only want the unique values from each column(a last week vs what changed this week kind of deal). The columns themselves will never have any duplicate data and .drop_duplicates isn’t giving the desired outcome. Is there a method or arguement I’m missing to make this work?