Home / Questions / 485631
Accepted
kev
Asked: 2022-09-22 09:46:33 +0800 CST 2022-09-22 09:46:33 +0800 CST

Export to excel data frames in R

  • 772

I have a data frame that I need to export to excel

enter image description here

In the excel I need the columns to be the years, the first row the code and the monthly rainfall values ​​to be for each year and code. The excel should have a sheet for each month, For example, the sheet for the month of April should be similar to this

`código  2000   2001   2002 ....  2019
 87345   116.3
 87347   103.6
 ....
 87467

`

r

1 Answers

  1. Best Answer
    library(tidyverse)
library(openxlsx)

    First convert the years to Wide format with the function pivot_wider

       df_1 = df %>% 
      pivot_wider(names_from = anio,values_from = precip.mensual)

    Then separate the df in a list with the monthly df with the split function

    df_1 %>% split(df_1$mes) %>% write.xlsx("df_por_mes.xlsx")

    The function write.xlsx understands that each element of the list is a tab

    • 1