Hi, I just have a quick question. If I got some result as the result of R, how can I export the result object? I mean, if I want to use the result object in Excel or other program in order to more specific investigation, how can I export it? If I just list the result and copy, The result is like this.. [586] "BB170029A10B06" "BB170029A20E06" First column, automatically show the number of result and other result also include the "". If I want to use this result, I have to manipulate the result by myself(I mean e.g remove " and remove [586] like this way)????? Or there is any good way to export this result object to other program? Please help me. Thanks in advance. =======================Younhee Ko(younko at uiuc.edu) http://comedu.korea.ac.kr/~unygo contact : 217-417-4868 Graduate Student in Dept. of Computer Science University of Illinois at Urbana-Champaign
If you want to export data frame, you can use write.table() to write out a CSV (comma separated value) file, which you can then read into Excel. -roger Ko,Younhee wrote:> Hi, > > I just have a quick question. > If I got some result as the result of R, how can I export > the result object? > > I mean, if I want to use the result object in Excel or other > program in order to more specific investigation, how can I > export it? > > If I just list the result and copy, > The result is like this.. > > > [586] "BB170029A10B06" "BB170029A20E06" > > First column, automatically show the number of result and > other result also include the "". > > If I want to use this result, I have to manipulate the > result by myself(I mean e.g remove " and remove [586] like > this way)????? > > Or there is any good way to export this result object to > other program? > > Please help me. > > Thanks in advance. > =======================> Younhee Ko(younko at uiuc.edu) > > http://comedu.korea.ac.kr/~unygo > contact : 217-417-4868 > Graduate Student in Dept. of Computer Science > University of Illinois at Urbana-Champaign > > ______________________________________________ > 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 >
I'm sorry, but your question seems to broad for me to provide a
succinct answer. You can look at "sink", but if that doesn't
answer
your question, please "read the posting guide!
http://www.R-project.org/posting-guide.html" on "How to ask good
questions that prompt useful answers", especially the part about
providing a small example that someone else can actually run. If we
know the kind of "results" you want to export, what you tried, and why
that was not satisfactory, it will be much easier for someone to help
you. (Moreover, you might even find an answer to your own question by
following the procedure in the posting guide.)
sorry I couldn't help more.
spencer graves
Ko,Younhee wrote:
>Hi,
>
>I just have a quick question.
>If I got some result as the result of R, how can I export
>the result object?
>
>I mean, if I want to use the result object in Excel or other
>program in order to more specific investigation, how can I
>export it?
>
>If I just list the result and copy,
>The result is like this..
>
>
>[586] "BB170029A10B06" "BB170029A20E06"
>
>First column, automatically show the number of result and
>other result also include the "".
>
>If I want to use this result, I have to manipulate the
>result by myself(I mean e.g remove " and remove [586] like
>this way)?????
>
>Or there is any good way to export this result object to
>other program?
>
>Please help me.
>
>Thanks in advance.
>=======================>Younhee Ko(younko at uiuc.edu)
>
>http://comedu.korea.ac.kr/~unygo
>contact : 217-417-4868
>Graduate Student in Dept. of Computer Science
>University of Illinois at Urbana-Champaign
>
>______________________________________________
>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
>
>
--
Spencer Graves, PhD, Senior Development Engineer
O: (408)938-4420; mobile: (408)655-4567
Ko,Younhee <younko <at> uiuc.edu> writes: : : Hi, : : I just have a quick question. : If I got some result as the result of R, how can I export : the result object? : : I mean, if I want to use the result object in Excel or other : program in order to more specific investigation, how can I : export it? : : If I just list the result and copy, : The result is like this.. : : [586] "BB170029A10B06" "BB170029A20E06" : : First column, automatically show the number of result and : other result also include the "". : : If I want to use this result, I have to manipulate the : result by myself(I mean e.g remove " and remove [586] like : this way)????? : : Or there is any good way to export this result object to : other program? There are many different ways to do this in R including via text files, .csv files, HTML files and Microsoft COM objects. 1. Search the mail archives for Excel, 2. read the Data Import and Export Manual and 3. read the FAQ. Pointers to where to find these are in the posting guide at the bottom of this and every post on this list.
Thanks very much. It was exactly what I want.>From next time, I will try to figure out more by myself.:-)Thanks again. Younhee. ---- Original message ---->Date: Fri, 31 Dec 2004 15:54:11 -0500 >From: "Roger D. Peng" <rpeng at jhsph.edu> >Subject: Re: [R] Export the R object >To: "Ko,Younhee" <younko at uiuc.edu> >Cc: R-help at stat.math.ethz.ch > >If you want to export data frame, you can use write.table()to write out a CSV>(comma separated value) file, which you can then read intoExcel.> >-roger > >Ko,Younhee wrote: >> Hi, >> >> I just have a quick question. >> If I got some result as the result of R, how can I export >> the result object? >> >> I mean, if I want to use the result object in Excel orother>> program in order to more specific investigation, how canI>> export it? >> >> If I just list the result and copy, >> The result is like this.. >> >> >> [586] "BB170029A10B06" "BB170029A20E06" >> >> First column, automatically show the number of result and >> other result also include the "". >> >> If I want to use this result, I have to manipulate the >> result by myself(I mean e.g remove " and remove [586]like>> this way)????? >> >> Or there is any good way to export this result object to >> other program? >> >> Please help me. >> >> Thanks in advance. >> =======================>> Younhee Ko(younko at uiuc.edu) >> >> http://comedu.korea.ac.kr/~unygo >> contact : 217-417-4868 >> Graduate Student in Dept. of Computer Science >> University of Illinois at Urbana-Champaign >> >> ______________________________________________ >> 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>>=======================Younhee Ko(younko at uiuc.edu) http://comedu.korea.ac.kr/~unygo contact : 217-417-4868 Graduate Student in Dept. of Computer Science University of Illinois at Urbana-Champaign