# How to transpose a DataFrame?

**URL:** <https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000>\
**Category:** General Usage\
**Tags:** question, dataframes\
**Created:** [January 3, 2022, 8:42pm UTC](https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000 "2022-01-03T20:42:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![leon](https://avatars.discourse-cdn.com/v4/letter/l/dc4da7/32.png) [@leon](https://discourse.julialang.org/u/leon)\
**Post date:** [January 3, 2022, 8:42pm UTC](https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000/1 "2022-01-03T20:42:52Z")

</div>

For example, if I have a DataFrame like the below. How do I transpose it?

```julia
df = 12×5 DataFrame
 Row │ Variable Col1 Col2 Col3 Col4
         │ String Float64 Float64 Float64 Float64
───┼──────────────────────────────────
   1 │ Var1 8.19625 7.74408 7.57055 7.42672
   2 │ Var2 12.5282 11.8329 11.5725 11.3412
   3 │ Var3 20.3213 20.2322 20.2025 20.1582
   4 │ Var4 18.6746 20.2428 20.8298 21.6727
   5 │ Var5 15.1324 16.456 16.9414 17.5668
   6 │ Var6 521.503 492.1 481.128 471.208

```

I tried the below and it did not work:  
`df_use = DataFrame(Matrix(df)');`

Many thanks.

---

<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:** [January 3, 2022, 8:47pm UTC](https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000/2 "2022-01-03T20:47:01Z")

</div>

Try `permutedims(df, 1)`

---

<div class="post-metadata">

**Author:** ![leon](https://avatars.discourse-cdn.com/v4/letter/l/dc4da7/32.png) [@leon](https://discourse.julialang.org/u/leon)\
**Post date:** [January 3, 2022, 8:51pm UTC](https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000/3 "2022-01-03T20:51:16Z")

</div>

It works!

Thank you very much.

---

<div class="post-metadata">

**Author:** ![rafael.guerra](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael.guerra/32/216610_2.png) [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)\
**Post date:** [January 3, 2022, 9:06pm UTC](https://discourse.julialang.org/t/how-to-transpose-a-dataframe/74000/4 "2022-01-03T21:06:14Z")

</div>

Fyi, there is [a nice solution posted in SO](https://stackoverflow.com/a/59485866/14071775) to transpose dataframes, including the column names.