How do you write a filepath into a table?

Question

Jorge Young 2022-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1663749-how-do-you-write-a-filepath-into-a-table

评论： Jorge Young 2022-3-4

I have searched for some answer relevent to what I am asking and cannot find anything, so any help would be appreciated. I have a strange set of data, in that the filename of the .csv does not give all of the info of what is in the data, most of the info is located in the folder names. This is not an issue when dealing with a small amount, and I can look at it manually. However I have hundreds of filepaths. So my question is, is there a way to put the data in a table with information from the folder names in the table with it? for example if the path was something like

C:\Users\JY\Desktop\Weather\Monday\Overcast.csv

can I have a table that would show

[Weather,Monday,Overcast,"data_from_.csv" ]

thanks in advance for any help on this.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2022-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1663749-how-do-you-write-a-filepath-into-a-table#answer_909969

在 MATLAB Online 中打开

file_names = { ...
    'C:\Users\JY\Desktop\Weather\Monday\Overcast.csv'
    'C:\Users\JY\Desktop\Weather\Tuesday\Sunny.csv' ...
    };
% split the file names on '\' and '.' (you can use filesep() instead of '\'
% here):
new_names = cellfun(@(x)strsplit(x,{'\' '.'}),file_names,'UniformOutput',false);
new_names{:}
ans = 1×8 cell array
    {'C:'}    {'Users'}    {'JY'}    {'Desktop'}    {'Weather'}    {'Monday'}    {'Overcast'}    {'csv'}
ans = 1×8 cell array
    {'C:'}    {'Users'}    {'JY'}    {'Desktop'}    {'Weather'}    {'Tuesday'}    {'Sunny'}    {'csv'}
% Keep the last 4 parts (everything after "Desktop"):
file_info = cellfun(@(x)x(end-3:end),new_names,'UniformOutput',false);
file_info = vertcat(file_info{:})
file_info = 2×4 cell array
    {'Weather'}    {'Monday' }    {'Overcast'}    {'csv'}
    {'Weather'}    {'Tuesday'}    {'Sunny'   }    {'csv'}
% append the 'data_from_.' to the last column (containing 'csv'):
file_info(:,end) = strcat('data_from_.',file_info(:,end));
disp(file_info);
    {'Weather'}    {'Monday' }    {'Overcast'}    {'data_from_.csv'}
    {'Weather'}    {'Tuesday'}    {'Sunny'   }    {'data_from_.csv'}
% convert to an array of strings if that's what you need to use:
file_info_str = string(file_info);
disp(file_info_str);
    "Weather"    "Monday"     "Overcast"    "data_from_.csv"
    "Weather"    "Tuesday"    "Sunny"       "data_from_.csv"
% or convert either one into a table:
t = array2table(file_info,'VariableNames',{'Type','Day','Category','file(?)'})
t = 2×4 table
       Type            Day          Category           file(?)      
    ___________    ___________    ____________    __________________

    {'Weather'}    {'Monday' }    {'Overcast'}    {'data_from_.csv'}
    {'Weather'}    {'Tuesday'}    {'Sunny'   }    {'data_from_.csv'}
t = array2table(file_info_str,'VariableNames',{'Type','Day','Category','file(?)'})
t = 2×4 table
      Type          Day        Category         file(?)     
    _________    _________    __________    ________________

    "Weather"    "Monday"     "Overcast"    "data_from_.csv"
    "Weather"    "Tuesday"    "Sunny"       "data_from_.csv"