I am trying to replicate the excel function concat in julia.
I have two columns A and B. I am trying to concatenate the values in these columns and produce a single column with the values in columns A and columns B concatenated with “:” in between.
Column A and Column B are of the same size A (1000, 1) and B(1000, 1).
I have tried the below code which isn’t given me the required outcome.
columnA = CSV.read(location, DataFrame; select = columnA) columnB = CSV.read(location, DataFrame; select = columnB])
y = DataFrame(x1 = columnA, x2 = columnB)
CONCAT = ["(r[:x1]):(r[:x2])" for r in eachrow(y)]
Any ideas how to change this to return a new column C with A and B concatented with “:” in between?