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 (최근 30일)
이전 댓글 표시
convert the GLDAS ......csv in the format of Apr-02.csv
댓글 수: 0
채택된 답변
KSSV
2018년 6월 26일
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
추가 답변 (1개)
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!