Can a magnet erase the memory of a CD or floppy disk?

The best way to clean a floppy disk is with an electromagnet not a regular magnet. If you can put it to the back of a large speaker when the speaker is turned on, that should work. On the other hand, if you wait about 10 years, that will also do it.