merge two GPS related tables

[apratap]

In the interest of keeping it simple and hopefully useful lets merge the following two tables

GPS Cluster Entries (v2):

1. please remove the following cols tod_bin, local_tz, pos, n_points
2. merge - dt_passive and tod to make a common timestamp col (unless there is a reason to keep them separate)

Identified Clusters Data Dictionary: the only reason we have this table is to keep mean_ti_between_visits. Let's get rid of that and merge with the table above.

PS: For internal analysis please still keep all the features available in the internal project.

-A

[lukeWaninger]

For this, I suggest dropping to the columns: participant_id, cid, category, week, time_in, and time_out

• dt_passive will become just the midpoint and the date is included in both time_in and time_out
• duration is calculated off time_out and time_in
• dropping the identified clusters table will also drop the cluster category unless we move it here

Should we include the timezone offset in the timestamps?

And finally, to match the other tables I suggest renaming to Passive Cluster Entries Brighten v2

Passive Cluster Entries Data Dictionary

#	Variable Name	Data Type	Description
1	participant_id	str	Unique ID
2	week	int	The $$( n^{th} )$$ week into the study
3	cid	str	Unique of participant's identified location
4	category	str	Semantic category of location
5	time_in	str	Timestamp of location entry (local)
6	time_out	str	Timestamp of location exit (local)

[apratap]

I agree this covers the baseline well