Is it possible to use pandas library in dynamo?

lei1 · February 17, 2019, 3:29am

As many of you guys might know, pandas is super powerful in dealing with excel files. Is there any way I can successfuly import pandas into my codes of python nodes in dynamo? Thanks!

CARLOSRODCEB · February 17, 2019, 7:01am

Sorry pal, it looks like it is not possible:

CARLOSRODCEB · February 20, 2019, 12:30pm

Ok, sorry to rush into the answer before digging more into it. If you have some time, it looks like this can be helpful:

github.com

eirannejad/pyRevit/blob/develop/extensions/pyRevitDevTools.extension/pyRevitDev.tab/Debug.panel/Misc Tests.pulldown/Test CPython Command.pushbutton/script.py

#! python3
# pylint: skip-file

# set PYTHONPATH to ....\Lib\site-packages correctly

def print_html(output_str):
    print(output_str.replace('<', '&clt;').replace('>', '&cgt;'))

import sys
print(sys.version)
print("\n## sys.path:")
print('\n'.join(sys.path))

# test numpy
try:
    import numpy as np
    print("\n## numpy array:")
    print(repr(np.arange(15).reshape(3, 5)))
except Exception as ex:
    print('numpy load error: {}'.format(ex))

This file has been truncated. show original

lei1 · February 20, 2019, 3:36pm

oh gosh! thank u so much for doing so much efforts on my question!!

i’ll try it during my tommorow’s work

maria.mingallon7S8Y4 · June 18, 2019, 11:19am

Hello,

Does this mean that we can use pandas within the Python Script editor in Dynamo? I have tried sys as above but it does not seem to work. Does it work for numpy?

Thanks
Maria

cgartland · June 18, 2019, 2:24pm

The above example is using PyRevit (CPython). Neither numpy nor pandas will work in Dynamo as it uses IronPython. There is a version of scipy and numpy specifically for IronPython, however it is 32-bit only (Dynamo is 64-bit), so this will not work either.

maria.mingallon7S8Y4 · June 20, 2019, 9:38pm

Hello,

posting link to this other thread which might result being a great way around this issue. Essentially resolving using numpy, pandas, scipy in Dynamo Python node.

Best
Maria

Topic		Replies	Views
IronPython 2.7 for Dynamo Developers	9	3049	February 21, 2018
Is there a way to use python 3 libraries in dynamobim Developers python	5	1124	March 6, 2020
Importing Numpy and scipy in Dynamo	6	2101	May 25, 2019
Intergral Functions - Dynamo Developers	5	1445	March 8, 2019
Libraries in Dynamo’s IronPython Developers python	2	598	November 24, 2021

Is it possible to use pandas library in dynamo?

Related topics