julia> using DataFrames
julia> df = DataFrame(A = 1:10, B = 2:2:20)
10x2 DataFrames.DataFrame
| Row | A | B |
|-----|----|----|
| 1 | 1 | 2 |
| 2 | 2 | 4 |
| 3 | 3 | 6 |
| 4 | 4 | 8 |
| 5 | 5 | 10 |
| 6 | 6 | 12 |
| 7 | 7 | 14 |
| 8 | 8 | 16 |
| 9 | 9 | 18 |
| 10 | 10 | 20 |
{meta}
DocTestSetup = quote
using DataFrames
df = DataFrame(A = 1:10, B = 2:2:20)
end
julia> df[1]
10-element DataArrays.DataArray{Int64,1}:
1
2
3
4
5
6
7
8
9
10
julia> df[:A]
10-element DataArrays.DataArray{Int64,1}:
1
2
3
4
5
6
7
8
9
10
julia> df[1, 1]
1
julia> df[1, :A]
1
julia> df[1:3, [:A, :B]]
3x2 DataFrames.DataFrame
| Row | A | B |
|-----|---|---|
| 1 | 1 | 2 |
| 2 | 2 | 4 |
| 3 | 3 | 6 |
julia> df[1:3, [:B, :A]]
3x2 DataFrames.DataFrame
| Row | B | A |
|-----|---|---|
| 1 | 2 | 1 |
| 2 | 4 | 2 |
| 3 | 6 | 3 |
julia> df[df[:A] % 2 .== 0, :]
5x2 DataFrames.DataFrame
| Row | A | B |
|-----|----|----|
| 1 | 2 | 4 |
| 2 | 4 | 8 |
| 3 | 6 | 12 |
| 4 | 8 | 16 |
| 5 | 10 | 20 |
julia> df[df[:B] % 2 .== 0, :]
10x2 DataFrames.DataFrame
| Row | A | B |
|-----|----|----|
| 1 | 1 | 2 |
| 2 | 2 | 4 |
| 3 | 3 | 6 |
| 4 | 4 | 8 |
| 5 | 5 | 10 |
| 6 | 6 | 12 |
| 7 | 7 | 14 |
| 8 | 8 | 16 |
| 9 | 9 | 18 |
| 10 | 10 | 20 |