title: Splitting a dataframe column from scraped webpage based on a delimiter
body: <p>I am working on getting data from a public API and converting it into a Pandas dataframe basically from US earthquake website. I got JSON form data which is actually list of nested dictionaries. I have Used an approach and converted it into dataframe which is of the form class <strong>'pandas.core.frame.DataFrame'</strong>. Now when I am trying to split the coordinates column I am getting NaN or other issues. The series is of the form <strong>class 'pandas.core.series.Series'</strong>.</p>
  
  <p>Here is my code-</p>
  
  <pre><code>import urllib.request, json
  import pandas as pd
  url = "https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&amp;starttime=2016-10-01&amp;endtime=2016-10-02"
  response = urllib.request.urlopen(url)
  data = json.loads(response.read())
  y=data['features']
  o=[]
  for d in y:
      d.update(d.pop('geometry', {}))
  for i in y:
      i.update(i.pop('properties', {}))
  #print(y)
  df1=pd.DataFrame(y)
  print(type(df1))
  df1=df1.drop(['alert','cdi','detail','felt','id','ids','mmi','net','sources','updated','url'],axis=1)
  print(type(df1['coordinates']))
  display(df1)
  </code></pre>
  
  <p>I tried using str.split, Pandas.Series.str.split, slitt </p>