Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In your applymap, don't include 'The Beatles' if not found:
.
Applymap('AlbumMusica_MAP', Artist) as Artist,
..
In your applymap, don't include 'The Beatles' if not found:
.
Applymap('AlbumMusica_MAP', Artist) as Artist,
..
This worked, thank you so much Lisa