Off topic:Adding the csv file names as a separate column to the csv file
0
0
Entering edit mode
3.6 years ago

Hello

I have multiple CSV files (14000) in a folder and all of them have the same column heads (temperature, humidity, ..) and rows of my CSV files are five minutes time steps for all the year. I need to combine all the CSV files, using bind_rows to have one single CSV file. How can I add the file name as a column to my final file to be able to recognize which rows belong to what file's name? ( For example, the first file name is home1 and the second one is home 2 and I want to see which row belongs to home 1 and which row belongs to the second home?

R • 371 views
ADD COMMENT
This thread is not open. No new answers may be added
Traffic: 2090 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6