Data Cleaning with Mapping

[Rosario_Aguilar]

Hello good afternoon to everyone.

For my learning, I am performing an example of data cleaning.

I download an excel file with data from the following page and add fields, with the intention of cleaning them: https://www.simonsezit.com/article/excel-crash-course-data-cleaning-in-excel-in-1-hour/

I would like to do the following:
1.-Change the data "The Beatles." , "Beatles.", "Beatles" for "The Beatles" with mapping or another form.
2.- Delete rows and columns without data.

I hope you can help me, I'm new.

I did a maping, but apparently I'm not applying it well, because it changes all the artists.

[Lisa_P · Accepted solution]

In your applymap, don't include 'The Beatles' if not found:
.

Applymap('AlbumMusica_MAP', Artist) as Artist,

..

[Rosario_Aguilar]

This worked, thank you so much Lisa