combining data into a single data frame

[Karina_Mendoza]

Good afternoon, I'm sort of stuck on a case study I'm currently working on. I had to download 12 csv files which each contains large amounts of data. I need to combine the data into a single data frame. I'm not sure if I should use SQL, R studio or python to execute this task. I already attempted this with R studio, but I kept getting errors. I feel that I'm skipping a step. I just don't know what it is. If anyone can help me I'd greatly appreciate it!

[FJCC]

I'm assuming you want to combine the data row-wise. If all the data frames have the same column names and types, this is easily done with the rbind() function. Here is a toy example.

DF1 <- data.frame(A = 1:3, B = 11:13)
DF1
#>   A  B
#> 1 1 11
#> 2 2 12
#> 3 3 13

DF2 <- data.frame(A = 21:23, B = 31:33)
DF2
#>    A  B
#> 1 21 31
#> 2 22 32
#> 3 23 33

DF3 <- rbind(DF1, DF2)
DF3
#>    A  B
#> 1  1 11
#> 2  2 12
#> 3  3 13
#> 4 21 31
#> 5 22 32
#> 6 23 33

^{Created on 2023-06-08 with reprex v2.0.2}

If you want to combine them column-wise, that can also be done but you will need to explain how the rows are matched.