join dataframe columns

[pip7...@gmail.com]

Hi

How can I join 2 columns in a dataframe.

e.g.

Dataframe 1

Row    Name       Name2       Amt

1         Test        A               123

2         Test2      B                456

etc

I want to be able to join Name and Name2 and use a separator like -

eg

Row    Name       Amt

1         Test-A     123

2         Test2-B    456

Regards

[Johan Sigfrids]

With a DataFrame like:

df = DataFrame(Name = ["Test", "Test2"], Name2 = ["A", "B"], Amt=[123,456])

you could do something like this:

df[:Name] = map((x,y) -> string(x, -, y), df[:Name], df[:Name2])

Note that you will still have the Name2 column.

[pgs]

Johan

Thanks for this.

I also found that I could use .* to join two columns in a DataFrame.

Using a dot star to join! -  I found surprising - but it worked.

Regards