|Perl Monk, Perl Meditation|
Data interpretationby rupesh (Hermit)
|on Nov 03, 2004 at 04:31 UTC||Need Help??|
rupesh has asked for the wisdom of the Perl Monks concerning the following question:
Using Hashes would be the best option for this sort of pattern matching I suppose, but I would like to have your point of view.
I have been making reports for senior management for the past 2 days and I've been thinking in the same way for this activity as well. Anyone have any better ideas?
The data is in the form of:
As you can see, the date is not sorted.
The case may change for the product and region.
And there may be (usually) multiple entries for the same date - the reason behind this activity.
1. For the year (2003), sort by month.
2. For one month (say Jan), get the product released for every day.
3. Automate that data to get into charts. What is required is a chart for every day for one month. For that day, I would need to show what products are released.
To begin with, I would need the data to understand which day of which month is a product(s) released.