Skip to content

Instantly share code, notes, and snippets.

@MichaelHatherly
Created March 17, 2016 12:37
Show Gist options
  • Save MichaelHatherly/b06b3a40bcecf4abb3e0 to your computer and use it in GitHub Desktop.
Save MichaelHatherly/b06b3a40bcecf4abb3e0 to your computer and use it in GitHub Desktop.
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 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment