In [1]:

    

import pandas as pd
from StringIO import StringIO


    

In [2]:

    

x = '''
longitude,latitude
degrees_east,degrees_north
-142.842,-1.82
-25.389,39.87
-37.704,27.114
'''


    

In [3]:

    

# Create a Pandas DataFrame
obs=pd.read_csv(StringIO(x.strip()), sep=",\s*")


    

In [4]:

    

print(obs)


    

    




      longitude       latitude
0  degrees_east  degrees_north
1      -142.842          -1.82
2       -25.389          39.87
3       -37.704         27.114

In [4]: