pandas in matlab using iloc for indexing

Question

Amir Azadeh Ranjbar 2023-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2029014-pandas-in-matlab-using-iloc-for-indexing

回答： Mike Croucher 2024-5-29

i want use pandas in matlab but i cant use this for iloc indexing :

% Import pandas:
pd = py.importlib.import_module('pandas');
% Create a dataframe:
df = pd.read_csv('movies.csv');
df.head(int8(5))
df.shape
df.dtypes
df.iloc(int8(5)) % in this line i got some error ->
"Same base class matlab.mixin.internal.indexing.Paren specified more"+...
"than once for class py.pandas.core.indexing._iLocIndexer.  Specify"+...
"each base class only once."

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Aimee Nogoy 2024-5-28

Did you ever figure this out? Got a similar error but for a different module

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Mike Croucher 2024-5-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2029014-pandas-in-matlab-using-iloc-for-indexing#answer_1465016

在 MATLAB Online 中打开

Indexing into Pandas data frames in this way is not supported. As of R2024a, you can convert the dataframe to a MATLAB table and then index into that

%Make a pandas dataframe
last_names = py.pandas.Series({"Sanchez","Johnson","Zhang","Diaz","Brown"},dtype="object");
age = py.numpy.random.randint(18,high=85,size=py.len(last_names));
height = py.numpy.random.randint(60,high=78,size=py.len(last_names));
df = py.pandas.DataFrame(struct("LastName",last_names,"Age",age,"Height",height));
%Convert to table
md = table(df)
md =
  5×3 table
    LastName     Age    Height
    _________    ___    ______
    "Sanchez"    45       75  
    "Johnson"    29       64  
    "Zhang"      65       71  
    "Diaz"       26       76  
    "Brown"      23       71  
%Index into it
    md(1,:)
ans =
  1×3 table
    LastName     Age    Height
    _________    ___    ______
    "Sanchez"    45       75 