ich habe (wie so viele) ein hoffentlich leicht zu lösendes Problem. Leider komme ich auf momentan auf keine einfache bzw. gute Lösung.
Mein Datensatz ist folgender:
https://covid.ourworldindata.org/data/o ... d-data.csv
Hierbei interessiert mich die Variable "total_cases_per_million". Von dieser hätte ich gern für alle erfassten Länder den ersten Wert über einem Schwellenwert (z.B. 10.000). Per subset ist es kein Problem alle Ausprägungen darunter wegzufiltern, aber von oben funktioniert es analog nicht.
Für einen kleinen Analysedurchlauf habe ich da ganze mal für europäischen Länder händisch vollzogen..
sieht dann so aus..
Code: Alles auswählen
av_casesx <- subset(av_cases, (CountryName == "Albania" & total_cases_per_million < 12.000 |
CountryName == "Austria" & total_cases_per_million < 11.000 |
CountryName == "Belarus" & total_cases_per_million < 12.000 |
CountryName == "Belgium" & total_cases_per_million < 12.000 |
CountryName == "Bulgaria" & total_cases_per_million < 12.000 |
CountryName == "Bosnia and Herzegovina" & total_cases_per_million < 12.000 |
CountryName == "Croatia" & total_cases_per_million < 12.000 |
CountryName == "Czech Republic" & total_cases_per_million < 12.000|
CountryName == "Cyprus" & total_cases_per_million < 16.000 |
CountryName == "Denmark" & total_cases_per_million < 20.000 |
CountryName == "Estonia" & total_cases_per_million < 13.000 |
CountryName == "Finland" & total_cases_per_million < 12.000 |
CountryName == "France" & total_cases_per_million < 12.000 |
CountryName == "Germany" & total_cases_per_million < 10.500 |
CountryName == "Greece" & total_cases_per_million < 13.000 |
CountryName == "Hungary" & total_cases_per_million < 12.000 |
CountryName == "Iceland" & total_cases_per_million < 18.000 |
CountryName == "Ireland" & total_cases_per_million < 15.000 |
CountryName == "Italy" & total_cases_per_million < 12.000 |
CountryName == "Latvia" & total_cases_per_million < 12.000 |
CountryName == "Lithuania" & total_cases_per_million < 13.000 |
CountryName == "Luxembourg" & total_cases_per_million < 12.000 |
iso_code == "MKD" & total_cases_per_million < 15.000 |
iso_code == "MLT" & total_cases_per_million < 12.000 |
CountryName == "Moldova" & total_cases_per_million < 14.000 |
iso_code == "MNE" & total_cases_per_million < 14.000 |
CountryName == "Netherlands" & total_cases_per_million < 12.000 |
CountryName == "Norway" & total_cases_per_million < 12.000 |
CountryName == "Poland" & total_cases_per_million < 12.000 |
CountryName == "Portugal" & total_cases_per_million < 12.000 |
CountryName == "Romania" & total_cases_per_million < 12.000 |
CountryName == "Russia" & total_cases_per_million < 12.000 |
CountryName == "Serbia" & total_cases_per_million < 12.000 |
CountryName == "Slovakia" & total_cases_per_million < 12.000 |
CountryName == "Slovenia" & total_cases_per_million < 15.000 |
CountryName == "Spain" & total_cases_per_million < 12.000 |
CountryName == "Sweden" & total_cases_per_million < 14.000 |
CountryName == "Switzerland" & total_cases_per_million < 12.000 |
CountryName == "Ukraine" & total_cases_per_million < 12.000 |
CountryName == "United Kingdom" & total_cases_per_million < 18.000),
select=c(iso_code, CountryName, date, C1_School.closing, C2_Workplace.closing, C3_Cancel.public.events,
C4_Restrictions.on.gatherings, C5_Close.public.transport, C6_Stay.at.home.requirements,
C7_Restrictions.on.internal.movement, C8_International.travel.controls, H1_Public.information.campaigns,
StringencyIndex, GovernmentResponseIndex, total_cases_per_million))
Hoffe ich konnte mein Probleme verständlich schildern und freue mich auf Anregungen eurerseits.
Vielen Dank im Voraus.
Rnest2