/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

4 votes55 views1 answer
Pandas display one row
Python
3 votes95 views1 answer
Python copy a dictionary to a new variable
Python
0 vote97 views1 answer
Convert all sizes to terabytes pandas
Python
0 vote100 views1 answer
Take screenshot of video python
Python
2 votes99 views2 answers
Count consecutive values in python
Python
0 vote97 views1 answer
Dictionary increment
Python
5 votes92 views2 answers
Check if dataframe contains infinity
Python
4 votes105 views5 answers
How to find runner up score in python
Python
0 vote130 views1 answer
Get attribute of timestamp python
Python
2 votes100 views1 answer
Graph implementation in python
Python