I think I am an idiot.
What did you do to feel that way?
I failed even in the easiest things, like walking down the street and making friends.
You can certainly walk down the street! Some people are shy. You need to go outside your comfort zone, join a club or a gym.
But I'm also bad at being a good friend.
You can improve on that too! Plenty of people are shy like that, and thinking positively will definitely help you try to get more friends. If you're always a ray of sunshine, people would want to be around you.