WOW! The final plot was so much more clear and so pretty. Great explanation for cleaning raw data and how to best represent the data you have. Keep up the great work!
Wow! Nice explanation. I have a question for you if CSV file data specifies as timestamp in one column and temperature in another column, how to separate timestamp to date and time
Hi Divyajyothi, There are a few ways to go about this. The first is to use regex (regular expressions, sometimes called string manipulation), that can help you split a string into components... thus separating into date, time, hour, and so forth. Another option would convert that column into characters. Then you can use matrix indexing, like A_matrix(1:4) to grab the first four items. In your case, that might be the year you want to save. You can convert that back to a double() to use as a number. You can also look at working with the datetime format directly (not quite sure what datatype the column comes in as). you should check out these links: www.mathworks.com/matlabcentral/answers/362990-separate-date-and-time www.mathworks.com/help/matlab/ref/datestr.html www.mathworks.com/help/matlab/date-and-time-operations.html
This was exactly what I needed for a lab I was assigned. Thank you!
Perfect! Happy to help :)
WOW! The final plot was so much more clear and so pretty. Great explanation for cleaning raw data and how to best represent the data you have. Keep up the great work!
Thank you for watching! Glad you got something out of the process.
Wow! Nice explanation. I have a question for you if CSV file data specifies as timestamp in one column and temperature in another column, how to separate timestamp to date and time
Hi Divyajyothi,
There are a few ways to go about this. The first is to use regex (regular expressions, sometimes called string manipulation), that can help you split a string into components... thus separating into date, time, hour, and so forth.
Another option would convert that column into characters. Then you can use matrix indexing, like A_matrix(1:4) to grab the first four items. In your case, that might be the year you want to save. You can convert that back to a double() to use as a number.
You can also look at working with the datetime format directly (not quite sure what datatype the column comes in as). you should check out these links:
www.mathworks.com/matlabcentral/answers/362990-separate-date-and-time
www.mathworks.com/help/matlab/ref/datestr.html
www.mathworks.com/help/matlab/date-and-time-operations.html