Hi, I am trying to clean and sort my data.
My data is monthly price data for several firms, where month(the period) is written 1996m7. It is not chronological, and I will need this, ie. jan 2010, feb 2010........ How can I sort this?
It is a big dataframe, with several companies:
Some of the companies don´t have data for all of the year/months, so I have removed the empty values (so each company might have different start and end time)
Company 1 ; 1996m1 ; price
Company 1 ; 1996m11 ; price
Company 1 ;1996m12 ; price
Company 1; 1996m2 ; price
Company 1; 1996m3 ; price
Company1;2000m9 ; price
Company2; 1996m1 ; price