Ladies do love to dance. But its fine if you don't know how.
Here's a trick that I learned to turn your weakness into a strength.
You're at a party, you're talking to a girl, you're having a good conversation. You see her vibing to the music, she probably wants to dance.
DONT BE ALARMED!
You kinda bring it up, she expresses her desire to dance.
Here's the golden line:
"I don't know how to dance, but you can teach me"
(or some variation)
It sounds weird. But it'll eliminate the awkwardness/shock of revealing yourself as a bad dancer. If you're going to look stupid on the dancefloor, smoothly giving her a heads up about it is only going to help you out.
And it gives her something more to DO with you.
Ladies love a good dancer, but they also love to feel like they're bonding with a guy.
And hell, you might even learn to dance.
Go forth and prosper.