如何将数据帧字符串列拆分为两列? [英] How to split a dataframe string column into two columns?
本文介绍了如何将数据帧字符串列拆分为两列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个带有一列(字符串)列的数据框,我想将其拆分为两列(字符串)列,其中一列标题为" fips"
,另一列为行"
I have a data frame with one (string) column and I'd like to split it into two (string) columns, with one column header as 'fips'
and the other 'row'
我的数据框 df
看起来像这样:
My dataframe df
looks like this:
row
0 00000 UNITED STATES
1 01000 ALABAMA
2 01001 Autauga County, AL
3 01003 Baldwin County, AL
4 01005 Barbour County, AL
我不知道如何使用 df.row.str [:]
来实现拆分行单元格的目的.我可以使用 df ['fips'] = hello
添加一个新列,并使用 hello
填充它.有什么想法吗?
I do not know how to use df.row.str[:]
to achieve my goal of splitting the row cell. I can use df['fips'] = hello
to add a new column and populate it with hello
. Any ideas?
fips row
0 00000 UNITED STATES
1 01000 ALABAMA
2 01001 Autauga County, AL
3 01003 Baldwin County, AL
4 01005 Barbour County, AL
推荐答案
也许有更好的方法,但这是一种方法:
There might be a better way, but this here's one approach:
row
0 00000 UNITED STATES
1 01000 ALABAMA
2 01001 Autauga County, AL
3 01003 Baldwin County, AL
4 01005 Barbour County, AL
df = pd.DataFrame(df.row.str.split(' ',1).tolist(),
columns = ['fips','row'])
fips row
0 00000 UNITED STATES
1 01000 ALABAMA
2 01001 Autauga County, AL
3 01003 Baldwin County, AL
4 01005 Barbour County, AL
这篇关于如何将数据帧字符串列拆分为两列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文