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
1 view (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
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!