[MacPorts] #44033: Python 27 - pandas library (openpyxl)dependency issues
#44033: Python 27 - pandas library (openpyxl)dependency issues ---------------------------------+-------------------------------- Reporter: meenu.kamalakshan@… | Owner: macports-tickets@… Type: defect | Status: new Priority: High | Milestone: Component: ports | Version: 2.3.0 Keywords: Python - pandas | Port: ---------------------------------+-------------------------------- I am successfully installing pandas using macport but when using the same I am getting the following error. In macport we are currently having openpyxl 1.5.8. SO we need an update for 1.6 or later.
import pandas /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7 /site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >='''1.6.1 and <2.0.0.''' .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))
-- Ticket URL: <https://trac.macports.org/ticket/44033> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Changes (by mf2k@…): * cc: meenu.kamalakshan@… (removed) * priority: High => Normal * owner: macports-tickets@… => stromnov@… * keywords: Python - pandas => * port: => py-pandas Old description:
I am successfully installing pandas using macport but when using the same I am getting the following error. In macport we are currently having openpyxl 1.5.8. SO we need an update for 1.6 or later.
import pandas /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7 /site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >='''1.6.1 and <2.0.0.''' .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))
New description: I am successfully installing pandas using macport but when using the same I am getting the following error. In macport we are currently having openpyxl 1.5.8. SO we need an update for 1.6 or later. {{{
import pandas /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7 /site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >='''1.6.1 and <2.0.0.''' .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver)) }}}
-- Comment: The Priority field is for use by Macports team members only. In the future, please use WikiFormatting, fill in the Port field and Cc the port maintainers ({{{port info --maintainers py-pandas}}}). As reporter, you do not need to Cc yourself. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:2> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by egall@…):
In macport we are currently having openpyxl 1.5.8. SO we need an update for 1.6 or later.
If this is the actual issue, the "Port" field and title for this ticket should be updated accordingly to reflect that this is actually an issue with py-openpyxl -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:3> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Thank You for the update. I did the following , But seems the problem still exists {{{ sudo port clean --all -f py27 sudo port selfupdate sudo port install py27-matplotlib py27-numpy py27-scipy py27-ipython sudo port install py27-pyfits py27-pywcs py27-atpy py27-aplpy sudo port install py27-pyfits datljamesg:~ mkamalakshan$ sudo port install py27-openpyxl @1.8.6 ---> Computing dependencies for py27-openpyxl ---> Cleaning py27-openpyxl ---> Scanning binaries for linking errors ---> No broken files found. datljamesg:~ mkamalakshan$ sudo port install py27-pandad Error: Port py27-pandad not found datljamesg:~ mkamalakshan$ sudo port install py27-pandas ---> Computing dependencies for py27-pandas ---> Cleaning py27-pandas ---> Scanning binaries for linking errors ---> No broken files found. datljamesg:~ mkamalakshan$ python Python 2.7.8 (default, Jul 3 2014, 06:13:58) [GCC 4.2.1 Compatible Apple LLVM 5.1 (clang-503.0.40)] on darwin Type "help", "copyright", "credits" or "license" for more information.
import pandas /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7 /site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0. .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver)) }}}
It seems the issue still persists. I am new to macports. so not completely positive that i did what you suggested me to do . Please let me know if i missed some steps or you are suggesting something different ? -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:5> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Replying to [comment:3 egall@…]:
In macport we are currently having openpyxl 1.5.8. SO we need an update for 1.6 or later.
If this is the actual issue, the "Port" field and title for this ticket should be updated accordingly to reflect that this is actually an issue with py-openpyxl
I am trying to install pandas. and install works fine.. But on importing it complaint about openpyxl . Hope the issue heading is right for this issue. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:6> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Hi stromnov@macports.org, I saw your upgrade of pandas from you ,FYI, But that also did not solve my problem . I would really like to be with macport as i had better experiences in this distribution . {{{ mkamalakshan$ sudo port clean --all py27-openpyxl ---> Cleaning py27-openpyxl mkamalakshan$ sudo port clean --all py27-pandas ---> Cleaning py27-pandas mkamalakshan$ sudo port install py27-pandas ---> Computing dependencies for py27-pandas ---> Cleaning py27-pandas ---> Scanning binaries for linking errors ---> No broken files found. mkamalakshan$ python Python 2.7.8 (default, Jul 3 2014, 06:13:58) [GCC 4.2.1 Compatible Apple LLVM 5.1 (clang-503.0.40)] on darwin Type "help", "copyright", "credits" or "license" for more information.
import pandas /opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7 /site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0. .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver)) }}}
-- Ticket URL: <https://trac.macports.org/ticket/44033#comment:7> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by stromnov@…): py*-openpyxl updated to version 1.8.6 at r122103. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:8> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Just an FYI .I did try first what you suggested. Hope this is the way to do the change. But still same issue persists. {{{ sudo port install py27-openpyxl @1.8.6 }}} Replying to [comment:8 stromnov@…]:
py*-openpyxl updated to version 1.8.6 at r122103.
-- Ticket URL: <https://trac.macports.org/ticket/44033#comment:9> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by mf2k@…): BTW, py-openpyxl is not even a dependency for py-pandas. Is this an opportunistic linking? -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:10> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by stromnov@…): Replying to [comment:9 meenu.kamalakshan@…]:
Just an FYI .I did try first what you suggested. Hope this is the way to do the change. But still same issue persists. {{{ sudo port install py27-openpyxl @1.8.6 }}}
Please, provide exact output of {{{port installed py27-openpyxl}}} command. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:11> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): yeah you got it right!!! somehow after cleaning and installing also active one is @1.5.8 not 1.8.6 {{{ mkamalakshan$ sudo port install py27-openpyxl @1.8.6 ---> Computing dependencies for py27-openpyxl ---> Cleaning py27-openpyxl ---> Scanning binaries for linking errors ---> No broken files found. mkamalakshan$ port installed py27-openpyxl The following ports are currently installed: py27-openpyxl @1.5.8_0 (active) }}} -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:12> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): I tried couple of things to make the new version activate . But it goes off once i install pandas. Could you suggest what to do ? I believe I am somehow overseeing some simple step . Could you help ?
Replying to [comment:9 meenu.kamalakshan@…]:
Just an FYI .I did try first what you suggested. Hope this is the way to do the change. But still same issue persists. {{{ sudo port install py27-openpyxl @1.8.6 }}}
Please, provide exact output of {{{port installed py27-openpyxl}}} command.
-- Ticket URL: <https://trac.macports.org/ticket/44033#comment:13> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by stromnov@…): You can try this: {{{ sudo port selfupdate sudo port uninstall py27-openpyxl sudo port install py27-openpyxl }}} Note, in {{{ sudo port install py27-openpyxl @1.8.6 }}} @1.8.6 part completely ignored. MacPorts always use one version, specified in corresponding Portfile. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:14> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Hi , i did try the above mentioned commands already . I will try to start anew i will {{{ sudo port -fp uninstall installed }}} I will let you know if that helps. Replying to [comment:14 stromnov@…]:
You can try this: {{{ sudo port selfupdate sudo port uninstall py27-openpyxl sudo port install py27-openpyxl }}}
Note, in {{{ sudo port install py27-openpyxl @1.8.6 }}} @1.8.6 part completely ignored. MacPorts always use one version, specified in corresponding Portfile.
-- Ticket URL: <https://trac.macports.org/ticket/44033#comment:15> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: Python 27 - pandas library (openpyxl)dependency issues ----------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.0 Resolution: | Keywords: Port: py-pandas | ----------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Hi , full cleaning did work . But as you said seems openpyxl had nothing to do with pandas. {{{ mkamalakshan$ port installed py27-openpyxl None of the specified ports are installed. mkamalakshan$ python Python 2.7.8 (default, Jul 13 2014, 17:11:32) [GCC 4.2.1 Compatible Apple LLVM 5.1 (clang-503.0.40)] on darwin Type "help", "copyright", "credits" or "license" for more information.
import pandas }}}
Thanks for being patient and walking me through Lesson learnt: its easier to clean install macport Thank You Meenu Replying to [comment:15 meenu.kamalakshan@…]:
Hi , i did try the above mentioned commands already . I will try to start anew i will {{{ sudo port -fp uninstall installed }}}
I will let you know if that helps.
Replying to [comment:14 stromnov@…]:
You can try this: {{{ sudo port selfupdate sudo port uninstall py27-openpyxl sudo port install py27-openpyxl }}}
Note, in {{{ sudo port install py27-openpyxl @1.8.6 }}} @1.8.6 part completely ignored. MacPorts always use one version, specified in corresponding Portfile.
-- Ticket URL: <https://trac.macports.org/ticket/44033#comment:16> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required --------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyx | --------------------------------------+------------------------ Changes (by petr@…): * version: 2.3.0 => * port: py-pandas => py-pandas py-py-openpyx -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:18> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ---------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyxl | ---------------------------------------+------------------------ Changes (by petr@…): * port: py-pandas py-py-openpyx => py-pandas py-py-openpyxl -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:19> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ---------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyxl | ---------------------------------------+------------------------ Comment (by petr@…): Looks like py-pandas needs to declare the dependency on `openpyxl`, to close this ticket. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:20> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ---------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyxl | ---------------------------------------+------------------------ Comment (by stromnov@…): Actually openpyxl (as well as many other packages) is a purely optional runtime dependency for pandas. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:21> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ---------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyxl | ---------------------------------------+------------------------ Comment (by petr@…): Okay, so if openpyxl should not be declared as a dependency, there is probably no way to get an updated version of openpyxl on installation or upgrade. The ticket is to be considered as resolved with the update in r122103, right? -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:22> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ---------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-py-openpyxl | ---------------------------------------+------------------------ Comment (by meenu.kamalakshan@…): Replying to [comment:22 petr@…]:
Okay, so if openpyxl should not be declared as a dependency, there is probably no way to get an updated version of openpyxl on installation or upgrade. The ticket is to be considered as resolved with the update in r122103, right?
Yes, The ticket it resolved!! I was able to work on pandas . Thank You -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:23> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: Resolution: | Keywords: Port: py-pandas py-openpyxl | ------------------------------------+------------------------ Changes (by petr@…): * port: py-pandas py-py-openpyxl => py-pandas py-openpyxl -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:24> MacPorts <http://www.macports.org/> Ports system for OS X
#44033: py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required ------------------------------------+------------------------ Reporter: meenu.kamalakshan@… | Owner: stromnov@… Type: defect | Status: closed Priority: Normal | Milestone: Component: ports | Version: Resolution: fixed | Keywords: Port: py-pandas py-openpyxl | ------------------------------------+------------------------ Changes (by petr@…): * status: new => closed * resolution: => fixed Comment: Closing as fixed! py-openpyxl has been updated so that it is compatible with py-pandas. But the dependency is optional, so no formal dependency is to be declared. -- Ticket URL: <https://trac.macports.org/ticket/44033#comment:25> MacPorts <http://www.macports.org/> Ports system for OS X
participants (1)
-
MacPorts