You said you wanted to learn to play piano. So I will just assume you want to become a pianist, and not a keyboardist. May I ask what kind of music you'd like to play? Also, what's your budget?
A few years ago I also started learning piano, with mainly classical music in mind. If that's also your case, I would give the advice to purchase at least a digital piano with weighted hammer action and/or, if your situation allows it, a decent (used) upright. That way you won't put too much money into it, should you decide to quit for whatever reasons. As others said, you can get both if your budget allows. That gives you the best of both worlds.
Frankly, for a total beginner, either a decent acoustic or decent digital should be fine until your level increases. A digital is of course nice for silent play and eventually recording.
The digital piano I started with was a Casio AP-450, which has the same hammer action as the Casio PX-160 (which is around the $500 price point. For some reason, I can't find any online... did it get deprecated?) I can't really say anything wrong about that action, it should do fine for your first few years. And maybe the following ones too, who knows, if you can bear with the action getting noisy
I never had any problem transferring to acoustic pianos, uprights or grands, during lessons or exams, at least for the beginner repertoire I was playing.
Ones I never tried:
- Other sub-$500 DPs which are regularly mentioned on these forums are the Roland FP-10, Yamaha P45, among others.
- A friend of mine got a Roland FP-30 and is so far happy with it, but it already costs more than $500. Also in the same price range: Kawai ES110, Yamaha P125.
Anyway, good luck in your piano journey! It's a fun one (with some difficulties along the road sometimes
)! Piano brought so much to my life I wished I had started as a kid. But it's never too late