Python，如何按给定的顺序将列表插入到表的列中

My table has 3 columns: ID, Author and In_order. I am reading in a file and a line contains a list of authors separated by a comma. What I am trying to achieve is inserting the names of the authors into the author column with its correct ID in the ID field and then the position in which it appears in the list (which will always be in order). What I want in the end is my table looking like this:My table has 3 columns: ID, Author and In_order