How to extract first 8 characters from a string in pandas

by

You are close, need indexing with str which is apply for each value of Series:

data['Order_Date'] = data['Shipment ID'].str[:8]

For better performance if no NaNs values:

data['Order_Date'] = [x[:8] for x in data['Shipment ID']]

print (data)
        Shipment ID Order_Date
0  20180504-S-20000   20180504
1  20180514-S-20537   20180514
2  20180514-S-20541   20180514
3  20180514-S-20644   20180514
4  20180514-S-20644   20180514
5  20180516-S-20009   20180516
6  20180516-S-20009   20180516
7  20180516-S-20009   20180516
8  20180516-S-20009   20180516

If omit str code filter column by position, first N values like:

print (data['Shipment ID'][:2])
0    20180504-S-20000
1    20180514-S-20537
Name: Shipment ID, dtype: object

More Related Contents:

  1. How to change the location of the column name in pandas?
  2. finding values in pandas series – Python3
  3. Importing pandas shows ImportError: cannot import name hashtable
  4. Convert object data type to string issue in python
  5. SKLearn warning “valid feature names” in version 1.0
  6. converting a pandas date to week number
  7. Pandas send email containing dataframe as a visual table
  8. Pandas pd.cut() – binning datetime column / series
  9. pandas multiindex – how to select second level when using columns?
  10. How to combine multiple columns in a DataFrame to Pandas datetime
  11. Could someone please go through this code line by line and explain it in Pseudocode or English
  12. How to provide a reproducible copy of your DataFrame with to_clipboard()
  13. DeprecationWarning: executable_path has been deprecated, please pass in a Service object
  14. Why does loading tensorflow on Mac lead to “Process finished with exit code 132 (interrupted by signal 4: SIGILL)”?
  15. seaborn histplot and displot output doesn’t match
  16. TypeError: can’t pickle _thread.lock objects
  17. Tensorflow (.pb) format to Keras (.h5)
  18. How to combine gridspec with plt.subplots() to eliminate space between rows of subplots
  19. How to check if input is float or int?
  20. pip3 install not working – No module named ‘pip._vendor.pkg_resources’
  21. AttributeError: ‘WebDriver’ object has no attribute ‘find_element_by_xpath’
  22. How to use Boto3 pagination
  23. How does one insert statistical annotations (stars or p-values) into matplotlib / seaborn plots?
  24. Format a number with commas to separate thousands
  25. reading multiple files contained in a zip file with pandas
  26. How to compute jaccard similarity from a pandas dataframe
  27. selenium.common.exceptions.WebDriverException: Message: unknown error: unable to discover open pages using ChromeDriver through Selenium
  28. Debugging Numpy VisibleDeprecationWarning (ndarray from ragged nested sequences)
  29. pandas scatter plotting datetime
  30. How to determine what version of python3 tkinter is installed on my linux machine?

Leave a Comment