# Select Columns by Index Using dplyr

Select Columns by Index Using dplyr, To pick data frame columns by index position in dplyr, use the following basic syntax.

Columns in specified index places can be selected.

```df %>%
select(1,2, 4)```

Columns in particular index positions are excluded.

```df %>%
select(-c(1,2))```

## Select Columns by Index Using dplyr

With the following data frame, the following examples demonstrate how to use this syntax in practice.

LSTM Network in R » Recurrent Neural network » finnstats

Let’s create a data frame

```df <- data.frame(team=c('Q1', 'Q2', 'Q3', 'Q4', 'Q5'),
points=c(9, 2, 3, 6, 9),
kick=c(13, 18, 31, 32, 14),
pass=c(32, 22, 23, 34, 35),
blocks=c(25, 39, 24, 28, 55))```

Now we can view the data frame

`df`
```team points kick pass blocks
1   Q1      9   13   32     25
2   Q2      2   18   22     39
3   Q3      3   31   23     24
4   Q4      6   32   34     28
5   Q5      9   14   35     55```

### Example 1: Columns in specified index places can be selected

The code below demonstrates how to choose columns in specified index positions.

How to Calculate the Scalar Product in R » finnstats

`library(dplyr)`

select columns in positions 1, 3, and 4

```df %>%
select(1, 3, 4)```
```  team kick pass
1   Q1   13   32
2   Q2   18   22
3   Q3   31   23
4   Q4   32   34
5   Q5   14   35```

### Example 2: Select Columns in Range

The code below demonstrates how to select columns from a range.

rbind in r-Combine Vectors, Matrix or Data Frames by Rows » finnstats

`library(dplyr)`

Now we can select columns in positions 2 through 3

```df %>%
select(2:3)```
```  points kick
1      9   13
2      2   18
3      3   31
4      6   32
5      9   14```

### Example 3: Exclude Specific Columns

The code below demonstrates how to omit specific columns depending on their index position.

`library(dplyr)`

select all columns except those in positions 1 and 2.

How to Calculate Jaccard Similarity in R » finnstats

```df %>%
select(-c(1, 2))```
```  kick pass blocks
1   13   32     25
2   18   22     39
3   31   23     24
4   32   34     28
5   14   35     55```

The first and second columns are not included.