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]]
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 <realityrandom at gmail.com>
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 at 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?
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 <realityrandom at gmail.com> 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 at 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. >