# Filtering DataFrame on String

**URL:** <https://discourse.julialang.org/t/filtering-dataframe-on-string/36117>\
**Category:** Data\
**Created:** [March 17, 2020, 9:56pm UTC](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117 "2020-03-17T21:56:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnh](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/johnh/32/3615_2.png) [@johnh](https://discourse.julialang.org/u/johnh)\
**Post date:** [March 17, 2020, 9:56pm UTC](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117/1 "2020-03-17T21:56:44Z")

</div>

Gahhhh… I show my ignorance. I have searched here and cannot quite get the answer.  
In the Kaggle covid-19 dataset I read covid\_19\_data.csv into a DataFrame  
The columns are:

julia\> names(df)  
8-element Array{Symbol,1}:  
:SNo  
:ObservationDate  
Symbol(“Province/State”)  
Symbol(“Country/Region”)  
Symbol(“Last Update”)  
:Confirmed  
:Deaths  
:Recovered

How can I create a second data frame which has let’s say Country/Region UK

---

<div class="post-metadata">

**Author:** ![tbeason](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tbeason/32/15898_2.png) [@tbeason](https://discourse.julialang.org/u/tbeason)\
**Post date:** [March 17, 2020, 10:51pm UTC](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117/2 "2020-03-17T22:51:25Z")

</div>

something like `filter(x -> x[Symbol("Country/Region")] == "UK",df)`

---

<div class="post-metadata">

**Author:** ![johnh](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/johnh/32/3615_2.png) [@johnh](https://discourse.julialang.org/u/johnh)\
**Post date:** [March 17, 2020, 10:56pm UTC](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117/3 "2020-03-17T22:56:30Z")

</div>

Thankyou!