# Autocomplete dataframe columns names not working in jupyter

**URL:** <https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880>\
**Category:** New to Julia\
**Tags:** jupyter, dataframes\
**Created:** [October 23, 2020, 12:39pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880 "2020-10-23T12:39:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lubo](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/lubo/32/18895_2.png) [@lubo](https://discourse.julialang.org/u/lubo)\
**Post date:** [October 23, 2020, 12:39pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880/1 "2020-10-23T12:39:57Z")

</div>

Hi there,  
julia newbie here, switching from python :).

I am using jupyter and dataframe package.  
Please, is there a way how to achieve autocomplete columns name in jupyter?

ie, having  
frame = DataFrame(PART\_NAME=String, YEAR\_URL=String)  
…  
some operations  
…  
then I would like to write:  
frame[:P] and hit tab and have full PART\_NAME auto-filled.  
This is working in VSCode, but not in Jupyter.

Same thing is working for Python+DataFrame(Pandas).  
For bigger projects with longer names this is very usefull to have.

Thank you  
Lubo

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [October 23, 2020, 12:42pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880/2 "2020-10-23T12:42:25Z")

</div>

Have you tried it using the `getproperty` syntax?

`df[:colname]` is deprecated, because it’s ambiguous if it’s acting on columns or rows.

Perhaps

```julia
df.P\tab

```

will work?

---

<div class="post-metadata">

**Author:** ![lubo](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/lubo/32/18895_2.png) [@lubo](https://discourse.julialang.org/u/lubo)\
**Post date:** [October 23, 2020, 12:53pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880/3 "2020-10-23T12:53:06Z")

</div>

Thanx a lot for quick reply!, I did not know, that this is deprecated.  
df.P\tab is working nicely.

Is there way to switch on depecated warnings?

Also, if I have dataframe and trying to sort according some columns, there is syntax:  
sort!(frame, :colname), is there also some trick to achieve autocomplete? :).

Also working in VSCode, but not in jupyter.

thanks

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [October 23, 2020, 12:56pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880/4 "2020-10-23T12:56:56Z")

</div>

I think it’s a bug that it’s not printing deprecation warnings, we should fix that!

I don’t think there is a way to get the autocomplete to work in Jupyter atm. I’m surprised that even works in VSCode! You should file an issue with IJulia.

---

<div class="post-metadata">

**Author:** ![lubo](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/lubo/32/18895_2.png) [@lubo](https://discourse.julialang.org/u/lubo)\
**Post date:** [October 23, 2020, 3:06pm UTC](https://discourse.julialang.org/t/autocomplete-dataframe-columns-names-not-working-in-jupyter/48880/5 "2020-10-23T15:06:03Z")

</div>

OK, seems to not working fully in VSCode either. Only in some cases, where names also used on different lines.  
But I tried to raise issue on IJulia, but was closed, as this should be solved in **REPLCompletions.jl**  
[https://github.com/JuliaLang/IJulia.jl/issues/957](https://github.com/JuliaLang/IJulia.jl/issues/957)

So does it make sence to raise issue there? Or is this not possible with Julia REPL?