# Spilt column and save into different column

**URL:** <https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368>\
**Category:** New to Julia\
**Tags:** question\
**Created:** [September 10, 2020, 10:31am UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368 "2020-09-10T10:31:34Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arpan\_Jain](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/arpan_jain/32/17816_2.png) [@Arpan\_Jain](https://discourse.julialang.org/u/Arpan_Jain)\
**Post date:** [September 10, 2020, 10:31am UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/1 "2020-09-10T10:31:34Z")

</div>

ho

 ![DATAMANGLING](https://global.discourse-cdn.com/julialang/original/3X/6/1/61668614f656d67f12add051f058af0e38230e34.jpeg)  
SOLVE E PART

---

<div class="post-metadata">

**Author:** ![tomerarnon](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tomerarnon/32/3170_2.png) [@tomerarnon](https://discourse.julialang.org/u/tomerarnon)\
**Post date:** [September 10, 2020, 11:00am UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/2 "2020-09-10T11:00:06Z")

</div>

Sounds like you want each row to become a column?

```julia
df_transpose = DataFrame(permutedims(Matrix(df), (2,1)))

```

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [September 10, 2020, 11:52am UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/3 "2020-09-10T11:52:48Z")

</div>

Is this a homework problem? What have you tried and why did it not work?

---

<div class="post-metadata">

**Author:** ![Arpan\_Jain](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/arpan_jain/32/17816_2.png) [@Arpan\_Jain](https://discourse.julialang.org/u/Arpan_Jain)\
**Post date:** [September 10, 2020, 1:21pm UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/4 "2020-09-10T13:21:17Z")

</div>

I TRIED TO CONVERT INTO STRING  
AND THEN TRIED TO SAVE INTO DIFFERENT COLUMNS  
foreach(enumerate([:DELAY1,:DELAY2,:DELAY3 ))do(i,n)  
df[!,n] = getindex.(data,i)  
end  
BUT IT SHOW BOUND ERROR:SHOW GETINDEX TRIED TO ACESS [1] ELEMENT AT 2ND POSTION

well yes this is my assignment and i have need help for solving in e part

---

<div class="post-metadata">

**Author:** ![Arpan\_Jain](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/arpan_jain/32/17816_2.png) [@Arpan\_Jain](https://discourse.julialang.org/u/Arpan_Jain)\
**Post date:** [September 10, 2020, 1:23pm UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/5 "2020-09-10T13:23:24Z")

</div>

JUST AFTER CONVERSION I USE SPILT  
DATA=SPLIT.(DF.RecentDelays,‘,’)

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [September 10, 2020, 1:50pm UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/6 "2020-09-10T13:50:05Z")

</div>

Please quote your code using triple backticks ( ``` `code` ```) to make it easier to read.

The error is telling you that you’re trying to access the second element of a length-1 vector, so you need to change your approach to take into account the `length` of each element in the `RecentDelays` column before accessing it.

---

<div class="post-metadata">

**Author:** ![tk3369](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tk3369/32/2824_2.png) [@tk3369](https://discourse.julialang.org/u/tk3369)\
**Post date:** [September 10, 2020, 2:29pm UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/7 "2020-09-10T14:29:16Z")

</div>

Take a look at this recent blog post?

> **[Separating a column into multiple columns in DataFrames.jl](https://bkamins.github.io/julialang/2020/09/04/separate.html)**
>
> Introduction

---

<div class="post-metadata">

**Author:** ![Arpan\_Jain](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/arpan_jain/32/17816_2.png) [@Arpan\_Jain](https://discourse.julialang.org/u/Arpan_Jain)\
**Post date:** [September 10, 2020, 5:44pm UTC](https://discourse.julialang.org/t/spilt-column-and-save-into-different-column/46368/8 "2020-09-10T17:44:50Z")

</div>

cant understand the approach  
can u code this??  
i am using julia 1.4