Return to Question

I'm looking to develop an analytics tool of economic, political, demographical, and geographical data on African states. The idea is to be able to:

• store country data
• ask one question for many countries at the same time
• define a criteria and see which countries fit the bill
• map correlations

I'm looking for advice for software solutions that is good for such a task.

(I've created a similar tool in Stata for economic data before; Stata does graphing and correlations well but appears to quickly become clumsy once the conditions and regular expressions in the queries are anything but very simple.)

I will scrape country data from many different sources and combine it all into one dataset. I'm looking for the best software to store the data in, in order to run the relevant queries and make the relevant graphs. I don't mind using different software solutions for different queries but then the database should be able to be read by all programs.

Example queries

• Which states have experienced conflict after 2006?
• Rank states by number of consecutive democratic elections between 1945 and 2005
• Display South Africa's political freedom index from 1980 to 2000
• What is (South/East/Central/West/North) Africa's dominant export?
• Correlate per capita income with democratic rule in a scatter plot for any given year states fitting specified criteria
• Which states held elections in 1990?

I will here have raw data on conflicts, elections, political freedom index, type of rule, trade flows, and economic indicators.

Software for OSX or Linux preferred but Windows will work as well.

I don't know much about either database structures or analytic software but not deterred by a high learning curve or long documentations as long as I end up with a solution well suited for the task. Thanks in advance for any help

I'm looking to develop an analytics tool of economic, political, demographical, and geographical data on African states. The idea is to be able to:

• store country data
• ask one question for many countries at the same time
• define a criteria and see which countries fit the bill
• map correlations

I'm looking for advice for software solutions that is good for such a task.

(I've created a similar tool in Stata for economic data before; Stata does graphing and correlations well but appears to quickly become clumsy once the conditions and regular expressions in the queries are anything but very simple.)

I will scrape country data from many different sources and combine it all into one dataset. I'm looking for the best software to store the data in, in order to run the relevant queries and make the relevant graphs. I don't mind using different software solutions for different queries but then the database should be able to be read by all programs.

Example queries

• Which states have experienced conflict after 2006?
• Rank states by number of consecutive democratic elections between 1945 and 2005
• Display South Africa's political freedom index from 1980 to 2000
• What is (South/East/Central/West/North) Africa's dominant export?
• Correlate per capita income with democratic rule in a scatter plot for any given year states fitting specified criteria
• Which states held elections in 1990?

I will here have raw data on conflicts, elections, political freedom index, type of rule, trade flows, and economic indicators.

Software for OSX or Linux preferred but Windows will work as well.

I don't know much about either database structures or analytic software but not deterred by a high learning curve or long documentations as long as I end up with a solution well suited for the task. Thanks in advance for any help