I have some data (Please see attached the screenshot) in an Excel sheet. I need to convert it into timeseries with two coloumns. Basically, the first coloumn should the date and the second coloumn should be the values. I was wondering if anyone could help me with this.
The data is formatted in two columns separated by a single space:
The first column is the datetime in the following format: 'DDMMYYYYhhmm'. 'DD' is the day of the month as a two digit integer 'MM' is the month of the year as a two digit integer 'YYYY' is the year as a four digit integer 'hh' is the hour of the day (using 24 hour time) as a two digit integer 'mm' is the minute of the hour as a two digit integer.
The second column is the water level reading in metres in the following format: 'si.fff'. 's' is a prefix indicating if the reading is positive or negative positive readings are denoted by a space ' ' negative readings are denoted by a dash '-'. 'i.fff' is the height of the recording in metres
For example, the line '190120380314 3.142' would refer to a height of 3.142 metres recorded at 03:14am on the 19th of January 2038.