# Insert time in missing rows

**URL:** <https://discourse.julialang.org/t/insert-time-in-missing-rows/91244>\
**Category:** New to Julia\
**Tags:** dates, dataframes, time-series, time\
**Created:** [December 5, 2022, 5:35am UTC](https://discourse.julialang.org/t/insert-time-in-missing-rows/91244 "2022-12-05T05:35:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sai\_matcha](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/sai_matcha/32/35801_2.png) [@sai\_matcha](https://discourse.julialang.org/u/sai_matcha)\
**Post date:** [December 5, 2022, 5:35am UTC](https://discourse.julialang.org/t/insert-time-in-missing-rows/91244/1 "2022-12-05T05:35:04Z")

</div>

Hi i have column containts time.  
looks like this

```julia
 julia> df.TOB
391-element SentinelArrays.ChainedVector{Union{Missing, Time}, SentinelArrays.SentinelVector{Time, Time, Missing, Vector{Time}}}:
 12:30:00
 12:30:00
 12:30:00
 07:47:00

```

Here is summary of column

```julia
 TOB (min) 01:15:00 (med) 13:23:00 (max) 23:38:00 7 Union{Missing, Time}

```

Time is missing in 7 rows out of 391 rows.  
I want fill missing rows with time “12:00:00”,  
I want column to be in time format after filling.  
Can someone help me to do this  
Thanks

---

<div class="post-metadata">

**Author:** ![chiraganand](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/chiraganand/32/32787_2.png) [@chiraganand](https://discourse.julialang.org/u/chiraganand)\
**Post date:** [December 5, 2022, 7:35am UTC](https://discourse.julialang.org/t/insert-time-in-missing-rows/91244/2 "2022-12-05T07:35:55Z")

</div>

You can use Impute.jl to fill `missing` values with another value in an Array:

```julia
julia> using Impute

julia> timestamps = [Time(12, 30),Time(12, 30), missing, missing, Time(15,30), Time(16, 30)]
6-element Vector{Union{Missing, Time}}:
 12:30:00
 12:30:00
 missing
 missing
 15:30:00
 16:30:00

julia> Impute.fill(timestamps, value=Time(12))
6-element Vector{Union{Missing, Time}}:
 12:30:00
 12:30:00
 12:00:00
 12:00:00
 15:30:00
 16:30:00

```

There is also an in-place version: `Impute.fill!()`.

---

<div class="post-metadata">

**Author:** ![bkamins](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bkamins/32/208538_2.png) [@bkamins](https://discourse.julialang.org/u/bkamins)\
**Post date:** [December 5, 2022, 7:42am UTC](https://discourse.julialang.org/t/insert-time-in-missing-rows/91244/3 "2022-12-05T07:42:36Z")

</div>

or just use `coalesce`. Here is an example how to do an in-place update:

```julia
julia> timestamps = [Time(12, 30),Time(12, 30), missing, missing, Time(15,30), Time(16, 30)]
6-element Vector{Union{Missing, Time}}:
 12:30:00
 12:30:00
 missing
 missing
 15:30:00
 16:30:00

julia> timestamps .= coalesce.(timestamps, Time(12))
6-element Vector{Union{Missing, Time}}:
 12:30:00
 12:30:00
 12:00:00
 12:00:00
 15:30:00
 16:30:00

```