py-pandas: unspecified dependency on openpyxl, py-openpyxl: update required

[meenu.kamalakshan@…]

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))

[meenu.kamalakshan@…]

Cc Me!

[mf2k (Frank Schima)]

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.

[cooljeanius (Eric Gallager)]

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

[cooljeanius (Eric Gallager)]

Cc Me!

[Russell-Jones-OxPhys (Russell Jones)]

Draft portfile for openpyxl 1.8.6 (builds and imports on 3.4 and 2.7, please test)

[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 ?

[meenu.kamalakshan@…]

Replying to 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.

[meenu.kamalakshan@…]

Hi stromnov@…,

I saw your upgrade of pandas from you .Thanks a lot. ,FYI, But that also did not solve my problem .

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))

[stromnov (Andrey Stromnov)]

py*-openpyxl updated to version 1.8.6 at r122103.

[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 stromnov@…:

py*-openpyxl updated to version 1.8.6 at r122103.

[mf2k (Frank Schima)]

BTW, py-openpyxl is not even a dependency for py-pandas. Is this an opportunistic linking?

[stromnov (Andrey Stromnov)]

Replying to 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.

[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)

[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 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.

[stromnov (Andrey 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.

[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 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.

[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 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 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.

[petrrr]

Cc Me!

[petrrr]

Looks like py-pandas needs to declare the dependency on openpyxl, to close this ticket.

[stromnov (Andrey Stromnov)]

Actually openpyxl (as well as many other packages) is a purely optional runtime dependency for pandas.

[petrrr]

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?

[meenu.kamalakshan@…]

Replying to 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

[petrrr]

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.