Python pandas 'Index' object has no attribute 'str'

Question

I'm trying to run this code, but it returns this error

import pandas as pd

df = pd.read_csv('olympics.csv', index_col=0, skiprows=1)

for col in df.columns:
    if col[:2]=='01':
        df.rename(columns={col:'Gold'+col[4:]}, inplace=True)
    if col[:2]=='02':
        df.rename(columns={col:'Silver'+col[4:]}, inplace=True)
    if col[:2]=='03':
        df.rename(columns={col:'Bronze'+col[4:]}, inplace=True)
    if col[:1]=='№':
        df.rename(columns={col:'#'+col[1:]}, inplace=True)

names_ids = df.index.str.split('\s\(') # split the index by '('

AttributeError: 'Index' object has no attribute 'str'

How can I solve it? I can't find it.

Thank you!

df.index is a numpy array, not a pandas Series (and so cannot use the method Series.str.split) — cmaher
– cmaher, Commented Feb 10, 2017 at 18:55

cluna · Accepted Answer · 2017-02-10 19:03:01Z

2

It solves with (posted in a comment by @Shijo)

df.index.to_series().str.split('\s\(')

answered Feb 10, 2017 at 19:03

cluna

952 silver badges8 bronze badges

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

1 Comment

jezrael Over a year ago

If upgrade pandas to last version 0.19.2 then df.index.str.split('\s\(') works.

Collectives™ on Stack Overflow

Python pandas 'Index' object has no attribute 'str'

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related