# EVID error while using read\_pumas

**URL:** <https://discourse.pumas.ai/t/evid-error-while-using-read-pumas/92>\
**Category:** Data read\
**Created:** [November 26, 2019, 2:47pm UTC](https://discourse.pumas.ai/t/evid-error-while-using-read-pumas/92 "2019-11-26T14:47:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sai\_matcha](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.pumas.ai/sai_matcha/32/297_2.png) [@sai\_matcha](https://discourse.pumas.ai/u/sai_matcha)\
**Post date:** [November 26, 2019, 2:47pm UTC](https://discourse.pumas.ai/t/evid-error-while-using-read-pumas/92/1 "2019-11-26T14:47:54Z")

</div>

i am got an error that dose related items must be non zero but they are already nonzero in dataset

```auto
mt = read_pumas(dat, id =:id, time = :TIME, dvs = [:dv],)
ERROR: AssertionError: Some dose-related data items must be non-zero when evid = 1
Stacktrace:
 [1] build_event_list!(::Array{Pumas.Event{Float64,Float64,Float64,Float64,Float64,Float64,Int64},1}, ::Bool, ::Float64, ::Int8, ::Float64, ::Int64, ::Float64, ::Int64, ::Float64, ::Int8) at C:\Users\Lenovo\.juliapro\JuliaPro_v1.2.0-1\packages\Pumas\6uorK\src\data_parsing\data_read.jl:84
 [2] Subject(::SubDataFrame{DataFrame,DataFrames.Index,Array{Int64,1}}, ::Array{Symbol,1}, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Array{Symbol,1}, ::Array{Symbol,1}, ::Bool) at C:\Users\Lenovo\.juliapro\JuliaPro_v1.2.0-1\packages\Pumas\6uorK\src\data_parsing\data_types.jl:254
 [3] (::getfield(Pumas, Symbol("##37#38")){Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Bool,Array{Symbol,1}})(::SubDataFrame{DataFrame,DataFrames.Index,Array{Int64,1}}) at .\none:0
 [4] collect(::Base.Generator{GroupedDataFrame{DataFrame},getfield(Pumas, Symbol("##37#38")){Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Symbol,Bool,Array{Symbol,1}}}) at .\generator.jl:47
 [5] #read_pumas#36(::Array{Symbol,1}, ::Array{Symbol,1}, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Symbol, ::Bool, ::typeof(read_pumas), ::DataFrame) at C:\Users\Lenovo\.juliapro\JuliaPro_v1.2.0-1\packages\Pumas\6uorK\src\data_parsing\data_read.jl:63
 [6] (::getfield(Pumas, Symbol("#kw##read_pumas")))(::NamedTuple{(:id, :time, :dvs),Tuple{Symbol,Symbol,Array{Symbol,1}}}, ::typeof(read_pumas), ::DataFrame) at .\none:0
 [7] top-level scope at none:0

```

data is

```auto
id	TIME	AMT	dv	MDV	wt	evid
1	0 50	.	1	70	1
1	2.5	.	0.26334	0	70	0
1	5	.	0.33196	0	70	0
1	10	.	0.28416	0	70	0
1	15	.	0.21946	0	70	0
1	30	.	0.116114	0	70	0
1	60	.	0.076738	0	70	0
1	90	.	0.061304	0	70	0
1	120	.	0.058616	0	70	0
1	180	.	0.053336	0	70	0
1	240	.	0.05046	0	70	0
1	300	.	0.034764	0	70	0
1	360	.	0.03508	0	70	0
1	480	.	0.038228	0	70	0
1	600	.	0.020326	0	70	0
2	0 100	.	1	60	1
2	2.5	.	2.1238	0	60	0
2	5	.	1.88695	0	60	0
2	10	.	1.12165	0	60	0
2	15	.	0.7418	0	60	0
2	30	.	0.56585	0	60	0
2	60	.	0.268845	0	60	0
2	90	.	0.418505	0	60	0
2	120	.	0.211785	0	60	0
2	180	.	0.238055	0	60	0
2	240	.	0.270265	0	60	0
2	300	.	0.112965	0	60	0
2	360	.	0.229935	0	60	0
2	480	.	0.17821	0	60	0
2	600	.	0.13506	0	60	0
3	0 200	.	1	65	1
3	2.5	.	5.6644	0	65	0
3	5	.	6.1286	0	65	0
3	10	.	3.4058	0	65	0
3	15	.	2.1382	0	65	0
3	30	.	1.1687	0	65	0
3	60	.	0.75104	0	65	0
3	90	.	0.61568	0	65	0
3	120	.	0.66896	0	65	0
3	180	.	0.69688	0	65	0
3	240	.	0.61602	0	65	0
3	300	.	0.53642	0	65	0
3	360	.	0.46574	0	65	0
3	480	.	0.43812	0	65	0
3	600	.	0.27616	0	65	0

```

---

<div class="post-metadata">

**Author:** ![sai\_matcha](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.pumas.ai/sai_matcha/32/297_2.png) [@sai\_matcha](https://discourse.pumas.ai/u/sai_matcha)\
**Post date:** [November 26, 2019, 2:49pm UTC](https://discourse.pumas.ai/t/evid-error-while-using-read-pumas/92/2 "2019-11-26T14:49:17Z")

</div>

sorry not able to paste data properly. please tell me if there is any procedure to paste excel data properly

---

<div class="post-metadata">

**Author:** ![andreasnoack](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.pumas.ai/andreasnoack/32/22_2.png) [@andreasnoack](https://discourse.pumas.ai/u/andreasnoack)\
**Post date:** [November 27, 2019, 8:10am UTC](https://discourse.pumas.ai/t/evid-error-while-using-read-pumas/92/3 "2019-11-27T08:10:51Z")

</div>

It looks like the data is not read correctly. Could you please try

```auto
using CSV
df = CSV.read(dat)

```

and see now things look like? Based on what you printed above, it does look like things are aligned incorrectly. E.g. see the `50` in the second line and the `100` further down. Are there possibly two tabs before those numbers instead of just one?