I have 2 excel files.
a.) One with column description.
b.) Other one with detailed data having colnames as V1 , V2 ...... V54. in first row.
I want to read one column from first dataframe i.e. column name as character array to use it for loading another dataframe argument which is "colnames".
is there any short/efficient way to accomplish this.
## reading first excel here and my target ColnamesAggregateData_Train <- (read_xlsx("data\\train_data\\Updated_Column_Description.xlsx", range = "Aggregate_data!A1:B54" , col_names = FALSE, col_types = NULL, na = "", trim_ws = TRUE, skip = 0, n_max = Inf, guess_max = min(14))) ColnamesAggregateData_Train <- ColnamesAggregateData_Train$X__2 AggregateData_Train <- fread("data\\train_data\\AggregateData_Train.csv" , drop =1, col.names = ColnamesAggregateData_Train )