Export Data with R (csv, tab-delineated and space separated examples)

[@BluePuppy210]

I've been trying to do this for daaaays!!! Thank you very much, this was a very easy and helpful explanation!

[@habeebaibraheem9925]

You solve my problem today. You superb

[@stefanevers1206]

a big "thank you" from Germany!

[@danielgreen4685]

So I've ran tests such as summary(lm(X ~ Y)) and correlation and covariance tests and it throws out all the information in my console, how do I export information from my console so I can use it in my paper?

[@athina532]

Thank you! That was very helpful!

[@economicurtis]

You bet. Happy to help. Looks like I might get a grant to do a bunch more of these R Videos!

[@km2052]

great , worked from first line write.csv(mydata1,file='export.csv')

[@economicurtis]

thanks! - I appreciate your nice words!

[@CocuxtleManguito]

Hi there. thanks a lot for the video. Do you know how to export a distance matrix? Thanks!

[@ritakang9357]

Hi, I was using : write.csv(brfss2013,file'brfss2013.csv') why am i getting error message 'unexpected string constant'

[@nikoleta9502]

Hey! When I do this, all the data from the rows gets clustered into the same column space. I have no idea why.The str() of the data looks exactly like yours.

[@RobvanMechelen]

I had exactly the same experience!

[@zahranasrazadani1502]

Thanks very helpful.

[@ahmedkmn6333]

write.table.(data,file=’ exported_data.csv’) Error: unexpected input in "write.table.(data,file=’"

[@RobvanMechelen]

When I do exactly as you presents, I get all data clustered in one column, with the column titles within double quotation marks " "

[@economicurtis]

my pleasure!

[@RobvanMechelen]

When I did what you suggested, I got all data clustered in one column. For those who experienced the same , as an alternative i would suggest install.packages("WriteXLS") library(WriteXLS) WriteXLS(mydata, ExcelFileName = "mydata.xlsx")

[@aaronasmr8833]

But what if you have more than one matrix to save to a file ....

[@marcoverduci7001]

great videos, needs louder volume, though

[@economicurtis]

Thanks for the kind words. This is unfortunately one of my first videos, before I learned much about the importance of recording quality. I've actually written much of a full course on R for data analysis, which I hope to record (with a nice mic) one day when I have the time!

[@victor5384]

its still help ! thks !!

[@thusyanthythananjayan9951]

Could you please suggest me a way to copy the results from r package into word file as a table. Example : Residuals: Min 1Q Median 3Q Max -7499.0 -1094.0 61.7 1004.7 13299.4 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) -2.008e+03 4.668e+02 -4.301 2.84e-05 *** TotFLC -3.647e-03 1.051e-02 -0.347 0.7290 TotHLC 7.787e-03 4.142e-03 1.880 0.0618 . OrgF 1.136e-02 6.407e-03 1.773 0.0780 . InorgF 9.569e-03 1.939e-02 0.494 0.6223 PTc 8.103e-03 4.022e-03 2.015 0.0455 * Credit 1.097e-03 3.001e-03 0.366 0.7152 Area 9.675e+03 1.700e+03 5.690 5.37e-08 *** How to copy these outputs as a table in excel or word file ?

[@abapokuaa]

hey, did you find a way to do this? i need help

[@rdjalayer]

nice video

[@Sothatjusticecanbedone]

Thank you very much

[@saradajosyula]

You'r voice is not audible ://

[@abdulf8680]

THANKS!! i find rstudio very confusing. STATA FTW

[@habeebaibraheem9925]

You solve my problem today. You superb