Transform to normal Data Frame which has row as list. Split rows to column
<p>My Data Frame output from reading a complex json looks like below.</p>

<p>Where individual row is a list within a single column.</p>

<p>Below is the sample Data Frame(<code>df</code>)</p>

<pre><code>col
[A,1,3,4,Null]
[B,4,5,6,Null]
[C,7,8,9,Null]
</code></pre>

<p>I tried to split to individual column using pandas but it didnt work as individual row itself is a list. 
I want the data frame to look like below.</p>

<pre><code>colA,colB,colC,colD,colE
A    1    3     4    Null
B    4    5     6    Null
C    7    8     9    Null
</code></pre>

<p>I dont need the column name to specified manually it can be auto-generated.</p>

<p>You can construct a df from the result of using <code>apply</code> and <code>pd.Series</code> ctor on each row:</p>

<pre><code>In [99]:
pd.DataFrame(df['col'].apply(pd.Series).values, columns=['colA','colB','colC','colD','colE'])

Out[99]:
  colA colB colC colD  colE
0    A    1    3    4  Null
1    B    4    5    6  Null
2    C    7    8    9  Null
</code></pre>

python list pandas dataframe multiple-columns