This can be easily achieved as follows:

import pandas as pd df = pd.DataFrame() X = '9 10 13 110 14 16' Y = '12 1 6 1 1 2'   df['X'] = X.split() df['Y'] = Y.split() 

If you are looking to hard-code it for only 2 columns, this can be achieved as follows:

import pandas as pd df = pd.DataFrame() text = '9 10 13 110 14 16 12 1 6 1 1 2' text = text.split()   df['X'] = text[:int(len(text)/2)] df['Y'] = text[int(len(text)/2):]