Need suggestions on structuring this data
I need input on how to store and analyze the data I am collecting. Basically, I am monitoring about 900 different "bins." Every ten minutes I record the number of items in each different bin, and the "alpha level" associated with each bin. Each bin has a maximum number of objects, and I've casually noticed that some bins hit max units and never fluctuate, while others flow up and down.
Right now I have it structured as follows (saved as a CSV file that appends every run):
Bin Name, Alpha Level, Bin Item Count, Bin Item Capacity, Date of recording
Again, my goals are :
1. Find Trends in alpha levels and item counts
2. Efficiently store and analyze my data ( I have limited resources - both computing power and bandwidth)
EDIT: Alpha Level, Bin Item Count, and Bin Capacity are real numbers, Bin Name is a string, and Date is obviously a date.