I'm not sure I'm posting in the correct forum, but here it goes:
I wanted to do some more advanced exploratory data analysis, but I'm having some problems as how to better interpret the date and time columns of data.
Is there any way I can merge these to in a valid format? Or would it no longer make sense?
If I want to analyze the behavior of price for 1 minute intervals for instance, the Date column alone is pretty useless, because it represents just a single value for a whole day but if it could be merged with the Time column, it would present a very different picture.
When I export the data from Metatrader, the resulting csv has Date and Time in separate columns.
Is there any way I can merge them together and still make sense? I don't want to merge them as a string.Ideally it would be a new date format I can use in Excel, R, Matlab etc.
Any suggestions? I feel the solution to this is simple but I can't quite put my finger on it exactly, given that I'm not a programmer Please help.
edit: Nevermind, I figured it out eventually after more Google digging. I first did a Find+Replace on the "." in the Date column and replaced them with "/" in order to be properly recognized as a Date format in Excel and no longer be a string. After that I created a third column and calculated Date+Time and formatted the result as m/d/yyyy h:mm
I wanted to do some more advanced exploratory data analysis, but I'm having some problems as how to better interpret the date and time columns of data.
Is there any way I can merge these to in a valid format? Or would it no longer make sense?
If I want to analyze the behavior of price for 1 minute intervals for instance, the Date column alone is pretty useless, because it represents just a single value for a whole day but if it could be merged with the Time column, it would present a very different picture.
When I export the data from Metatrader, the resulting csv has Date and Time in separate columns.
Is there any way I can merge them together and still make sense? I don't want to merge them as a string.Ideally it would be a new date format I can use in Excel, R, Matlab etc.
Any suggestions? I feel the solution to this is simple but I can't quite put my finger on it exactly, given that I'm not a programmer Please help.
edit: Nevermind, I figured it out eventually after more Google digging. I first did a Find+Replace on the "." in the Date column and replaced them with "/" in order to be properly recognized as a Date format in Excel and no longer be a string. After that I created a third column and calculated Date+Time and formatted the result as m/d/yyyy h:mm