MATLAB: How to use Python pandas in MATLAB

modulepython

Looking at this tutorial (https://uk.mathworks.com/help/matlab/matlab_external/call-user-defined-custom-module.html), it appears easy to use a Python module in MATLAB.
I'd like to execute the following Python code snippet in MATLAB:
import pandas
tbl = pandas.read_csv('xxxxx.csv')
However, the following does not work in MATLAB.
tbl = py.pandas.read_csv('xxxxx.csv')
Any suggestions?

Best Answer

pyversion returns Python installation outside of Anaconda.
>> pyversion
       version: '2.7'
    executable: 'C:\Python27\python.EXE'
       library: 'C:\WINDOWS\system32\python27.dll'
          home: 'C:\Python27'
      isloaded: 1
So I needed to change the reference to the Anaconda version of Python.
After relaunching MATLAB, I used pyversion again to change the Python path. Then py.pandas.read_csv() worked!
>> pyversion 'C:\Users\xxxxxxxxx\AppData\Local\Continuum\anaconda2\python.EXE'
>> pyversion
       version: '2.7'
    executable: 'C:\Users\xxxxxxxxx\AppData\Local\Continuum\anaconda2\python.EXE'
       library: 'C:\Users\xxxxxxxxx\AppData\Local\Continuum\anaconda2\python27.dll'
          home: 'C:\Users\xxxxxxxxx\AppData\Local\Continuum\anaconda2'
      isloaded: 1
>> py.pandas.read_csv('xxxxxxxxx.csv')
ans = 
  Python DataFrame with properties:
          T: [1×1 py.pandas.core.frame.DataFrame]
         at: [1×1 py.pandas.core.indexing._AtIndexer]
       axes: [1×2 py.list]
     blocks: [1×1 py.dict]
    columns: [1×1 py.pandas.core.indexes.base.Index]
      empty: 0
        iat: [1×1 py.pandas.core.indexing._iAtIndexer]
       iloc: [1×1 py.pandas.core.indexing._iLocIndexer]
      index: [1×1 py.pandas.core.indexes.range.RangeIndex]
    is_copy: [1×1 py.NoneType]
         ix: [1×1 py.pandas.core.indexing._IXIndexer]
        loc: [1×1 py.pandas.core.indexing._LocIndexer]
       ndim: 2
      shape: [1×2 py.tuple]
       size: 120
      style: [1×1 py.pandas.io.formats.style.Styler]
     values: [1×1 py.numpy.ndarray]
       ...
    0  ...
    1  ...
    2  ...
    3  ...
    4  ...
    5  ...
    6  ...
    7  ...
    8  ...
    9  ...
    10 ...
    11 ...
    12 ...
    13 ...
    14 ...
    
    [15 rows x 8 columns]
Related Question