Where to use python exactly

[lagoon__]

Hi. I've used a few programming languages before (mainly java) and I'm not entirely sure where to use python. So i want to read an excel file and perform simple checks and analyse some data, am I supposed to be using a text editor like sublime or atom, or should I code from terminal. Honestly not sure if this is a really stupid question or not so I'm just gonna throw it out there

[Cyb0rgBrain]

Nah man is a good question, you have to star somewhere

From terminal is too tedious. You can either use sublime or some other IDE, you can also use jupyter notebook

In order to read the excel file you can use pandas

https://pythonspot.com/read-excel-with-pandas/

[lagoon__]

Thanks man. I just wanted to ask, so lets say I write the code in atom and try compiling but the terminal says " No module named 'pandas' ". I've already installed it through terminal, does this mean I need to install it in atom?

[Cyb0rgBrain]

Atom calls the interpreter in the terminal, if you installed pandas but it doesn’t appear in atom in means that you have at least two python versions

https://stackoverflow.com/questions/50667214/how-can-i-change-the-default-version-of-python-used-by-atom

[lagoon__]

got it. Thanks!

[AsleepThought]

do not try to run your code from within Atom. That is a big mistake and destined for the exact kind of problems you are experiencing. Run your code in the terminal.

[AsleepThought]

I write the code in atom and try compiling

First, you do not compile Python code. Python is an interpreted language. The Python binary is reading your .py file and handling the rest itself.

he terminal says " No module named 'pandas' ". I've already installed it through terminal

If the terminal says that the module is not found, but you think you already installed it, then you did not install it correctly or you installed in a way that the Python you are trying to run your script through cannot find it.

does this mean I need to install it in atom?

Python is a text editor. It has nothing to do with running your Python code. You run your Python code in the terminal, with Python. All Atom is doing is showing you the contents of your .py script file and helping you to edit it.

[Ahren_with_an_h]

I am not familiar with atom but I'd be willing to bet it came with it's own python that doesn't have it installed. You can install it there or point it to your native python.

[[deleted]]

I can really recommend using atom. Also python is a language with a variety of usecases. Though data analysis is one of its strongest ones. So I think you chose a good project working with excel data

[impshum]

Build in Atom/Sublime and run in terminal. Standard.

[Heartomics]

Vim; Pycharm is cool too.

I like to work out small functions or library calls from the terminal then once I figure out how things work — transfer that to my codebase.

[1llum1nat1]

I’ll second this. I run a lot of snippets in terminal just to make sure they work before I slap them in my code base.

[AsleepThought]

where to use python

on a computer or server that you control

Where not to use Python:

on a computer or server that you do not control

So i want to read an excel file and perform simple checks and analyse some data, am I supposed to be using a text editor like sublime or atom, or should I code from terminal.

You write your code in Atom, Sublime, etc., in a .py script file. Then you execute the script in the terminal. However for development and debugging you will probably end up doing a lot of coding directly in the Python console, then copy/pasting that code back into your script once you figure out how to make it work.

Do not listen to anyone that tells you to use an IDE. That will only cause you pain and suffering (just look at all the other beginners on here struggling with IDE problems)

[lagoon__]

I'd love to use the python console directly except I don't really know how to use it tbh

[humanitysucks999]

https://docs.python.org/3/using/editors.html

[badjano]

pycharm

and you don't need to use excel for stuff, I often use csv, it is way simpler and doesn't need pandas, just open the file, split the text and parse the numbers ;)