[R] Importing data by targeting in filenames inside a nested list

BARLAS Marios 247554 Marios.BARLAS at cea.fr
Tue Dec 8 12:29:57 CET 2015

Hello everyone,

So, rookie me is trying to write a smart code, so here's what I'm doing:

I have a list of a couple of hundrend files, some of which refer to different experiments. 
The naming of the file refers to the experiment and the serial number to the topological reference on my sample.

Performing my data analysis in 1 file class at a time looks OK, so I'm trying to generalize my code.
I figured out I could group them together by performing a pattern read on a nested list, which works for getting the file names and grouping them but then I'm getting some problems when I try to perform the import from the nested list. My code looks like this:

# Vector containing file name patterns to be read and grouped together
measurement_filenames <- c("*Q_Read_prist*", "*Quasi_Forming*", "*read_set#1*","*Q_Reset_pForm#1*","*read_reset#2*","*quasistatic_set*", "*read_set#2*", "*quasistatic_reset#2*" )

# Create a list of the files to be read in sorted in a natural fashion
electrical_meas_files <- lapply(measurement_filenames, function(x) naturalsort(list.files(path, pattern=x)))
names(electrical_meas_files) <- measurement_filenames

# Perform data import for each element

for(i in 1:length(measurement_filenames))
  electrical_meas_raw_data[[i]] <- lapply(electrical_meas_files[[i]], function(x) read.xlsx(file=x, sheetName="Data", header=TRUE, as.data.frame =TRUE,  stringsAsFactors = F) )

My idea is to come up with a nested list of the structure 
{list of different experiments}
	{list of all sites where the experiment was run}
		{set of dataframes with all data for each site}

Do I make sense or am I over-complicating the situation ?

Any ideas how I could write this piece of code or improve it ?

Thanks in advance,

More information about the R-help mailing list