Get last “column” after .str.split() operation on column in pandas DataFrame

by

Do this:

In [43]: temp2.str[-1]
Out[43]: 
0    p500
1    p600
2    p700
Name: ticker

So all together it would be:

>>> temp = pd.DataFrame({'ticker' : ['spx 5/25/2001 p500', 'spx 5/25/2001 p600', 'spx 5/25/2001 p700']})
>>> temp['ticker'].str.split(' ').str[-1]
0    p500
1    p600
2    p700
Name: ticker, dtype: object

More Related Contents:

  1. removing newlines from messy strings in pandas dataframe cells?
  2. Split string every nth character?
  3. Splitting dataframe into multiple dataframes
  4. Pandas filtering for multiple substrings in series
  5. Create Pandas DataFrame from a string
  6. String concatenation of two pandas columns
  7. Splitting a string into words and punctuation
  8. Pandas split column into multiple columns by comma
  9. How to split strings into text and number?
  10. Convert columns to string in Pandas
  11. Reading a text file and splitting it into single words in python
  12. Product code looks like abcd2343, how to split by letters and numbers?
  13. Remove non-ASCII characters from pandas column
  14. How to split strings inside a list by whitespace characters
  15. Left justify string values in a pandas DataFrame
  16. Convert list of strings to dictionary
  17. Filter string data based on its string length
  18. Converting pandas column of comma-separated strings into dummy variables
  19. Is there a way to split a string by every nth separator in Python?
  20. Pandas Dataframe: split column into multiple columns, right-align inconsistent cell entries
  21. FutureWarning: The default value of regex will change from True to False in a future version
  22. How to remove numbers from string terms in a pandas dataframe
  23. Split a string into 2 in Python
  24. How can I split by 1 or more occurrences of a delimiter in Python?
  25. Split strings in tuples into columns, in Pandas
  26. Filtering pandas dataframe rows by contains str
  27. Copy text between parentheses in pandas DataFrame column into another column
  28. Splitting a math expression string into tokens in Python
  29. Split pandas dataframe in two if it has more than 10 rows
  30. pandas combine two strings ignore nan values

Leave a Comment