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 <jparkerpow...@gmail.com> Sent: Tuesday, September 1, 2020 5:33 AM To: Steve <Gronicus@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@sga.ninja <mailto:Gronicus@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 <jparkerpow...@gmail.com <mailto:jparkerpow...@gmail.com> > Sent: Tuesday, September 1, 2020 4:30 AM To: Steve <Gronicus@sga.ninja <mailto:Gronicus@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@sga.ninja <mailto:Gronicus@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 -- https://mail.python.org/mailman/listinfo/python-list
