Hi everyone!
I was wondering if anyone had a way to programmatically deal with missing PurpleAir time stamps, in either R or Excel? We primarily use hourly averages and query the sensor with PurpleAir’s API in R. I am left with a large csv file from the compiled text file queries. My script doesn’t leave blanks for missing time stamps, but I would like it to since I use Excel to roll up the hourly averages into 24hr, so the missing time stamps are important for me
I was wondering if anyone currently uses a code or method in either R or Excel to add in the missing time stamps?
thanks!!