🔒 i need help with pandas | Python | Page 1

tropic warrenBOT Apr 2, 2024, 3:50 PM

#

@slow ermine

Python help channel opened

Remember to:

Ask your Python question, not if you can ask or if there's an expert who can help.
Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

slow ermine Apr 2, 2024, 3:50 PM

#

how can I solve it

#

cuz with csv reading works

#

but with excel not

#

i need help

stoic nymph Apr 2, 2024, 3:55 PM

#

did you install openpyxl?

sturdy epoch Apr 2, 2024, 3:56 PM

#

@slow ermine you just have to install openpyxl

slow ermine Apr 2, 2024, 3:57 PM

#

ok I'll try then I'll let you know

sturdy epoch Apr 2, 2024, 3:58 PM

#

don't be afraid of error messages. in this case, it told you exactly what the problem was, and the solution.

slow ermine Apr 2, 2024, 4:03 PM

#

when I type pip install openpyxl it in the terminal it gives me an error

sturdy epoch Apr 2, 2024, 4:06 PM

#

slow ermine when I type pip install openpyxl it in the terminal it gives me an error

whenever you get an error, don't say that you got an error. just copy and paste the whole error message into the chat.

slow ermine Apr 2, 2024, 4:07 PM

#

tht error is in italian

sturdy epoch Apr 2, 2024, 4:07 PM

#

that's fine.

slow ermine Apr 2, 2024, 4:07 PM

#

pip : Termine 'pip' non riconosciuto come nome di cmdlet, funzione, programma eseguibile o file script. Controllare l'ortografia del nome o verificare che il percorso sia incluso e corretto, quindi riprovare.
In riga:1 car:1

pip install openpyxl

  + CategoryInfo          : ObjectNotFound: (pip:String) [], CommandNotFoundException
  + FullyQualifiedErrorId : CommandNotFoundException

sturdy epoch Apr 2, 2024, 4:07 PM

#

what command do you do to run the program?

slow ermine Apr 2, 2024, 4:07 PM

#

pip install openpyxl

sturdy epoch Apr 2, 2024, 4:08 PM

#

that's to pip install. not to run the program

slow ermine Apr 2, 2024, 4:08 PM

#

yes

sturdy epoch Apr 2, 2024, 4:08 PM

#

I need the command that you use to run the python program that you are writing

slow ermine Apr 2, 2024, 4:08 PM

#

ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl.

sturdy epoch Apr 2, 2024, 4:08 PM

#

what command did you do to get that error message?

slow ermine Apr 2, 2024, 4:09 PM

#

that the program message

#

mport pandas as pd

file = pd.read_excel('rubi.xlsx')
print(file)

sturdy epoch Apr 2, 2024, 4:09 PM

#

please show a screenshot of your terminal

#

@slow ermine

slow ermine Apr 2, 2024, 4:11 PM

#

im doing the screenshoot

#

sturdy epoch Apr 2, 2024, 4:12 PM

#

slow ermine

show what comes before that

slow ermine Apr 2, 2024, 4:12 PM

#

i think i have to reinstall python

sturdy epoch Apr 2, 2024, 4:12 PM

#

no

#

please show what comes before that text in the terminal

#

@slow ermine if you have started trying to reinstall python, I will not be able to help

slow ermine Apr 2, 2024, 4:14 PM

#

#

i tried to install openpyxl

sturdy epoch Apr 2, 2024, 4:14 PM

#

slow ermine

I need to know what happens immediately before this appears on your terminal

#

you haven't shown that yet

#

you've shown the output of a hidden command. I need to know the command.

slow ermine Apr 2, 2024, 4:15 PM

#

sturdy epoch Apr 2, 2024, 4:16 PM

#

slow ermine

what's the command that you enter that does all of this?

slow ermine Apr 2, 2024, 4:16 PM

#

import pandas as pd

file = pd.read_excel('rubi.xlsx')
print(file)

tropic warrenBOT Apr 2, 2024, 4:16 PM

#

Hey @slow ermine!

It looks like you're trying to paste code into this channel.

Discord has support for Markdown, which allows you to post code with full syntax highlighting. Please use these whenever you paste code, as this helps improve the legibility and makes it easier for us to help you.

To do this, use the following method:
```py
print('Hello, world!')
```

This will result in the following:

print('Hello, world!')```
You can **edit your original message** to correct your code block.

sturdy epoch Apr 2, 2024, 4:16 PM

#

slow ermine import pandas as pd file = pd.read_excel('rubi.xlsx') print(file)

this is python code. not a command.

slow ermine Apr 2, 2024, 4:16 PM

#

i know

sturdy epoch Apr 2, 2024, 4:16 PM

#

how do you run the python program? are you pushing a button?

slow ermine Apr 2, 2024, 4:16 PM

#

yes

sturdy epoch Apr 2, 2024, 4:17 PM

#

what button

slow ermine Apr 2, 2024, 4:17 PM

#

i clicked excecute pytohn file

sturdy epoch Apr 2, 2024, 4:18 PM

#

okay. put this at the top of that python file

import sys; print('venv is', sys.executable); exit()

and then run the python file, and copy and paste the output as text (no screenshot) into this chat

#

@slow ermine please ping me when you have done that

slow ermine Apr 2, 2024, 4:20 PM

#

it give me no output

#

@sturdy epoch

sturdy epoch Apr 2, 2024, 4:21 PM

#

okay, in powershell, try this

python -m pip install openpyxl

and then run the program again

#

but if that doesn't work, I unfortunately don't have more time to help.

slow ermine Apr 2, 2024, 4:23 PM

#

thank you now it works!

sturdy epoch Apr 2, 2024, 4:23 PM

#

oh, and delete import sys; print('venv is', sys.executable); exit() from the program

#

hmm, okay

slow ermine Apr 2, 2024, 4:23 PM

#

i already deleted

sturdy epoch Apr 2, 2024, 4:24 PM

#

well use python -m pip any time you want to use pip

#

instead of just pip

slow ermine Apr 2, 2024, 4:24 PM

#

ok

tropic warrenBOT Apr 2, 2024, 4:58 PM

#

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

#

🔒 i need help with pandas

#🔒 i need help with pandas