Extract int from string in Pandas

by

You can convert to string and extract the integer using regular expressions.

df['B'].str.extract('(\d+)').astype(int)

More Related Contents:

  1. How to add a new column to an existing DataFrame?
  2. How to change the order of DataFrame columns?
  3. Add missing dates to pandas dataframe
  4. Python Pandas – Find difference between two data frames
  5. Pandas: sum DataFrame rows for given columns
  6. pandas: filter rows of DataFrame with operator chaining
  7. Rename Pandas DataFrame Index
  8. Pandas DataFrame: replace all values in a column, based on condition
  9. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  10. How to check if any value is NaN in a Pandas DataFrame
  11. Python Pandas max value in a group as a new column
  12. Convert row to column header for Pandas DataFrame,
  13. Select multiple ranges of columns in Pandas DataFrame
  14. pandas – filter dataframe by another dataframe by row elements
  15. Python Pandas replicate rows in dataframe
  16. Efficiently replace values from a column to another column Pandas DataFrame
  17. Left justify string values in a pandas DataFrame
  18. Copying MultiIndex dataframes with pd.read_clipboard?
  19. Can’t drop NAN with dropna in pandas
  20. Override global variable inside function not working with Spyder 4
  21. Putting many python pandas dataframes to one excel worksheet
  22. Remove Unnamed columns in pandas dataframe [duplicate]
  23. Find difference between two data frames
  24. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  25. append dictionary to data frame
  26. Efficient way to add rows to dataframe
  27. Find names of top-n highest-value columns in each pandas dataframe row
  28. Calculate summary statistics of columns in dataframe
  29. Python: Adding hours to pandas timestamp
  30. Pandas: Join dataframe with condition

Leave a Comment