{"id":24608,"date":"2023-12-22T01:27:03","date_gmt":"2023-12-22T00:27:03","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/help-pulling-multiple-csv-files-with-timestamped-data-and-multiple-participants-into-one-file\/"},"modified":"2023-12-22T01:27:03","modified_gmt":"2023-12-22T00:27:03","slug":"help-pulling-multiple-csv-files-with-timestamped-data-and-multiple-participants-into-one-file","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/help-pulling-multiple-csv-files-with-timestamped-data-and-multiple-participants-into-one-file\/","title":{"rendered":"Help Pulling Multiple .csv Files With Timestamped Data And Multiple Participants Into One File."},"content":{"rendered":"

<\/p>\n

\n

I have 11 .csv files containing data which has information about multiple participants in a study. All of the tables have a ‘timestamp’ column, some have ‘start-time’ and ‘end-time’ columns too. I then have 5 .csv files with data that is *not* timestamped – it contains some background\/onboarding information collected at the beginning of the study.<\/p>\n

I want to use this data to train a machine learning model.<\/p>\n

I need to pull all of this information into one .csv file. I’m not sure how exactly to go about doing this. I’ve thought about matching timestamps for each table, and adding the relevant columns onto the row with the same timestamp, and just having the non-timestamped information in each row for that participant ID. <\/p>\n

i.e., it would look something like this:<\/p>\n

[ID] [timestamp] [feature1] [added feature 1] [added feature 2] <\/p>\n

Then, all of the timestamps associated with each person’s id would have its own row, but some of the features would be empty\/null values. <\/p>\n

Would it make sense to do this? What are some methods I could use to achieve this?<\/p>\n<\/div>\n

submitted by \/u\/an-diabhal <\/a>
[link]<\/a><\/span> [comments]<\/a><\/span><\/p>