The qlpvt function returns the Latex for a basic pivot table with
one line of R.
qlpvt(dataFrame, rows = NULL, columns = NULL, calculations = NULL, ...)The data frame containing the data to be summarised in the pivot table.
A character vector of variable names to be plotted on the rows of the pivot table, or "=" to specify the position of the calculations.
A character vector of variable names to be plotted on the columns of the pivot table, or "=" to specify the position of the calculations.
One or more summary calculations to use to calculate the values of the cells in the pivot table.
Additional arguments, currently format, formats, totals, argumentCheckMode, compatibility, caption and/or label. See the Latex output vignette for a description of caption and label.
Latex.
qlpvt(bhmtrains, "TOC", "TrainCategory", "n()")
#> [1] "\\begin{table}[h!]\n \\centering\n \\begin{tabular}{|l|rrr|}\n \\hline\n & Express Passenger & Ordinary Passenger & Total\\\\\n \\hline\n Arriva Trains Wales & 3079 & 830 & 3909\\\\\n CrossCountry & 22865 & 63 & 22928\\\\\n London Midland & 14487 & 33792 & 48279\\\\\n Virgin Trains & 8594 & & 8594\\\\\n Total & 49025 & 34685 & 83710\\\\\n \\hline\n \\end{tabular}\n\\end{table}"
qlpvt(bhmtrains, "TOC", "TrainCategory", "n()",
caption="my caption", label="mylabel")
#> [1] "\\begin{table}[h!]\n \\centering\n \\caption{my caption}\n \\label{tab:mylabel}\n \\begin{tabular}{|l|rrr|}\n \\hline\n & Express Passenger & Ordinary Passenger & Total\\\\\n \\hline\n Arriva Trains Wales & 3079 & 830 & 3909\\\\\n CrossCountry & 22865 & 63 & 22928\\\\\n London Midland & 14487 & 33792 & 48279\\\\\n Virgin Trains & 8594 & & 8594\\\\\n Total & 49025 & 34685 & 83710\\\\\n \\hline\n \\end{tabular}\n\\end{table}"