I told you I was going to work on these data processing tips! Just uploaded a new one on dealing with dates and times, particularly around importing and moving between data analysis software packages. There’s no consensus on how to encode dates and times, and every software maker has done it differently (or in the case of Microsoft, two different ways with another complication depending on the date itself). Understanding what the software is doing helps, but there’s also a belt-and-braces way of making absolutely sure nothing goes wrong.
Published by Robert