What kind of magic do I need to get python to talk to Excel xlsm file?

[Steve]

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