title: Deleting substrings in a panda dataframe using regular expressions
body: <p>Hi I want to delete <code>{endIndex:8,startIndex:0,value:</code> from <code>date-and-time:{city:{endIndex:8,startIndex:0,value:Atlantic}</code> in multiple rows and columns in my dataframe.</p>
  
  <p>Here's an example of one row in my dataframe.</p>
  
  <pre><code>{ "_id" : ObjectId("5ad13551df70d8025b7811db"), "Article url" : "http://wreg.com/2015/08/02/mpd-officer-killed-in-the-line-of-duty-identified/",  "Full text" : "Blah blah", "Json" : "{circumstances:{number-of-shots-fired:{endIndex:-1,startIndex:-1,value:},type-of-gun:{endIndex:-1,startIndex:-1,value:}},date-and-time:{city:{endIndex:7,startIndex:0,value:MEMPHIS},clock-time:{endIndex:226,startIndex:218,value:9:15 p.m}, victim-section:[{age:{endIndex:151,startIndex:148,value:33,},gender:Male,name:{endIndex:146,startIndex:135,value:Sean Bolton},race:{endIndex:-1,startIndex:-1,value:},victim-was:[killed]}]}", "Publication date" : "2015-08-03 10:24:27+00:00" }
  </code></pre>
  
  <p>As you can see <code>{endIndex:,startIndex:,value:}</code> shows up in a bunch of different columns with different values (sometimes no value). 
  So how do I go from </p>
  
  <pre><code>date-and-time:{city:{endIndex:7,startIndex:0,value:MEMPHIS}
  </code></pre>
  
  <p>To my desired output</p>
  
  <pre><code>date-and-time:{city:MEMPHIS}
  </code></pre>
  
  <p>*I know the value doesn't make sense so please ignore that.</p>
  
  <p>So far I was thinking of using pandas.DataFrame.replace combined with regular expression to find substrings that match my conditions.</p>
  
  <p><code>new_df=old_df.replace('abc{endIndex:X,startIndex:Y,value:ABC', '', regex=True)</code></p>
  
  <p>What would be the equivalent regular expression for abc, ABC, and X, Y? Where they can be anything.</p>