How to write output data in excel csv files?

1 次查看（过去 30 天）

显示更早的评论

Devendra 2024-3-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2098656-how-to-write-output-data-in-excel-csv-files

编辑： gauri 2024-5-19

采纳的回答： Voss

在 MATLAB Online 中打开

My for loops are as follows;

number of image files are 114

number of shape files are 242

for m = 1:length(imgfiles)
    for n = 1:length(shapefiles)
        avg_village_ndvi(n,m) = mean(village_ndvi(mask));
        avge_village_ndre1(n,m) = mean(village_ndre1(mask));
        avg_village_cire(n,m) = mean(village_cire(mask));
        CAF(n,m) = nnz(village_ndvi(mask) > 0.4) / (size(village_ndvi,1)*size(village_ndvi,2))
    end
end

I want to write these data in seperate excel csv file with file name as 'c:\data\ndvi_predictors.csv','c:\data\ndre1_predictors.csv','c:\data\cire_predictors.csv' and 'c:\data\caf_predictors.csv'.

I request all to please suggest me how to do it in above mentioned matlab code.

I would appreciate any help in this regard.

Dave

采纳的回答

Voss 2024-3-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2098656-how-to-write-output-data-in-excel-csv-files#answer_1430696

在 MATLAB Online 中打开

After the for loops:

writematrix(avg_village_ndvi,'c:\data\ndvi_predictors.csv')
writematrix(avge_village_ndre1,'c:\data\ndre1_predictors.csv')
writematrix(avg_village_cire,'c:\data\cire_predictors.csv')
writematrix(CAF,'c:\data\caf_predictors.csv')

23 个评论
显示 21更早的评论隐藏 21更早的评论

Voss 2024-5-7

You're welcome!

gauri 2024-5-19

编辑：gauri 2024-5-19

Once again I seek your kind help to retrieve the data using shape file. I am using the mask to extract the data using shape file as follows;

mask = reshape(isinterior(polygon, lon(:), lat(:)), [length(lat), length(lon)]);

% Convert the logical mask to uint16 format

maskConverted = uint16(mask);

% Apply the converted mask to the raster

imgMasked = img .* maskConverted;

The size of imgMasked is same as that of img(5490 5490 7). However, it contains non zero data over shape file area and zeros over rest of the image data. I wanted to retrieve the non zeros data from imgMasked as per the size of the shape file. I request you to please suggest me how to retrieve the desired data from imgMasked. I have kept the imgMasked.mat file on following google link;

https://drive.google.com/file/d/1COeEtDXcX3FW7HXXGzYfLBR0cqrKjRhE/view?usp=drive_link

I request you to please have a look on it and suggest me how to get required data from imgMasked.

I would be highly obliged to you.

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

Statistics and Machine Learning Toolbox

版本

R2024a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by