I am currently working on a data set that has yearly data for 4 different categories for example a,b,c and d. Now, this yearly data for each category has 20-25 number of observations (data in columns) depending on year and which category it is.
The problem that i am facing here is
- For this yearly data for a particular year (1900) category a has 5 records and out of those 3 records have 24 observations and 2 have 38 observations.
- Also, there is no particular sequence of years for which data have been recorded. Like, we have data for 1900,1901, 1902 and the staright we have data for year 1909.
So, given the above constraint, How should i proceed ahead to create a time series out of the given data frame of data. ?