Convert object data type to string issue in python

by

object is the default container capable of holding strings, or any combination of dtypes.

If you are using a version of pandas < '1.0.0' this is your only option. If you are using pd.__version__ >= '1.0.0' then you can use the new experimental pd.StringDtype() dtype. Being experimental, the behavior is subject to change in future versions, so use at your own risk. 

df.dtypes
#country    object

# .astype(str) and .astype('str') keep the column as object. 
df['country'] = df['country'].astype(str)
df.dtypes
#country    object

df['country'] = df['country'].astype(pd.StringDtype())
df.dtypes
#country    string

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. How to extract first 8 characters from a string in pandas
  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. selenium.common.exceptions.ElementNotInteractableException: Message: element not interactable when clicking on an element using Selenium Python
  12. Pygame window freezes when it opens
  13. How to deal with multi-level column names downloaded with yfinance
  14. python 3.x ImportError: No module named ‘cStringIO’
  15. Run a python script in virtual environment from windows task scheduler
  16. Installing modules to Anaconda from .tar.gz
  17. python random.getstate() and random.setstate()
  18. Implementing a backspace in Python 3.3.2 Shell using Idle [duplicate]
  19. Speed up bitstring/bit operations in Python?
  20. pip throws “TypeError: deprecated() ” error
  21. Multiple Displays in Pygame
  22. Flask: Get gzip filename sent from Postman
  23. Updating a value in a pandas dataframe in an iterrows loop
  24. FutureWarning: The default value of regex will change from True to False in a future version
  25. Check if rows in one dataframe exist in another dataframe
  26. Python 3.4 on Sublime Text 3
  27. Python making combined bar and line plot with secondary y-axis
  28. Fetching multiple urls with aiohttp in python
  29. ImportError: cannot import name ‘escape’ from ‘jinja2’
  30. Can’t install Matplotlib on Python 3.10 after its release (2021-10-05)

Leave a Comment