Split list and convert to dataframe in Pandas

Question

Given a list as follows:

['start year: 2019', 'end year: 2021']

How could I split them by : and convert into a dataframe?

start year      end year
  2019            2021

Thanks for your help at advance.

ah bon · Accepted Answer · 2020-07-07 03:07:19Z

3

You can do

df = pd.DataFrame([x.split(':')for x in l ]).set_index(0).T
0 start year end year
1       2019     2021

ah bon

10.1k22 gold badges82 silver badges187 bronze badges

answered Jul 7, 2020 at 2:54

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

May I ask: why the column name row's is 0, index 0 should start with 2019 2021 row, right?