Hello,
I am working with GGIR to try to process some csv data from actigraph monitors (ActiGraph GT9X). The data I have were exported from the cloud service 'CentrePoint' and have the following structure as a header:
#-----Data File Created By CP3 Data Retrieval------
#Serial Number: TAS1H19200026
#Start Date: 2021-09-22 16:05:00 UTC
#Download Date: 2021-09-22 16:45:09 UTC
#Sample Rate: 30
#--------------------------------------------------
Timestamp UTC,Accelerometer X,Accelerometer Y,Accelerometer Z
2021-09-22 16:24:02,0.08203125000000,-0.95703125000000,-0.04687500000000
2021-09-22 16:24:02,0.00000000000000,-1.00390625000000,0.00000000000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00390625000000
2021-09-22 16:24:02,0.01562500000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.01171875000000,0.00390625000000
2021-09-22 16:24:02,0.00390625000000,-1.01171875000000,0.00000000000000
2021-09-22 16:24:02,0.00000000000000,-1.01171875000000,-0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00390625000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.01953125000000,0.00390625000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00390625000000,-1.01953125000000,0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.02343750000000,0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00000000000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00390625000000,-1.01562500000000,0.01171875000000
2021-09-22 16:24:02,0.00781250000000,-1.01953125000000,0.01171875000000
2021-09-22 16:24:02,0.00781250000000,-1.01171875000000,0.00000000000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.00390625000000
2021-09-22 16:24:02,0.01171875000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00781250000000,-1.01562500000000,0.01171875000000
2021-09-22 16:24:02,0.00390625000000,-1.01562500000000,0.00781250000000
2021-09-22 16:24:02,0.00390625000000,-1.01171875000000,0.01171875000000
I believe this header is different than what is provided by the actilife software, but do not have access to the software to check. When I try to process the file in GGIR I get confirmation that the file is the one I want processed (File name: SYNH006.csv), but immediately get the error:
File name: SYNH006.csv
Errors and warnings for SYNH006.csv$message
[1] "duplicate row.names: "
$call
data.frame(value = H[RowsWithData, 2], row.names = H[RowsWithData,
1], stringsAsFactors = TRUE)
Parts 2, 3 & 4 fail due to 'cannot open the connection'.
Could someone please confirm if the header is different on an actilife csv file than the CentrePoint csv file? If so, I assume that this is what is causing the error that I am receiving. I understand that GGIR is configured to automatically detect csv from Actigraph, but perhaps not with the CentrePoint header.
Any insight or feedback would be appreciated.
Thanks in advance for considering my request.
Grant