AttributeError: 'DataFrame' object has no attribute 'ix'

Question

I am getting this error when I try to use the .ix attribute of a pandas data frame to pull out a column, e.g. df.ix[:, 'col_header'].

AttributeError: 'DataFrame' object has no attribute 'ix'

The script worked this morning, but this afternoon I ran it in a new Linux environment with a fresh install of Pandas. Has anybody else seen this error before? I've searched here and elsewhere but can't find it.

You were running an older version of pandas. See this? https://stackoverflow.com/questions/43838999/pandas-replacement-for-ix — StupidWolf, Jan 30 '20 at 17:45

Code42 · Answer 1 · 2020-12-16T10:08:01.303

110

try df.iloc[:, integer]

.ix is deprecated

By the way, df.loc[:,'col_header'] is for str or Boolean indexing

edited Dec 16 '20 at 10:08

answered Mar 15 '20 at 22:33

Code42

2,292
1
17
22

I receive "Location based indexing can only have [integer, integer slice (START point is INCLUDED, END point is EXCLUDED), listlike of integers, boolean array] types" for that. – Ben May 15 '20 at 08:01
"*By the way, df.loc[:,'col_header'] is for str indexing*" and will be required if the indexer was a Boolean mask. – mins Dec 15 '20 at 11:04
3

*"`.ix` is deprecated"* - `.ix` was removed, not deprecated (which means discouraged but still available). – wisbucky Jul 21 '21 at 18:28

score 52 · Answer 2 · edited Mar 02 '21 at 19:26

52

Change .ix to .loc and it should work correctly.

edited Mar 02 '21 at 19:26

Melanie Palen

2,645
6
31
50

answered May 01 '20 at 14:39

Abidi Mohamed

723
7
7

ALollz · Answer 3 · 2020-01-30T17:55:22.320

27

A fresh install today (Jan 30, 2020) would install pd.__version__ == '1.0.0'. With that comes a removal of many deprecated features.

Removed Series.ix and DataFrame.ix (GH26438)

edited Jan 30 '20 at 17:55

answered Jan 30 '20 at 17:38

ALollz

57,915
7
66
89

score 4 · Answer 4 · answered Jun 09 '20 at 15:25

4

Try following steps: 1) installing new version of Pandas 2) use .loc instead of .ix

answered Jun 09 '20 at 15:25

Sau

99
5

score 3 · Answer 5 · answered Feb 03 '20 at 20:01

3

had same issue with pandas 1.0.0, this worked for me

Open Anaconda Prompt (cmd) as Administrator, then

conda install pandas==0.25.1

Your newer pandas version will be overwritten by older one!

answered Feb 03 '20 at 20:01

Eric Stralsund

541
1
5
17

score 3 · Answer 6 · answered Sep 07 '20 at 19:34

3

it works for me

Use df.loc[] instade of ix[]

answered Sep 07 '20 at 19:34

Dhiren Biren

472
4
7

score 2 · Answer 7 · answered Mar 09 '22 at 08:19

2

as ix is removed

use iloc or loc inplace of ix.

use .loc if you have string or userdefined indexing.

answered Mar 09 '22 at 08:19

Luicfer Ai

56
2

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 09 '22 at 12:06
"as ix is removed" What does this mean exactly? – ryanwebjackson Mar 11 '22 at 20:03
Ix is now not available to be used in pandas. You have to use .iloc Or loc these will give you same result. – Luicfer Ai Mar 13 '22 at 03:27

score 1 · Answer 8 · answered May 11 '20 at 11:21

1

I used .loc() instead of .ix() and it worked.

answered May 11 '20 at 11:21

user3752821

11
2

score 1 · Answer 9 · answered Sep 28 '21 at 12:26

1

replace .ix with .iloc after replacing its works well for me also

predictions_ARIMA_log = pd.Series(ts_log.iloc[0], index=ts_log.index)

answered Sep 28 '21 at 12:26

Ekramy Younan

11
2

score 1 · Answer 10 · edited May 31 '23 at 00:31

1

If you need to use .ix[], you must downgrade your pandas version to 0.20.0. In newer versions, you could use .loc[] or .iloc[] instead.

edited May 31 '23 at 00:31

Kyle F Hartzenberg

2,567
3
6
24

answered May 30 '23 at 22:08

Abolfazl

637
4
7

score 0 · Answer 11 · answered Mar 08 '20 at 08:40

0

one column:

df[['sepal width']]

two columns:

df[['sepal width','petal width']]

special columns(select column include 'length'):

df[[c for c in df.columns if 'length' in c]]

answered Mar 08 '20 at 08:40

HelloNewWorld

335
3
11

score 0 · Answer 12 · answered Jul 01 '20 at 07:58

0

I am reading the book 'Python for data analysis' by Wes McKinney and I met the same problem of Dataframe.ix[] while retrieving the rows with index. I replace ix by iloc and it works perfectly.

answered Jul 01 '20 at 07:58

Avicii

98
1
8

Fabio Pomi · Answer 13 · 2020-07-10T08:41:45.923

I'm using .ix as I have mixed indexing, labels and integers. .loc() does not solve the issue as well as .iloc; both are ending in errors. I was intentionally using .ix because it was the fast lane when the index is a mix of integers and labels.

As example a df like:

My way out is to back-up columns and index, replace with integers, use .iat and then restore the df as it was at the beginning. I have something like:

# Save the df and replace indec and columns with integers
lista_colonne = list(df.columns)  
df.columns = range(0,len(lista_colonne))    
nome_indice = df.index.name
lista_indice = list(df.index)
df['Indice'] = range(0,len(lista_indice))
df.index = df['Indice']
del df['Indice']

  ... indexing here with .iat in place of .ix


# Now back as it was
df.columns = lista_colonne
df['Indice'] = lista_indice
df.index = df['Indice']
del df['Indice']
df.index.name = nome_indice

Bye, Fabio.

score 0 · Answer 14 · edited Jul 24 '20 at 15:45

0

I had to do this:

returns.ix['2015-01-01':'2015-12-31'].std()

After much ado I made it happen using this:

returns.xs(key='2015',axis=0).std()

I believe at least for this case we can use cross section and filter using 2015 as key.

edited Jul 24 '20 at 15:45

Matt Ke

3,599
12
30
49

answered Jul 24 '20 at 15:17

user13989469

1

score 0 · Answer 15 · edited Mar 02 '21 at 19:25

0

Yes, that's right. Replace df.ix[] with df.iloc[] or df.loc[]

edited Mar 02 '21 at 19:25

Melanie Palen

2,645
6
31
50

answered Aug 24 '20 at 13:12

Pravu Chaudhary

101
1
4

score -2 · Answer 16 · answered Jul 20 '20 at 15:13

-2

Guys try to update current pandas
replace .ix with .iloc after replacing its works well for me For details refers documentations

answered Jul 20 '20 at 15:13

SIVA001

17
2

AttributeError: 'DataFrame' object has no attribute 'ix'

16 Answers16

Linked

Related