CS424 Visualization and Visual Analytics

Project 1: Heat of the Moment

Data processing

1. use format_data.sh : get rid of of Sensor Labels. use folder identify different rooms

for example:

May/04/2008 10:00 PM FF00080057FB1810 67

FF00080057FB1810 means office space which is No.7 . So I created a folder named 1 and store May/04/2008 10:00 PM \TAB 67 in a file named 7.txt

I also created a file named 7_2008.txt to store the record and another file named 7_day_raw.txt which only stores May/04/2008 67 to get average data

Finally, I get 7 folders (1 2 3 4 5 6 7) and their every year data and 2005-2011 whole data

2. Use the pre processed data to calc average temperature of the year/month/day

Actually, I took a very long time to try to find a easy way to process, but I'm not familiar with date processing. Finally I use excel to get the average data. and store the date to [room_number]/year_avg.txt, [room_number]/month_avg.txt, [room_number]/day_avg.txt