Inserting the file name as column value in a csv file in R

Question

I have a file called “Day1.csv” with X number or rows. I would like to create a new column that includes the file name (“Day1”) in each row (from 1 to X). I have seen similar posts but I cannot get it to work. I was wondering is someone could give me a hand with this. Many thanks in advance.

Please provide a reproducible example of what you have tried so far. — jdobres
– jdobres, Commented Apr 10, 2018 at 11:55
Please put some data and some code that you have tried before and the error u get. Then we can try to help u. — J0ki
– J0ki, Commented Apr 10, 2018 at 11:55

Luke Hayden · Accepted Answer · 2018-04-10 11:58:32Z

1

Try this:

fn <- "Day1"
df <- read.csv(file=paste(fn, ".csv", sep=""))
df$filename <- fn

This way you can reproducibly fetch other filenames if you need (Day2, Day3, etc)

answered Apr 10, 2018 at 11:58

Luke Hayden

7124 silver badges8 bronze badges

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

4 Comments

jogo Over a year ago

or paste0(fn, ".csv")

Carlos Over a year ago

Thank you Luke. I have many files to go through so I was wondering if the name of the file can be automatically extracted so I dont have to type it each time.

Luke Hayden Over a year ago

You're welcome. Using Sys.glob("*.csv") will yield a list of all the .csv files in your directory.

Carlos Over a year ago

Ive just found an easy way of extracting the file name csvname<- basename(DataPathway)

Collectives™ on Stack Overflow

Inserting the file name as column value in a csv file in R

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related