0

I have a dataframe with 60 rows of data, here I'm posting a single column of it, so we have some data to work:

    local   N
1    IPA   0.164
2    IPA   0.045
3    IPA   0.069
4    IPA   0.100
5    IPA   0.050
.     .      .
.     .      .
.     .      . 
28   IPA   0.078
29   IPA   0.121
30   IPA   0.104
31   OPA   0.035
32   OPA   0.057
33   OPA   0.043
.     .      .
.     .      .
.     .      .
55   OPA   0.021
56   OPA   0.004
57   OPA   0.043
58   OPA   0.002
59   OPA   0.005
60   OPA   0.034

Observe that the local for the 30 first reading is IPA and the local for the last 30 readings is OPA. I'm using knitr to make a pdf file with all my analysis in R, however if I print this column, I get a very long table that occupies a whole page.

stargazer(data[c("local", "N")], summary=FALSE)

I'm using stargazer, but I can also do it with other packages. My goal is to divide the printed table in two columns so it can have better dimensions and fit better my text. I'm trying to get something lie this:

    local    N          local   N
1    IPA   0.164   31   OPA   0.035
2    IPA   0.045   32   OPA   0.057
3    IPA   0.069   33   OPA   0.043
4    IPA   0.100   34   OPA   0.029
5    IPA   0.050   35   OPA   0.017
.     .      .     .     .      .
.     .      .     .     .      .
.     .      .     .     .      .
25   IPA   0.141   55   OPA   0.021
26   IPA   0.100   56   OPA   0.004
27   IPA   0.104   57   OPA   0.043
28   IPA   0.078   58   OPA   0.002
29   IPA   0.121   59   OPA   0.005
30   IPA   0.104   60   OPA   0.034

I'm diving 30 rown to the left and 30 to the right because the local for the 30 first readings (IPA) is different from the local to the 30 last readings (OPA). An even better achievement for me will be to have the local as a name of the table, something like:

    IPA N        OPA N
1   0.164   31   0.035
2   0.045   32   0.057
3   0.069   33   0.043
4   0.100   34   0.029
5   0.050   35   0.017
.     .     .      .  
.     .     .      .  
.     .     .      .  
25   0.141   55   0.021
26   0.100   56   0.004
27   0.104   57   0.043
28   0.078   58   0.002
29   0.121   59   0.005
30   0.104   60   0.034

I have tried to make stargazer understand the data I'm sending to it as a 2 column table, but I'm not having the desired result

stargazer(c(data[grep("IPA", data$local), "N"],
            data[grep("OPA", data$local), "N"]),
          summary=FALSE)

This results in a very long row, actually. :/

rvbarreto
  • 683
  • 9
  • 24

0 Answers0