For example, my data is like this:
Category 1
2010 indicator 1
indicator 2
2009 indicator 1
2008 indicator 3
2007 indicator 1
indicator 2
indicator 3
instead of
Category 1
2010 indicator 1
indicator 2
indicator 3
2009 indicator 1
indicator 2
indicator 3
2008 indicator 1
indicator 2
indicator 3
I am trying to solve this problem, when I input my data, the software can read them, but cant show them correctly.
When I checked the STAT for World Bank, I found some of the indicators does not contain all years data, I think they have the same data type like I have.
So, can you help me to organize such data type and let the software show them correctly (since in some yaers, the data of one or more indicators are not complete)?
Thanks,
Chen
Wed, 08/08/2012 - 14:40
#1
How to deal with different numbers of indicator in each year?
The data is too large, I cant make too many sub-categories.
Hi Chen,
One approach would be to insert the indicators anyway even if there is no data for that particular year. This is the approach used with the World Bank dataset. The alternative would be to use sub-sub-categories (if you already have too many sub-categories), which is implemented in the same way as sub-categories, but instead of the symbol > you use two of these symbols before the category name: >>
I hope that might help resolve your issue.
Best,
Frank
Hi Frank
I understand. I think made sub-sub-category is not very easy since I have huge data set.
And for the World Bank Dataset, how can I get it and insert my own data?
Thanks,
Chen
Hi Chen,
The World Bank dataset is huge (around 5000 indicators, many indicators with data for several decades). You can find all the data at data.worldbank.org, with a number of options for accessing it. StatPlanet World Bank accesses the data dynamically through the World Bank API (via XML), so there is no data file.
Best,
Frank