Problem with autocompletion with Pandas in Jupyter

Question

I am having a problem similar to this user: when calling autocomplete on df.col., I get no autocompletion even after evaluating a cell containing only df.col. For instance, I'd like to see df.col.str.matc to autocomplete to df.col.str.match. What can I do to solve this?

Take as example the following dataframe:

import pandas as pd
data = [['Alex in FL','ten'],['Bob in FLORIDA','five'],['Will in GA','three']]
df = pd.DataFrame(data,columns=['Name','Age'])

#Dataframe:
    Name             Age
0   Alex in FL       ten
1   Bob in FLORIDA   five
2   Will in GA       three

#Command that should autocomplete (but does not):
df.Name.str.matc [+TAB]

I do not want to try hinterland since I only want autocomplete upon pressing tab.

Thanks a lot in advance!

df.columns.str.match is the thing you are looking for. df.col. +tab will not give anything since there is nothing like df.col. (col is not an attribute of dataframe). — vb_rises
– vb_rises, Commented Oct 8, 2019 at 14:05
@vb_rises to clarify, col is one of the columns in the df, so that df.col is a series. But anyways, df.columns.str.matc + tab still does not autocomplete. the problem remains — Sos
– Sos, Commented Oct 9, 2019 at 7:16
if col contains string values like 'abc', 'def' or in other words, it's type is object, then df.col.str.mat + tab will work. But if col has integer or float values (type is int or float), then df.col.str.mat + tab will not autocomplete. You can convert it to x = df.col.astype('str') and then try x.str.mat + tab, it should work. — vb_rises
– vb_rises, Commented Oct 9, 2019 at 9:29
@vb_rises thanks. I'll edit my question to clarify these points, but my dataframe falls on your first example, but it doesn't work in any case. — Sos
– Sos, Commented Oct 9, 2019 at 13:05
your updated example perfectly works fine with me. My pandas version is 0.19.2. check your version. And I hope that you are running df.Name.st.mat + TAB in a NEW CELL after initializing df. — vb_rises
– vb_rises, Commented Oct 9, 2019 at 13:31

vb_rises · Accepted Answer · 2019-10-10 09:50:22Z

4

After reading this, it seems that this problem is faced by other people and with specific version of ipython. The solution is also given on that link.

It is like this:

Run below command from the terminal:

ipython profile create

It will create a default profile at ~/.ipython/profile_default/ipython_config.py

Now edit this ipython_config.py and add the below lines and it will solve the issue.

c = get_config()
c.Completer.use_jedi = False

Reference:

answered Oct 10, 2019 at 9:50

vb_rises

1,9071 gold badge12 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with autocompletion with Pandas in Jupyter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related