List to dataframe, each element in list in column

Question

Ho everyone,

I want to create a dataframe from list, where each element from a list is a column. Example:

    Col
0   A_1
1   A_2
2   A_1
3   B_3
4   B_2

I want to have a dataframe like this

Col1 . col2 
0   A .  1  
1   A .  2
2   B .  3
3   B .  2

....

split by the '_' and make two columns and remove the duplicate

Thanks in advance

jezrael · Accepted Answer · 2019-02-26 14:28:36Z

3

Use:

df[['Col1','Col2']]=df.pop('Col').str.split("_",expand=True)
df = df.drop_duplicates()
print(df)

  Col1 Col2
0    A    1
1    A    2
3    B    3
4    B    2

edited Feb 26, 2019 at 14:28

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

answered Feb 26, 2019 at 14:25

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

2 Comments

noaai Over a year ago

thanks for your answer, I had this error ValueError: Columns must be same length as key

anky Over a year ago

@noaai possible that you have 2 underscores in some data?

BENY · Accepted Answer · 2019-02-26 14:41:24Z

1

Using extract

yourdf=df.drop_duplicates().Col.str.extract(r'(?P<col1>[AB])_(?P<col2>\d)')
yourdf
Out[16]: 
  col1 col2
0    A    1
1    A    2
3    B    3
4    B    2

answered Feb 26, 2019 at 14:41

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

List to dataframe, each element in list in column

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related