Hi all.
I am working on big data with survey design. Until now, I am putting my R results manually in the word document. I was wondering if there is a package or specific function that can automatically give me publication quality table.
Thank you
Zafar
{rmarkdown} and {quarto} can mix text and code and can use a variety of formatters to render documents or standalone portions such as tables as HTML, pdf or, if necessary Word. Some of them are near automatic,
``` r
mtcars |> pander::pander()
| mpg | cyl | disp | hp | drat | wt | qsec | vs | |
|---|---|---|---|---|---|---|---|---|
| Mazda RX4 | 21 | 6 | 160 | 110 | 3.9 | 2.62 | 16.46 | 0 |
| Mazda RX4 Wag | 21 | 6 | 160 | 110 | 3.9 | 2.875 | 17.02 | 0 |
| Datsun 710 | 22.8 | 4 | 108 | 93 | 3.85 | 2.32 | 18.61 | 1 |
| Hornet 4 Drive | 21.4 | 6 | 258 | 110 | 3.08 | 3.215 | 19.44 | 1 |
| Hornet Sportabout | 18.7 | 8 | 360 | 175 | 3.15 | 3.44 | 17.02 | 0 |
| Valiant | 18.1 | 6 | 225 | 105 | 2.76 | 3.46 | 20.22 | 1 |
| Duster 360 | 14.3 | 8 | 360 | 245 | 3.21 | 3.57 | 15.84 | 0 |
| Merc 240D | 24.4 | 4 | 146.7 | 62 | 3.69 | 3.19 | 20 | 1 |
| Merc 230 | 22.8 | 4 | 140.8 | 95 | 3.92 | 3.15 | 22.9 | 1 |
| Merc 280 | 19.2 | 6 | 167.6 | 123 | 3.92 | 3.44 | 18.3 | 1 |
| Merc 280C | 17.8 | 6 | 167.6 | 123 | 3.92 | 3.44 | 18.9 | 1 |
| Merc 450SE | 16.4 | 8 | 275.8 | 180 | 3.07 | 4.07 | 17.4 | 0 |
| Merc 450SL | 17.3 | 8 | 275.8 | 180 | 3.07 | 3.73 | 17.6 | 0 |
| Merc 450SLC | 15.2 | 8 | 275.8 | 180 | 3.07 | 3.78 | 18 | 0 |
| Cadillac Fleetwood | 10.4 | 8 | 472 | 205 | 2.93 | 5.25 | 17.98 | 0 |
| Lincoln Continental | 10.4 | 8 | 460 | 215 | 3 | 5.424 | 17.82 | 0 |
| Chrysler Imperial | 14.7 | 8 | 440 | 230 | 3.23 | 5.345 | 17.42 | 0 |
| Fiat 128 | 32.4 | 4 | 78.7 | 66 | 4.08 | 2.2 | 19.47 | 1 |
| Honda Civic | 30.4 | 4 | 75.7 | 52 | 4.93 | 1.615 | 18.52 | 1 |
| Toyota Corolla | 33.9 | 4 | 71.1 | 65 | 4.22 | 1.835 | 19.9 | 1 |
| Toyota Corona | 21.5 | 4 | 120.1 | 97 | 3.7 | 2.465 | 20.01 | 1 |
| Dodge Challenger | 15.5 | 8 | 318 | 150 | 2.76 | 3.52 | 16.87 | 0 |
| AMC Javelin | 15.2 | 8 | 304 | 150 | 3.15 | 3.435 | 17.3 | 0 |
| Camaro Z28 | 13.3 | 8 | 350 | 245 | 3.73 | 3.84 | 15.41 | 0 |
| Pontiac Firebird | 19.2 | 8 | 400 | 175 | 3.08 | 3.845 | 17.05 | 0 |
| Fiat X1-9 | 27.3 | 4 | 79 | 66 | 4.08 | 1.935 | 18.9 | 1 |
| Porsche 914-2 | 26 | 4 | 120.3 | 91 | 4.43 | 2.14 | 16.7 | 0 |
| Lotus Europa | 30.4 | 4 | 95.1 | 113 | 3.77 | 1.513 | 16.9 | 1 |
| Ford Pantera L | 15.8 | 8 | 351 | 264 | 4.22 | 3.17 | 14.5 | 0 |
| Ferrari Dino | 19.7 | 6 | 145 | 175 | 3.62 | 2.77 | 15.5 | 0 |
| Maserati Bora | 15 | 8 | 301 | 335 | 3.54 | 3.57 | 14.6 | 0 |
| Volvo 142E | 21.4 | 4 | 121 | 109 | 4.11 | 2.78 | 18.6 | 1 |
Table continues below
| am | gear | carb | |
|---|---|---|---|
| Mazda RX4 | 1 | 4 | 4 |
| Mazda RX4 Wag | 1 | 4 | 4 |
| Datsun 710 | 1 | 4 | 1 |
| Hornet 4 Drive | 0 | 3 | 1 |
| Hornet Sportabout | 0 | 3 | 2 |
| Valiant | 0 | 3 | 1 |
| Duster 360 | 0 | 3 | 4 |
| Merc 240D | 0 | 4 | 2 |
| Merc 230 | 0 | 4 | 2 |
| Merc 280 | 0 | 4 | 4 |
| Merc 280C | 0 | 4 | 4 |
| Merc 450SE | 0 | 3 | 3 |
| Merc 450SL | 0 | 3 | 3 |
| Merc 450SLC | 0 | 3 | 3 |
| Cadillac Fleetwood | 0 | 3 | 4 |
| Lincoln Continental | 0 | 3 | 4 |
| Chrysler Imperial | 0 | 3 | 4 |
| Fiat 128 | 1 | 4 | 1 |
| Honda Civic | 1 | 4 | 2 |
| Toyota Corolla | 1 | 4 | 1 |
| Toyota Corona | 0 | 3 | 1 |
| Dodge Challenger | 0 | 3 | 2 |
| AMC Javelin | 0 | 3 | 2 |
| Camaro Z28 | 0 | 3 | 4 |
| Pontiac Firebird | 0 | 3 | 2 |
| Fiat X1-9 | 1 | 4 | 1 |
| Porsche 914-2 | 1 | 5 | 2 |
| Lotus Europa | 1 | 5 | 2 |
| Ford Pantera L | 1 | 5 | 4 |
| Ferrari Dino | 1 | 5 | 6 |
| Maserati Bora | 1 | 5 | 8 |
| Volvo 142E | 1 | 4 | 2 |
Created on 2023-03-31 with reprex v2.0.2
but often publications have exacting requirements. With luck, there are formatters but if not almost any style of table can be produced using the LaTeX language.
Hi,
It probably depends on where you are publishing and what you are publishing. As @technocrat points out "often publications have exacting requirements".
" Until now, I am putting my R results manually in the word document'.
You should consider looking into using Rmarkdown or the new Quarto writing systems that are designed to integrate well with R
Tables with Rmarkdown gives a bit of genoral information on using tables information. The stargazer package may be useful and the qwraps2 package looks like it might be handy.
If you have the pleasure (horror?) of using APA style there are some dedicated packages such as apaTables or papaja. I believe that {papaja} is only usable in Rmarkdown or Quarto which will give Word, PDF & HTML output.
Both of the APA style packages probably will provide tables that are fine in other publications. They are just intended to meet the APA Manual's rather exacting demands.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.