How can i find specific data from a large no. of csv file?

1 次查看（过去 30 天）

Deepesh Kumar Gupta 2022-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1685199-how-can-i-find-specific-data-from-a-large-no-of-csv-file

评论： KSSV 2022-4-1

i have 1080 csv file named 1_1,1_2,...1_36, 2_1, 2_2,...2_36........30_1, 30_2,30_36, each file have different no. of rows with same no. of column,these files have x, y ,z and temperature values. I have one csv file named Data.csv having 68 combination of x ,y and z values , now i want to extract all 68 temperature values for each x , y and z points of Data.csv for each file into a single matrix of [68*1080]. How can i do this ,please help me with matlab code.

i am attaching Data.scv and one 1_1.csv for reference.

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

请先登录，再进行评论。

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

回答（1 个）

KSSV 2022-3-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1685199-how-can-i-find-specific-data-from-a-large-no-of-csv-file#answer_931274

在 MATLAB Online 中打开

T = readtable('Data.csv') ; 
csvFiles = dir('*.csv') ;   % otherfiles in a folder. Keep Data.csv seperatly 
N = length(csvFiles) ; 
M = size(T,1) ; 
iwant = zeros(M,N) ; 
for i = 1:N
    Ti = readtable(csvFiles(i).name) ; 
    idx = knnsearch([Ti.(1) Ti.(2)],[T.(1) T.(2)]) ; 
    iwant(:,i) = Ti.(3)(idx) ; 
end