split dataframe column into multiple columns

Question

I have been sent a file. I have read it in as a dataframe which contains only one column and over a 1,000,000 rows. Each row is a mixture of numbers and text.

I tried the following line below.

data = data.str.split('/t',expand=True)

However I get the error below,

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

I thought maybe it was because its of type object and not string. So tried the line below however that seems to have no effect.

data.astype('str')

How can I split this column?

jezrael · Accepted Answer · 2020-05-18 10:28:00Z

1

I think there is one column DataFrame, so for one column is possible select first column by position with DataFrame.iloc:

data = data.iloc[:, 0].str.split('/t',expand=True)

Or if psosible select first column by name:

data = data['col'].str.split('/t',expand=True)

answered May 18, 2020 at 10:28

jezrael

867k102 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

mHelpMe Over a year ago

using the first suggestion just seems to have changed the column name from some long horrible name to 0. I didn't try the second as the column name is so long

jezrael Over a year ago

@mHelpMe - Are you sure? Because 0 here means first column of data

mHelpMe Over a year ago

sorry it is now working, just re-ran it and indeed it worked, thanks

Collectives™ on Stack Overflow

split dataframe column into multiple columns

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related