Might be the stupidest question here: What do programmers actually do?

Last year I decided to slightly tilt my career towards data analysis. Python was part of my studying, accompanied by deeper knowledge of statistics, SQL and other stuff. Last two months I have solely spent on studying Python due to genuine interest. I barely touch other subjects as they seem boring now. I never considered to become a programmer. But now I question if I were one what would it be?

Generally, I understand that software developers create... software, either web, desktop, cloud or else. But I wonder how different real job from exercises? Obviously, you don't get tasks like calculating variations of cash change or creating cellular automata. But is the workflow the same? You get a task with requirements on I/O, performance etc., and are supposed to deliver code?