# Array to DataFrames Columns. convert(Array{Float64,1}, a)

**URL:** https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325
**Category:** New to Julia
**Created:** [September 3, 2019, 1:38pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325 "2019-09-03T13:38:37Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)
#### Post date: [September 3, 2019, 1:38pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/1 "2019-09-03T13:38:37Z")

</div>

Would you help me?  
It seems very easy.

There is error: Cannot convert an object of type Array{Int,2} to an object of type Int

> a=DataFrame(a=[1,2],c=[3,4],d=[5,6])  
> a[:,[:c ,:d]] = [1 2; 3 4]

---

<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: [September 3, 2019, 1:47pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/2 "2019-09-03T13:47:47Z")

</div>

This works as expected if you check out `DataFrames#master` package version (we were going through a deprecation period).

If you prefer to stick to 0.19.3 version you should follow the error message recommendation and use broadcasting:

```julia
julia> a[:,[:c ,:d]] .= [1 2; 3 4]
2×2 SubDataFrame
│ Row │ c │ d │
│ │ Int64 │ Int64 │
├─────┼───────┼───────┤
│ 1 │ 1 │ 2 │
│ 2 │ 3 │ 4 │

julia> a
2×3 DataFrame
│ Row │ a │ c │ d │
│ │ Int64 │ Int64 │ Int64 │
├─────┼───────┼───────┼───────┤
│ 1 │ 1 │ 1 │ 2 │
│ 2 │ 2 │ 3 │ 4 │

```

Also note that in the past this operation was not allowed at all (that is why you get an error).

---

<div class="post-metadata">

### Author: ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)
#### Post date: [September 3, 2019, 1:51pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/3 "2019-09-03T13:51:23Z")

</div>

I am sorry to stupid question. How can I check the version?  
Unfortunately, your code doesn’t work (I have tried it early too, and right now again).  
There is error.

> MethodError: no method matching copyto!(::DataFrame, ::Base.Broadcast.Broadcasted{Base.Broadcast.DefaultArrayStyle{2},Tuple{Base.OneTo{Int64},Base.OneTo{Int64}},typeof(identity),Tuple{Array{Int64,2}}})  
> Closest candidates are:  
> copyto!(!Matched::AbstractArray, ::Base.Broadcast.Broadcasted) at broadcast.jl:797  
> copyto!(!Matched::AbstractArray, ::Any) at abstractarray.jl:666  
> materialize!(::DataFrame, ::Base.Broadcast.Broadcasted{Base.Broadcast.DefaultArrayStyle{2},Nothing,typeof(identity),Tuple{Array{Int64,2}}}) at broadcast.jl:756  
> top-level scope at none:0

---

<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: [September 3, 2019, 2:03pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/4 "2019-09-03T14:03:32Z")

</div>

Use:

```julia
julia> using Pkg

julia> Pkg.status("DataFrames")
    Status `C:\Users\bogum\.julia\environments\v1.2\Project.toml`
  [a93c6f00] DataFrames v0.19.3

```

And you should get the same version. If not run:

```julia
Pkg.update("DataFrames")

```

to get the latest released version.

---

<div class="post-metadata">

### Author: ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)
#### Post date: [September 3, 2019, 2:09pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/5 "2019-09-03T14:09:41Z")

</div>

For some reasons I have only v0.18.4

Can it be due to Julia version 1.1.1

Is there other methods to do the same things?

thank you in advance

---

<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: [September 3, 2019, 2:26pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/6 "2019-09-03T14:26:25Z")

</div>

Then do:

```julia
a[:,[:c ,:d]] = DataFrame([1 2; 3 4], [:c, :d])

```

but this is not a recommended style in the long run as it is not efficient.

---

<div class="post-metadata">

### Author: ![BMval](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bmval/32/7647_2.png) [@BMval](https://discourse.julialang.org/u/BMval)
#### Post date: [September 3, 2019, 2:28pm UTC](https://discourse.julialang.org/t/array-to-dataframes-columns-convert-array-float64-1-a/28325/7 "2019-09-03T14:28:13Z")

</div>

Thank you.
