Hello Manikandan,
I understand that you want to determine the missing dates & times from your .csv file and save it in another .csv file in ascending order.
The algorithm is as follows:
Algorithm:
- Import the content of the file in a table.
- Traverse the table and at every iteration consider the current and the next timestamp.
- If the difference between two consecutive timestamps is not equals to 5 minutes, there are some missing timestamps. So, keep incrementing by 5 minutes and store the missing timestamps in an array.
- Finally create a .csv file with the array that contains missing timestamps.
The following code implements the algorithm:-
% Import the csv file
h = readtable('Rainfall.csv');
% Create a string array which will store the missing date and time
missingData = strings(1,1);
% Traverse the whole table
for i = 1:size(h,1)-1
% After storing the content of csv file in table format, the first
% column of every row gets stored as cell array.
% In order to perform operation, we need to convert it to datetime
% format
currTime = datetime(h{i,1},'InputFormat','dd-MM-yyyy HH:mm');
nextTime = datetime(h{i+1,1},'InputFormat','dd-MM-yyyy HH:mm');
% If the difference between two consecutive timestamps is not equals to
% 5 minutes, there are missing date and time according to the
% definition
if nextTime - currTime ~= duration(0,5,0)
currTime = currTime + duration(0,5,0);
% So keep incrementing by 5 minutes until the next timestamp is
% reached and store them in missingData array.
while currTime ~= nextTime
missingData(end+1) = string(currTime);
currTime = currTime + duration(0,5,0);
end
end
end
% Remove the first element as it is an empty string and unnecessary
missingData(1) = [];
% Finally create a csv file from the missing data
writematrix(missingData','ultimate.csv')
I hope this helps.
