import pandas as pd
import psycopg2

time_range = [1980, 1985, 1990, 1995, 2000, 2005, 2010]
countries = ['Germany', 'Austria', 'Italy', 'Switzerland', 'France', 'China']

conn = psycopg2.connect("dbname='...' user='...' host='localhost' password='...'")

for i in time_range:
    for country in countries:
        df = pd.read_sql("""
        SELECT * from mytable
#countries should appear in 'country', e.g. name_0 = 'Germany' in first iteration
#years should appear in year, e.g. year >= 1980 and year <= 1984 in first iteration
        WHERE name_0 = 'country' and year >= i  and year <= i+4;
        """, con=conn)

#now clustering of data in df - code not shown
#save resulting array as columns in csv-file using iterators from loop in file name,
#e.g., data_Germany_1980.csv in first iteration
        np.savetxt("data_country_i.csv", np.c_[a,b,c,d], delimiter=",", header="var1,var2,labels,probabilities", fmt='%1.4f', comments="")