Having Issues in Creating Time Series out of an unstructured dataset

[kkaul003]

Hi,
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

1. 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.
2. 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. ?

Thanks
K

[andresrcs]

Hi!

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[kkaul003]

Attached is the sample data set out of the entire dataset that i am working on.
I uploaded this data in R studio and below is the code of lines that i tried to run.

R-Code

#Sort the data
sample.yearly <-sample.yearly[order(sample.yearly$Category, sample.yearly$Starting Year),]

#Create time series & plot
sample.yearly.ts = ts(sample.yearly)
plot(sample.yearly.ts) #just a plot

#Error
Error in plotts(x = x, y = y, plot.type = plot.type, xy.labels = xy.labels, :
cannot plot more than 10 series as "multiple"

My aim here is to create a time series for the attached dataset

1. Based on each Category
2. Time series as a whole dataset

Any pointers for this would be highly appreciated.

Thanks

[andresrcs]

@kkaul003

Attached is the sample data set out of the entire dataset that i am working on.

That is not sample data, that is a screenshot (and not a good thing to do here), please read the link I gave you before and try to make a proper reproducible example.