/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

0 vote310 views1 answer
Flask mongoengine getting started
Python
2 votes323 views3 answers
How to get local ip in python
Python
1 vote324 views1 answer
Nlargest hierarchy series pandas
Python
3 votes337 views1 answer
Plotly not showing in jupyter
Python
1 vote346 views1 answer
How to replace the last character of a string in python
Python
0 vote320 views1 answer
Right-left staircase python
Python
1 vote339 views1 answer
Issue Pandas TypeError: no numeric data to plot
Python
2 votes358 views2 answers
Python sort file names with numbers
Python
0 vote285 views1 answer
Accumulator programming python
Python
0 vote308 views1 answer
Size of the query process in python BigQuery
Python