i have attached two csv file i want to convert "GLDAS_NOAH10......csv"file in the format of "Apr-02.csv".please provide me the code
2 views (last 30 days)
Show older comments
convert the GLDAS ......csv in the format of Apr-02.csv
0 Comments
Accepted Answer
KSSV
on 26 Jun 2018
file = 'GLDAS_NOAH10_M.A200201.021.csv' ;
[num,txt,raw] = xlsread(file) ;
lon = num(1,:) ; lon(1) = [] ;
lat = num(:,1) ; lat(1) = [] ;
A = num(2:end,2:end) ;
[X,Y] = meshgrid(lon,lat) ;
T = [X(:) Y(:) A(:)] ;
xlswrite('check.xlsx',T)
0 Comments
More Answers (1)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!