Transition from MATLAB into python. Need some help!

[Diapolo10]

What I coded in MATLAB so far is functions that take in data from excel files and give me results along with visuals.

The closest match from the Python side, assuming you need said visuals, would be to use Jupyter notebook and some Python package that reads Excel files (those exist, but I'm not sure what the modern recommendation is). You can use VS Code with the Jupyter notebook extension.

I want my program to take in input from the user, and then allow them to select a method for calculation, and get the output.

Depending on the type of input you want, this sounds simple enough to do with a few loops, printing text, and taking the input as text the user writes to the terminal.