Comparison of two unequal length files.

Question

Devang Anadkat 2021-3-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/771613-comparison-of-two-unequal-length-files

评论： Devang Anadkat 2021-3-13

I have two .csv files of unequal length. each file has two colomns and one has 50000 rows and other has 27000 rows. in this first colomn is of wavelengths and other is of intensity. I want to get data in which the wavelengths of both files are equal and also want corrsponding intensities. so how can i find it using program?

thanking you in advance.

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

请先登录，再进行评论。

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

Answer 1

Jan 2021-3-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/771613-comparison-of-two-unequal-length-files#answer_646813

Import the files. (Is this a part of your problem?)
Search the intersection of the common variable with the command intersect . The 2nd and 3rd output give you the overlapping indices.

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

Jan 2021-3-13

编辑：Jan 2021-3-13

在 MATLAB Online 中打开

I do not know, how the intensities are represented. Did you mention, if you your data are matrices with a specific number pof columns? A small example would be useful. With some guessing:

A = [1; 3; 2; 17]   % 1st file
B = [0, 0.1; 1, 0.2; 2, 0.3; 3 0.4; 17, 0.5; 24, 0.6];  % 2nd file
[Common, iA, iB] = intersect(A, B(:, 1));
CommonIntesity   = B(iB, 2)
A(iA, 2)         = B(iB, 2)   % Maybe wanted...

Devang Anadkat 2021-3-13

this is first file

4.0004000e+02 2.2576667e+03

4.0006000e+02 2.7194000e+03

4.0008000e+02 2.9347143e+03

4.0010000e+02 3.0555556e+03 &

this is second file

400.04 0.2702

400.05 0.27026

400.06 0.27031

400.07 0.27036

400.08 0.27041

in this both files first colomn is of wavelength and other one is of intensity. i got the wavelength which are same in both files say 400.04 400.06 etc.. but in both files intensity is different corresponding to that same wavelength. so now i want the table in which i got first colomn is of wavelength which are common in both file second colomn is of intensity which is in file 1 corresponding to common wavelength and 3rd colomn is of intensity which is in file 2.

请先登录，再进行评论。