如何基于多个分隔符 pandas 进行分割 [英] How to split based on multiple delimiter pandas

问题描述

我有一个df列，其中包含

I have a df column which contains

Phone number
12399422/930201021
5451354;546325642
789888744,656313214
123456654

我想将其分为两列

Phone number1      Phone number2
12399422           930201021
5451354            546325642
789888744          656313214
123456654

我尝试使用Apply

I have tried to use apply,

    df['TELEPHONE1'] = df['TELEPHONE'].str.split(',').str.get(0)
    df['TELEPHONE2'] = df['TELEPHONE'].str.split(',').str.get(1)
    df['TELEPHONE1'] = df['TELEPHONE'].str.split(';').str.get(0)
    df['TELEPHONE2'] = df['TELEPHONE'].str.split(';').str.get(1)
    df['TELEPHONE1'] = df['TELEPHONE'].str.split('/').str.get(0)
    df['TELEPHONE2'] = df['TELEPHONE'].str.split('/').str.get(1)

但是它只能分割'/'谢谢您的帮助

but it can only split '/' Thank you for your help

推荐答案

使用str.split

df.Phonenumber.str.split('/|;|,',expand=True).add_prefix('Number_')
    Number_0   Number_1
0   12399422  930201021
1    5451354  546325642
2  789888744  656313214
3  123456654       None

这篇关于如何基于多个分隔符 pandas 进行分割的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！