split cell to rows by pipe python
<p>I am trying to split a cell into 2 rows by pipe ("|").</p>

<p>For instance:</p>

<pre><code>ID  Site    Category    Queries

1   0        38037      antique+wall+telephone|antique+wall+phone
</code></pre>

<p>will become:</p>

<pre><code>ID  Site    Category    Queries

1   0         38037     antique+wall+telephone

1   0         38037     antique+wall+phone
</code></pre>

<p>Using talend, You can also use tNormalize component : you just have to specify the column to normalize in the dropdown menu. Be careful if you want to use "|" as the item separator, as it is a reserved character, you have to escape it using "\|".
<a href="http://i.stack.imgur.com/IuYbI.png" rel="nofollow"><img src="http://i.stack.imgur.com/IuYbI.png" alt="enter image description here"></a></p>

python