Continuous time data in R

Asked

Viewed 43 times

0

I’ve put together a dataset of covid-19 cases per monthly death, but I can’t plot the results. Does anyone know a more elegant or correct way to do this?

I processed the database, and at the end it’s in the summary. I did the grouping and then Plot, but the graph gets missing data, as shown below.

It is possible to plot the continuous data month by month, ending the year 2020 and continuing in 2021 successively?

Summary of my data

> glimpse(dados)
Rows: 1,984,377
Columns: 5
$ data   <date> 2020-02-25, 2020-02-26, 2020-02-27, 2020-02-...
$ obitos <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...
$ semana <int> 9, 9, 9, 9, 9, 10, 10, 10, 10, 10, 10, 10, 11...
$ mes    <ord> fev, fev, fev, fev, fev, mar, mar, mar, mar, ...
$ ano    <dbl> 2020, 2020, 2020, 2020, 2020, 2020, 2020, 202...

Grouping of data

dados_mensais <- group_by(dados, ano, mes) %>% 
  summarise(total_obitos=sum(obitos))

Graph

ggplot(dados_mensais, aes(x=mes, y=total_obitos)) +
  geom_line(lwd=1.1, col='red')+
  scale_y_continuous(labels = number_format(scale = 1/100000, suffix = 'mil'))+
  labs(x='Anos', y=NULL, title='Evolução da população brasileira') +
  theme_minimal()

Gráfico faltando informações...

r ggplot2 graphic time-series

  • Welcome to SOPT! It would be interesting if you put a small part of your data to play (using dput() for example).

  • 1

    And don’t use the tag rstudio if the question is not specific to that GUI.

  • @Artur_indio interesting this sample tip with dput(). I already added here in the script.Follow the link to the data sample: data sample

  • @Carloseduardolagosta used the tag because it was the IDE I’m using, I didn’t notice it. Thank you.

  • @jaac in case you should put the dput result in your question, for example by putting 10% of your data and not the cloud data link for someone to download.

  • Link file and question data are different enough not to be able to reproduce the problem.

Show 1 more comment

1 answer

0

An alternative is to add the variable year as Facet on the chart:

   ggplot(dados_mensais, aes(x=mes, y=total_obitos)) +
      geom_line(lwd=1.1, col='red')+
      scale_y_continuous(labels = number_format(scale = 1/100000, suffix = 'mil'))+
      labs(x='Anos', y=NULL, title='Evolução da população brasileira') +
      theme_minimal()+
      facet_grid(~.ano, scales = "free", space = "free")

Browser other questions tagged r ggplot2 graphic time-series

You are not signed in. Login or sign up in order to post.