August 17, 2022
I have a large data set which is recorded in hundredths of seconds. Realistically I only need a record every second. So 99% of the data is excessive.
Initial Data Set Snippet attached:
432,000 rows / 101 columns
4,320 rows / 101 columns
A) What is an effective method of keeping the whole number data per second, (i.e. 0, 1, 2, 3, 4, ... 4,320) while deleting or dis-including non-whole number data (i.e. 0.01, 0.02, 0.03, 0.04, 0.05, ... 4,319.99)?
February 13, 2021
How is the data captured? Could you use Power Query to import and filter the data? If you get stuck please upload a sample copy of your file with a mock up of the desired result.