CODEWITHSUNDEEP
juliadataframes.jl
Josep Espasa
Josep Espasa

Reputation: 759

Add a column with a constant value to a DataFrame

How can I add a column with a constant value to a DataFrame?

E.g. I have the following DataFrame:

using DataFrames

df = DataFrame(x = 1:10, y = 'a':'j')

And I would like to add a new variable z with constant value 1 and obtain:

10×3 DataFrame
 Row │ x      y     z     
     │ Int64  Char  Int64
─────┼────────────────────
   1 │     1  a         1
   2 │     2  b         1
   3 │     3  c         1
   4 │     4  d         1
   5 │     5  e         1
   6 │     6  f         1
   7 │     7  g         1
   8 │     8  h         1
   9 │     9  i         1
  10 │    10  j         1

Upvotes: 4

Views: 1435

Answers (2)

Bogumił Kamiński
Bogumił Kamiński

Reputation: 69869

A more general alternative is:

julia> insertcols!(df, :z => 1)
10×3 DataFrame
 Row │ x      y     z
     │ Int64  Char  Int64
─────┼────────────────────
   1 │     1  a         1
   2 │     2  b         1
   3 │     3  c         1
   4 │     4  d         1
   5 │     5  e         1
   6 │     6  f         1
   7 │     7  g         1
   8 │     8  h         1
   9 │     9  i         1
  10 │    10  j         1

which by default does the same, but it additionally:

  1. allows you to specify the location of the new column;
  2. by default makes sure that you do not accidentally overwrite an existing column

Upvotes: 6

Likan Zhan
Likan Zhan

Reputation: 1076

To create such column:

df = DataFrame(x = 1:10, y = 'a':'j', d = 1)

To append such column to the existing DataFrame, you need broadcasting:

df.e .= 1

or

df[:, "f"] .= 1

Upvotes: 7

Related Questions