Rearranging long dataframe for printing in Sweave (andrecoding a factor)
JL The solution which was proposed by Joseph Wright on the Latex Community Forum was as follows 1) Use R to create the table and then save it in csv format 2) Use LaTex to print the table. 3) LaTex on it's own is not able to do this and you must install the 'datatool' package. 4) What 'datatool' allows you to do is to read the csv into an internal database and from that various very nice table printing styles can be provided. 5) If you click on the link below provided by Liviu, you can follow the postings between Joesph and myself and there are various code files as well as pdf's which show how a single table with more rows than one page, can be divided in two and placed one one page. If that's what you are looking for then this might be a solution. The only problem is that if like me you don't have strong LaTex skills, then you will have to do some experimenting and learning, in order to achieve this result. HTH - Good luck Steve ----- Original Message ----- From: "Jean-Louis Abitbol" <abitbol at sent.com> To: "Steve Sidney" <sbsidney at mweb.co.za>; "Liviu Andronic" <landronimirc at gmail.com> Cc: "R Help" <r-help at stat.math.ethz.ch> Sent: Monday, January 25, 2010 9:18 AM Subject: Re: [R] Rearranging long dataframe for printing in Sweave (andrecoding a factor) Hi Steve and Liviu, Thanks for the pointer to your posts. Steve can you share your elegant solution ? Up to now I have not had any answer from R-Help ... Best, JL On Sun, 24 Jan 2010 18:24 +0200, "Steve Sidney" <sbsidney at mweb.co.za> wrote:
Dear Liviu / Jean-Louis As the original poster I did find what I think is an elegant solution. The only remaining problem is that I have not been able to get it to work in Lyx, but it does work using a LaTeX editor (in this case WinEdt) and MikTex. I would still like to resolve why I can't read the csv table in Lyx. Regards Steve ----- Original Message ----- From: "Liviu Andronic" <landronimirc at gmail.com> To: "Jean-Louis Abitbol" <abitbol at sent.com> Cc: "R Help" <r-help at stat.math.ethz.ch> Sent: Sunday, January 24, 2010 5:56 PM Subject: Re: [R] Rearranging long dataframe for printing in Sweave (andrecoding a factor)
Hello On 1/24/10, Jean-Louis Abitbol <abitbol at sent.com> wrote:
I have to print a dataframe with >1000 rows and 2 columns for a report done with Sweave. I could use Hmisc latex function with longtable option. However it is a waiste of space and paper given that I have only 2 (or sometime 3) columns in the dataframe. So it came to my mind that I could maybe rearrange the dataframe and create several new variables from the original 2 in a tabular way for printing in less space.
There was a recent discussion on lyx-users [1] on a similar issue. I am not sure whether the original poster found a solution, though. Liviu [1] http://www.mail-archive.com/lyx-users at lists.lyx.org/msg78933.html
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Jean-Louis Abitbol abitbol at sent.com Tel 33 (0)6 24 47 59 34 1 ter Rue C?line, 92160 Antony, France