Numerical Computing with Python

There's more...

The split method worked exceptionally well in this example with a simple regular expression. For other examples, some columns might require you to create splits on several different patterns. To search for multiple regular expressions, use the pipe character |. For instance, if we wanted to split only the degree symbol and comma, each followed by a space, we would do the following:

>>> cities.Geolocation.str.split(pat='° |, ', expand=True)

This returns the same DataFrame from step 2. Any number of additional split patterns may be appended to the preceding string pattern with the pipe character.

The extract method is another excellent method which allows you to extract specific groups within each cell. These capture groups ...