'ts' object must have one or more observations

Question

the error is shown above. I am trying to plot a graph that show the amount of tweet within each month of 2016. My question is how can I am able to found out the amount of tweet for each month in order for me to plot a graph to see which month tweeted the most.

library(ggplot2)  
library(RColorBrewer)  
library(rstudioapi)

current_path = rstudioapi::getActiveDocumentContext()$path 
setwd(dirname(current_path ))
print( getwd() )

donaldtrump <- read.csv("random_poll_tweets.csv", stringsAsFactors = FALSE)

print(str(donaldtrump))

time8_ts <- ts(random$time8, start = c(2016,8), frequency = 12)
time7_ts <- ts(random$time7, start = c(2016,7), frequency = 12)
time6_ts <- ts(random$time6, start = c(2016,6), frequency = 12)
time5_ts <- ts(random$time5, start = c(2016,5), frequency = 12)
time4_ts <- ts(random$time4, start = c(2016,4), frequency = 12)
time3_ts <- ts(random$time3, start = c(2016,3), frequency = 12)
time2_ts <- ts(random$time2, start = c(2016,2), frequency = 12)
time1_ts <- ts(random$time1, start = c(2016,1), frequency = 12)

browser_mts <- cbind(time8_ts, time7_ts,time6_ts,time5_ts,time4_ts,time3_ts,time2_ts,time1_ts)
dimnames(browser_mts)[[2]] <- c("8","7","6","5","4","3","2","1")

pdf(file="fig_browser_tweet_R.pdf",width = 11,height = 8.5)  
ts.plot(browser_mts, ylab = "Amount of Tweet", xlab = "Month",
        plot.type = "single", col = 1:5)
legend("topright", colnames(browser_mts), col = 1:5, lty = 1, cex=1.75)

Welcome to SO. Please provide a `dput(head(donaldtrump))` so we can see the data structure. — Benson_YoureFired, Nov 24 '22 at 16:28
sorry I didnt really get you. But from my program i didnt do any data frame for it. Thanks @Benson_YoureFired — Mastery mind, Nov 24 '22 at 16:35
[This page](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) will explain how to make a great R reproducible example. — Benson_YoureFired, Nov 24 '22 at 16:42
We need to see the structure of your data so we can help. `browser_ts` is the variable holding your data, correct ? — Benson_YoureFired, Nov 24 '22 at 16:43
Yes. I have basically 3 column in my excel sheet. The second column is the one im trying to find. 448 obs. of 3 variables. @Benson_YoureFired — Mastery mind, Nov 25 '22 at 03:11

Isaiah · Accepted Answer · 2022-11-25T07:19:40.587

library(lubridate)
library(dplyr)
donaldtrump$created_at <- donaldtrump$created_at |>
  mdy_hm() |>
  floor_date(unit = "month")
donaldtrump |> count(created_at)

Just because you are looking at a time series doesn't mean that you must use a time series object.

If you want a plot:

library(ggplot2)
donaldtrump |>
  count(created_at) |>
  ggplot(aes(created_at, n)) + geom_col() +
  labs(x = "Amount of Tweet", y = "Month")

'ts' object must have one or more observations

1 Answers1