I use the following command to write data to a .csv file:
write.csv(yxz,file="foo.csv")
And I get the following in the file, with one column appended to the file:
"","fsp","fsec","cincome",
"1",0,3,2.25,...
"2",0,1,2.75,...
"3",1,1,0.625,...
Question: is there a way to avoid the first column? Thanks.
I believe you need to specify row.names = FALSE See the help for write.table() On Sep 24, 2014, at 2:00 PM, Steven Yen <syen04 at gmail.com> wrote:> I use the following command to write data to a .csv file: > > write.csv(yxz,file="foo.csv") > > And I get the following in the file, with one column appended to the file: > > "","fsp","fsec","cincome", > "1",0,3,2.25,... > "2",0,1,2.75,... > "3",1,1,0.625,... > > Question: is there a way to avoid the first column? Thanks. > > ______________________________________________ > 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.Don McKenzie Research Ecologist Pacific Wildland Fire Sciences Lab US Forest Service Affiliate Professor School of Environmental and Forest Sciences University of Washington dmck at uw.edu
Read the help docs? ( pay attention to the row.names argument) -- Bert Bert Gunter Genentech Nonclinical Biostatistics (650) 467-7374 "Data is not information. Information is not knowledge. And knowledge is certainly not wisdom." Clifford Stoll On Wed, Sep 24, 2014 at 2:00 PM, Steven Yen <syen04 at gmail.com> wrote:> I use the following command to write data to a .csv file: > > write.csv(yxz,file="foo.csv") > > And I get the following in the file, with one column appended to the file: > > "","fsp","fsec","cincome", > "1",0,3,2.25,... > "2",0,1,2.75,... > "3",1,1,0.625,... > > Question: is there a way to avoid the first column? Thanks. > > ______________________________________________ > 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.
?write.csv 2nd line of Usage: example
Clint Bowman INTERNET: clint at ecy.wa.gov
Air Quality Modeler INTERNET: clint at math.utah.edu
Department of Ecology VOICE: (360) 407-6815
PO Box 47600 FAX: (360) 407-7534
Olympia, WA 98504-7600
USPS: PO Box 47600, Olympia, WA 98504-7600
Parcels: 300 Desmond Drive, Lacey, WA 98503-1274
On Wed, 24 Sep 2014, Steven Yen wrote:
> I use the following command to write data to a .csv file:
>
> write.csv(yxz,file="foo.csv")
>
> And I get the following in the file, with one column appended to the file:
>
> "","fsp","fsec","cincome",
> "1",0,3,2.25,...
> "2",0,1,2.75,...
> "3",1,1,0.625,...
>
> Question: is there a way to avoid the first column? Thanks.
>
> ______________________________________________
> 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.
>
>
On Wed, Sep 24, 2014 at 4:00 PM, Steven Yen <syen04 at gmail.com> wrote:> I use the following command to write data to a .csv file: > > write.csv(yxz,file="foo.csv") > > And I get the following in the file, with one column appended to the file: > > "","fsp","fsec","cincome", > "1",0,3,2.25,... > "2",0,1,2.75,... > "3",1,1,0.625,... > > Question: is there a way to avoid the first column? Thanks. >I'm fairly sure you need: write.csv(yxz,file="foo.csv",row.names=FALSE); If you don't want the header row at the top, you might want to try: write.table(yxz,file="foo.csv",row.names=FALSE,col.names=FALSE,sep=',',qmethod="double"); -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown