Pandas: convert dtype ‘object’ to int

by

Documenting the answer that worked for me based on the comment by @piRSquared.

I needed to convert to a string first, then an integer.

>>> df['purchase'].astype(str).astype(int)

More Related Contents:

  1. Replacing values represented by 'UN' with NaN
  2. Convert pandas dataframe to NumPy array
  3. Strings in a DataFrame, but dtype is object
  4. Performance of Pandas apply vs np.vectorize to create new column from existing columns
  5. What does axis in pandas mean?
  6. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  7. pandas select from Dataframe using startswith
  8. How to map numeric data into categories / bins in Pandas dataframe
  9. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  10. Restart cumsum and get index if cumsum more than value
  11. How can I map True/False to 1/0 in a Pandas DataFrame?
  12. What does the term “broadcasting” mean in Pandas documentation?
  13. Dropping infinite values from dataframes in pandas?
  14. ValueError: numpy.dtype has the wrong size, try recompiling
  15. ‘DataFrame’ object has no attribute ‘sort’
  16. Pandas pd.Series.isin performance with set versus array
  17. Improve Row Append Performance On Pandas DataFrames
  18. Difference between data type ‘datetime64[ns]’ and ‘
  19. python pandas flatten a dataframe to a list
  20. Precision lost while using read_csv in pandas
  21. Get week start date (Monday) from a date column in Python (pandas)?
  22. What is dtype(‘O’), in pandas?
  23. pandas distinction between str and object types
  24. Normalize data in pandas
  25. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  26. Python Pandas – Missing required dependencies [‘numpy’] 1
  27. Pandas: Difference between largest and smallest value within group
  28. How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
  29. mean from pandas and numpy differ
  30. Convert Pandas dataframe to Sparse Numpy Matrix directly

Leave a Comment