What kind of magic do I need to get python to talk to Excel xlsm file?
Steve
Gronicus at SGA.Ninja
Tue Sep 1 16:16:16 EDT 2020
Ok, I think I ran into this about a year ago when this was suggested back then.
I entered “pip install pandas”
I am told to “install Anaconda which can be deleted later” (huh?)
Then it tells me “Installing with “Miniconda” (huh? Huh?)
Then “Installing from PyPl which is what I used to get the same page that is telling me all this…
ActivePython, then finally Linux which I am not using.
Ok, then I see:
Installing from source
See the contributing guide for complete instructions on building from the git source tree. Further, see creating a development environment if you wish to create a pandas development environment.
And the music goes round and round…..
FootNote:
If money does not grow on trees, then why do banks have branches?
From: Jeffrey Powell <jparkerpowell at gmail.com>
Sent: Tuesday, September 1, 2020 5:33 AM
To: Steve <Gronicus at sga.ninja>
Subject: Re: What kind of magic do I need to get python to talk to Excel xlsm file?
Hi Steve,
Yes, you need to install pandas first. I use pip install pandas
Kind regards,
Jeffrey Powell
On Tue, 1 Sep 2020, 11:15 Steve, <Gronicus at sga.ninja <mailto:Gronicus at sga.ninja> > wrote:
ModuleNotFoundError: No module named 'pandas'
I take it that this is an installation.
Is there anything I need to know about this first?
Steve
FootNote:
If money does not grow on trees, then why do banks have branches?
From: Jeffrey Powell <jparkerpowell at gmail.com <mailto:jparkerpowell at gmail.com> >
Sent: Tuesday, September 1, 2020 4:30 AM
To: Steve <Gronicus at sga.ninja <mailto:Gronicus at sga.ninja> >
Subject: Re: What kind of magic do I need to get python to talk to Excel xlsm file?
Hi Steve,
Maybe something like this:
import pandas as pd
dt = pd.read_excel("myData.xls", sheet_name="mySheetName", skiprows=0, usecols=list(range(0,11)))
where usecols are the column numbers you want.
Kind regards,
Jeff
On Tue, Sep 1, 2020 at 10:24 AM Steve <Gronicus at sga.ninja <mailto:Gronicus at sga.ninja> > wrote:
Glutton for punishment, I am looking into designing another .py program. I
would like to pull two columns of information from Excel but the more I look
into coding on the 'net, the more confusing it looks. I don't understand
what I need to import or install to get the link.
Steve
Footnote:
Some mornings it just isn't worth chewing through the leather straps.
--
https://mail.python.org/mailman/listinfo/python-list
--
Jeffrey Powell, PhD. Senior Data Scientist, Dataworkz.nl
More information about the Python-list
mailing list