python - How can I import submodules of pandas without importing matplotlib? -

-

i using pandas 0.14.1 on webserver process reports sql database.

i not need plotting facilities, matplotlib always imported.

how can import modules need following?

df = pd.io.sql.frame_query(query, con=conn) df['colname'].apply(somefunc) df.set_index('colname') print df.to_html()

i having add following hack of report generating scripts:

import os os.environ['mplconfigdir'] = '/tmp/'

before import pandas. can avoid this?

here's webserver error log when omit hack:

file "/var/www/scripts/myscript.py", line 46, in index\n    pandas.io import sql file "/usr/lib/python2.7/dist-packages/pandas/__init__.py", line 41, in <module>\n    pandas.core.api import * file "/usr/lib/python2.7/dist-packages/pandas/core/api.py", line 9, in <module>\n    pandas.core.groupby import grouper file "/usr/lib/python2.7/dist-packages/pandas/core/groupby.py", line 15, in <module>\n    pandas.core.frame import dataframe file "/usr/lib/python2.7/dist-packages/pandas/core/frame.py", line 38, in <module>\n    pandas.core.series import series file "/usr/lib/python2.7/dist-packages/pandas/core/series.py", line 2524, in <module>\n    import pandas.tools.plotting _gfx file "/usr/lib/python2.7/dist-packages/pandas/tools/plotting.py", line 26, in <module>\n    import pandas.tseries.converter conv file "/usr/lib/python2.7/dist-packages/pandas/tseries/converter.py", line 7, in <module>\n    import matplotlib.units units file "/usr/lib/pymodules/python2.7/matplotlib/__init__.py", line 774, in <module>\n    rcparams = rc_params() file "/usr/lib/pymodules/python2.7/matplotlib/__init__.py", line 692, in rc_params\n    fname = matplotlib_fname() file "/usr/lib/pymodules/python2.7/matplotlib/__init__.py", line 604, in matplotlib_fname\n    fname = os.path.join(get_configdir(), 'matplotlibrc') file "/usr/lib/pymodules/python2.7/matplotlib/__init__.py", line 253, in wrapper\n    ret = func(*args, **kwargs) file "/usr/lib/pymodules/python2.7/matplotlib/__init__.py", line 478, in _get_configdir\n    raise runtimeerror("failed create %s/.matplotlib; consider setting mplconfigdir writable directory matplotlib configuration data"%h) runtimeerror: failed create /var/www/.matplotlib; consider setting mplconfigdir writable directory matplotlib configuration data

further detail: platform ubuntu 12.04lts has old version of matplotlib. recent versions fix error creating temp file. still sucks matplotlib running in webserver when don't need it.

unfortunately answer upgrade matplotlib version creates writable configuration directory on startup if default locations not available. pain if you're using linux distribution packages (matplotlib v1.1.1) versions after 1.3.1 should fine.

both suggestions in comments not fix problem.

changing mpl config use different display driver agg not stop matplotlib trying create config directory.

adding empty matplotlib.py file breaks pandas because requires matplotlib.units module datatype conversion.

so avoid until upgrading matplotlib, os.environ['mplconfigdir'] = '/tmp/' hack works fine, have remember put in every file uses pandas on our webserver. (or create our own custom module hides of this)


Comments

Post a Comment

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

-
i need in configuring java on machine because, when try loading forms, loader goes in circles , gives error: java.lang.classnotfoundexception: oracle.apps.fnd.formsclient.formslauncher.class @ sun.plugin2.applet.applet2classloader.findclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass0(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ java.lang.classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadcode(unknown source) @ sun.plugin2.applet.plugin2manager.createapplet(unknown source) @ sun.plugin2.applet.plugin2manager$appletexecutionrunnable.run (unknown source) @ java.lang.thread.run(unknown source) i have tried re-installing firefox, older versions of java runtime environments, disabling proxy. what missing? application working on other machines. i spent around 100 hours finding s
Read more

c# - how to use buttonedit in devexpress gridcontrol -

-
Image
i trying create gridcontrol buttonedit in 1 of columns. when user clicks button edit, popups form select product. when selection done on popup, returns datarow selection main grid below. but when column loses focus, value wrote column disappear. here code creates gridcontrol's data , buttonedit's click event. private void frmsiparisnew_load(object sender, eventargs e) { dt = new datatable(); dt.columns.add("malzeme_kodu",typeof(string)); dt.columns.add("malzeme_aciklama", typeof(string)); dt.columns.add("adet", typeof(decimal)); dt.columns.add("birim", typeof(string)); dt.columns.add("fiyat", typeof(decimal)); dt.columns.add("kur", typeof(string)); dt.columns.add("tutar", typeof(decimal)); datarow dr = dt.newrow(); dt.rows.add(dr); gc.datasource = dt; } private void repositoryitembuttoneditmal
Read more

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -

-
good morning i using angularjs-nvd3-directives, great, having difficulties when setting color of multi bar chart ( http://cmaurer.github.io/angularjs-nvd3-directives/multi.bar.chart.html ). the show legend works well: <div ng-controller="examplectrl"> <nvd3-multi-bar-chart data="exampledata" id="showlegendexample" width="550" height="300" showxaxis="true" showyaxis="true" xaxistickformat="xaxistickformatfunction()" showlegend="true"> <svg></svg> </nvd3-multi-bar-chart> </div> but when add option in conjunction color="colorfunction()" where, var colorarray = ['#ff0000', '#0000ff', '#ffff00', '#00ffff']; $scope.colorfunction = function() { return function(d, i) { return colorarray[i]; }; } the color of cha
Read more