Breaking News: Grepper is joining You.com. Read the official announcement!

split dataframe by delimiter pandas

Add Answer

minty_mosquito_69 answered on July 8, 2020 Popularity 9/10 Helpfulness 5/10

answer split dataframe by delimiter pandas

related delimiter pandas

related split a pd dataframe

related split dataframe row on delimiter python

related pandas sep and delimiter

split dataframe by delimiter pandas

Comment

In [42]:
df[['V','allele']] = df['V'].str.split('-',expand=True)
df

Out[42]:
      ID    Prob      V allele
0   3009  1.0000  IGHV7   B*01
1    129  1.0000  IGHV7   B*01
2    119  0.8000  IGHV6   A*01
3    120  0.8056   GHV6   A*01
4    121  0.9000  IGHV6   A*01
5    122  0.8050  IGHV6   A*01
6    130  1.0000  IGHV4   L*03
7   3014  1.0000  IGHV4   L*03
8    266  0.9970  IGHV5   A*01
9    849  0.4010  IGHV5   A*04
10   174  1.0000  IGHV6   A*02
11   844  1.0000  IGHV6   A*02

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: dataframe delimiter pandas python

Link to this answer
Share Copy Link

Contributed on May 25 2023

minty_mosquito_69

0 Answers Avg Quality 2/10

Closely Related Answers

delimiter pandas

Comment

Pandas provide a method to split string around a passed separator/delimiter. After that, the string can be stored as a list in a series or it can also be used to create multiple column data frames from a single separated string.

Popularity 9/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: delimiter deli

Link to this answer
Share Copy Link

Contributed on Aug 01 2020

Dhwaj Sharma

0 Answers Avg Quality 2/10

split a pd dataframe

Comment

In [255]: df = pd.DataFrame(np.random.rand(5, 6), columns=list('abcdef'))

In [256]: df
Out[256]:
          a         b         c         d         e         f
0  0.823638  0.767999  0.460358  0.034578  0.592420  0.776803
1  0.344320  0.754412  0.274944  0.545039  0.031752  0.784564
2  0.238826  0.610893  0.861127  0.189441  0.294646  0.557034
3  0.478562  0.571750  0.116209  0.534039  0.869545  0.855520
4  0.130601  0.678583  0.157052  0.899672  0.093976  0.268974

In [257]: dfs = np.split(df, [4], axis=1)

In [258]: dfs[0]
Out[258]:
          a         b         c         d
0  0.823638  0.767999  0.460358  0.034578
1  0.344320  0.754412  0.274944  0.545039
2  0.238826  0.610893  0.861127  0.189441
3  0.478562  0.571750  0.116209  0.534039
4  0.130601  0.678583  0.157052  0.899672

In [259]: dfs[1]
Out[259]:
          e         f
0  0.592420  0.776803
1  0.031752  0.784564
2  0.294646  0.557034
3  0.869545  0.855520
4  0.093976  0.268974

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Sep 08 2020

White Faced Tree Rat

0 Answers Avg Quality 2/10

split dataframe row on delimiter python

Comment

In [1]: df = pd.DataFrame({'A': [[0, 1, 2], 'foo', [], [3, 4]],
   ...:                    'B': 1,
   ...:                    'C': [['a', 'b', 'c'], np.nan, [], ['d', 'e']]})

In [2]: df
Out[2]:
           A  B          C
0  [0, 1, 2]  1  [a, b, c]
1        foo  1        NaN
2         []  1         []
3     [3, 4]  1     [d, e]

In [3]: df.explode('A')
Out[3]:
     A  B          C
0    0  1  [a, b, c]
0    1  1  [a, b, c]
0    2  1  [a, b, c]
1  foo  1        NaN
2  NaN  1         []
3    3  1     [d, e]
3    4  1     [d, e]

Popularity 9/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on May 19 2022

Fares Ahmed

0 Answers Avg Quality 2/10

pandas sep and delimiter

Comment

there is no difference

Popularity 9/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: delimiter deli

Link to this answer
Share Copy Link

Contributed on Jul 08 2020

mihai

0 Answers Avg Quality 2/10

split dataframe by delimiter pandas

Contents

More Related Answers

split dataframe by delimiter pandas

Closely Related Answers

delimiter pandas

split a pd dataframe

split dataframe row on delimiter python

pandas sep and delimiter

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.