Werte aus Spalte herausfiltern
Verfasst: Mo Apr 02, 2018 10:32 am
Hallo Zusammen
Ich habe meinen Datensatz "goq<-read.dta("qog_bas_ts_jan18.dta")" geladen und dann ein subsample "Afrika" erstellt:
> Afrika<-filter(goq,cname %in% c("Algeria","Angola","Benin","Botswana","Burkina Faso","Burundi","Cape Verde","Cameroon","Central African Republic","Chad","Comoros","Congo,Republic of","Congo, Democratic Republic","Cote d'Ivoire","Djibouti","Egypt","Equatorial Guinea","Eritrea","Ethiopia (-1992)","Ethiopia (1993-)","Gabon","Gambia","Ghana","Guinea","Guinea-Bissau","Kenya","Lesotho","Liberia","Libya","Madagascar","Malawi","Mali","Mauritania","Mauritius","Morocco","Mozambique","Namibia","Niger","Nigeria","Rwanda","Sao Tome and Principe","Senegal","Seychelles","Sierra Leone","Somalia","South Africa","South Sudan","Sudan (-2011)","Sudan (2012-)","Swaziland","Tanzania","Togo","Tunisia","Uganda","Zambia","Zimbabwe"))
Der sieht so aus:
> head(Afrika)
ccode cname year ccodealp cname_year ccodealp_year ccodecow ccodewb version
1 12 Algeria 1946 DZA Algeria 1946 DZA46 615 12 QoGBasTSJan18
2 12 Algeria 1947 DZA Algeria 1947 DZA47 615 12 QoGBasTSJan18
3 12 Algeria 1948 DZA Algeria 1948 DZA48 615 12 QoGBasTSJan18
4 12 Algeria 1949 DZA Algeria 1949 DZA49 615 12 QoGBasTSJan18
5 12 Algeria 1950 DZA Algeria 1950 DZA50 615 12 QoGBasTSJan18
6 12 Algeria 1951 DZA Algeria 1951 DZA51 615 12 QoGBasTSJan18
hat noch weitere Variablen.
Nün würde ich gerne aus der Spalte "year" nur die Jahre 1990-2017 haben.
Ich habe es bereits mit diversen Befehlen versucht, unter anderem mit folgendem:
Zeit<-Afrika[Afrika$year==c("1990","1991","1992","1993","1994","1995","1996","1997","1998","1999","2000","2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017")]
Aber da bekomme ich immer folgende Fehlermeldung:
Warnmeldung:
In Afrika$year == c("1990", "1991", "1992", "1993", "1994", "1995", :
Länge des längeren Objektes
ist kein Vielfaches der Länge des kürzeren Objektes
Kann mir da jemand helfen?
Ich habe meinen Datensatz "goq<-read.dta("qog_bas_ts_jan18.dta")" geladen und dann ein subsample "Afrika" erstellt:
> Afrika<-filter(goq,cname %in% c("Algeria","Angola","Benin","Botswana","Burkina Faso","Burundi","Cape Verde","Cameroon","Central African Republic","Chad","Comoros","Congo,Republic of","Congo, Democratic Republic","Cote d'Ivoire","Djibouti","Egypt","Equatorial Guinea","Eritrea","Ethiopia (-1992)","Ethiopia (1993-)","Gabon","Gambia","Ghana","Guinea","Guinea-Bissau","Kenya","Lesotho","Liberia","Libya","Madagascar","Malawi","Mali","Mauritania","Mauritius","Morocco","Mozambique","Namibia","Niger","Nigeria","Rwanda","Sao Tome and Principe","Senegal","Seychelles","Sierra Leone","Somalia","South Africa","South Sudan","Sudan (-2011)","Sudan (2012-)","Swaziland","Tanzania","Togo","Tunisia","Uganda","Zambia","Zimbabwe"))
Der sieht so aus:
> head(Afrika)
ccode cname year ccodealp cname_year ccodealp_year ccodecow ccodewb version
1 12 Algeria 1946 DZA Algeria 1946 DZA46 615 12 QoGBasTSJan18
2 12 Algeria 1947 DZA Algeria 1947 DZA47 615 12 QoGBasTSJan18
3 12 Algeria 1948 DZA Algeria 1948 DZA48 615 12 QoGBasTSJan18
4 12 Algeria 1949 DZA Algeria 1949 DZA49 615 12 QoGBasTSJan18
5 12 Algeria 1950 DZA Algeria 1950 DZA50 615 12 QoGBasTSJan18
6 12 Algeria 1951 DZA Algeria 1951 DZA51 615 12 QoGBasTSJan18
hat noch weitere Variablen.
Nün würde ich gerne aus der Spalte "year" nur die Jahre 1990-2017 haben.
Ich habe es bereits mit diversen Befehlen versucht, unter anderem mit folgendem:
Zeit<-Afrika[Afrika$year==c("1990","1991","1992","1993","1994","1995","1996","1997","1998","1999","2000","2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017")]
Aber da bekomme ich immer folgende Fehlermeldung:
Warnmeldung:
In Afrika$year == c("1990", "1991", "1992", "1993", "1994", "1995", :
Länge des längeren Objektes
ist kein Vielfaches der Länge des kürzeren Objektes
Kann mir da jemand helfen?