Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Question] Is there a way to not show nan and to collapse the index column? #235

Closed
jolespin opened this issue Aug 6, 2020 · 11 comments
Closed

Comments

@jolespin
Copy link

jolespin commented Aug 6, 2020

First off THANK YOU for making this tool. This is going to up my workflow by so much. RIP .to_clipboard opening up a table in Excel and then digging into the details. However, I was wondering if it's possible to do a couple of things.

Here's an example of my dataframe:
image

I have a function that reads in a table but it stores the filename as the index.name attribute. I can easily just remove this but I was wondering if there was a way to either minimize the index or manually resize?

My second question was whether theres is a way to have a blank cell instead of nan for missing values?

@aschonfeld
Copy link
Collaborator

aschonfeld commented Aug 7, 2020

@jolespin Glad it's helping! Hearing stuff like that makes the sleepless nights worth it.

  1. You have a few options if you click the column header for that index column:
  • Delete (simple as it sounds, delete the column from your dataframe)
  • Rename (change the name of the column to something shorter if you don't feel like being as heavy-handed as deleting)
  • Hide (this won't alter your dataframe at all, but it will hide the column from view and to unhide it simply click the X next to the hidden columns at the top of the screen after you've hidden it)
  1. There's 2 options I can think of off the top of my head:

    1: Replacements: unfortunately this first option is a little cumbersome since you'll have to do it column by column:

    • Click the column header of each column with nan values and click the "Replacement" button.
    • Once the Replacements menu comes up choose"Value(s)" for Replacement Type
    • Unfortunately it doesn't look like there's a way to enter an empty string right now, so in the last text input just put something like - (I'll look into adding a way to specify empty strings)
    • Click "Replace" (here's some documentation on the "Replacements" functionality as well)

    2: Simply replacing all nan values on your data

    • so if you're using a jupyter notebook you can instantiate your session like this: d = dtale.show(df)
    • in another cell you can simply execute d and it will display your D-Tale session
    • in another cell you can execute: d.data.fillna('')
    • if you refresh your browser you should see the nan values go away (just be careful turning nan values into strings on columns that were previous floats will now turn them into mixed types)

    3: when starting D-Tale you could always do dtale.show(df.fillna(''))

Going forward I can look into a global formatting option for displaying nan values. Some options could be:

  • nan (default)
  • empty string
  • dash (-)

Hopefully one of these options will work for now, but let me know if you're still having issues. Good luck

@aschonfeld
Copy link
Collaborator

@jolespin Just wanted to give you an update on my progress with this. Here's what I have for the nan formatting so far: https://youtu.be/I3qYHexY214

Please let me know if there is any other options you'd like to see?

Hopefully I'll have this released soon after taking care of a couple more bugs.

@jolespin
Copy link
Author

Wow, that was really fast. Thank you! I can’t think of any other features. I have a pretty complex environment for my main analysis environment and had trouble getting dtale to run properly. I’ll give this another shot when I get to my work computer.

@aschonfeld
Copy link
Collaborator

If you still have trouble let me know and we can trying working through it 👍

@jolespin
Copy link
Author

I've uploaded a video of trying to load the iris dataset with dtale.
loading.mov.zip

I tried checking the __version__ attribute but didn't see it on dtale. Is there another way to check the version?

I'm using dtale v1.12.1 according to conda list.

My environment is pretty complex which is probably why it's not working but I'm not sure what would be conflicting:

jespinoz$ conda list
# packages in environment at /Users/jespinoz/anaconda3/envs/soothsayer5_env:
#
# Name                    Version                   Build  Channel
_r-mutex                  1.0.1               anacondar_1    conda-forge
adjusttext                0.7.3.1                    py_1    conda-forge
appdirs                   1.4.3                      py_1    conda-forge
appnope                   0.1.0           py38h32f6830_1001    conda-forge
argon2-cffi               20.1.0           py38h4d0b108_1    conda-forge
attrs                     19.3.0                     py_0    conda-forge
backcall                  0.2.0              pyh9f0ad1d_0    conda-forge
backports                 1.0                        py_2    conda-forge
backports.functools_lru_cache 1.6.1                      py_0    conda-forge
bids-validator            1.5.2                    pypi_0    pypi
bioconductor-annotationdbi 1.48.0                    r36_0    bioconda
bioconductor-biobase      2.46.0            r36h01d97ff_0    bioconda
bioconductor-biocgenerics 0.32.0                    r36_0    bioconda
bioconductor-biomformat   1.14.0                    r36_0    bioconda
bioconductor-biostrings   2.54.0            r36h01d97ff_0    bioconda
bioconductor-edger        3.28.0            r36h6740361_1    bioconda
bioconductor-ggtree       2.0.0                     r36_0    bioconda
bioconductor-go.db        3.10.0                    r36_0    bioconda
bioconductor-ihw          1.14.0                    r36_0    bioconda
bioconductor-impute       1.60.0            r36h4bb4525_0    bioconda
bioconductor-iranges      2.20.0            r36h01d97ff_0    bioconda
bioconductor-limma        3.42.0            r36h01d97ff_0    bioconda
bioconductor-lpsymphony   1.14.0            r36h6de7cb9_0    bioconda
bioconductor-metagenomeseq 1.28.0                    r36_0    bioconda
bioconductor-multtest     2.42.0            r36h01d97ff_0    bioconda
bioconductor-philr        1.12.0                    r36_0    bioconda
bioconductor-phyloseq     1.30.0                    r36_0    bioconda
bioconductor-preprocesscore 1.48.0            r36h01d97ff_0    bioconda
bioconductor-rhdf5        2.30.0            r36h6de7cb9_0    bioconda
bioconductor-rhdf5lib     1.8.0             r36h01d97ff_0    bioconda
bioconductor-s4vectors    0.24.0            r36h01d97ff_0    bioconda
bioconductor-treeio       1.10.0                    r36_0    bioconda
bioconductor-wrench       1.4.0                     r36_0    bioconda
bioconductor-xvector      0.26.0            r36h01d97ff_0    bioconda
bioconductor-zlibbioc     1.32.0            r36h01d97ff_0    bioconda
biom-format               2.1.8            py38h3b54f70_0    conda-forge
biopython                 1.77             py38h4d0b108_1    conda-forge
bleach                    3.1.5              pyh9f0ad1d_0    conda-forge
blosc                     1.20.0               hb1e8313_0    conda-forge
bokeh                     2.1.1            py38h32f6830_0    conda-forge
brotli                    1.0.7                    pypi_0    pypi
brotlipy                  0.7.0           py38h64e0658_1000    conda-forge
brunsli                   0.1                  hb1e8313_0    conda-forge
bwidget                   1.9.14                        0    conda-forge
bz2file                   0.98                     pypi_0    pypi
bzip2                     1.0.8                haf1e3a3_2    conda-forge
c-ares                    1.11.0                        0    bioconda
ca-certificates           2020.6.20            hecda079_0    conda-forge
cachecontrol              0.12.6                     py_0    conda-forge
cairo                     1.16.0            hec6a9b0_1003    conda-forge
cctools                   949.0.1              h22b1bf0_0    conda-forge
cctools_osx-64            949.0.1              h5ba7a2e_0    conda-forge
certifi                   2020.6.20        py38h32f6830_0    conda-forge
cffi                      1.14.1           py38hc4dd44e_0    conda-forge
chardet                   3.0.4           py38h32f6830_1006    conda-forge
charls                    2.1.0                h4a8c4bd_2    conda-forge
clang                     9.0.1           default_hf57f61e_0    conda-forge
clang-tools               9.0.1           default_hf57f61e_0    conda-forge
clang_osx-64              9.0.1                h05bbb7f_2    conda-forge
clangxx                   9.0.1           default_hf57f61e_0    conda-forge
clangxx_osx-64            9.0.1                h05bbb7f_2    conda-forge
click                     7.1.2              pyh9f0ad1d_0    conda-forge
cloudpickle               1.5.0                      py_0    conda-forge
colorcet                  2.0.1                      py_0    conda-forge
colourmap                 0.1.1                    pypi_0    pypi
compiler-rt               9.0.1                h6a512c6_3    conda-forge
compiler-rt_osx-64        9.0.1                h99342c6_3    conda-forge
compositional             2020.5.19                pypi_0    pypi
cryptography              3.0              py38h52adbb4_0    conda-forge
curl                      7.71.1               hbdca1c0_4    conda-forge
cycler                    0.10.0                     py_2    conda-forge
cython                    0.29.21          py38hc84c608_0    conda-forge
cytoolz                   0.10.1           py38h0b31af3_0    conda-forge
dash                      1.14.0                   pypi_0    pypi
dash-bootstrap-components 0.10.3                   pypi_0    pypi
dash-colorscales          0.0.4                    pypi_0    pypi
dash-core-components      1.10.2                   pypi_0    pypi
dash-daq                  0.5.0                    pypi_0    pypi
dash-html-components      1.0.3                    pypi_0    pypi
dash-renderer             1.6.0                    pypi_0    pypi
dash-table                4.9.0                    pypi_0    pypi
dask                      2.22.0                     py_0    conda-forge
dask-core                 2.22.0                     py_0    conda-forge
datashader                0.10.0                     py_0    conda-forge
datashape                 0.5.4                      py_1    conda-forge
dbus                      1.13.6               h2f22bb5_0    conda-forge
decorator                 4.4.2                      py_0    conda-forge
defusedxml                0.6.0                      py_0    conda-forge
distributed               2.22.0           py38h32f6830_0    conda-forge
docopt                    0.6.2                    pypi_0    pypi
dtale                     1.12.1                   pypi_0    pypi
ensemble-networkx         2020.7.21                pypi_0    pypi
entrypoints               0.3             py38h32f6830_1001    conda-forge
et-xmlfile                1.0.1                    pypi_0    pypi
ete3                      3.1.1              pyh9f0ad1d_2    conda-forge
expat                     2.2.9                h4a8c4bd_2    conda-forge
fastcluster               1.1.26           py38h5fc983b_1    conda-forge
fastparquet               0.4.0                    pypi_0    pypi
flask                     1.1.2                    pypi_0    pypi
flask-compress            1.5.0                    pypi_0    pypi
flask-ngrok               0.0.25                   pypi_0    pypi
fontconfig                2.13.1            h6b1039f_1001    conda-forge
freetype                  2.10.2               h8da9a1a_0    conda-forge
fribidi                   1.0.10               h0b31af3_0    conda-forge
fsspec                    0.8.0                      py_0    conda-forge
future                    0.18.2           py38h32f6830_1    conda-forge
gettext                   0.19.8.1          h46ab8bc_1002    conda-forge
gfortran_impl_osx-64      7.5.0                h970e067_1    conda-forge
gfortran_osx-64           7.5.0                hb7f2cba_5    conda-forge
giflib                    5.2.1                h0b31af3_2    conda-forge
glib                      2.65.0               h577aef8_0    conda-forge
gmp                       6.2.0                h4a8c4bd_2    conda-forge
gneiss                    0.4.6                      py_0    bioconda
graphite2                 1.3.13            h12caacf_1001    conda-forge
graphviz                  2.38.0            hc6cc99f_1011    conda-forge
gsl                       2.6                  ha2d443c_0    conda-forge
h5py                      2.10.0          nompi_py38he4534f8_104    conda-forge
harfbuzz                  2.4.0                hd8d2a14_3    conda-forge
hdf5                      1.10.6          nompi_haae91d6_101    conda-forge
hdmedians                 0.13            py38h65ad66c_1002    conda-forge
heapdict                  1.0.1                      py_0    conda-forge
hive-networkx             2020.8.3                 pypi_0    pypi
holoviews                 1.13.3             pyh9f0ad1d_0    conda-forge
hvplot                    0.6.0              pyh9f0ad1d_0    conda-forge
icu                       64.2                 h6de7cb9_1    conda-forge
idna                      2.10               pyh9f0ad1d_0    conda-forge
imagecodecs               2020.5.30        py38h197531b_2    conda-forge
imagecodecs-lite          2019.12.3        py38h65ad66c_1    conda-forge
imageio                   2.9.0                      py_0    conda-forge
importlib-metadata        1.7.0            py38h32f6830_0    conda-forge
importlib_metadata        1.7.0                         0    conda-forge
iniconfig                 1.0.1              pyh9f0ad1d_0    conda-forge
ipykernel                 5.3.4            py38h23f93f0_0    conda-forge
ipython                   7.17.0           py38h1cdfbd6_0    conda-forge
ipython_genutils          0.2.0                      py_1    conda-forge
ipywidgets                7.5.1                    pypi_0    pypi
isl                       0.22.1               h65ac59c_1    conda-forge
itsdangerous              1.1.0                    pypi_0    pypi
jdcal                     1.4.1                    pypi_0    pypi
jedi                      0.17.2           py38h32f6830_0    conda-forge
jinja2                    2.11.2             pyh9f0ad1d_0    conda-forge
joblib                    0.16.0                     py_0    conda-forge
jpeg                      9d                   h0b31af3_0    conda-forge
json5                     0.9.4                    pypi_0    pypi
jsonschema                3.2.0            py38h32f6830_1    conda-forge
jupyter                   1.0.0                    pypi_0    pypi
jupyter-console           6.1.0                    pypi_0    pypi
jupyter_client            6.1.6                      py_0    conda-forge
jupyter_core              4.6.3            py38h32f6830_1    conda-forge
jupyterlab                2.1.2                    pypi_0    pypi
jupyterlab-server         1.1.1                    pypi_0    pypi
jxrlib                    1.1                  h0b31af3_2    conda-forge
kiwisolver                1.2.0            py38ha0d09dd_0    conda-forge
krb5                      1.17.1               h14dd6a4_2    conda-forge
lcms2                     2.11                 h174193d_0    conda-forge
ld64                      530                           0    conda-forge
ld64_osx-64               530                  h3c32e8a_0    conda-forge
lerc                      2.2                  hb1e8313_0    conda-forge
libaec                    1.0.4                h4a8c4bd_1    conda-forge
libblas                   3.8.0               17_openblas    conda-forge
libcblas                  3.8.0               17_openblas    conda-forge
libclang                  9.0.1           default_hf57f61e_0    conda-forge
libcurl                   7.71.1               he6690cf_4    conda-forge
libcxx                    10.0.1               h5f48129_0    conda-forge
libedit                   3.1.20191231         hed1e85f_1    conda-forge
libev                     4.33                 haf1e3a3_0    conda-forge
libffi                    3.2.1                         1    bioconda
libgfortran               4.0.0                         2    conda-forge
libiconv                  1.15              h0b31af3_1006    conda-forge
liblapack                 3.8.0               17_openblas    conda-forge
libllvm8                  8.0.1                h770b8ee_0    conda-forge
libllvm9                  9.0.1                h7475705_1    conda-forge
libnghttp2                1.41.0               h8a08a2b_1    conda-forge
libopenblas               0.3.10          openmp_h63d9170_4    conda-forge
libpng                    1.6.37               hbbe82c9_1    conda-forge
libpq                     12.3                 h489d428_0    conda-forge
libsodium                 1.0.18               h01d97ff_0    conda-forge
libssh2                   1.9.0                h39bdce6_5    conda-forge
libtiff                   4.1.0                h2ae36a8_6    conda-forge
libwebp-base              1.1.0                h0b31af3_3    conda-forge
libxcb                    1.13              h1de35cc_1002    conda-forge
libxml2                   2.9.10               h53d96d6_0    conda-forge
libxslt                   1.1.33               h320ff13_0    conda-forge
libzopfli                 1.0.3                h4a8c4bd_0    conda-forge
llvm-openmp               10.0.1               h28b9765_0    conda-forge
llvm-tools                9.0.1                h1341992_1    conda-forge
llvmlite                  0.32.0                   pypi_0    pypi
locket                    0.2.0                      py_2    conda-forge
lockfile                  0.12.2                     py_1    conda-forge
lxml                      4.5.2            py38hc829089_0    conda-forge
lz4                       3.1.0                    pypi_0    pypi
lz4-c                     1.9.2                h4a8c4bd_1    conda-forge
make                      4.3                  h0b31af3_0    conda-forge
markdown                  3.2.2                      py_0    conda-forge
markupsafe                1.1.1            py38h64e0658_1    conda-forge
matplotlib                3.3.0                         1    conda-forge
matplotlib-base           3.3.0            py38haed9462_1    conda-forge
matplotlib-venn           0.11.5                     py_2    conda-forge
mistune                   0.8.4           py38h64e0658_1001    conda-forge
mmh3                      2.5.1                    pypi_0    pypi
more-itertools            8.4.0                      py_0    conda-forge
mpc                       1.1.0             ha57cd0f_1009    conda-forge
mpfr                      4.0.2                h65ac59c_1    conda-forge
mplcyberpunk              0.1.11                   pypi_0    pypi
msgpack-python            1.0.0            py38ha0d09dd_1    conda-forge
multipledispatch          0.6.0                      py_0    conda-forge
natsort                   7.0.1                      py_0    conda-forge
nbconvert                 5.6.1            py38h32f6830_1    conda-forge
nbformat                  5.0.7                      py_0    conda-forge
ncurses                   6.2                  hb1e8313_1    conda-forge
networkx                  2.4                        py_1    conda-forge
nibabel                   3.1.0                    pypi_0    pypi
nilearn                   0.6.2                    pypi_0    pypi
nose                      1.3.7           py38h32f6830_1004    conda-forge
notebook                  6.1.1            py38h32f6830_0    conda-forge
nspr                      4.20              h0a44026_1000    conda-forge
nss                       3.47                 hc0980d9_0    conda-forge
num2words                 0.5.10                   pypi_0    pypi
numba                     0.49.0                   pypi_0    pypi
numpy                     1.19.1           py38h598c1e0_0    conda-forge
olefile                   0.46                       py_0    conda-forge
openjpeg                  2.3.1                h254dc36_3    conda-forge
openpyxl                  3.0.3                    pypi_0    pypi
openssl                   1.1.1g               haf1e3a3_1    conda-forge
packaging                 20.3                     pypi_0    pypi
palettable                3.3.0                      py_0    conda-forge
pandas                    1.0.5            py38h5fc983b_0    conda-forge
pandoc                    2.10.1               haf1e3a3_0    conda-forge
pandocfilters             1.4.2                    pypi_0    pypi
panel                     0.9.7                      py_0    conda-forge
pango                     1.42.4               haa940fe_4    conda-forge
param                     1.9.3                      py_0    conda-forge
parso                     0.7.0              pyh9f0ad1d_0    conda-forge
partd                     1.1.0                      py_0    conda-forge
pathlib2                  2.3.5                    pypi_0    pypi
patsy                     0.5.1                      py_0    conda-forge
pca                       1.0.8                    pypi_0    pypi
pcre                      8.44                 h4a8c4bd_0    conda-forge
pexpect                   4.8.0            py38h32f6830_1    conda-forge
pickleshare               0.7.5           py38h32f6830_1001    conda-forge
pillow                    7.2.0            py38h83dc5e5_1    conda-forge
pip                       20.2.2                     py_0    conda-forge
pixman                    0.38.0            h01d97ff_1003    conda-forge
plotly                    4.6.0                    pypi_0    pypi
plotly-express            0.4.1                    pypi_0    pypi
pluggy                    0.13.1           py38h32f6830_2    conda-forge
pooch                     1.1.1                      py_0    conda-forge
prometheus_client         0.8.0              pyh9f0ad1d_0    conda-forge
prompt-toolkit            3.0.6                      py_0    conda-forge
psutil                    5.7.2            py38h4d0b108_0    conda-forge
pthread-stubs             0.4               h1de35cc_1001    conda-forge
ptitprince                0.2.3                    pypi_0    pypi
ptyprocess                0.6.0                   py_1001    conda-forge
py                        1.9.0              pyh9f0ad1d_0    conda-forge
pybids                    0.10.2                   pypi_0    pypi
pycparser                 2.20               pyh9f0ad1d_2    conda-forge
pyct                      0.4.6                      py_0    conda-forge
pyct-core                 0.4.6                      py_0    conda-forge
pygments                  2.6.1                      py_0    conda-forge
pygraphviz                1.5             py38h64e0658_1002    conda-forge
pyhamcrest                2.0.2                    pypi_0    pypi
pyopenssl                 19.1.0                     py_1    conda-forge
pyparsing                 2.4.7              pyh9f0ad1d_0    conda-forge
pyqt                      5.12.3           py38hf180056_3    conda-forge
pyqt5-sip                 4.19.18                  pypi_0    pypi
pyqtchart                 5.12                     pypi_0    pypi
pyqtwebengine             5.12.1                   pypi_0    pypi
pyrsistent                0.16.0           py38h64e0658_0    conda-forge
pysocks                   1.7.1            py38h32f6830_1    conda-forge
pytest                    6.0.1            py38h32f6830_0    conda-forge
python                    3.8.5           h85f3143_2_cpython    conda-forge
python-dateutil           2.8.1                      py_0    conda-forge
python-louvain            0.14                     pypi_0    pypi
python_abi                3.8                      1_cp38    conda-forge
pytz                      2020.1             pyh9f0ad1d_0    conda-forge
pyviz_comms               0.7.6              pyh9f0ad1d_0    conda-forge
pywavelets                1.1.1            py38h65ad66c_1    conda-forge
pyyaml                    5.3.1            py38h64e0658_0    conda-forge
pyzmq                     19.0.0                   pypi_0    pypi
qt                        5.12.5               h514805e_3    conda-forge
qtconsole                 4.7.3                    pypi_0    pypi
qtpy                      1.9.0                    pypi_0    pypi
r-acepack                 1.4.1           r36h384270c_1005    conda-forge
r-ade4                    1.7_15            r36hb6d66fe_2    conda-forge
r-ape                     5.4               r36hdab79a9_0    conda-forge
r-askpass                 1.1               r36h17f1fa6_2    conda-forge
r-assertthat              0.2.1             r36h6115d3f_2    conda-forge
r-backports               1.1.8             r36h17f1fa6_0    conda-forge
r-base                    3.6.3                h0dd4800_2    conda-forge
r-base64enc               0.1_3           r36h17f1fa6_1004    conda-forge
r-bh                      1.72.0_3          r36h6115d3f_1    conda-forge
r-biocmanager             1.30.10           r36h6115d3f_1    conda-forge
r-bit                     4.0.4             r36h800e0f2_0    conda-forge
r-bit64                   4.0.2             r36h800e0f2_0    conda-forge
r-bitops                  1.0_6           r36h17f1fa6_1004    conda-forge
r-blob                    1.2.1             r36h6115d3f_1    conda-forge
r-brew                    1.0_6           r36h6115d3f_1003    conda-forge
r-callr                   3.4.3             r36h6115d3f_1    conda-forge
r-catools                 1.18.0            r36hc5da6b9_1    conda-forge
r-checkmate               2.0.0             r36h17f1fa6_1    conda-forge
r-cli                     2.0.2             r36h6115d3f_1    conda-forge
r-clipr                   0.7.0             r36h6115d3f_1    conda-forge
r-clisymbols              1.2.0           r36h6115d3f_1003    conda-forge
r-cluster                 2.1.0             r36h384270c_3    conda-forge
r-codetools               0.2_16          r36h6115d3f_1002    conda-forge
r-colorspace              1.4_1             r36h17f1fa6_2    conda-forge
r-commonmark              1.7             r36h17f1fa6_1002    conda-forge
r-covr                    3.5.0             r36hc5da6b9_1    conda-forge
r-crayon                  1.3.4           r36h6115d3f_1003    conda-forge
r-crosstalk               1.1.0.1           r36h6115d3f_1    conda-forge
r-curl                    4.3               r36h17f1fa6_1    conda-forge
r-data.table              1.12.8            r36h17f1fa6_1    conda-forge
r-dbi                     1.1.0             r36h6115d3f_1    conda-forge
r-deoptimr                1.0_8           r36h6115d3f_1003    conda-forge
r-desc                    1.2.0           r36h6115d3f_1003    conda-forge
r-devtools                2.3.1             r36h6115d3f_0    conda-forge
r-digest                  0.6.25            r36hc5da6b9_2    conda-forge
r-doparallel              1.0.15            r36h6115d3f_1    conda-forge
r-dplyr                   1.0.1             r36h710217c_0    conda-forge
r-dt                      0.15              r36h6115d3f_0    conda-forge
r-dynamictreecut          1.63_1          r36h6115d3f_1003    conda-forge
r-ellipsis                0.3.1             r36h17f1fa6_0    conda-forge
r-evaluate                0.14              r36h6115d3f_2    conda-forge
r-fansi                   0.4.1             r36h17f1fa6_1    conda-forge
r-farver                  2.0.3             r36hc5da6b9_1    conda-forge
r-fastcluster             1.1.25          r36hd17c0aa_1003    conda-forge
r-fastmatch               1.1_0           r36h17f1fa6_1005    conda-forge
r-fdrtool                 1.2.15          r36h17f1fa6_1003    conda-forge
r-fit.models              0.64              r36h6115d3f_0    conda-forge
r-foreach                 1.5.0             r36h6115d3f_1    conda-forge
r-foreign                 0.8_76            r36h17f1fa6_1    conda-forge
r-formula                 1.2_3           r36h6115d3f_1003    conda-forge
r-fs                      1.5.0             r36h710217c_0    conda-forge
r-gdata                   2.18.0          r36h6115d3f_1003    conda-forge
r-generics                0.0.2           r36h6115d3f_1003    conda-forge
r-ggplot2                 3.3.2             r36h6115d3f_0    conda-forge
r-gh                      1.1.0             r36h6115d3f_1    conda-forge
r-git2r                   0.27.1            r36h8d49edc_0    conda-forge
r-glmnet                  4.0_2             r36h384270c_0    conda-forge
r-glue                    1.4.1             r36h17f1fa6_0    conda-forge
r-gplots                  3.0.4             r36h6115d3f_0    conda-forge
r-gridextra               2.3             r36h6115d3f_1003    conda-forge
r-gtable                  0.3.0             r36h6115d3f_3    conda-forge
r-gtools                  3.8.2             r36h17f1fa6_1    conda-forge
r-highr                   0.8               r36h6115d3f_2    conda-forge
r-hmisc                   4.4_1             r36hbce4cb8_0    conda-forge
r-htmltable               2.0.1             r36h6115d3f_0    conda-forge
r-htmltools               0.5.0             r36hc5da6b9_0    conda-forge
r-htmlwidgets             1.5.1             r36h6115d3f_1    conda-forge
r-httr                    1.4.2             r36h6115d3f_0    conda-forge
r-igraph                  1.2.5             r36h28033da_1    conda-forge
r-ini                     0.3.1           r36h6115d3f_1003    conda-forge
r-isoband                 0.2.2             r36hc5da6b9_0    conda-forge
r-iterators               1.0.12            r36h6115d3f_1    conda-forge
r-jpeg                    0.1_8.1           r36h17f1fa6_1    conda-forge
r-jsonlite                1.7.0             r36h17f1fa6_0    conda-forge
r-kernsmooth              2.23_17           r36h3830744_1    conda-forge
r-knitr                   1.29              r36h6115d3f_0    conda-forge
r-labeling                0.3             r36h6115d3f_1003    conda-forge
r-later                   1.1.0.1           r36hc5da6b9_0    conda-forge
r-lattice                 0.20_41           r36h17f1fa6_2    conda-forge
r-latticeextra            0.6_29            r36h6115d3f_1    conda-forge
r-lazyeval                0.2.2             r36h17f1fa6_2    conda-forge
r-lifecycle               0.2.0             r36h6115d3f_1    conda-forge
r-locfit                  1.5_9.4           r36h17f1fa6_1    conda-forge
r-magrittr                1.5             r36h6115d3f_1003    conda-forge
r-markdown                1.1               r36h17f1fa6_1    conda-forge
r-mass                    7.3_51.6          r36h17f1fa6_2    conda-forge
r-matrix                  1.2_18            r36h26f5615_3    conda-forge
r-matrixstats             0.56.0            r36h17f1fa6_1    conda-forge
r-memoise                 1.1.0           r36h6115d3f_1004    conda-forge
r-mgcv                    1.8_31            r36h26f5615_1    conda-forge
r-mime                    0.9               r36h17f1fa6_1    conda-forge
r-munsell                 0.5.0           r36h6115d3f_1003    conda-forge
r-mvtnorm                 1.1_1             r36h384270c_0    conda-forge
r-nlme                    3.1_148           r36h384270c_0    conda-forge
r-nnet                    7.3_14            r36h17f1fa6_1    conda-forge
r-openssl                 1.4.2             r36h9d0ceee_0    conda-forge
r-pcapp                   1.9_73          r36hdab79a9_1003    conda-forge
r-permute                 0.9_5             r36h6115d3f_3    conda-forge
r-phangorn                2.5.5             r36hc5da6b9_2    conda-forge
r-pillar                  1.4.6             r36h6115d3f_0    conda-forge
r-pixmap                  0.4_11          r36h6115d3f_1003    conda-forge
r-pkgbuild                1.1.0             r36h6115d3f_0    conda-forge
r-pkgconfig               2.0.3             r36h6115d3f_1    conda-forge
r-pkgload                 1.1.0             r36hc5da6b9_0    conda-forge
r-plogr                   0.2.0           r36h6115d3f_1003    conda-forge
r-plyr                    1.8.6             r36hc5da6b9_1    conda-forge
r-png                     0.1_7           r36h17f1fa6_1004    conda-forge
r-praise                  1.0.0           r36h6115d3f_1004    conda-forge
r-prettyunits             1.1.1             r36h6115d3f_1    conda-forge
r-processx                3.4.3             r36h17f1fa6_0    conda-forge
r-promises                1.1.1             r36hc5da6b9_0    conda-forge
r-propr                   4.2.6             r36hc5da6b9_1    conda-forge
r-ps                      1.3.4             r36h800e0f2_0    conda-forge
r-purrr                   0.3.4             r36h17f1fa6_1    conda-forge
r-quadprog                1.5_8             r36h3830744_2    conda-forge
r-r6                      2.4.1             r36h6115d3f_1    conda-forge
r-rcmdcheck               1.3.3             r36h6115d3f_3    conda-forge
r-rcolorbrewer            1.1_2           r36h6115d3f_1003    conda-forge
r-rcpp                    1.0.5             r36hc5da6b9_0    conda-forge
r-rematch2                2.1.2             r36h6115d3f_1    conda-forge
r-remotes                 2.2.0             r36h6115d3f_0    conda-forge
r-reshape2                1.4.4             r36hc5da6b9_1    conda-forge
r-rex                     1.2.0             r36h6115d3f_1    conda-forge
r-rlang                   0.4.7             r36h17f1fa6_0    conda-forge
r-robust                  0.5_0.0           r36hb1cbdc7_1    conda-forge
r-robustbase              0.93_6            r36hb1cbdc7_1    conda-forge
r-roxygen2                7.1.1             r36hc5da6b9_0    conda-forge
r-rpart                   4.1_15            r36h17f1fa6_2    conda-forge
r-rprojroot               1.3_2           r36h6115d3f_1003    conda-forge
r-rrcov                   1.5_5             r36h2e3815d_0    conda-forge
r-rsqlite                 2.2.0             r36hc5da6b9_2    conda-forge
r-rstudioapi              0.11              r36h6115d3f_1    conda-forge
r-rvcheck                 0.1.8             r36h6115d3f_1    conda-forge
r-rversions               2.0.2             r36h6115d3f_0    conda-forge
r-scales                  1.1.1             r36h6115d3f_0    conda-forge
r-sessioninfo             1.1.1           r36h6115d3f_1002    conda-forge
r-shape                   1.4.4                  r36_1003    conda-forge
r-slam                    0.1_47            r36h39f91c9_2    conda-forge
r-sp                      1.4_2             r36h17f1fa6_0    conda-forge
r-stringi                 1.4.6             r36h3211bb2_2    conda-forge
r-stringr                 1.4.0             r36h6115d3f_2    conda-forge
r-survival                3.2_3             r36h17f1fa6_0    conda-forge
r-sys                     3.4               r36h800e0f2_0    conda-forge
r-testthat                2.3.2             r36hc5da6b9_1    conda-forge
r-tibble                  3.0.3             r36h17f1fa6_0    conda-forge
r-tidyr                   1.1.1             r36h710217c_1    conda-forge
r-tidyselect              1.1.0             r36h6115d3f_0    conda-forge
r-tidytree                0.3.3             r36h6115d3f_1    conda-forge
r-usethis                 1.6.1             r36h6115d3f_1    conda-forge
r-utf8                    1.1.4           r36h17f1fa6_1003    conda-forge
r-vctrs                   0.3.2             r36h800e0f2_0    conda-forge
r-vegan                   2.5_6             r36hb1cbdc7_2    conda-forge
r-viridis                 0.5.1           r36h6115d3f_1004    conda-forge
r-viridislite             0.3.0           r36h6115d3f_1003    conda-forge
r-wgcna                   1.69              r36hf99fc2c_0    bioconda
r-whisker                 0.4               r36h6115d3f_1    conda-forge
r-withr                   2.2.0             r36h6115d3f_1    conda-forge
r-xfun                    0.16              r36h800e0f2_0    conda-forge
r-xml2                    1.3.2             r36hc5da6b9_1    conda-forge
r-xopen                   1.0.0           r36h6115d3f_1003    conda-forge
r-yaml                    2.2.1             r36h17f1fa6_1    conda-forge
r-zeallot                 0.1.0           r36h6115d3f_1002    conda-forge
readline                  8.0                  h0678c8f_2    conda-forge
requests                  2.24.0             pyh9f0ad1d_0    conda-forge
retrying                  1.3.3                    pypi_0    pypi
rpy2                      3.3.2                    pypi_0    pypi
scikit-bio                0.5.6            py38h65ad66c_2    conda-forge
scikit-image              0.17.2           py38h5fc983b_1    conda-forge
scikit-learn              0.23.2           py38hfde8033_0    conda-forge
scipy                     1.5.2            py38h1402333_0    conda-forge
seaborn                   0.10.1                        1    conda-forge
seaborn-base              0.10.1                     py_1    conda-forge
send2trash                1.5.0                      py_0    conda-forge
setuptools                49.3.1           py38h32f6830_0    conda-forge
six                       1.15.0             pyh9f0ad1d_0    conda-forge
sklearn                   0.0                      pypi_0    pypi
snappy                    1.1.8                h4a8c4bd_3    conda-forge
soothsayer                2020.8.12                pypi_0    pypi
soothsayer-utils          2020.7.31                pypi_0    pypi
sortedcontainers          2.2.2              pyh9f0ad1d_0    conda-forge
sqlalchemy                1.3.16                   pypi_0    pypi
sqlite                    3.32.3               h93121df_1    conda-forge
statsmodels               0.11.1           py38h64e0658_2    conda-forge
supervenn                 0.1.17                   pypi_0    pypi
tapi                      1000.10.8            h879752b_4    conda-forge
tbb                       2019.0                   pypi_0    pypi
tblib                     1.6.0                      py_0    conda-forge
templateflow              0.6.0                    pypi_0    pypi
teneto                    0.5.1                    pypi_0    pypi
terminado                 0.8.3                    pypi_0    pypi
testpath                  0.4.4                      py_0    conda-forge
threadpoolctl             2.1.0              pyh5ca1d4c_0    conda-forge
thrift                    0.13.0                   pypi_0    pypi
tifffile                  2020.7.24                  py_0    conda-forge
tk                        8.6.10               hbbe82c9_0    conda-forge
tktable                   2.10                 h008db23_3    conda-forge
toml                      0.10.1             pyh9f0ad1d_0    conda-forge
toolz                     0.10.0                     py_0    conda-forge
tornado                   6.0.4            py38h64e0658_1    conda-forge
tqdm                      4.48.2             pyh9f0ad1d_0    conda-forge
traitlets                 4.3.3            py38h32f6830_1    conda-forge
typing_extensions         3.7.4.2                    py_0    conda-forge
tzlocal                   2.1                pyh9f0ad1d_0    conda-forge
umap-learn                0.4.2                    pypi_0    pypi
urllib3                   1.25.10                    py_0    conda-forge
wcwidth                   0.2.5              pyh9f0ad1d_1    conda-forge
webencodings              0.5.1                    pypi_0    pypi
werkzeug                  1.0.1                    pypi_0    pypi
wget                      3.2                      pypi_0    pypi
wheel                     0.34.2                     py_1    conda-forge
widgetsnbextension        3.5.1                    pypi_0    pypi
xarray                    0.16.0                     py_0    conda-forge
xlrd                      1.2.0                    pypi_0    pypi
xorg-kbproto              1.0.7             h1de35cc_1002    conda-forge
xorg-libice               1.0.10               h01d97ff_0    conda-forge
xorg-libsm                1.2.3             h01d97ff_1000    conda-forge
xorg-libx11               1.6.11               haf1e3a3_0    conda-forge
xorg-libxau               1.0.9                h1de35cc_0    conda-forge
xorg-libxdmcp             1.1.3                h01d97ff_0    conda-forge
xorg-libxext              1.3.4                h01d97ff_0    conda-forge
xorg-libxrender           0.9.10            h01d97ff_1002    conda-forge
xorg-renderproto          0.11.1            h1de35cc_1002    conda-forge
xorg-xextproto            7.3.0             h1de35cc_1002    conda-forge
xorg-xproto               7.0.31            h1de35cc_1007    conda-forge
xz                        5.2.5                haf1e3a3_1    conda-forge
yaml                      0.2.5                h0b31af3_0    conda-forge
zeromq                    4.3.2                h4a8c4bd_3    conda-forge
zfp                       0.5.5                h4a8c4bd_1    conda-forge
zict                      2.0.0                      py_0    conda-forge
zipp                      3.1.0                      py_0    conda-forge
zlib                      1.2.11                     1007    conda-forge
zstd                      1.4.5                h0384e3a_2    conda-forge

@aschonfeld
Copy link
Collaborator

So you should be able to check your version using the “About” button on the main menu which you can access bu clicking the triangle in the upper lefthand corner

@aschonfeld
Copy link
Collaborator

@jolespin So I think the issue is that its having an issue trying to verify that its up and running. I've seen this before and I keep meaning to put a timeout on that verification (I will do that now). Anyways, one way around that is to do the following:

d = dtale.show(df)
d._main_url

You can either click on the output of d._main_url (which in some notebooks gets rendered as a clickable link) or just copy and paste that url into your browser.

Let me know if that works, because if not i'll need some more information on how you're running your notebook. Like if it is running under kubernetes I'd try using the jupyterhub_server_proxy support

@aschonfeld
Copy link
Collaborator

Hmm, looks like I did add a timeout back in version 1.8.13. Let me know if those options I suggested work...

aschonfeld added a commit that referenced this issue Aug 18, 2020
* #243: column menu descriptions
* #247: code export compilation error fixes
* #242: type conversion column menu option & auto-column names on "Build Column"
* #235: nan formatting
@jolespin
Copy link
Author

jolespin commented Aug 18, 2020

Thanks for looking into it. I'm checking it right now.

image

I tried opening up the URL but it's also not loading:

http://jespinozlt2-osx:40000/dtale/main/1

I'm using jupyter lab on Mac OS v10.15.5

@aschonfeld
Copy link
Collaborator

Well last ditch effort you can simply try entering http://localhost:40000 in your browser and see if it works. I’ve certainly seen macs return hostnames (computer names) that arent valid hostnames.

If that works you can just set your host to localhost when starting dtale: dtale.show(df, host=‘localhost’)

aschonfeld added a commit that referenced this issue Aug 19, 2020
* #243: column menu descriptions
* #247: code export compilation error fixes
* #242: type conversion column menu option & auto-column names on "Build Column"
* #235: nan formatting
aschonfeld added a commit that referenced this issue Aug 20, 2020
* #243: column menu descriptions
* #247: code export compilation error fixes
* #242: type conversion column menu option & auto-column names on "Build Column"
* #235: nan formatting
aschonfeld added a commit that referenced this issue Aug 20, 2020
* #243: column menu descriptions
* #247: code export compilation error fixes
* #242: type conversion column menu option & auto-column names on "Build Column"
* #235: nan formatting
@aschonfeld
Copy link
Collaborator

Added in v1.14.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants