/Python/Drop duplicates pandas considering lowercase

Drop duplicates pandas considering lowercase

result_df = df.apply(lambda x: x.astype(str).str.lower()).drop_duplicates(subset=['Column1', 'Column2'], keep='first')

print(result_df)
  Column1   Column2 Column3
0   'cat'     'bat'   'xyz'
1   'toy'  'flower'   'abc'

Source: stackoverflow.com

Similar codes

2 votes192 views1 answer
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb0 in position 1968: invalid start byte
Python
0 vote188 views1 answer
Open chrome with python stack overflow
Python
0 vote233 views1 answer
File "pandas/_libs/index.pyx", line 465, in pandas._libs.index.DatetimeEngine.get_loc KeyError: Timestamp('2019-01-02 07:09:00')
Python
-1 vote220 views1 answer
How to scan directory recursively python
Python
1 vote135 views1 answer
Take columns to rows in pandas
Python
2 votes190 views2 answers
Pandas find all rows not null
Python
14 votes213 views1 answer
Pd.to_datetime python
Python
-1 vote174 views1 answer
Show all text contained in a line pandaq
Python
0 vote224 views1 answer
Django cms api
Python Django
1 vote195 views1 answer
Get int64 column pandas
Python