# Viewing columns and datatype in dataframe

**URL:** <https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621>\
**Category:** New to Julia\
**Tags:** question, dataframes\
**Created:** [March 28, 2022, 3:14pm UTC](https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621 "2022-03-28T15:14:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![janilin](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/janilin/32/33769_2.png) [@janilin](https://discourse.julialang.org/u/janilin)\
**Post date:** [March 28, 2022, 3:14pm UTC](https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621/1 "2022-03-28T15:14:30Z")

</div>

I created a dataframe first:

```julia
using DataFrames
df = DataFrame(id=[1,2,3], 
    salary=4500, 
    age=[30, 30, 32])

```

To view column names and datatypes, used:

```julia
Dict(names(df) .=> eltype.(eachcol(df)))

```

However, it gets the job done but is there any better way for this, like any function or using package?

---

<div class="post-metadata">

**Author:** ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)\
**Post date:** [March 28, 2022, 3:15pm UTC](https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621/2 "2022-03-28T15:15:43Z")

</div>

More verbose:

```julia
julia> describe(df)
3×7 DataFrame
 Row │ variable mean min median max nmissing eltype
     │ Symbol Float64 Int64 Float64 Int64 Int64 DataType
─────┼────────────────────────────────────────────────────────────────
   1 │ id 2.0 1 2.0 3 0 Int64
   2 │ salary 4500.0 4500 4500.0 4500 0 Int64
   3 │ age 30.6667 30 30.0 32 0 Int64

```

if you really don’t want to know anything else:

```julia
julia> describe(df, :eltype)
3×2 DataFrame
 Row │ variable eltype
     │ Symbol DataType
─────┼────────────────────
   1 │ id Int64
   2 │ salary Int64
   3 │ age Int64

```

---

<div class="post-metadata">

**Author:** ![janilin](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/janilin/32/33769_2.png) [@janilin](https://discourse.julialang.org/u/janilin)\
**Post date:** [March 28, 2022, 3:19pm UTC](https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621/3 "2022-03-28T15:19:37Z")

</div>

> [@nilshg](#):
>
> `describe(df, :eltype)`

```julia
describe(df, :eltype)

```

It’s neat indeed! Thanks for helping out!

---

<div class="post-metadata">

**Author:** ![bkamins](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bkamins/32/208538_2.png) [@bkamins](https://discourse.julialang.org/u/bkamins)\
**Post date:** [March 28, 2022, 3:25pm UTC](https://discourse.julialang.org/t/viewing-columns-and-datatype-in-dataframe/78621/4 "2022-03-28T15:25:04Z")

</div>

or

```julia
julia> mapcols(eltype, df)
1×3 DataFrame
 Row │ id salary age
     │ DataType DataType DataType
─────┼──────────────────────────────
   1 │ Int64 Int64 Int64

```