knime pandas dataframe
import re
import pandas as pd
output_table = pd.DataFrame(columns=('ID','username','CREATED','MODIFIED','CONTENT','TYPE','NAME','CDS_FIELD_ID'))
cds_ids = pd.DataFrame(columns=('ID','CDS_FIELD_ID'))
for theID, username,theCreated,theModified,theContent,theType,theName in zip(input_table['ID'],input_table['USER521'],input_table['CREATED'],input_table['MODIFIED'],input_table['CONTENT'],input_table['TYPE'],input_table['NAME']):
idSeries = re.findall(r'FACT\/([0-9]*)',theContent)
print idSeries
for theCDS in enumerate(idSeries):
print theID,username,theCreated,theModified,theContent,theType,theName,theCDS[1]
thisRow = pd.DataFrame([theID,username,theCreated,theModified,theType,theName,theCDS[1]])
output_table.append(thisRow)
print output_table