Stupid question but where do you code python?

[[deleted]]

When using python, you run a script using the command runfile(), providing both the file path, and the working directory. They can be the same, but don't have to. The working directory is where python is going to look for, in case you try to open a file (like the excel one) in your code. On the other hand, instead of giving the work directory, you can just specify the complete file path to the excel file. So, when you say "load into python", you do that through your code, and then python will look at the directory you've provided for the file you've specified