add col name to row name for csv file

Question

Is there a way to add a col name for the row name field if I use the rownames for an output file?

I know it cannot be done in this function (unless I am completely wrong):

colnames(df)<-c("fullname","addr1","addr2","City","State","ZIP","Keycode","csz")

Is there an argument for the write.csv() function to accomplish it?

LyzandeR · Accepted Answer · 2021-12-01 20:34:42Z

1

You can easily use cbind for this:

df <- cbind(myname = row.names(mtcars), mtcars)
write.csv(df, row.names = FALSE)

You practically add the row names as a new column (with your selected column name) and you write your csv without row.names in this case.

      myname  mpg cyl  disp  hp drat    wt  qsec vs am gear carb
Mazda RX4                     Mazda RX4 21.0   6 160.0 110 3.90 2.620 16.46  0  1    4    4
Mazda RX4 Wag             Mazda RX4 Wag 21.0   6 160.0 110 3.90 2.875 17.02  0  1    4    4
Datsun 710                   Datsun 710 22.8   4 108.0  93 3.85 2.320 18.61  1  1    4    1
Hornet 4 Drive           Hornet 4 Drive 21.4   6 258.0 110 3.08 3.215 19.44  1  0    3    1
Hornet Sportabout     Hornet Sportabout 18.7   8 360.0 175 3.15 3.440 17.02  0  0    3    2
Valiant                         Valiant 18.1   6 225.0 105 2.76 3.460 20.22  1  0    3    1
Duster 360                   Duster 360 14.3   8 360.0 245 3.21 3.570 15.84  0  0    3    4

answered Dec 1, 2021 at 20:34

LyzandeR

38k12 gold badges84 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

OldManSeph Over a year ago

I figured there had to be a way to use the rownames and give a col name without making a new index column. Thank you for you help.

LyzandeR Over a year ago

Very glad I could help :)

Collectives™ on Stack Overflow

add col name to row name for csv file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related