Add a column to the left side of a dataset

Question

What I am trying to do is to add an id column at the left side of my data set.

This is the data set I am working with. I Have three columns and I want to add a new column on the left side with the column tag ID with the following values: Id={1,2,3,4,5,6}.

Dataset@
 {
  <|"Team name" -> "Chealse", "GF" -> 23, "GA" -> 12|>,
  <|"Team name" -> "Arsenal", "GF" -> 30, "GA" -> 13|>,
  <|"Team name" -> "Burnley", "GF" -> 33, "GA" -> 15|>,
  <|"Team name" -> "Everton", "GF" -> 53, "GA" -> 11|>,
  <|"Team name" -> "Watford", "GF" -> 45, "GA" -> 9|>,
  <|"Team name" -> "Brighton", "GF" -> 24, "GA" -> 7|>
  }

If your dataset is ds then n = 1; ds = ds[All, Prepend[#, "ID" -> n++] &] — Bob Hanlon, May 31 '20 at 05:55

kglr · Accepted Answer · 2020-05-31T10:09:23.973

7

Join[Dataset[Association /@ Thread["ID" -> Id]], ds, 2]

Also

MapIndexed[Prepend[#, "ID" -> #2[[1]]] &, ds]

edited May 31 '20 at 10:09

answered May 31 '20 at 07:27

kglr

394,356
18
477
896

It worked fine, but I don´t understand the 2 on the Join function. – Las Des May 31 '20 at 22:33
2

@LasDes, the third argument of Join specifies that the elements at Level 2 of the objects in the first and second argument are to be joined. Try, for example, Join[{{a}, {b}, {c}}, {{1}, {2}, {3}}] and Join[{{a}, {b}, {c}}, {{1}, {2}, {3}}, 2] – kglr May 31 '20 at 22:37
I can see now why, thanks. – Las Des May 31 '20 at 22:42

score 2 · Answer 2 · answered May 31 '20 at 17:37

2

Another way

ds[MapIndexed[<|"ID" -> First@#2, #|> &]]

answered May 31 '20 at 17:37

Rohit Namjoshi

10,212
6
16
67

Add a column to the left side of a dataset

2 Answers2