# Delete all rows which have null values/missing values in 'all' the columns

**URL:** <https://discourse.julialang.org/t/delete-all-rows-which-have-null-values-missing-values-in-all-the-columns/59489>\
**Category:** Data\
**Tags:** dataframes\
**Created:** [April 17, 2021, 5:43pm UTC](https://discourse.julialang.org/t/delete-all-rows-which-have-null-values-missing-values-in-all-the-columns/59489 "2021-04-17T17:43:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![harneet411](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/harneet411/32/24799_2.png) [@harneet411](https://discourse.julialang.org/u/harneet411)\
**Post date:** [April 17, 2021, 5:43pm UTC](https://discourse.julialang.org/t/delete-all-rows-which-have-null-values-missing-values-in-all-the-columns/59489/1 "2021-04-17T17:43:13Z")

</div>

I am trying to find a similar functionality like in Python where in I can delete the rows which have ‘all’ null values in a row -

code in python - Using Pandas dataframe ‘closed\_prices’  
closed\_prices.dropna(axis=0, how=‘all’, inplace=True)

Basically I want to drop rows which have missing values for all columns - I am using a stock data and want to remove the weekends and holidays, each column represent closing price of a particular stock. So if all the column values are null/missing for a particular row I want to delete that row.

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [April 17, 2021, 6:02pm UTC](https://discourse.julialang.org/t/delete-all-rows-which-have-null-values-missing-values-in-all-the-columns/59489/2 "2021-04-17T18:02:28Z")

</div>

Here is one example

```julia
julia> df = DataFrame(a = [1, missing], b = [missing, missing])
2×2 DataFrame
 Row │ a b       
     │ Int64? Missing 
─────┼──────────────────
   1 │ 1 missing 
   2 │ missing missing 

julia> filter(AsTable(:) => t -> !all(ismissing, t), df)
1×2 DataFrame
 Row │ a b       
     │ Int64? Missing 
─────┼─────────────────
   1 │ 1 missing 

```