I have many data frames id.1, id.2, ... ,id.21
and in each of which I want to extract 2 data points: id.1[5,4]
and id.1[10,6]
, id.2[5,4]
and id.2[10,6]
, etc. The first data point is a date and the second data point is a integer.
I want to export this list to obtain something like this in an .csv
file:
V1 V2
1 5/10/2016 1654395291
2 5/11/2016 1645024703
3 5/12/2016 1763825219
I have tried
x=c(for (i in 1:21) {
file1 = paste("id.", i, "[5,4]", sep="")}, for (i in 1:21) {
file1 = paste("id.", i, "[10,6]", sep="")})
write.csv(x, "x.csv")
But this yields x
being NULL
. How can I go about getting this vector?