split dataframe row on delimiter python

Fares Ahmed answered on May 19, 2022 Popularity 9/10 Helpfulness 2/10

answer split dataframe row on delimiter python

related split dataframe by delimiter pandas

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 delimiter python row

Link to this answer
Share Copy Link

Contributed on May 19 2022

Fares Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

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 6/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on May 25 2023

minty_mosquito_69

0 Answers Avg Quality 2/10

split dataframe row on delimiter python

Contents

More Related Answers

split dataframe row on delimiter python

Closely Related Answers

split dataframe by delimiter pandas

Grepper

Documentation

Social

Legal

Contact

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