search

UNCG-CSE / Library-Computer-Usage-Analysis

The University Libraries at UNCG currently track the state of a computer, determining whether or not a particular computer is in use. This data is compiled into a database, and a web app pulls from this database to show a map and number of available computers. As of Fall 2017, the data had not been used to determine which computers are used more frequently, aside from counting the number of times a computer transitions into/away from the 'in-use' state. This project attempts to correlate the usage of these computers with various factors, including: campus scheduling, equipment configuration, placement, population in the library, and area weather. Using this data, this project also uses machine learning to determine the best placement of computers for future allocation, and possible reconfiguration of equipment and space.
1 stars 1 forks source link

Convert timestamps to minutes of access #19

Closed brownworth closed 6 years ago

brownworth commented 6 years ago

Timestamps are datetime with ms precision, this needs to be expanded to minutes to be able to do summation stats.

brownworth commented 6 years ago

Right now, the data is 3 columns, ostensibly indexed by datestamp. To me, it makes more sense to be indexed by minute (or hour) and the columns are each individual computer, with the intersection being the state of that machine at that point in time.

smindinvern commented 6 years ago

8b991e44b5aa6a2a81d3c4a3e97b769702aa04e5 for my attempt at this.

smindinvern commented 6 years ago

31

brownworth commented 6 years ago

I didn't see that you had something like this in place, and I have done something similar. We can compare code to see which suits our needs.

https://github.com/UNCG-CSE/Library-Computer-Usage-Analysis/commit/da030564a2c7fb166110b49542e5bf6376335297

smindinvern commented 6 years ago

As an update I just pushed a change that improves the speed of what i had before immensely.

That's in efa5140

smindinvern commented 6 years ago

After looking at this yet further, I found some potential issues with the implementation currently in develop. I revisited my alternate implementation and managed to get the runtime down quite a bit. I've pointed out some discrepancies in the results between the two methods in the nick-data-import-issues branch.

smindinvern commented 6 years ago

Already merged.