Python list with key-value to dataframe

My current set looks as follows:

['dept_id: 00001', 'col_two: 00001value', 'col_three: 00001false', 'name: some_name',   'col_four: 00001value', 'col_five: 00001value', 'col_six: 00001false', 'name: some_name',   'col_seven: 00001value', 'col_eight: 00001value', 'col_nine: 00001false', 'dept_id: 00002',   'col_two: 00002value', 'col_three: 00002value', 'name: some_name', 'col_four: 00002value',   'col_five: 00002value', 'col_six: 00002false', 'name: some_name', 'col_seven: 00002value',   'col_eight: 00002value', 'col_nine: 00002false']  

What I need is a data in dataframe form with additional value from seperate variable date_from='2021-01-15':

   date_from     dept_id   col_two    col_three   col_four  col_five  0  2021-01-15    00001     value      value       value     value  1  2021-01-15    00002     value      value       value     value  

Starting point for me is print(DataFrame(new_list))

                        0  0          dept_id: 00001  1     col_two: 00001value  2   col_three: 00001false  3         name: some_name  4    col_four: 00001value  5    col_five: 00001value  6     col_six: 00001false  7         name: some_name  8   col_seven: 00001value  9   col_eight: 00001value  10   col_nine: 00001false  11         dept_id: 00002  12    col_two: 00002value  13  col_three: 00002value  14        name: some_name  15   col_four: 00002value  16   col_five: 00002value  17    col_six: 00002false  18        name: some_name  19  col_seven: 00002value  20  col_eight: 00002value  21   col_nine: 00002false  

https://stackoverflow.com/questions/65756643/python-list-with-key-value-to-dataframe January 17, 2021 at 10:05AM