Re: [R] How to write to a table column by column?
Hi Yuchen, First of all please notice that you may not have more than 2^8 = 256 columns in Excel, so if you have more than 256 time-series you can not put them all in one Excel sheet. I also believe that you can not have more than 2^16 = 65536 rows. If you do not have more than 256 time-series, I see two possibilities. The first one is to create a list which will hold all your time-series (each list member holds one time-series) and then make a double loop: one from 1 to as long as there is more data and if the first variable is i you create a string by looping through the list and adding to your string either element i (and a tab) of time-series j if it's length is = j or a tab (and a tab) otherwise. Then you can write each row to the file (using 'cat'). When you are done import the resulting file into Excel. Another possibility is to use xlsReadWritePro which allows you to write to a specific column of a specific sheet of an Excel file (and to append this). Regards, Moshe. --- Yuchen Luo [EMAIL PROTECTED] wrote: Dear friends. Every loop of my program will result in a list that is very long, with a structure similar to the one below: Lst - list(name=Fred, wife=Mary, daily.incomes=c(1:850)) Please notice the large size of daily.incomes. I need to store all such lists in a csv file so that I can easily view them in Excel. Excel cannot display a row of more than 300 elements, therefore, I have to store the lists as columns. It is not hard to store one list as a column in the csv file. The problem is how to store the second list as a second column, so that the two columns will lie side by side to each other and I can easily compare their elements. ( If I use 'appened=TRUE', the second time series will be stored in the same column. ) Thank you for your tine and your help will be highly appreciated!! Best Yuchen Luo [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch 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. __ R-help@stat.math.ethz.ch 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.
Re: [R] How to write to a table column by column?
Assuming that the daily.incomes are the same lengths, then your loop could be:
Lst - list()
for (i in 1:count) Lst[[i]] - list(..)
Lst.col - do.call('cbind', Lst)
On 8/12/07, Yuchen Luo [EMAIL PROTECTED] wrote:
Dear friends.
Every loop of my program will result in a list that is very long, with a
structure similar to the one below:
Lst - list(name=Fred, wife=Mary, daily.incomes=c(1:850))
Please notice the large size of daily.incomes.
I need to store all such lists in a csv file so that I can easily view them
in Excel. Excel cannot display a row of more than 300 elements, therefore, I
have to store the lists as columns. It is not hard to store one list as a
column in the csv file. The problem is how to store the second list as a
second column, so that the two columns will lie side by side to each other
and I can easily compare their elements. ( If I use 'appened=TRUE', the
second time series will be stored in the same column. )
Thank you for your tine and your help will be highly appreciated!!
Best
Yuchen Luo
[[alternative HTML version deleted]]
__
R-help@stat.math.ethz.ch 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.
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem you are trying to solve?
__
R-help@stat.math.ethz.ch 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.
[R] How to write to a table column by column?
Dear friends. Every loop of my program will result in a list that is very long, with a structure similar to the one below: Lst - list(name=Fred, wife=Mary, daily.incomes=c(1:850)) Please notice the large size of daily.incomes. I need to store all such lists in a csv file so that I can easily view them in Excel. Excel cannot display a row of more than 300 elements, therefore, I have to store the lists as columns. It is not hard to store one list as a column in the csv file. The problem is how to store the second list as a second column, so that the two columns will lie side by side to each other and I can easily compare their elements. ( If I use 'appened=TRUE', the second time series will be stored in the same column. ) Thank you for your tine and your help will be highly appreciated!! Best Yuchen Luo [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch 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.
