Changes

This page is mainly for DIYers with at least some knowledge of [[Excel]] or other spreadsheet software.

This page is mainly for DIYers with at least some knowledge of [[Excel]] or other spreadsheet software.  Previous steps would be choosing a [[:Category:Tools|Tool]] or [[Aggregators|Aggregator]]. Some tools give data straight to the user. This page is the set of steps after receiving data. Check if the device or app produces correct data soon after first use.  

==== File Format ====

==== File Format ====

==== Data Cleaning ====

==== Data Cleaning ====

Check if the device or app produces correct data soon after first use. Correct, remove or impute outliers (very extreme values) produced by errors but not real events. In the rare case that the data is raw sensor like [[Accelerometry]], aggregate it into something more manageable. Consumer wearables make "steps per 10 minutes" for which open source script is likely available. Finally, compare against other data to remove errors like exercising in the middle of sleep. I have not seen a script for this yet. [[User:DG|DG]] ([[User talk:DG|talk]])

Correct, remove or impute outliers (very extreme values) produced by errors but not real events. In the rare case that the data is raw sensor like [[Accelerometry]], aggregate it into something more manageable. Consumer wearables make "steps per 10 minutes" for which open source script is likely available. Finally, compare against other data to remove errors like exercising in the middle of sleep. I have not seen a script for this yet. [[User:DG|DG]] ([[User talk:DG|talk]])

== References ==

== References ==