Python Forum
finding rows with one column distinct and the other column different
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
finding rows with one column distinct and the other column different
#1
Suppose we have the following table:

I am trying to do a duplicate check on only Name and Date column and a check to make sure that Title column is "not" duplicate. Salary column does not matter here.

Name Title Date Salary
Joan Analyst 25 51
Joan Support 25 49
Martha CEO 46 44
Martha CEO 46 10

If i use dedupe=df.drop_duplicates, that would give me only record with Joan. What i need instead is to drop Joan and keep Martha's records.

Any assistance would be much appreciated. Thanks
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Adding PD DataFrame column bsben 2 245 Mar-08-2024, 10:46 PM
Last Post: deanhystad
  Get an average of the unique values of a column with group by condition and assign it klllmmm 0 223 Feb-17-2024, 05:53 PM
Last Post: klllmmm
  Help copying a column from a csv to another file with some extras g0nz0uk 3 403 Feb-01-2024, 03:12 PM
Last Post: DeaD_EyE
  Converting column of values into muliple columns of counts highland44 0 205 Feb-01-2024, 12:48 AM
Last Post: highland44
  Python code to set column width 1418 11 945 Jan-20-2024, 07:20 AM
Last Post: Pedroski55
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 690 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Returning Column and Row Data From Spreadsheet knight2000 0 413 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Find a string from a column of one table in another table visedwings049 8 1,085 Sep-07-2023, 03:22 PM
Last Post: deanhystad
  DF value by Column... not sure what to call it tester_V 2 533 Aug-26-2023, 06:56 PM
Last Post: tester_V
  python sqlite autoincrement in primary column janeik 6 1,075 Aug-13-2023, 11:22 AM
Last Post: janeik

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020