How do I choose which card to have and which ones to cancel?

Florin J asked: I carry 5 credit cards in my wallet and spend across all the five. Though my expenses are not very high (they will actually fit into a card or two) I just collected these cards over time because the offers were good. Now I want to own just one or two cards. [...]