Renaming multiple columns in Julia DataFrames

Question

I have the following Julia Daataframe;

data_test = DataFrame(Time = 1:2, X1 = [0,1], X2 = [10,5])

And I have a list of names as follows;

technology = ["oil", "gas"]

How do I rename columns X1 and X2 using the list (excluding Time column). I can do it manually, however, this is not an efficient option to rename hundreds of columns. So, essentially, I'm what I'm looking for is a way to map the list of names to the columns. Any efficient solution is highly appreciated.

score 2 · Answer 1 · answered Jun 20 '22 at 14:57

2

You can try something like this (works for Julia 1.7.2):

data_test = DataFrame(Time = 1:2, X1 = [0,1], X2 = [10,5])
new_names = Dict(
    :X1=>"oil",
    :X2=>"gas",
)
rename!(data_test, new_names)

answered Jun 20 '22 at 14:57

Amon

402
2
8

or just `rename!(data_test, :X1 => "oil", :X2 => "gas")` – Bogumił Kamiński Jun 20 '22 at 15:18

score 0 · Answer 2 · answered Jun 20 '22 at 16:04

0

A solution I received from JuliaDiscourse.

rename!(data_test, ["X$i" => tech for (i, tech) in enumerate(technology)])

answered Jun 20 '22 at 16:04

M.B

19
7

Renaming multiple columns in Julia DataFrames

2 Answers2