Hello,
I have a dataset excel CSV sheet with a three columns,(X,Y, and Z)
The first and second columns represents the coordinates of point, while the third one represents the elevations value of the point.
What I need is to subtract the first row from the second one and the second row from the third and the fourth from the fifth and the fifth from the sixth ….. etc. till the end of the data
The output should be saved on a fourth column (say output column)
Finally all the datasets to be saved to an excel file
Thanks A lot,
Could you not do this in Excel without any programming? Or just use VBA (Visual Basic for Applications) within Excel, without MATLAB? After all, the data is going into Excel in the end. The answer below works because Excel can use relative references when calculating values. As it seems you are measuring a difference in elevation, here's a procedure for that:
I've attached a file to demonstrate (MS Excel)
Hi Eslam,
Here are my replies.
1. Import the original csv file into Matlab by using the Import Data function on the HOME tab. You can rename the imported table as "data".
2. Use the code data=data{:,:} to convert the "data" from table to string.
3. Build the function to abstract the values. For example, if there are 100 columns
for i=1: 99
T(i,1)=data(i,i+1);
end
4. Convert T from string to double.
T=str2double(T)
5. Output T to a csv file.
csvwrite('T.csv',T)
I would like to recommend R programming. A data frame, table, matrix, etc.. Extract the rows each time and save on csv
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column